netmaster Posted February 10, 2004 Share Posted February 10, 2004 Hi I can?t install oscommerce in my Webb hotel. I fill in login information etc and when I click on next error message "no contact with DB". Webb hotel Adim said they have Mysql 4 servers and my script can be old. I had registered my db account before installation. And I must use web hotel control panel. Please help me! Link to comment Share on other sites More sharing options...
FIMBLE Posted February 10, 2004 Share Posted February 10, 2004 I doubt very much if the script is old! More like the database is either set up incorrectly or, the incorrect user name is being used. Nic Sometimes you're the dog and sometimes the lamp post [/url] My Contributions Link to comment Share on other sites More sharing options...
netmaster Posted February 22, 2004 Author Share Posted February 22, 2004 Cpanel and PHP Myadmin solutions: Pre installation: Use PHP Myadmin: 1. Create a database 2. Import the file oscommerc.sql to the DB. Use button ?location to your textfile?. Then use ?GO? Installation: 1. Use your browser and go to your server/catalog/install 2. Unselect import a DB 3. Fill in your information about DB etc. Note you shall use your Cpanel admin password and username. Not your DB Myadmin password and username. Link to comment Share on other sites More sharing options...
swbchen Posted February 27, 2004 Share Posted February 27, 2004 1. Create a database >>> say : eshop 2. Import the file oscommerc.sql to the DB. Use button ?location to your textfile?. Then use ?GO? step 2:: (during http://...../phpmyAdmin/index.php ????)where and how to import the file oscommerce.sql to the DB ???? can you give me a picture to show it ???? Link to comment Share on other sites More sharing options...
swbchen Posted February 27, 2004 Share Posted February 27, 2004 Note you shall use your Cpanel admin password and username. Not your DB Myadmin password and username. admin password and username >>>> is the system operator(webmaster) username and password????? Link to comment Share on other sites More sharing options...
netmaster Posted February 27, 2004 Author Share Posted February 27, 2004 My Webb Hotel use Cpanel. This is my Webb administration login account. To create DB there I use Mysql admin in Cpanel. So I use Mysql admin to import Oscommerc.sql file and create a DB (eshop) name. Pre installation (log in to your Cpanel admin account) 1. Open Mysql in Cpanel (If you have this system) 2. Open (your new created eshop DB) and go to SQL (query) 3. Import the file oscommerc.sql to the DB. Use button ?location to your textfile?. Then use ?GO?. This file can bee in your own PC at home. This file is in oscommerce-2.2ms2 zip file. (unzipped on your PC) 4. Now you have the files in your DB (eshop). Installation In my case to reach DB in installation mode you must use Cpanel admin login (username and password). After installation you can use /www.your_webb_address/catalog/admin 1. Use your browser and go to your server(www.your_webb_address) /catalog/install 2. Unselect import a DB (you have already created in Mysql) 3. Fill in your information about DB etc. Note you shall use your Cpanel admin password and username. Not your DB Myadmin password and username. B) Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2004 Share Posted February 27, 2004 I have the same installation problem as the member who started this thread. In your reply above you said: "1. Open Mysql in Cpanel (If you have this system) 2. Open (your new created eshop DB) and go to SQL (query) 3. Import the file oscommerc.sql to the DB. Use button ?location to your textfile?. Then use ?GO?. This file can bee in your own PC at home. This file is in oscommerce-2.2ms2 zip file. (unzipped on your PC)" I have been unable to locate this file on my PC. Is there somewhere that I can download it?? Thanks for your time keeweelad Link to comment Share on other sites More sharing options...
netmaster Posted February 27, 2004 Author Share Posted February 27, 2004 Hi You can downlod from http://www.oscommerce.com/downloads Filename oscommerce-2.2ms2.zip (unzip!). I think you can have problem if you don?t have this file! :blink: You must upload the rest of the files in the zip with your FTP. Instrutions can you find http://www.oscommerce.com or in Forum. Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2004 Share Posted February 27, 2004 Hi Jan; Thank you for such a prompt reply - I appreciate that. I have previously downloaded oscommere-2.2ms2.zip and that has been unzipped successfully. Is it your advice that I download the complete package again? keeweelad Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2004 Share Posted February 27, 2004 Hi again; I have now got the missing file sorted out OK and have followed your previous instructions regarding setting up. Having entered my user id and password from cPanel plus the other required info I get the following error message: A test connection made to the database was NOT successful. The error message returned is: Access denied for user: '[email protected]' (Using password: YES) Please click on the Back button below to review your database server settings. What am I doing wrong ?? How do I proceed from here? bemused keeweelad Link to comment Share on other sites More sharing options...
netmaster Posted February 28, 2004 Author Share Posted February 28, 2004 Hi again You can go to install again. Your /catalog/install But uncheck import DB. Check use auto config. Check: This is auto filled. 1. www address: http://www.your_site.com 2. webserver root: /?/www/html/catalog 3. http cookie domain:??? 4. http cookie path?? 5. ??. USE SSL ?YES? if your Webb hotel have this function. oscommerce config 1. DB server: localhost 2. Username: Cpanel name 3. Password: Cpanel passw 4. DB namne: eshop_eshop (something) 5. Persistent Connection:Yes 6. Session Storage: Database Link to comment Share on other sites More sharing options...
user99999999 Posted February 28, 2004 Share Posted February 28, 2004 Try using localhost for your server name. Link to comment Share on other sites More sharing options...
steveo_uk Posted March 16, 2004 Share Posted March 16, 2004 Hi im also new to php and mysql, I get exactly the same error on my machine and cant seem to fix the issue. i'm running IIS6 , php and mysql. The MySql seems to work ok can create databases and show the results. I have read the oscommerce notes but dont understand what the Note: Create and Drop permissions are required at this point of the installation procedure. This first user should have CREATE privileges on the database means. can you please explain what a cpanel name is ? and how does one set one up. regards Stephen Link to comment Share on other sites More sharing options...
steveo_uk Posted March 16, 2004 Share Posted March 16, 2004 ignore the last post downloaded navicat for windows and that solved the problem 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.