joeabouata Posted April 24, 2004 Posted April 24, 2004 I'm hung up on step 3 In IE I type in http://www.sonomaphoneman.com/catalog/install/ to install this free e-commerce store. I'm importing the blank database I created, so the info I entered and the response I received: Database Server: 100megs27.com Username: "my database user name" Passwd: "my database user name's passwd" Database name: "my database's name" I hit enter, and the page reads: ****** 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. If you require help with your database server settings, please consult your hosting company. heeellpp ****
Databuilder Posted April 24, 2004 Posted April 24, 2004 Try this define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
241 Posted April 24, 2004 Posted April 24, 2004 Database Server: 100megs27.com whereas the error has megs27.100mwh.com so you need Database Server: megs27.100mwh.com No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
joeabouata Posted April 25, 2004 Author Posted April 25, 2004 Thanks, I tried adding: megs27.100mwh.com I still received the same 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. If you require help with your database server settings, please consult your hosting company.
santafefleamarket.com Posted April 25, 2004 Posted April 25, 2004 Hi, I'm having problems with the same step using a Mac. If you figure this out would you let me know? Is the password supposed to be the same as for the web site? Rand
AlanR Posted April 26, 2004 Posted April 26, 2004 The db user password is usually not the same as your hosting access pw. Check your controls, it wll tell you what the db user name is and will usually give you the option of changing the password. Being on a Mac has nothing to do with it. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 I've been reading the documents in the Wiki site http://wiki.oscommerce.com/docsInstallNew and it seems to be saying that the mysql database doesn't come with this installation. Do we have to go somewhere else and get a database in order for this to work? I haven't seen that said anywhere. But, I am really new to this. Pardon me for bringing this up, but the instructions I got with the program are these: "Once having downloaded the archive from the downloads page, follow these steps to get the online shop running: 1. Extract the files from within the package unzip oscommerce-2.2ms2.zip -- or -- tar -xzf oscommerce-2.2ms2.tar.gz -- or -- use your favourite graphical application to extract the files, such as WinZip (http://www.winzip.com) 2. This creates a directory called 'oscommerce-2.2ms2'. Enter this directory and copy the 'catalog' directory to the webroot path of your webserver: cd oscommerce-2.2ms2 cp -R catalog /usr/local/apache/htdocs/ For this example, '/usr/local/apache/htdocs/' is used as the webroot path of the Apache webserver. Do the same for the 'admin' directory but rename the directory to a unique and secret name. This directory does not have to reside inside the catalog directory, though may need to be manually configured. 3. Using your favourite browser, go to the following address: http://[your site]/catalog/install and follow the instructions on the screen." I understood this to mean I take the downloaded files and upload them into the public.html folder on my server. Then using my browser, find domainname.com/catalog/install... Is there something implied in there that I missed? Warmest regards and my sincere thanks to anyone who understands this stuff!
DnJ Posted April 26, 2004 Posted April 26, 2004 There is a sample database included in the osc snapshot that when you run the install script will access mysql on your server and create the database tables required to work with oscommerce. When you run the install script you will be required to provide information about your database server as well as your local or web server "One Of Life's Greatest Pleasures Is Doing What Others Say You Can't"
AlanR Posted April 26, 2004 Posted April 26, 2004 Is there something implied in there that I missed? Warmest regards and my sincere thanks to anyone who understands this stuff! Yep. :lol: Your hosting account should include a mySQL account which is an account which will use the database server associated with your hosting account. Asking if osC provides this is kinda like asking if osC comes with a web hosting account. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 Hey Joe, The first thing I learned is that you have to set up your database. I contacted my host and found how to set up the mysql database. You name it and choose your username and password. Unfortunately it didn't help at all, I still get the same error message as before: "Can't connect to MySQL server on 'db1.godaddy.com' (111)"
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 I must be getting warmer. I'm getting a new error message: Unknown MySQL Server Host 'phpmysqladmin.secureserver.net' (0) Does it take a while for them to set up or is it immediate? Any takers? Advance gratitude for anyone who understands this stuff.
AlanR Posted April 26, 2004 Posted April 26, 2004 You're going to have to go into whatever control panel godaddy provides and find the correct information. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 I did! I managed to get it working - sort of... These are the error messages I am now getting: Warning: fopen(): open_basedir restriction in effect. File(/home/andallwest/public_html\includes/configure.php) is not within the allowed path(s): (/home/content/a/n/d/andallwest) in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 209 Warning: fopen(/home/andallwest/public_html\includes/configure.php): failed to open stream: Operation not permitted in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 209 Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 210 Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 211 Warning: fopen(): open_basedir restriction in effect. File(/home/andallwest/public_html\admin/includes/configure.php) is not within the allowed path(s): (/home/content/a/n/d/andallwest) in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259 Warning: fopen(/home/andallwest/public_html\admin/includes/configure.php): failed to open stream: Operation not permitted in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259 Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 260 Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 261 The configuration was successful!
Guest Posted April 26, 2004 Posted April 26, 2004 perhaps you should find your proper document root path. place this into a file, name it test.php and put it into your root, ie would be called like this: http://www.domain.com/test.php <?php phpinfo(); ?> Then search for the word 'document' you will find your document root how your host has it defined.
linkfm Posted April 26, 2004 Posted April 26, 2004 I m new to this stuff and faced same problems when I was trying to install osC ... well here r some tips that may help u as i get installed my osC through this way... try to used "localhost" instead of any server name make databse base as little as u can like "dname_db" dname="ur domain user name" db="database name" before installation create a database, a user and asign database for that user. use "MySQL Databases" option in ur cpanel to make a database...
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 Bless you both for your dedication, and thank you. I will remember the "localhost" and to keep filenames short. I ran that script and it gave me a lot of information, but I don't know what it means. http://www.santafefleamarket.com/test.php Warmest regards.
AlanR Posted April 26, 2004 Posted April 26, 2004 This is what you want from that page DOCUMENT_ROOT /home/content/a/n/d/andallwest/html so the corresponding line in /catalog/includes/configure.php should be: define('DIR_FS_CATALOG', '/home/content/a/n/d/andallwest/html/catalog/'); Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
Guest Posted April 26, 2004 Posted April 26, 2004 santefe, just so you know, i searched your php file, it does not have 'curl' installed, so you may have some problems with some payment modules. so before going to much more, you should check that portion, if you will need to use curl, then i suggest going to another host
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 Hey Mibble, Thanks for the headsup. Where would you suggest? and What else do I need? And, dare I ask, is there a place that lists what we need to run this program? Not to put too fine a point on it, but first I needed Mysql, now curl, what else....? I have a suggestion for the docs folks. Anyway, thanks again. I doubt I will ever be able to write any php, but I am deeply grateful for those of you who can help.
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 This is what you want from that page DOCUMENT_ROOT /home/content/a/n/d/andallwest/html so the corresponding line in /catalog/includes/configure.php should be: define('DIR_FS_CATALOG', '/home/content/a/n/d/andallwest/html/catalog/'); How do I do this, please?
Guest Posted April 26, 2004 Posted April 26, 2004 use the above where it asks for document root and double check your configure.php files.
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 Thanks, John, but I haven't a clue what you mean. I tried http://santafefleamarket.com/catalog/configure.php and got error 404 Page Not Found. Can you be more specific? I'm greener than you can imagine! Thank you for your patience with us newbys.
Guest Posted April 26, 2004 Posted April 26, 2004 it sounds like you should go back to the basics, and read the documentation on the software, as what you are asking is explained there. also, go search the net for php tutorials, mysql tutorials. what kind of server are you using? if apache, go to apache.org and read through how paths work, how to manage servers, etc.
AlanR Posted April 26, 2004 Posted April 26, 2004 Change the permissions (chmod to 777 or rrr, www, eee) on the catalog/includes/configure.php catalog/admin/includes/configure.php files with your ftp program and run the installer again. Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
santafefleamarket.com Posted April 26, 2004 Posted April 26, 2004 Changed the permissions in both places. Got this message. "Warning: fopen(/home/content/a/n/d/andallwest/html/catalog/admin/includes/configure.php): failed to open stream: No such file or directory in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 259 Warning: fputs(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 260 Warning: fclose(): supplied argument is not a valid stream resource in /home/content/a/n/d/andallwest/html/catalog/install/templates/pages/install_7.php on line 261 The configuration was successful!"
Recommended Posts
Archived
This topic is now archived and is closed to further replies.