topic something wrong connecting to mysql in Alfresco Archive

something wrong connecting to mysql

sharrie — Tue, 23 Aug 2005 07:05:25 GMT

mysql version:4.1.11jdk version: 1.5.0_04I have started mysql, and have tried:mysql -h localhost -u root -pmysql -h 127.0.0.1 -u root -pthey are both ok.now when i start tomcat, the console print the following error msg:/*****************************************************/2005-8-23 14:45:42 org.ap

Re: something wrong connecting to mysql

tvenkatmca — Tue, 23 Aug 2005 07:09:06 GMT

when u r going to run the alfresco first time first double click the db_setup.bat file which will be available in the alfresco folder

then run alf_start_tc.bat

may be every thing will be ok.

Re: something wrong connecting to mysql

sharrie — Tue, 23 Aug 2005 07:09:12 GMT

and database alfresco exist
user name alfresco exist
password is 123456(I have changed relative terms in repository.properties)

and i have typed the following line:
mysql -u root -p -e "grant all on alfresco.* to 'alfresco'@'localho
st' identified by '123456' with grant option;"

my os is : winxp with sp2
i have enabled the firewall which windows itself brings

Re: something wrong connecting to mysql

gavinc — Tue, 23 Aug 2005 08:18:48 GMT

You have a couple of errors during startup due to missing files.

In the "bin" directory of the distribution, you'll find two files, an executable and a DLL, these must both be on the system path i.e. c:\windows\system32 or your JRE's bin directory.

This should remove the ERROR messages you are seeing and allow all the bootstrap data to be loaded.

Re: something wrong connecting to mysql

derek — Tue, 23 Aug 2005 08:22:27 GMT

Hi,

Are you running Tomcat from the distribution or one from a previous installation?

If the latter is true, you will also need to drop the mysql jdbc connector jar into the tomcat common lib folder.

Have there been any other modifications made to the configuration files? If so, it might be worth zipping the entire config folder up and sending them to me: Derek dot Hulley at Alfresco dot org. Include a description of any other changes that you may have made, if relevant.

Regards

Re: something wrong connecting to mysql

sharrie — Tue, 23 Aug 2005 08:38:58 GMT

Hi,

Are you running Tomcat from the distribution or one from a previous installation?

If the latter is true, you will also need to drop the mysql jdbc connector jar into the tomcat common lib folder.

Have there been any other modifications made to the configuration files? If so, it might be worth zipping the entire config folder up and sending them to me: Derek dot Hulley at Alfresco dot org. Include a description of any other changes that you may have made, if relevant.

Regards

Hi,
I compile alfrsco from source code, using ant build_tomcat to build and deploy.

I have changed build.xml besides repository.xml.
I changed mysql-connector-* to mysql-connector-java-3.1.10-bin-g.jar in build.xml.

Re: something wrong connecting to mysql

sharrie — Tue, 23 Aug 2005 08:40:16 GMT

You have a couple of errors during startup due to missing files.

In the "bin" directory of the distribution, you'll find two files, an executable and a DLL, these must both be on the system path i.e. c:\windows\system32 or your JRE's bin directory.

This should remove the ERROR messages you are seeing and allow all the bootstrap data to be loaded.

Hi,
what executable and dll I have missed?

Re: something wrong connecting to mysql

sharrie — Tue, 23 Aug 2005 08:54:15 GMT

once more, I have replaced the original mysql driver from 3rd-party/lib with mysql-connector-java-3.1.10-bin-g.jar.

I have examined many times, just dont know what happens

Re: something wrong connecting to mysql

sharrie — Wed, 24 Aug 2005 03:38:40 GMT

Well, i used mysql without install , then everything gets ok!