Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Install problem


elchillum

Recommended Posts

(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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?"

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...