meander Posted March 9, 2007 Posted March 9, 2007 I'm nervous about posting this because I see people in forums get really irritated and snippy with other people. It scares me away from asking a question, but I really want to understand. I haven't belonged to this forum long enough to judge the 'feel' here, but people seem very intelligent and thorough. I've searched a variety of things and not found my situation, so I'd like to try here. I'm sure it's simple, but I don't know almost anything about MySQL or PHP, and perhaps I SHOULD know more before continuing. I'm working on fixing that, but if anyone has any suggestions of a beloved reading material or source for learning, feel free to suggest it. On to the problem:: My sister was helping me go through Vger's quick install guide and as I get down to number five where you begin the install proceedure, I've filled out all the database information accurately and elect to store sessions in the database and have not enabled persistent connections... everything seems fine. I submit and am returned the message: "New Installation Database Import A test connection made to the database was NOT successful. The error message returned is: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46) Please click on the Back button below to review your database server settings. If you require help with your database server settings, please consult your hosting company." Now, someone might say that was my first sign that this question doesn't belong here. I -know- that I know nearly nothing about databases, and maybe I'm in over my head. But I'd like to think I can learn, and I'm just curious if someone can even direct me to whether this IS a hosting company issue or an osCommerce issue and what I can do, because I don't even understand what the error message is telling me happened. My web hosting company doesn't have a helpful community like this, so I wanted to try here first. : ) Thank you anyone who might let me know where I can even start, what my problem might be, or where might be the best start to brush up on these systems so I can be more self-reliant in the future. Have a wonderful day!
spax Posted March 9, 2007 Posted March 9, 2007 I'm nervous about posting this because I see people in forums get really irritated and snippy with other people. It scares me away from asking a question, but I really want to understand. Don't be so silly! WHAT'S THE MATTER WITH YOU?????? :angry: Just kidding! :D Obvious one first, did you create a blank database before attempting osC installation? If you did, did you define the database server correctly in the configure files? It is usually localhost or 127.0.0.1 but not always. If you have it as one of those, check with your host as to the correct address. define('DB_SERVER', 'localhost');
meander Posted March 17, 2007 Author Posted March 17, 2007 Don't be so silly! WHAT'S THE MATTER WITH YOU?????? :angry: Just kidding! :D Obvious one first, did you create a blank database before attempting osC installation? If you did, did you define the database server correctly in the configure files? It is usually localhost or 127.0.0.1 but not always. If you have it as one of those, check with your host as to the correct address. define('DB_SERVER', 'localhost'); Thank you very much! I've been trying to figure this out, using your help. It took me a while to even understand what you mean. I'm sorry, I kind of feel like I'm over my head, but like I said.. I'm trying very hard to learn and I appreciate your patience! I've tried both localhost and 127.0.0.1 in the configuration of my instal and get the same error (replacing 127.0.0.1 with local host as the failure to connect location when I've tried the IP address instead, of course.) I'm trying hard to search out info on my own and get what you mean- you said to check with my host as to the correct address. Do you mean to find out my IP address? You wrote " define('DB_SERVER', 'localhost');" is that a code I can put in somewhere to have it tell me what it is? Working on it as we speak... Man, I used to feel so smart with my silly HTML years ago. : ) It's all gotten so advanced! I don't know if this might help to show:: Once I try to go look at my database information to try to figure out what to do, I'm faced with this control panel http://img.photobucket.com/albums/v255/mea...us/help01-1.jpg I clicked on the databases section to see what I had going on:: http://img.photobucket.com/albums/v255/meanderous/help02.jpg I think it might show all those phpmyadmin databases and the galleries because the only way I could find to get into this control panel is by reinstalling it and my sister tried installing a gallery to initiate some kind of database (the webhoster offered the galleries, and when she was having trouble with her firefox browser, she tried opening a gallery to see if it would help "make it work")... So I'm going to keep reading on their instructions on how to use these programs, but maybe this will help show where I'm at?
spax Posted March 17, 2007 Posted March 17, 2007 You wrote " define('DB_SERVER', 'localhost');" is that a code I can put in somewhere to have it tell me what it is? No, that is how osC knows where the database server is located. It is defined in your 2 configure files, which you can find at: includes/configure.php admin/includes/configure.php Download them to your hard drive so you can make changes, if necessary. Remember which is which though. Usually, the databse server is "localhost" or "127.0.0.1" but it isn't always. It could be mysql_your_domain for example. The best thing would be to contact your host and ask them the address.
meander Posted March 19, 2007 Author Posted March 19, 2007 No, that is how osC knows where the database server is located. It is defined in your 2 configure files, which you can find at: includes/configure.php admin/includes/configure.php Download them to your hard drive so you can make changes, if necessary. Remember which is which though. Usually, the databse server is "localhost" or "127.0.0.1" but it isn't always. It could be mysql_your_domain for example. The best thing would be to contact your host and ask them the address. Thank you for all your help. I'm going to keep studying and try to get more on the same page with you and other people. I appreciate all your help, but I still don't get what you're saying and I don't think it's fair of me to keep asking for tips when I can't even make sense of the replies. You're a doll- Take it easy!
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.