Can't log into Admin

[Ajeh]

Check your paths etc. between your two files:
/includes/configure.php
/admin/includes/configure.php

[dscvry]

Checked the two files and all common variables seem to have consistent values being assigned to them (not sure what else exactly to check for here ...).

Tried again with queries to see if login would work anyway - same issue persists. It seems that the password is being recognised - there's no username/password error message generated as there is if you just type anything in the boxes - but with the Admin/admin combo (which we know therefore is correct) the login page just sticks on the screen with the boxes emptied.

These are the two SQL queries tried:

1.
DELETE FROM admin WHERE admin_name = 'Admin';
INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);

2.
DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;

INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1);


Not sure what else to try ...? Here's the background info:
Server - Apache/2.2.3 (Unix)
PhP v 5.1.6
MySQL v5.0.30-Debian_1-log

Disco

[Ajeh]

Try only running this in phpMyAdmin ...

DROP TABLE IF EXISTS admin;
CREATE TABLE admin (
admin_id int(11) NOT NULL auto_increment,
admin_name varchar(32) NOT NULL default '',
admin_email varchar(96) NOT NULL default '',
admin_pass varchar(40) NOT NULL default '',
admin_level tinyint(1) NOT NULL default '1',
PRIMARY KEY (admin_id),
KEY idx_admin_name_zen (admin_name),
KEY idx_admin_email_zen (admin_email)
) TYPE=MyISAM;

INSERT INTO admin (admin_name, admin_email, admin_pass, admin_level) VALUES ('Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); 

Login: Admin
Password: admin

Once in be sure to update your login name, email address and password to your own ...

[dscvry]

Running it in cpanel on the SQL page (both with & without hitting the 'Create PHP Code' function) produces this response (but still no access to admin):

DROP TABLE IF EXISTS admin; # MySQL returned an empty result set (i.e. zero rows).
CREATE TABLE admin(
admin_id int( 11 ) NOT NULL AUTO_INCREMENT ,
admin_name varchar( 32 ) NOT NULL default '',
admin_email varchar( 96 ) NOT NULL default '',
admin_pass varchar( 40 ) NOT NULL default '',
admin_level tinyint( 1 ) NOT NULL default '1',
PRIMARY KEY ( admin_id ) ,
KEY idx_admin_name_zen( admin_name ) ,
KEY idx_admin_email_zen( admin_email )
) TYPE = MYISAM ; # MySQL returned an empty result set (i.e. zero rows).
INSERT INTO admin( admin_name, admin_email, admin_pass, admin_level )
VALUES (
'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1
); # Affected rows:1

Skipping through the other tabs in cpanel, there is an Error box on the Operations page with this message:
"PMA Database ... not OK[ Documentation ]
General relation features Disabled"

Could this be the spanner in the works (or maybe later on) ?

[dscvry]

Some other things to mention on the sticky-login business ...
... double-checked the browser is accepting the cookies - it is
... double-checked the .htaccess file issue; renaming as .bak doesn't alter the login page behaviour
... checking in the admin table after running the query, the password/login do change each time the query runs
There's probably going to be sthg mindnumbingly obvious that solves this in the end.
[BTW I'm beginning to have doubts about the apparent (lack of) functionality of MyphpAdmin at this host - being my first encounter with it, I've no idea what's supposed to be here or how to get at it - but squinting hard at thumbnails of the screen presentation options on the 'Welcome to MyphpAdmin' page, it looks like the LH sidebar with several functions on has gone MyAWOL. There's no obvious way of doing anything other than through MySQL (which is why the admin query was run from there ... )]

[telepatico]

What if you log on to your database with PHPMyAdmin and click on the "admin" table then up on the tabs, click on "browse" and delete the user, then click on "insert" and add another user? You can add another user and then try to log in to your admin. Notice that when creating a password this way, it will not be encrypted from your database table to your form and vice versa.

so try then to log in to the administrator and create a new one, look again to the admin table and see if it is encrypted. Remember to apply the password type on phpmyadmin on the function. Once again, you can delete the actual user and add anew one, or add a new one first then delete the old one.

Use the same process to add more administrators or users with administrative access if needed.

[dscvry]

Thanks for this telepatico ...

Ajeh's suggested routine does do what it sets out to do - it establishes a valid, replacement password - but for reasons unknown the login form does not shift from the screen. I still can't get access to the Zencart administrator.

I tried your suggestions: the extra admin-user fields are entered in the database's admin table directly, although the login routine will not recognise the new passwords as valid (I've tried various function assignments but might have missed a trick here). If it did recognise them though, I suspect that they would encounter the same access prob as the Admin/admin attempts.

Looking at other field details in the admin table, I noticed that the entire database has been set up with collation fields as latin1_swedish_ci (Zencart default setting ?). The default setting for the database (when created before Zencart install) was/is utf8-general-ci ... although switching these to the same now hasn't helped with the login issue. I'm wondering whether this discrepancy could cause a glitch in the encryption mechanics (probably does no harm to have the collation values all lined up & pointing in the same direction anyway I'd imagine?). But that wouldn't explain either (a) why the non-encrypted passwords are not being recognised or (b) why the recognised Admin/admin user/password combination isn't opening up access to the Zencart administrator.

I'm reluctant to torch the current upload and try reinstalling the works, since it was not easy to get zc_install to run in the first place ... For the moment my host site seems to be sloughing off a hangover, but any ideas for cracking this one would be welcome.

[Website Rob]

When the easy or obvious solutions do not work, all we are left with are the hard solutions. In this case that would mean a complete reinstall.

Whether you toast the current setup or use a testbed is up to you, but with the time involved so far with no resolution in sight, it might be faster to just start again.

[goodmorning]

Still having the problem. I put so much time into customizing the cart for this client, that I really need to fix this instead of reinstalling.

Ajeh, would you mind looking at my ftp, phpmyadmin? I will PM you the info.

[Ajeh]

You may drop me a PM and I can peek when I get some time ...