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

eZ debug

Timing:	Jan 19 2025 01:16:44
Script start
Timing:	Jan 19 2025 01:16:44
Module start 'layout'
Timing:	Jan 19 2025 01:16:44
Module start 'content'
Timing:	Jan 19 2025 01:16:44
Module end 'content'
Timing:	Jan 19 2025 01:16:44
Script end

Main resources:

Total runtime	0.0243 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0077	590.2969	152.6250
Module start 'layout'	0.0077	0.0064	742.9219	39.4453
Module start 'content'	0.0140	0.0081	782.3672	89.4766
Module end 'content'	0.0221	0.0021	871.8438	34.3047
Script end	0.0242		906.1484

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0032	13.3514	14	0.0002
Check MTime	0.0014	5.5805	14	0.0001
Mysql Total
Database connection	0.0014	5.7279	1	0.0014
Mysqli_queries	0.0056	23.0681	3	0.0019
Looping result	0.0000	0.1603	1	0.0000
Template Total	0.0017	6.8	1	0.0017
Template load	0.0009	3.6328	1	0.0009
Template processing	0.0008	3.1796	1	0.0008
Override
Cache load	0.0006	2.5651	1	0.0006
General
dbfile	0.0003	1.1365	8	0.0000
String conversion	0.0000	0.0413	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs