error during install

[jayncali61]

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /var/www/vhosts/myeroticdomain.com/httpdocs/install.php on line 534
I cannot connect to the PhotoPost Classifieds MySQL server. [host:$host][mysql_user:$mysql_user][mysql_password:$mysql_password]. Check your config-inc.php for the correct settings and rerun.

[Chuck S]

Thar message states your mysql server has gone down. Make sure it is running and you are using the correct information to connect to it when installing.

[jayncali61]

i check and its up and running can it be anything else


[root@p ~]# service mysqld start
Starting MySQL: [ OK ]
[root@p ~]# chkconfig mysqld on
[root@p ~]# /etc/rc.d/init.d/mysqld start
Starting MySQL: [ OK ]
[root@p ~]#

[Chuck S]

I am not sure you might want to contact your server host and ask for assistance as there appears to be an issue with the mysql server.

MySQL Lists: bugs: Re: Fwd: Error 2013 when running Configuration Wizard

[jayncali61]

host said it not the server. so i need to make sure i'm doing the set up correct is there something i missed?

/var/www/vhosts/mydomain.com/httpdocs

PhotoPost Classifieds Database Host mydomain.com
PhotoPost Classifieds Database Name db name
PhotoPost Classifieds Database User usr
PhotoPost Classifieds Database Password xxxxx
PhotoPost Classifieds Database Prefix (cannot be changed once set) cp_

User Database Host (enter same info as above if not integrating with a third party forum)
User Database Name mydomain.com
User Database User usr
User Database Password xxxxxxx

Default Gallery Language english
Thumbnail Generator gd1
Path for MOGRIFY executable


pp-classifieds
images (chmod 755)
uploads (chmod 777)
help (chmod 755)
forums (chmod 755)
languages (chmod 755)
stylesheets (chmod 755)
templates (chmod 777)
data (chmod 777)
1 (chmod 777)
2 (chmod 777)

All permissions for .php and .sql files should be set to chmod 644, except for config-inc.php and config-int.php

[Chuck S]

host name should either be localhost or whatever your sql manager says it is

database name is the database name you setup same for user and password.

I do not think host as your domain.com would be correct I will say that.

Remember if your not integrating with a forum the user database info will be the same as the photopost database info and you enter accordingly.

[jayncali61]

ok that work and error after step 4


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nameU'@'localhost' (using password: NO) in /var/www/vhosts/mydomain.com/httpdocs/install.php on line 1221
I cannot connect to the Members database.

[Chuck S]

Make sure you place the same information you put in the photopost database portion in the user database portion if this is a standalone install otherwise place your forum database info where it says user database if this is integrated with a forum.

[jayncali61]

thank you but i'm going to pay for the install. only have so much time

[Chuck S]

Okay they will be in contact after you do so then.