anthonylane13 Posted October 19, 2007 Share Posted October 19, 2007 Hi This is my first dabble into this kind of thing although I have built web sites before, I have never used php/ mySQL before, so please humour me! I followed the instructions and my installation went very smoothly. However, once I had finished changing the permissions as shown on the documentation.pdf, I now receive the following error on my page mydomain/catalog/index.php: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/anthonylane13.onlinewebshop.net/catalog/includes/functions/database.php on line 19 Unable to connect to database server! I have no idea what this means or how to fix it... please advise. Thanks Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2007 Share Posted October 20, 2007 Hi This is my first dabble into this kind of thing although I have built web sites before, I have never used php/ mySQL before, so please humour me! I followed the instructions and my installation went very smoothly. However, once I had finished changing the permissions as shown on the documentation.pdf, I now receive the following error on my page mydomain/catalog/index.php: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/anthonylane13.onlinewebshop.net/catalog/includes/functions/database.php on line 19 Unable to connect to database server! I have no idea what this means or how to fix it... please advise. Thanks Check your configuration files (found in catalog/includes and catalog/admin/includes directories). It looks like the database you set up is not corresponding to the information (db name, user id and password) found in your configure.php fiels. Link to comment Share on other sites More sharing options...
Guest Posted October 20, 2007 Share Posted October 20, 2007 You just had a fresh install and went fine then your configure.php should be fine.The problem my be with your host or change attribute on configure.php what the dbase can not read.The configure.php should be 644. Link to comment Share on other sites More sharing options...
anthonylane13 Posted October 20, 2007 Author Share Posted October 20, 2007 Hi This is my first dabble into this kind of thing although I have built web sites before, I have never used php/ mySQL before, so please humour me! I followed the instructions and my installation went very smoothly. However, once I had finished changing the permissions as shown on the documentation.pdf, I now receive the following error on my page mydomain/catalog/index.php: Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/anthonylane13.onlinewebshop.net/catalog/includes/functions/database.php on line 19 Unable to connect to database server! I have no idea what this means or how to fix it... please advise. Thanks Hi Thanks so much for helping me - I think I may have come across the problem here... I have had a look at the configure.php files in catalog/includes and in admin/catalog/includes One contains all my database details, the other has a list of empty definitions eg define('DB_SERVER_USERNAME', ''); etc. I have an intuition that these files should be the same? Am I right? Your advice is very much appreciated. Thank you Anthony Link to comment Share on other sites More sharing options...
anthonylane13 Posted October 20, 2007 Author Share Posted October 20, 2007 Check your configuration files (found in catalog/includes and catalog/admin/includes directories). It looks like the database you set up is not corresponding to the information (db name, user id and password) found in your configure.php fiels. Hi Thanks so much for helping me - I think I may have come across the problem here... I have had a look at the configure.php files in catalog/includes and in admin/catalog/includes One contains all my database details, the other has a list of empty definitions eg define('DB_SERVER_USERNAME', ''); etc. I have an intuition that these files should be the same? Am I right? Your advice is very much appreciated. Thank you Anthony (as you can see I am still a bit of a dufus with all this - I just replied to my own question.....) Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2007 Share Posted October 22, 2007 yes.It should be the same.Just correct it.how that happen with fresh install? Link to comment Share on other sites More sharing options...
anthonylane13 Posted October 22, 2007 Author Share Posted October 22, 2007 yes.It should be the same.Just correct it.how that happen with fresh install? Hi Thanks - I corrected it and it works! It's probably my lack of experience with my ftp - I was messing around with the permissions and must have accidentally re-sent the file to the server from my desktop. (My ftp does it automatically if you double click - I was expecting to see it in an editor...). Thanks for your support. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.