eeleek Posted July 16, 2003 Share Posted July 16, 2003 hey guys my link to my test store is (or was)http://24.47.169.144:2307/catalog/ it worked fine for 2 weeks straight my server is still up but i tried everything and my catalog wont go it says : Unable to connect to database server! what can i do ? Im afraid all my database is gone now :( please if anyone can tell me what to do - or restart the server or something, anything? Im desperate? Thanks eeleek. Ilan` Link to comment Share on other sites More sharing options...
Mark1 Posted July 16, 2003 Share Posted July 16, 2003 Did you change the password to your database server in the past few days? Mark Link to comment Share on other sites More sharing options...
eeleek Posted July 16, 2003 Author Share Posted July 16, 2003 No, i haven't i left ,y server running and i left town i checked everything and it was all fine today. just a few hours ago it gave me that message :/ i have no idea why Ilan` Link to comment Share on other sites More sharing options...
Mark1 Posted July 16, 2003 Share Posted July 16, 2003 Does the problem present itself on both the user side and the admin side? If so, you likely have a database problem. If not, there is possibly something wrong on the hosting side (possibly needing a reset) or your catalog/includes/configure.php and or your catalog/admin/includes/configure.php files may need looking at. Mark Link to comment Share on other sites More sharing options...
davechl Posted July 16, 2003 Share Posted July 16, 2003 No, i haven't i left ,y server running and i left town i checked everything and it was all fine today. just a few hours ago it gave me that message :/i have no idea why I'm experiencing a similar problem. I was just working on it today and tonight I can't connect to the DB. I get this message: Warning: Can't connect to MySQL server on 'localhost' (10061) in c:apachehtdocscatalogincludesfunctionsdatabase.php on line 19 Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' (10061) in c:apachehtdocscatalogincludesfunctionsdatabase.php on line 19 Unable to connect to database server! Line 19 sets the connection to the DB with username and password. I'm running Apache. Any advice on where/what I can check to make sure the connection works again? Link to comment Share on other sites More sharing options...
eeleek Posted July 16, 2003 Author Share Posted July 16, 2003 Hey i found out that my mysql server shutdown for some reason, i checked the event viewer of windows and it says the service failed: my mysql on xp stopped for some reason and when i try "net start mysql" i get: "System error 3 has occurred, The system cannot find the path specified." (my sql is installed on c:mysql and my.ini file set correctly) :/ anyone please? i double checked my my.ini file. i have no clue why this is happeneing my catalog was running perfect until today (was running nice 2 weeks that means my mysql server was running to) but when i try "mysql" it says the serer is not running. and i cant run it again : "System error 3 has occurred, The system cannot find the path specified." can anyone help ? i havn't changed anyhting in settings. Ilan` Link to comment Share on other sites More sharing options...
ElLeonBlanco Posted July 16, 2003 Share Posted July 16, 2003 Question 1: Are you running on Linux or Windows? 8) *If windows see bottom of post. :? Question 2: Can you connect to the db by command line? Question 3: Ever thought about placing a GUI application like MySQL Front or MySQL CC on the DB localhost? Question 4: Were you smart enough to change the root login to your db? :?: Ok, now for the fun part. MySQL should NOT run on the same machine as your Apache server. TRUST ME ON THIS. You need to set it up to run all alone on it's own pc behind a local nonroutable firewalled network. Give it a LOCAL IP only like 192.168.0.15 and place a second network card in the web server that has a similar LOCAL nonrouteable IP like say 192.168.0.10. This ISOLATES your DB server from the rest of the known world. Set the admin user on the db to handle just that ADMIN. Then go to DB Server. Open GUI interface and create your DB Set that db to ONLY connect to nonrouteable IP of webserver as accepted host, set a username and password exclusivly for that host's IP DB connection. Set the minimal required priveledges the webserver needs to access db server. Then for safteys sake load all your .sql files and updates through GUI on DB server. AFTER MAKING A BACKUP!!! :!: Have 3 Db servers running MySql here on LINUX Red Hat of course and have had NO problems whatsoever in 6 months. :D FYI: In the past I have run MySQL on a WIN 2k an XP platform. Always crashed and always developed wierd problems. :( Sorry for my long rants and raves but for serious business you need OsCommerce, LINUX, APACHE, PHP4, and MySQL. They were written to work together and perform like they should when used TOGETHER. WINDOWS IS FOR WIMPS! That are afraid of learning what it takes to be serious about E-commerce. :wink: *IF WINDOWS YOU HAVE JUST ANSWERED ALL YOUR PROBLEMS. :twisted: ElLeonBlanco "The man of genius makes no mistakes. His errors are volitional and are the portals of discovery." James Joyce (1882?1941) Link to comment Share on other sites More sharing options...
davechl Posted July 17, 2003 Share Posted July 17, 2003 So do you think the error message about "line 19 of database.php" or any other part of this file is at fault? Rather, it's the database? Link to comment Share on other sites More sharing options...
Guest Posted July 17, 2003 Share Posted July 17, 2003 I have just spent the last 5 hours on the same fault:- Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' c:catalogincludesfunctionsdatabase.php on line 19 Unable to connect to database server! .. ended up being the database wasn't registered with MySQL properly.. reinstalled it and it worked fine...the fix took 5 minutes, in finding took 5 hours :) Link to comment Share on other sites More sharing options...
davechl Posted July 17, 2003 Share Posted July 17, 2003 I have just spent the last 5 hours on the same fault:- Warning: MySQL Connection Failed: Can't connect to MySQL server on 'localhost' c:catalogincludesfunctionsdatabase.php on line 19 Unable to connect to database server! .. ended up being the database wasn't registered with MySQL properly.. reinstalled it and it worked fine...the fix took 5 minutes, in finding took 5 hours :) What did you have to do with oscommerce catalog before reinstalling? 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.