Unable to connect with db server

[kate4567]

I'd appreciate it so much if someone could direct me to a more detailed installation rundown than what is in the knowledge base--I have not been able to find one that tells me exactly what parameters to put in the configure.php files. I keep installing, and everything looks successful, I'm able to get into admin and my site; but then when I change the two configure.php files to read only and reupload them, I get this message:

 

Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/www/asmartgift.com/includes/functions/database.php on line 19

Unable to connect to database server!

 

I don't understand what' going on and this has been going on for a week now. I'd really appreciate some help!

[♥Vger]

includes/configure.php for a site using a shared ssl cert (some settings may vary depending on server)

 

<?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.yourdomain.com/'); // eg, http://localhost - should not be empty for productive servers
?define('HTTPS_SERVER', 'https://servername.yourhost.com/yourdomain.com'); // (input your server name here) eg, https://localhost - should not be empty for productive servers
?define('ENABLE_SSL', true); // secure webserver for checkout procedure? (Change this to true)
?define('HTTP_COOKIE_DOMAIN', 'www.yourdomain.com');
?define('HTTPS_COOKIE_DOMAIN', '');
?define('HTTP_COOKIE_PATH', '/'); 
?define('HTTPS_COOKIE_PATH', '/'); 
?define('DIR_WS_HTTP_CATALOG', '/var/www/html/'); // absolute path required (add 'catalog' if not installed in root directory)
?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', DIR_WS_CATALOG . 'pub/');
?define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/'); (you can delete this line)
?define('DIR_FS_CATALOG', '/var/www/html/'); 
?define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
?define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
?define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
?define('DB_SERVER_USERNAME', 'your mysql username');
?define('DB_SERVER_PASSWORD', 'yourmysql password');
?define('DB_DATABASE', 'oscommerce');(default install name for database)
?define('USE_PCONNECT', 'false'); // use persistent connections?
?define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'(set to mysql)
?>

 

admin/includes/configure.php for a site using shared ssl

 

