Guest Posted July 3, 2007 Posted July 3, 2007 This is becoming a nightmare. I've tried everything I could find from a google search... I'm desperate. :P Anyway, I go through the installation and everything is great, until I reach the last screen. A bunch of warnings pop up: Warning: fopen(/inetpub/vhosts/gamers-retreat.com/subdomains/httpdocs/catalog/includes/configure.php): failed to open stream: No such file or directory in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 209 Warning: fputs(): supplied argument is not a valid stream resource in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 210 Warning: fclose(): supplied argument is not a valid stream resource in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 211 Warning: fopen(/inetpub/vhosts/gamers-retreat.com/subdomains/httpdocs/catalog/admin/includes/configure.php): failed to open stream: No such file or directory in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 259 Warning: fputs(): supplied argument is not a valid stream resource in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 260 Warning: fclose(): supplied argument is not a valid stream resource in C:\Inetpub\vhosts\gamers-retreat.com\subdomains\shop\httpdocs\catalog\install\templates\pages\install_7.php on line 261 I've tried everything to fix this, but nothing works! Any help at all would be greatly appreciated. :)
spax Posted July 4, 2007 Posted July 4, 2007 This is probably because your two configure.php files are Read Only. You'll need to go into your control panel, select the file manager and change their properties so osCommerce can write to them. Alternatively, you can download them and manually input the information. Whichever way you do it, once they have been written, you need to make them Read Only again.
Guest Posted July 4, 2007 Posted July 4, 2007 If you mean /catalog/includes/configure.php, /catalog/admin/configure.php, or /catalog/admin/configuration.php, then I've tried that. Doesn't work.
Guest Posted July 4, 2007 Posted July 4, 2007 If it helps, when I click administration tool, I get this: Warning: mysql_connect(): Access denied for user 'mysql'@'localhost' (using password: NO) in C:\Inetpub\vhosts\gamers-retreat.com\httpdocs\shop\catalog\admin\includes\functions\database.php on line 19 Unable to connect to database server!
spax Posted July 4, 2007 Posted July 4, 2007 Looks like you haven't put in the correct database username and/or password in the configure files. Are the files completely populated?
Guest Posted July 4, 2007 Posted July 4, 2007 the database is populated. What files are you asking about?
Guest Posted July 4, 2007 Posted July 4, 2007 If you are setting this up online then you need to create the data base first, then create a user for the data base, finally add the user to the database. This is done via PHPMyadmin (access this through your hosting control panel). Sometime though (just to confuse a newbie) when you create a data base and name it "osc" it will add your hosting account name to the beginning so it will be "hostingaccountname_osc". The same for the username. Be sure to check this before entering the information into the database part of the install process.
spax Posted July 4, 2007 Posted July 4, 2007 the database is populated. What files are you asking about? Sorry, I was asking about the configure files. Do they have all the information needed or are some of the definitions empty?
Guest Posted July 4, 2007 Posted July 4, 2007 If the Data Base is populated then your server probably added your hosting accounts user name to the front of the data base name and user name. If that is the case you can just make the changes in your 2 configure.php files.
Guest Posted July 4, 2007 Posted July 4, 2007 Alright, I checked the configure.php files and the spaces are blank, so I think that's the problem. I've set permissions to allow read/write etc. Is there any way to check the database name? I made the database 'shop' and the username 'shop' and when I go into phpmyadmin, it says shop as well, so I don't think this is the problem. Thanks for the help so far. :)
Guest Posted July 4, 2007 Posted July 4, 2007 Try changing your catalog/includes/configure.php file to the settings below (???????? is where your REAL password is entered) // define our database connection define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', 'shop'); define('DB_SERVER_PASSWORD', '?????????); define('DB_DATABASE', 'shop'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql' Then save the file back to the server and open your store in a browser (www.yourdomain.com). If that works then also edit your catalog/admin/includes/configure.php file. After it works the permissions for those files should be set to 644.
spax Posted July 4, 2007 Posted July 4, 2007 Alright, I checked the configure.php files and the spaces are blank, so I think that's the problem. I've set permissions to allow read/write etc. Is there any way to check the database name? I made the database 'shop' and the username 'shop' and when I go into phpmyadmin, it says shop as well, so I don't think this is the problem. Thanks for the help so far. :) Some server setups won't allow you to use CHMOD for permissions. The fact that the configure files are blank means that osC cannot write to them - Read Only - which is why you got the errors you quote in your first post. If you have a control panel, look for a file manager option. From that, you should be able to change permissions. If not, you could contact your host and ask them to set permissions temporarily to 777 so you can complete the install. Otherwise, you can try downloading the files and manually entering the information. Your host can tell you all your database information - db server, db name, username, password - but if it is what you stated, "shop", then use Web Host's example for that. The one that might need changing is the DB_SERVER. It could be localhost but it could be something entirely different. You should be able to see that from phpmyadmin, on the landing page where it says Server:
d4funky1 Posted July 4, 2007 Posted July 4, 2007 check that your db_server is actually called localhost i know that some are called mysql01 and some give a random name. go into phpmyadmin then click on your relevant database name. the server name should be there.
Guest Posted July 5, 2007 Posted July 5, 2007 Alright, so I got it configured, but now the admin panel isn't working right.... :( I manually configured the admin configure as well, and I can get to the admin control panel, but I get 404 errors every time I click a link. Sorry for all the trouble. :(
Guest Posted July 5, 2007 Posted July 5, 2007 Alright, I figured the problem out, but I don't know the solution :P . Whenever I click a button on the admin panel I need to add to the url /catalog/ between ".com" and "/admin/" Anyone know how to fix this?
Guest Posted July 5, 2007 Posted July 5, 2007 Can you post both your configure.php files leaving out the database information at the bottom.
Guest Posted July 5, 2007 Posted July 5, 2007 They're both the same. <?php /* $Id: configure.php,v 1.14 2003/07/09 01:15:48 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', ''); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', ''); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', ''); define('HTTPS_COOKIE_PATH', ''); define('DIR_WS_HTTP_CATALOG', ''); define('DIR_WS_HTTPS_CATALOG', ''); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); //DATABASE STUFF IS HERE ?> I thought I would need to configure other things in this,is that true?
Guest Posted July 5, 2007 Posted July 5, 2007 oops, just noticed, they are different... :P This one is the admin/includes/configure.php <?php /* $Id: configure.php,v 1.14 2003/02/21 16:55:24 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2002 osCommerce Released under the GNU General Public License */ // define our webserver variables // FS = Filesystem (physical) // WS = Webserver (virtual) define('HTTP_SERVER', ''); // eg, http://localhost or - https://localhost should not be NULL for productive servers define('HTTP_CATALOG_SERVER', ''); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', $DOCUMENT_ROOT); // where your pages are located on the server. if $DOCUMENT_ROOT doesnt suit you, replace with your local path. (eg, /usr/local/apache/htdocs) define('DIR_WS_ADMIN', '/admin/'); define('DIR_FS_ADMIN', DIR_FS_DOCUMENT_ROOT . DIR_WS_ADMIN); define('DIR_WS_CATALOG', '/catalog/'); define('DIR_FS_CATALOG', DIR_FS_DOCUMENT_ROOT . DIR_WS_CATALOG); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); //DATABASE STUFF ?> Thanks again for all you've done.
spax Posted July 5, 2007 Posted July 5, 2007 Your store being served from the catalog directory and assuming no SSL certificate, they should look like this: includes/configure.php <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://www.your_domain.com'); // eg, http://localhost - should not be empty for productive servers define('HTTPS_SERVER', ''); // eg, https://localhost - should not be empty for productive servers define('ENABLE_SSL', false); // secure webserver for checkout procedure? define('HTTP_COOKIE_DOMAIN', 'www.your_domain.com'); define('HTTPS_COOKIE_DOMAIN', ''); define('HTTP_COOKIE_PATH', '/catalog/'); define('HTTPS_COOKIE_PATH', ''); define('DIR_WS_HTTP_CATALOG', '/catalog/'); define('DIR_WS_HTTPS_CATALOG', ''); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_DOWNLOAD_PUBLIC', 'pub/'); define('DIR_FS_CATALOG', '/path/to/public_html/your_domain.com/catalog/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); // DB Stuff ?> admin/includes/configure.php <?php /* osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License */ // Define the webserver and path parameters // * DIR_FS_* = Filesystem directories (local/physical) // * DIR_WS_* = Webserver directories (virtual/URL) define('HTTP_SERVER', 'http://www.your_domain.com'); // eg, http://localhost - should not be empty for productive servers define('HTTP_CATALOG_SERVER', 'http://www.your_domain.com'); define('HTTPS_CATALOG_SERVER', ''); define('ENABLE_SSL_CATALOG', 'false'); // secure webserver for catalog module define('DIR_FS_DOCUMENT_ROOT', '/path/to/public_html/your_domain.com/catalog/'); // where the pages are located on the server define('DIR_WS_ADMIN', '/catalog/admin/'); // absolute path required define('DIR_FS_ADMIN', '/path/to/public_html/your_domain.com/catalog/admin/'); // absolute pate required define('DIR_WS_CATALOG', '/catalog/'); // absolute path required define('DIR_FS_CATALOG', '/path/to/public_html/your_domain.com/catalog/'); // absolute path required define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/'); define('DIR_WS_CATALOG_IMAGES', DIR_WS_CATALOG . 'images/'); define('DIR_WS_INCLUDES', 'includes/'); define('DIR_WS_BOXES', DIR_WS_INCLUDES . 'boxes/'); define('DIR_WS_FUNCTIONS', DIR_WS_INCLUDES . 'functions/'); define('DIR_WS_CLASSES', DIR_WS_INCLUDES . 'classes/'); define('DIR_WS_MODULES', DIR_WS_INCLUDES . 'modules/'); define('DIR_WS_LANGUAGES', DIR_WS_INCLUDES . 'languages/'); define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . 'includes/languages/'); define('DIR_FS_CATALOG_IMAGES', DIR_FS_CATALOG . 'images/'); define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . 'includes/modules/'); define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/'); // DB Stuff ?> Obviously change the information to your own.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.