felipecardoso Posted July 1, 2004 Posted July 1, 2004 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...
Guest Posted July 1, 2004 Posted July 1, 2004 try and take your password out, some time it will work.
felipecardoso Posted July 1, 2004 Author Posted July 1, 2004 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
241 Posted July 1, 2004 Posted July 1, 2004 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! Is your Osc dated try Phoenix raising oscommerce from the ashes.
felipecardoso Posted July 1, 2004 Author Posted July 1, 2004 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!
241 Posted July 1, 2004 Posted July 1, 2004 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! Is your Osc dated try Phoenix raising oscommerce from the ashes.
felipecardoso Posted July 1, 2004 Author Posted July 1, 2004 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?
Guest Posted July 1, 2004 Posted July 1, 2004 the same with the mysql database username and password.
felipecardoso Posted July 2, 2004 Author Posted July 2, 2004 where is the mysql database username and password? I don't found anything like this in phpmyadmin... thank's for the help...
241 Posted July 2, 2004 Posted July 2, 2004 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! Is your Osc dated try Phoenix raising oscommerce from the ashes.
felipecardoso Posted July 2, 2004 Author Posted July 2, 2004 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...
241 Posted July 2, 2004 Posted July 2, 2004 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! Is your Osc dated try Phoenix raising oscommerce from the ashes.
felipecardoso Posted July 2, 2004 Author Posted July 2, 2004 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
Recommended Posts
Archived
This topic is now archived and is closed to further replies.