elchillum Posted April 13, 2004 Posted April 13, 2004 (i also started this one in the wrong section so thats why i post it again in the right one ;) ... my appolegies ...) --> this was my post ... hello guys ... like many of you i need a online webstore for a middle big company ... they asked me to install the thing ... first i uploaded the catalog file and all the things went as planned ... i inserted the host / username / password of the mysql settings etc ... then after clicking a few times proceed ... (with all codes and underneeth 'the configuration was successfull) i want to click to administration tool ... but i get this error ... Warning: mysql_connect(): Can't connect to MySQL server on 'localhost' (10061) in D:\Inetpub\webs\tripleit\ecommerce\catalog\admin\includes\functions\database.php on line 19 Unable to connect to database server! ---> first of all i dont understand what D:\Inetpub\webs\tripleit\ecommerce\catalog\admin\includes\functions\database.php stands for ... i also tried to put another url there but doesnt work either ... maybe someone of the smarter persons regarding php and databases could help me out to finally start my online store the server is windows 2000 hosting i guess ... i can access the database in the admin panel of my hosting company ... i have no idea if i can access the database with prompt ... stream resource in D:\Inetpub\webs\tripleit\ecommerce\catalog\install\templates\pages\install_7.php on line 210 Warning: fclose(): supplied argument is not a valid stream resource in D:\Inetpub\webs\tripleit\ecommerce\catalog\install\templates\pages\install_7.php on line 211 Warning: fopen(D:/Inetpub/webs/tripleit/ecommerce/catalog/install/oscommerce.sql\admin/includes/configure.php): failed to open stream: No such file or directory in D:\Inetpub\webs\tripleit\ecommerce\catalog\install\templates\pages\install_7.php on line 259 Warning: fputs(): supplied argument is not a valid stream resource in D:\Inetpub\webs\tripleit\ecommerce\catalog\install\templates\pages\install_7.php on line 260 Warning: fclose(): supplied argument is not a valid stream resource in D:\Inetpub\webs\tripleit\ecommerce\catalog\install\templates\pages\install_7.php on line 261 The configuration was successful! maybe this is usefull info ... thanx in advance, el chillum
elchillum Posted April 13, 2004 Author Posted April 13, 2004 btw in my mysql panel there i see all the files installed ... i mean... there is a connection problem but the files are there ... please help me out ... :blink: ;) el chillum
tdupres Posted April 13, 2004 Posted April 13, 2004 Hi Have you checked the configure.php file in the admin/includes folder. You can change the path to your SQL server in this file. Might be the problem?
elchillum Posted April 13, 2004 Author Posted April 13, 2004 Hi Have you checked the configure.php file in the admin/includes folder. You can change the path to your SQL server in this file. Might be the problem? ;) hi thanx for the help ... isnt it risky to put username and password in this document? ... if pple download it and then open it with notepad cant they hack my mysql server? ... for the rest this is the config.php doc: // 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/'); // define our database connection define('DB_SERVER', ''); // eg, localhost - should not be empty for productive servers define('DB_SERVER_USERNAME', ''); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'osCommerce'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' ?> --> this is a whole lot to fill in for a non expert like me ... enable ssl? ... cookies http? ... dunno what to fill in there ... define usepconnect, false etc ... please gimme some indications .... then ill change it and upload it to my server ;) ps: as mentionned above...in the database on mysql admin panel i see that there are files installed ;) greetz, el chillum
elchillum Posted April 14, 2004 Author Posted April 14, 2004 hmmmz ... someone that can help me out with this problem? ... please ... el chillum
vcache Posted April 14, 2004 Posted April 14, 2004 Well...the thing is that the entire oscommerce system depends on having full access to it's database...so not putting the needed information into the configure.php kind of defeats the purpose of installing oscommerce as it will not be able to function...everything from product listings to pricing to the shopping cart to checkout depends on total access to the database also...they first have to be aware of the *existance* of the file to even think about downloading it...and to be honest...anyone that can get in and download a php file that they don't even know exists would have no problem also aquiring the database... I'm not trying to scare you or anything...just trying to show you that putting or not putting the information in that particular file isn't something you should worry about....as all php is handled server-side and only the resulting html is sent to the browser Contribs added: AdminLogin-Catalog With Images-Credit Class/Gift Voucher-CoolMenu EasyPopulate-LoginBox-Paypal Shopping Cart IPN-PDF Catalogs Product Listing In Columns - Image Strip -- ...the young jedi said to his master "you want me to do WHAT?"
elchillum Posted April 14, 2004 Author Posted April 14, 2004 Well...the thing is that the entire oscommerce system depends on having full access to it's database...so not putting the needed information into the configure.php kind of defeats the purpose of installing oscommerce as it will not be able to function...everything from product listings to pricing to the shopping cart to checkout depends on total access to the database also...they first have to be aware of the *existance* of the file to even think about downloading it...and to be honest...anyone that can get in and download a php file that they don't even know exists would have no problem also aquiring the database... I'm not trying to scare you or anything...just trying to show you that putting or not putting the information in that particular file isn't something you should worry about....as all php is handled server-side and only the resulting html is sent to the browser hello ;) first of all i have total access to the database ... i have an admin panel from the hosting site where i ordered it ;) for the rest thanx for the good info :) For the rest could you tell me what to fill in in the cofigure.php file? ... cookies etc etc ... the list goes on and on ... and i dont understand half of it ;) greetz, el chillum
Guest Posted April 14, 2004 Posted April 14, 2004 what he means by that, is there are items missing from the configure.php file. from what i can tell, this is a new install of oscommerce. did you download osCommerce from here or did you get it elsewhere? did you follow the installation instructions in the documentation? did you read the installation documentation? it explains this process you are having troubles with.
elchillum Posted April 14, 2004 Author Posted April 14, 2004 what he means by that, is there are items missing from the configure.php file. from what i can tell, this is a new install of oscommerce. did you download osCommerce from here or did you get it elsewhere? did you follow the installation instructions in the documentation? did you read the installation documentation? it explains this process you are having troubles with. i did download the oscommerce from http://www.oscommerce.com/solutions/downloads ... i think i did it right ... uploaded the catalog folder (but that's it) ...and then followed the steps in the install file... ... going to mywebsite/.../install and then did the steps there are ... dunno what i can do wrong in these few things ... i hope i did something wrong so at least i know what the problem is :D el chillum
elchillum Posted April 14, 2004 Author Posted April 14, 2004 btw IF not all things are uploaded ... you never know with hosting companies and file rights etc ... how can i do it in the exact right way;) el chillum
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.