Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Unable to connect database


felipecardoso

Recommended Posts

Posted

Hi...

 

I have PhpTriad (apache+php+sql)

My oscommerce is 2.2MS2

 

well....

1? - I enter in http://localhost/phpmyadmin and created the sql database with the name "loja" (loja means something with market in portuguese), imported the database from oscommerce.sql of /install directory

2? - I have descompacted the catalog folder into htdocs

3? - I enter in http://localhost/catalog/install/ and the instalation process is OK.

 

details of the installation:

1? - don't import catalog database and automatic configuration

2? - www adress: http://azul/catalog (azul is the name of my pc)

web server root directory: C:/apache/htdocs/catalog/ (default)

3? - Database server: azul

username: felipe

password: cardoso

database name: loja

Persistent Connections: not checked

Sesion Storage: Files

4? - osCommerce Configuration

 

The configuration was successful!

----------------------------------------------------------

When I try to access Catalog or Administration Tool I get this message:

 

Warning: MySQL Connection Failed: Access denied for user: 'felipe@AZUL' (Using password: YES) in C:\apache\htdocs\catalog\includes\functions\database.php on line 19

Unable to connect to database server!

 

I sow in other messages that I have to change CHMOD to 777 in admin/includes/configure.php and ind includes/configure.php, but I am using my HD, my computer to store this files, not an remote web server.

 

Please help-me...

Posted

try and take your password out, some time it will work.

Posted

I removed the password of the 2 configure.php and the message returned is:

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

[TEP STOP]

 

 

I don't know what is wrong...

thank's

Posted

try database server 127.0.0.1

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

Now the message show felipe@localhost and before was felipe@AZUL

 

Warning: MySQL Connection Failed: Access denied for user: 'felipe@localhost' (Using password: YES) in C:\apache\htdocs\catalog\includes\functions\database.php on line 19

Unable to connect to database server!

Posted

Warning: mysql_connect(): Host '******' is not allowed to connect to this MySQL server in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong server DB_SERVER information in the configure.php files

 

Warning: mysql_connect(): Access denied for user: '****@*****' (Using password: *****) in *:\******\www\*****\******\includes\functions\database.php on line 19

Unable to connect to database server!

 

This indicates the wrong username DB_SERVER_USERNAME or password DB_SERVER_PASSWORD information in the configure.php files

 

1046 - No Database Selected

 

select configuration_key as cfgKey, configuration_value as cfgValue from configuration

 

This indicates that either no database has been created or the wrong database name DB_DATABASE exists in the configure.php files

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

In my case I configured the boths configure.php with /catalog/install program...

One question... I have only configured in phpmyadmin and

created the bd "loja" and imported the oscommerce.sql

this is correct?

 

The username and password in configure.php have to be the same with what?

Posted

the same with the mysql database username and password.

Posted

If you start up phpMyAdmin and look at the right hand side you should see the information given there will be name@name2 where name is the user name and name2 is the database server then when you select the database from the left hand side, then go to the right hand side and the information will give you the name of the database.

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

okay!

 

I install all the programs in other pc, the error now is:

 

Warning: open(/tmp\sess_38ce0017fea1f6fe5b262240fb6f21f5, O_RDWR) failed: No such file or directory (2) in c:\apache\htdocs\catalog\includes\functions\sessions.php on line 67

Warning: The sessions directory does not exist: /tmp. Sessions will not work until this directory is created.

 

and appears the screen: This program executed an illegal operation ....

If the problem persists .......

 

I'm brasilian, then appears to me: Este programa executou uma opera??o ilegal e ser? fechado.

Se o problema persistir, entre em contato com o revendedor.

 

But the page is loaded after this error.

 

thank's for the help...

Posted

SESSION DIRECTORY DOES NOT EXIST

 

change the last line in the following files

 

catalog/includes/configure.php

admin/includes/configure.php

 

from

define('STORE_SESSIONS', '');

to

define('STORE_SESSIONS', 'mysql');

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! :P

Is your Osc dated try Phoenix  raising oscommerce from the ashes.

Posted

in the other computer appears:

MySQL 3.23.32-debug running on localhost

 

I put localhost as database server and username and password are blank.

It's working now!!!!!

 

But is not secure the username and password blank... what I have to do?

I think is something that appears on

MySQL 3.23.32-debug running on localhost

 

 

thank's for all!!!!

:D :D :D

Archived

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

×
×
  • Create New...