<?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.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
?define('HTTPS_SERVER', 'https://servername.yourhost.com/yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
?define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com');
?define('HTTPS_CATALOG_SERVER', 'https://servername.yourhost.com/yourdomain.com');
?define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
?define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/'); // where the pages are located on the server
?define('DIR_WS_ADMIN', '/instore/'); // absolute path required
?define('DIR_FS_ADMIN', '/var/www/html/admin/'); // absolute pate required
?define('DIR_WS_CATALOG', '/'); // absolute path required
?define('DIR_FS_CATALOG', '/var/www/html/'); // 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/');

// define our database connection
?define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
?define('DB_SERVER_USERNAME', 'database user name');
?define('DB_SERVER_PASSWORD', 'your password');
?define('DB_DATABASE', 'oscommerce');
?define('USE_PCONNECT', 'false'); // use persisstent connections?
?define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

 

Don't forget to change the permissions before trying to download, and change the permissions back after you have uploaded them.

 

Vger

[♥Vger]

P.S. Have you set a mysql Password in your web hosting control panel?

 

Vger

[kate4567]

Thank you for this information. I am still trying to make it work, and I'm getting this error since I've filled in the parameters in the configure.php files:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I get this error when I try to even call up installation, at www.mydomain.com/oscommerce. Here is what I put in the two configure.php files:

 

In admin/includes/configure.php I put the following:

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

define('HTTP_SERVER', 'http://www.asmartgift.com'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

define('HTTPS_SERVER', 'https://www.hollosite.com/asmartgift.com'); // eg, http://localhost - should not be empty for productive servers

define('HTTP_CATALOG_SERVER', 'http://www.asmartgift.com');

define('HTTPS_CATALOG_SERVER', 'https://www.hollosite.com/asmartgift.com');

define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module

define('DIR_FS_DOCUMENT_ROOT', /home/www/asmartgift.com/); // 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/');

 

// define our database connection

define('DB_SERVER', 'hollosite.com:3306');

define('DB_SERVER_USERNAME', 'richard2_bla');

define('DB_SERVER_PASSWORD', '64898469');

define('DB_DATABASE', 'richardge2_bla');

define('USE_PCONNECT', 'false');

define('STORE_SESSIONS', '');

?>

 

In includes/configure.php I put the following:

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

define('HTTP_SERVER', 'http://www.asmartgift.com/'); // eg, http://localhost - should not be empty for productive servers

define('HTTPS_SERVER', 'https://hollosite.com/asmartgift.com'); // eg, https://localhost - should not be empty for productive servers

define('ENABLE_SSL', true); // secure webserver for checkout procedure?

define('HTTP_COOKIE_DOMAIN', 'www.asmartgift.com');

define('HTTPS_COOKIE_DOMAIN', '');

define('HTTP_COOKIE_PATH', '/');

define('HTTPS_COOKIE_PATH', '/');

define('DIR_WS_HTTP_CATALOG', '/home/www/asmartgift.com/');

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', 'hollosite.com:3306'); // eg, localhost - should not be empty for productive servers

define('DB_SERVER_USERNAME', 'richardge2_bla');

define('DB_SERVER_PASSWORD', '64898469');

define('DB_DATABASE', 'osCommerce');

define('USE_PCONNECT', 'false'); // use persistent connections?

define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

 

My host is telling me they don't want to help me with coding, so I would really appreciate any help you might give. Thanks.

 

 

includes/configure.php for a site using a shared ssl cert (some settings may vary depending on server)

 

<?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.yourdomain.com/'); // eg, http://localhost - should not be empty for productive servers
?define('HTTPS_SERVER', 'https://servername.yourhost.com/yourdomain.com'); // (input your server name here) eg, https://localhost - should not be empty for productive servers
?define('ENABLE_SSL', true); // secure webserver for checkout procedure? (Change this to true)
?define('HTTP_COOKIE_DOMAIN', 'www.yourdomain.com');
?define('HTTPS_COOKIE_DOMAIN', '');
?define('HTTP_COOKIE_PATH', '/'); 
?define('HTTPS_COOKIE_PATH', '/'); 
?define('DIR_WS_HTTP_CATALOG', '/var/www/html/'); // absolute path required (add 'catalog' if not installed in root directory)
?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', DIR_WS_CATALOG . 'pub/');
?define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/'); (you can delete this line)
?define('DIR_FS_CATALOG', '/var/www/html/'); 
?define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/');
?define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/');

// define our database connection
?define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
?define('DB_SERVER_USERNAME', 'your mysql username');
?define('DB_SERVER_PASSWORD', 'yourmysql password');
?define('DB_DATABASE', 'oscommerce');(default install name for database)
?define('USE_PCONNECT', 'false'); // use persistent connections?
?define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'(set to mysql)
?>

 

admin/includes/configure.php for a site using shared ssl

 

<?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.yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
?define('HTTPS_SERVER', 'https://servername.yourhost.com/yourdomain.com'); // eg, http://localhost - should not be empty for productive servers
?define('HTTP_CATALOG_SERVER', 'http://www.yourdomain.com');
?define('HTTPS_CATALOG_SERVER', 'https://servername.yourhost.com/yourdomain.com');
?define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module
?define('DIR_FS_DOCUMENT_ROOT', '/var/www/html/'); // where the pages are located on the server
?define('DIR_WS_ADMIN', '/instore/'); // absolute path required
?define('DIR_FS_ADMIN', '/var/www/html/admin/'); // absolute pate required
?define('DIR_WS_CATALOG', '/'); // absolute path required
?define('DIR_FS_CATALOG', '/var/www/html/'); // 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/');

// define our database connection
?define('DB_SERVER', 'localhost'); // eg, localhost - should not be empty for productive servers
?define('DB_SERVER_USERNAME', 'database user name');
?define('DB_SERVER_PASSWORD', 'your password');
?define('DB_DATABASE', 'oscommerce');
?define('USE_PCONNECT', 'false'); // use persisstent connections?
?define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'
?>

 

Don't forget to change the permissions before trying to download, and change the permissions back after you have uploaded them.

 

Vger

<{POST_SNAPBACK}>

[kate4567]

Yes, I've set my mysql password in my control panel.

 

P.S.  Have you set a mysql Password in your web hosting control panel?

 

Vger

<{POST_SNAPBACK}>

[♥Vger]

I hope those weren't your real User Name and Password. If they were - now that you've posted them on a public forum you'd better change them quickly!

 

Remove the last slash from this

 

'http://www.asmartgift.com/'

 

Make the last line like this

 

define('STORE_SESSIONS', 'mysql')

 

Try those changes - however, the error you are getting is usually to do with

a. No database

b. Server unable to find it

c. Database installed, but did not install correctly

 

Vger

[kate4567]

Thank you for this information. I am still trying to make it work, and I'm getting this error since I've filled in the parameters in the configure.php files:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

I get this error when I try to even call up installation, at www.mydomain.com/oscommerce. Here is what I put in the two configure.php files:

 

In admin/includes/configure.php I put the following:

 

// define our webserver variables

// FS = Filesystem (physical)

// WS = Webserver (virtual)

  define('HTTP_SERVER', 'http://www.asmartgift.com'); // eg, http://localhost or - https://localhost should not be NULL for productive servers

  define('HTTPS_SERVER', 'https://www.hollosite.com/asmartgift.com'); // eg, http://localhost - should not be empty for productive servers

  define('HTTP_CATALOG_SERVER', 'http://www.asmartgift.com');

  define('HTTPS_CATALOG_SERVER', 'https://www.hollosite.com/asmartgift.com');

  define('ENABLE_SSL_CATALOG', 'true'); // secure webserver for catalog module

  define('DIR_FS_DOCUMENT_ROOT', /home/www/asmartgift.com/); // 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/');

 

// define our database connection

  define('DB_SERVER', 'hollosite.com:3306');

  define('DB_SERVER_USERNAME', 'richard2_bla');

  define('DB_SERVER_PASSWORD', '64898469');

  define('DB_DATABASE', 'richardge2_bla');

  define('USE_PCONNECT', 'false');

  define('STORE_SESSIONS', '');

?>

 

In includes/configure.php I put the following:

 

// Define the webserver and path parameters

// * DIR_FS_* = Filesystem directories (local/physical)

// * DIR_WS_* = Webserver directories (virtual/URL)

  define('HTTP_SERVER', 'http://www.asmartgift.com/'); // eg, http://localhost - should not be empty for productive servers

  define('HTTPS_SERVER', 'https://hollosite.com/asmartgift.com'); // eg, https://localhost - should not be empty for productive servers

  define('ENABLE_SSL', true); // secure webserver for checkout procedure?

  define('HTTP_COOKIE_DOMAIN', 'www.asmartgift.com');

  define('HTTPS_COOKIE_DOMAIN', '');

  define('HTTP_COOKIE_PATH', '/');

  define('HTTPS_COOKIE_PATH', '/');

  define('DIR_WS_HTTP_CATALOG', '/home/www/asmartgift.com/');

  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', 'hollosite.com:3306'); // eg, localhost - should not be empty for productive servers

  define('DB_SERVER_USERNAME', 'richardge2_bla');

  define('DB_SERVER_PASSWORD', '64898469');

  define('DB_DATABASE', 'osCommerce');

  define('USE_PCONNECT', 'false'); // use persistent connections?

  define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql'

?>

 

My host is telling me they don't want to help me with coding, so I would really appreciate any help you might give. Thanks.

<{POST_SNAPBACK}>

 

I should change the file permissions back to read only after re-installing, right? Not simply after re-uploading? And, the only way I can do that is by re-uploading them after checking the read-only permissions--is that okay? I can't change the permissions within my ftp program--it won't let me.

[♥Vger]

You're on a Windows server then. You can change file permission with Telner or SSH access. Find out if your hosting company provides for either of these.

 

Uploading with 'read only' checked may do the job, but that attribute may not get carried to the server. The only way to check is to FT P to the site and check what file permissions there are. However, this should have nothing to do with the db error you are getting, unless you have overwritten your configure.php files with blanks or localhost files.

 

Vger

[kate4567]

I hope those weren't your real User Name and Password.  If they were - now that you've posted them on a public forum you'd better change them quickly!

 

Remove the last slash from this

 

'http://www.asmartgift.com/'

 

Make the last line like this

 

define('STORE_SESSIONS', 'mysql')

 

Try those changes - however, the error you are getting is usually to do with

a. No database

b. Server unable to find it

c. Database installed, but did not install correctly

 

Vger

<{POST_SNAPBACK}>

 

So, do you have an idea of what I might do? Because I can't even get into the installation anymore. I get this when I type in www.asmartgift.com/oscommerce/:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

[kate4567]

So, do you have an idea of what I might do? Because I can't even get into the installation anymore. I get this when I type in www.asmartgift.com/oscommerce/:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

<{POST_SNAPBACK}>

 

 

And BTW, I changed my username/password--how dumb of me to put it out there. I knew how dumb that was, and I wasn't going to do that--I just forgot to change them. Thanks for the headsup.

[♥Vger]

This looks wrong to me, but please check with your hosting company as to what you should have here

 

define('DB_SERVER', 'hollosite.com:3306');

 

this would normally be (on Linux/Unix servers)

 

define('DB_SERVER', 'localhost');

 

Vger

[kate4567]

This looks wrong to me, but please check with your hosting company as to what you should have here

 

define('DB_SERVER', 'hollosite.com:3306');

 

this would normally be (on Linux/Unix servers)

 

define('DB_SERVER', 'localhost');

 

Vger

<{POST_SNAPBACK}>

 

I have been working for hours trying to set the correct parameters in the configure.php files (my host is unwilling to help), and finally now when I type in my domain, my site appears. However, I cannot seem to get into my admin. I get this error when I try to access http://mydomain.com/admin:

 

Warning: main(includes/application.php): failed to open stream: No such file or directory in /home/www/asmartgift.com/install/index.php on line 13

 

Fatal error: main(): Failed opening required 'includes/application.php' (include_path='.:/usr/local/lib/php') in /home/www/asmartgift.com/install/index.php on line 13

 

Am I trying the wrong url to get into my admin or is there some other problem. Thank very much for all your help.

[kate4567]

I have been working for hours trying to set the correct parameters in the configure.php files (my host is unwilling to help), and finally now when I type in my domain, my site appears. However, I cannot seem to get into my admin. I get this error when I try to access http://mydomain.com/admin:

 

Warning: main(includes/application.php): failed to open stream: No such file or directory in /home/www/asmartgift.com/install/index.php on line 13

 

Fatal error: main(): Failed opening required 'includes/application.php' (include_path='.:/usr/local/lib/php') in /home/www/asmartgift.com/install/index.php on line 13

 

Am I trying the wrong url to get into my admin or is there some other problem. Thank very much for all your help.

<{POST_SNAPBACK}>

 

Sorry--I just gave you wrong information. When I type in http://mydomain.com/admin, I get this message:

 

Parse error: parse error in /home/www/asmartgift.com/admin/includes/configure.php on line 21

 

Warning: main(DIR_WS_INCLUDESfilenames.php): failed to open stream: No such file or directory in /home/www/asmartgift.com/admin/includes/application_top.php on line 44

 

Fatal error: main(): Failed opening required 'DIR_WS_INCLUDESfilenames.php' (include_path='.:/usr/local/lib/php') in /home/www/asmartgift.com/admin/includes/application_top.php on line 44

 

And, when I type in http://mydomain.com/install, I get the message I previously gave you:

 

Warning: main(includes/application.php): failed to open stream: No such file or directory in /home/www/asmartgift.com/install/index.php on line 13

 

Fatal error: main(): Failed opening required 'includes/application.php' (include_path='.:/usr/local/lib/php') in /home/www/asmartgift.com/install/index.php on line 13

 

Thanks for any help you can give.

[♥Vger]

Hi, First thing to do is to delete the 'install' directory. This should be deleted immediately you have completed the installation. Do you know what your FTP login details are?

 

Host ID (something like ftp.yourdomain.com)

User Name

Password

 

If you have these details and you want me to take a look at your configure.php files then PM me those details and I'll take a look for you.

 

Vger

[dobsy]

Thank you for this information. I am still trying to make it work, and I'm getting this error since I've filled in the parameters in the configure.php files:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

<{POST_SNAPBACK}>

 

Hi,

 

I don't know if you've solved the above problem (and it looks like Vger is helping you anyway), but this may (or may not help).

 

I had same message when transferring an existing Oscommerce site to new server. I found that although I had set up database and a user for the database, I had forgotten to assign the user to the database. You may need to do this in your hosting control panel, it depends on your server.

 

Hope this helps!

[♥Vger]

The problem is now resolved. It was a configuration file issue.

 

Vger