MySQL connection problem

Next topic

Author	Message
Olivier Ligny	Monday 07 November 2005 12:43:51 am Hello, I have a computer with Wamp installed, but stopped. During the ezPublish installation process, there is a problem with MySQL : <i><b>Installing MySQL: Service successfully installed. Installing MySQL return: 0 Starting MySQL: Le service MySQL a démarré (</i>Mysql started sucessfully<i>). Starting MySQL return: 0 Creating databases: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061) Creating databases return: 1</b></i> First I didn't see that problem (it's only in the install.log file). So I did continue the installation, and I started the configuration steps, I configured the SMTP server ... And then it said me : "The database would not accept the connection, please review your settings and try again." I saw that the MySQL server wasn't started. So I try to enter "net start mysql" on my command-line, and I got again the following error : <i><b>Le service MySQL démarre. Le service MySQL n'a pas pu être lancé. Une erreur système s'est produite. L'erreur système 1067 s'est produite. Le processus s'est arrêté inopinément.</b></i> So, what is this "system error 1067" ? I successfully launched my other MySQL server (which came with Wamp). But even then, ezPublish didn't see it, I got the same error ("The database would not accept ...") !!! I'm tired :-( Does someone have an idea ? Thanks a lot :) Olivier (excuse my bad english !)
Łukasz Serwatka	Tuesday 08 November 2005 8:50:54 am Olivier, for installation process try to enable DebugOutput, look in to settings/site.ini.append.php then locate [DebugSettings] and set DebugOutput=enabled If you will see error like: "Client does not support authentication protocol" Then you will have to run SQL query mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd') -> WHERE Host = 'some_host' AND User = 'some_user'; mysql> FLUSH PRIVILEGES; or start mysqld with the --old-passwords option Personal website -> http://serwatka.net Blog (about eZ Publish) -> http://serwatka.net/blog
Olivier Ligny	Wednesday 09 November 2005 6:39:06 am Hello, The problem was that the databases hadn't been created, because of the MySQL server which crashes at startup, I think. So I use my own MySQL server instead (which came with Wamp). And I added this line in the ezmysqldb.php file : if ( $this->IsConnected && $db != null ) { mysql_query("CREATE DATABASE IF NOT EXISTS $db", $connection); $ret = mysql_select_db( $db, $connection ); Now, it works. (The ezpublish MySQL server still crashes). Bye Olivier

Author

Message

Monday 07 November 2005 12:43:51 am

Hello,

I have a computer with Wamp installed, but stopped.
During the ezPublish installation process, there is a problem with MySQL :

Installing MySQL: Service successfully installed.
Installing MySQL return: 0
Starting MySQL:
Le service MySQL a démarré (Mysql started sucessfully).
Starting MySQL return: 0
Creating databases: ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)
Creating databases return: 1

First I didn't see that problem (it's only in the install.log file). So I did continue the installation, and I started the configuration steps, I configured the SMTP server ... And then it said me : "The database would not accept the connection, please review your settings and try again."

I saw that the MySQL server wasn't started. So I try to enter "net start mysql" on my command-line, and I got again the following error :
Le service MySQL démarre.
Le service MySQL n'a pas pu être lancé.
Une erreur système s'est produite.
L'erreur système 1067 s'est produite.
Le processus s'est arrêté inopinément.
So, what is this "system error 1067" ?

I successfully launched my other MySQL server (which came with Wamp). But even then, ezPublish didn't see it, I got the same error ("The database would not accept ...") !!!

I'm tired :-(
Does someone have an idea ?

Thanks a lot :)
Olivier (excuse my bad english !)

Łukasz Serwatka

Tuesday 08 November 2005 8:50:54 am

Olivier, for installation process try to enable DebugOutput, look in to settings/site.ini.append.php then locate [DebugSettings] and set DebugOutput=enabled

If you will see error like:

"Client does not support authentication protocol"

Then you will have to run SQL query

mysql> UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
    -> WHERE Host = 'some_host' AND User = 'some_user';
mysql> FLUSH PRIVILEGES;

or start mysqld with the --old-passwords option

Personal website -> http://serwatka.net
Blog (about eZ Publish) -> http://serwatka.net/blog

Olivier Ligny

Wednesday 09 November 2005 6:39:06 am

Hello,

The problem was that the databases hadn't been created, because of the MySQL server which crashes at startup, I think. So I use my own MySQL server instead (which came with Wamp). And I added this line in the ezmysqldb.php file :

if ( $this->IsConnected && $db != null ) {
mysql_query("CREATE DATABASE IF NOT EXISTS $db", $connection);
$ret = mysql_select_db( $db, $connection );

Now, it works. (The ezpublish MySQL server still crashes).

Bye
Olivier