I installed RC8 on a new localhost site (Vista Ultimate, Apache 2.2.4, Mysql 5.1.30, PHP5)
and found the same problem as in RC7. The user database table is empty after installation.
http://forum.opencart.com/index.php/topic,2797.0.html
No match for Username and/or Password
and found the same problem as in RC7. The user database table is empty after installation.
http://forum.opencart.com/index.php/topic,2797.0.html
No match for Username and/or Password
This seems to only affect you still .
Is there anyway you can forward the port so I can get access to your localsite and take a look?
I'd need the url (i.e. http://72.43.53.24/shop)
ftp access and
the phpmyadmin login.
At the very least, can you tell me if the database is being populated at all and can you export the database to a sql file and attach it so I can take a look
I run my locahost server on Vista Ultimate, Apache 2.2.4, Mysql 5.1.30 and PHP 5.2.0 as well with no problem. What hosting package do you use? Have you tried Xampp or EasyWamp?
Is there anyway you can forward the port so I can get access to your localsite and take a look?
I'd need the url (i.e. http://72.43.53.24/shop)
ftp access and
the phpmyadmin login.
At the very least, can you tell me if the database is being populated at all and can you export the database to a sql file and attach it so I can take a look
I run my locahost server on Vista Ultimate, Apache 2.2.4, Mysql 5.1.30 and PHP 5.2.0 as well with no problem. What hosting package do you use? Have you tried Xampp or EasyWamp?
I think the installer files do not work correctly. After fresh installation the database is being populated successfully and I can get access to the frontend of the site. However the database table 'user' remains empty after installation. Therefore I cannot get access to the admin panel.
During installation I have not received any error message. Therefore the step3.php code do not work.
config.php after installation:
During installation I have not received any error message. Therefore the step3.php code do not work.
Code: Select all
if (!$errors) {
mysql_query('set character set utf8', $link);
mysql_query("delete from user where user_id = '1'");
mysql_query("insert into `user` set user_id = '1', user_group_id = '1', username = '" . mysql_real_escape_string($_POST['username']) . "', password = '" . mysql_real_escape_string(md5($_POST['password'])) . "', date_added = now()", $link);
mysql_close($link);
}
config.php after installation:
Code: Select all
<?php
define('CONFIG_VERSION', '0.7.9-RC8');
define('DB_HOST', 'localhost');
define('DB_USER', 'root');
define('DB_PASSWORD', 'admin');
define('DB_NAME', '798');
define('DIR_BASE', 'C:\\Apache\\server\\798\\');
define('HTTP_BASE', 'http://127.0.0.1/798/');
define('HTTPS_BASE', '');
?>
I've created a simple debug version of step3.phpdad wrote: During installation I have not received any error message. Therefore the step3.php code do not work.Code: Select all
if (!$errors) { mysql_query('set character set utf8', $link); mysql_query("delete from user where user_id = '1'"); mysql_query("insert into `user` set user_id = '1', user_group_id = '1', username = '" . mysql_real_escape_string($_POST['username']) . "', password = '" . mysql_real_escape_string(md5($_POST['password'])) . "', date_added = now()", $link); mysql_close($link); }
Please extract this file into your install folder and run installer again. Please copy and paste all the echo'd messages you see at the top of step3 when installing. Maybe we will figure out where it's having a problem
Last edited by Qphoria on Thu Jan 29, 2009 11:22 pm, edited 1 time in total.
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 47
After ; was added at the end of,
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 51
....
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 56
.....
'../config.php' was updated successfully.
link is okabout to create adminadmin should be created
Finished!
.....
Congratulations! You have successfully installed OpenCart.
BUT NOTHING WAS CHANGED!
The 'user' db table is empty again and therefore the same message: No match for Username and/or Password
After ; was added at the end of
Code: Select all
echo "link is ok";
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 51
....
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 56
.....
'../config.php' was updated successfully.
link is okabout to create adminadmin should be created
Finished!
.....
Congratulations! You have successfully installed OpenCart.
BUT NOTHING WAS CHANGED!
The 'user' db table is empty again and therefore the same message: No match for Username and/or Password
Last edited by dad on Thu Jan 29, 2009 9:42 pm, edited 1 time in total.
I changed code in the step3.php:
and received following messages:
Code: Select all
if ([color=red]$errors[/color]) {
if (!$link = @mysql_connect($_POST['db_host'], $_POST['db_user'], $_POST['db_pass'])) {
$errors[] = 'Could not connect to the database server using the username and password provided.';
echo 'Could not connect to the database server using the username and password provided.';
}
else {
if (!@mysql_select_db($_POST['db_name'], $link)) {
$errors[] = 'The database could selected, check you have permissions, and check it exists on the server.';
echo 'The database could selected, check you have permissions, and check it exists on the server.';
}
}
echo 'errors';
}
[color=red]echo 'The database could selected';[/color]
Code: Select all
'../config.php' was updated successfully.
The database could selected
Notice: Undefined variable: link in C:\Apache\server\798\install\step3.php on line 56
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Apache\server\798\install\step3.php on line 56
Warning: mysql_query() [function.mysql-query]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Apache\server\798\install\step3.php on line 57
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\Apache\server\798\install\step3.php on line 57
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Apache\server\798\install\step3.php on line 58
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Apache\server\798\install\step3.php on line 58
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'ODBC'@'localhost' (using password: NO) in C:\Apache\server\798\install\step3.php on line 58
Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in C:\Apache\server\798\install\step3.php on line 58
Notice: Undefined variable: link in C:\Apache\server\798\install\step3.php on line 58
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Apache\server\798\install\step3.php on line 58
Notice: Undefined variable: link in C:\Apache\server\798\install\step3.php on line 59
Warning: mysql_close(): supplied argument is not a valid MySQL-Link resource in C:\Apache\server\798\install\step3.php on line 59
Last edited by dad on Thu Jan 29, 2009 11:22 pm, edited 1 time in total.
Sorry... I shouldn't code so early in the morning.dad wrote:
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 51
....
Parse error: parse error, expecting `','' or `';'' in C:\Apache\server\798\install\step3.php on line 56
Try the one attached here. I'm not expecting it to change, I just want to see the messages
Attachments
Last edited by Qphoria on Thu Jan 29, 2009 11:26 pm, edited 1 time in total.
Please see only the messages:
'../config.php' was updated successfully.
link is okabout to create adminadmin should be created Finished!
You MUST delete this install directory!
Make 'config.php' unwritable (chmod go-w).
Make 'admin/config.php' unwritable (chmod go-w).
Congratulations! You have successfully installed OpenCart.
'../config.php' was updated successfully.
link is okabout to create adminadmin should be created Finished!
You MUST delete this install directory!
Make 'config.php' unwritable (chmod go-w).
Make 'admin/config.php' unwritable (chmod go-w).
Congratulations! You have successfully installed OpenCart.
Hmm yea.. that all sounds right. It's at least getting to that section of the code.
Try this one and copy/paste the output again. This one will echo the results of each mysql_query command to see which one (if any) is failing and why.
Try this one and copy/paste the output again. This one will echo the results of each mysql_query command to see which one (if any) is failing and why.
Attachments
'../config.php' was updated successfully.
about to create adminres1=1res2=1res3=admin should be created Finished!
You MUST delete this install directory!
Make 'config.php' unwritable (chmod go-w).
Make 'admin/config.php' unwritable (chmod go-w).
Congratulations! You have successfully installed OpenCart.
Thank you for your help. The matter will keep till tomorrow.
Good bye!
about to create adminres1=1res2=1res3=admin should be created Finished!
You MUST delete this install directory!
Make 'config.php' unwritable (chmod go-w).
Make 'admin/config.php' unwritable (chmod go-w).
Congratulations! You have successfully installed OpenCart.
Thank you for your help. The matter will keep till tomorrow.
Good bye!
Last edited by dad on Fri Jan 30, 2009 2:10 am, edited 1 time in total.
ok...
res1=1 - mysql_query('set character set utf8', $link); - SUCCESS
res2=1 - mysql_query("delete from user where user_id = '1'", $link); - SUCCESS
res3="" - mysql_query("insert into `user` set user_id = '1', user_group_id = '1', username = '" . mysql_real_escape_string($_POST['username']) . "', password = '" . mysql_real_escape_string(md5($_POST['password'])) . "', date_added = now()", $link); - FAIL
So it's choking on that.
Can you enter this manually into your phpmyadmin sql window and execute it:
Then try logging in or paste the error if you get one
res1=1 - mysql_query('set character set utf8', $link); - SUCCESS
res2=1 - mysql_query("delete from user where user_id = '1'", $link); - SUCCESS
res3="" - mysql_query("insert into `user` set user_id = '1', user_group_id = '1', username = '" . mysql_real_escape_string($_POST['username']) . "', password = '" . mysql_real_escape_string(md5($_POST['password'])) . "', date_added = now()", $link); - FAIL
So it's choking on that.
Can you enter this manually into your phpmyadmin sql window and execute it:
Code: Select all
insert into `user` set user_id = '1', user_group_id = '1', username = 'admin', password = '21232f297a57a5a743894a0e4a801fc3', date_added = now()
Last edited by Qphoria on Fri Jan 30, 2009 2:41 am, edited 1 time in total.
I tried to execute your query and received phpmyadmin error message:
#1364 - Field 'ip' doesn't have a default value
INSERT INTO `user`
SET user_id = '1',
user_group_id = '1',
username = 'admin',
PASSWORD = '21232f297a57a5a743894a0e4a801fc3',
date_added = now( )
#1364 - Field 'ip' doesn't have a default value
INSERT INTO `user`
SET user_id = '1',
user_group_id = '1',
username = 'admin',
PASSWORD = '21232f297a57a5a743894a0e4a801fc3',
date_added = now( )
Ah.. that's the issue I think.
http://bugs.mysql.com/bug.php?id=14786
http://bugkill.blogspot.com/2007/06/mys ... fault.html
http://trac.roundcube.net/ticket/1483940
Something to do with mysql strict mode.
Tho the table does have a default set:
But mysql's always been kinda silly that way.. where you have NOT NULL, but the default is NULL.
Maybe hm2k has an idea. It's not really practical to update every table to have a non-null value. Most sites tell you to run in non-strict mode by editing your ini file and changing:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode=""
http://bugs.mysql.com/bug.php?id=14786
http://bugkill.blogspot.com/2007/06/mys ... fault.html
http://trac.roundcube.net/ticket/1483940
Something to do with mysql strict mode.
Tho the table does have a default set:
Code: Select all
CREATE TABLE IF NOT EXISTS `user` (
`user_id` int(11) NOT NULL auto_increment,
`user_group_id` int(11) NOT NULL default '0',
`username` varchar(20) collate utf8_unicode_ci NOT NULL default '',
`password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`firstname` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`lastname` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`email` varchar(96) collate utf8_unicode_ci NOT NULL default '',
[color=red]`ip` varchar(39) collate utf8_unicode_ci NOT NULL default '',[/color]
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user_id`),
UNIQUE KEY `username` (`username`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Maybe hm2k has an idea. It's not really practical to update every table to have a non-null value. Most sites tell you to run in non-strict mode by editing your ini file and changing:
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
to
sql-mode=""
Last edited by Qphoria on Fri Jan 30, 2009 3:11 pm, edited 1 time in total.
Who is online
Users browsing this forum: No registered users and 10 guests