Zen Cart Logo
Forums / General Questions / Admin USer & Password no loner work.

Admin USer & Password no loner work.

Locked

Views: 8,842

Results 1 to 20 of 33
This thread is locked. New replies are disabled.
13 Jan 2007, 12:48 AM
#1
jaden avatar

jaden

New Zenner

Join Date:
Oct 2006
Posts:
63
Plugin Contributions:
0

Admin USer & Password no loner work.

Hi Zenners,

For some reason my User and Password do not work to my Zencart Admin panel any more! I tried to resend a new password but this does not help. I tried to use the old User and Admin but I still can not get in.

I tried to use the resetting via phpMyAdmin with the code given in the lost password article, but this does not help. Any answers as to what I could do?

Thanks in Advance
Jamie
Down Under

13 Jan 2007, 1:14 AM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Admin USer & Password no loner work.

Using phpMyAdmin you can fix this by dropping and recreating the admin table and adding a default login and password:

      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)
) TYPE=MyISAM; 
```Next run this to set the login to Admin/admin:

Reset login and password to: Admin admin
```php
      INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); 

WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ... in Tools ... Admin Settings ...

13 Jan 2007, 1:15 AM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Admin USer & Password no loner work.

NOTE: if using prefixes on your database table names such as:

zen_admin ... you will need to alter that fix for your specific prefix ...

13 Jan 2007, 4:50 AM
#4
jaden avatar

jaden

New Zenner

Join Date:
Oct 2006
Posts:
63
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

Hi Linda,

Unfortunatly this is what i have already done (as stated above)! But sayingthat I am most likely doing it wrong.
Here is the error.....
Fatal error: Call to a member function Execute() on a non-object in /home/ausjamuu/public_html/includes/functions/sessions.php on line 61

I log onto my servers cpanel, MySQL Account Maintenance, phpMyAdmin. Then I run the script in Run SQL query/queries on databsae(my databse is listed here). It then comes back with an error. If this is incorrect, what tab should I be looking for to run these scripts?

Thanks
jamie

13 Jan 2007, 4:55 AM
#5
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Admin USer & Password no loner work.

That is a php 5.2.0 bug ...

The fix for the sessions.php files are at:
http://www.zen-cart.com/forum/showpost.php?p=287587&postcount=26

Note: this php bug has been addressed in the current Zen Cart v1.3.7 until php fixes the bug themselves ...

14 Jan 2007, 10:20 AM
#6
jaden avatar

jaden

New Zenner

Join Date:
Oct 2006
Posts:
63
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

Ok Great.

I have done the above mod to the file. Now do I apply the php code again as I tried previously? Now I know nothing about php so be gental!

Or would I be better of applying the latest Zen-Cart upgrade?

I also have a complete backup I can reload, or will my problem still exist?

Thanks for your time

14 Jan 2007, 3:28 PM
#7
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Admin USer & Password no loner work.

Personally I would upgrade ...

Upgrades contain bugfixes, security fixes, new features, etc. ...

Backup both your database and site ... and go for the upgrade ... take your time and you will be glad that you did in the end ... :smile:

27 Jul 2007, 6:11 PM
#8
matt6805 avatar

matt6805

New Zenner

Join Date:
Jan 2006
Posts:
7
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

Hi Everyone.
I can't login to my admin either. Very disturbing considering I was just about to launch the site. I've tried every thing on this thread and several other with no success. My database has no prefixes, so I used the appropriate SQL code. I still not get response from Admin/admin.

I recently fowarded the domain thesiteguys.com, to siteguys.com. Could that be part of the issue? I made the URL change in the configure.php file so the browser points to the correct place. There must be a way to fix this issue. Does anyone have any advice or point me in another direction?

Thanks in advance.

27 Jul 2007, 6:37 PM
#9
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

please post your admin/includes/configure.php without your password.

27 Jul 2007, 7:52 PM
#10
matt6805 avatar

matt6805

New Zenner

Join Date:
Jan 2006
Posts:
7
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

Kim,
Here's the config file:

<?php /** * * @package Configuration Settings * @copyright Copyright 2003-2006 Zen Cart Development Team * @copyright Portions Copyright 2003 osCommerce * @license <http://www.zen-cart.com/license/2_0.txt> GNU Public License V2.0 */ /*************** NOTE: This file is similar, but DIFFERENT from the "admin" version of configure.php. ***********/ /*************** The 2 files should be kept separate and not used to overwrite each other. ***********/ // Define the webserver and path parameters // HTTP_SERVER is your Main webserver: eg, <http://www.yourdomain.com> // HTTPS_SERVER is your Secure webserver: eg, <https://www.yourdomain.com> define('HTTP_SERVER', 'http://www.siteguys.com'); define('HTTPS_SERVER', 'https://www.siteguys.com'); // Use secure webserver for checkout procedure? define('ENABLE_SSL', 'true'); // NOTE: be sure to leave the trailing '/' at the end of these lines if you make changes! // * DIR_WS_* = Webserver directories (virtual/URL) // these paths are relative to top of your webspace ... (ie: under the public_html or httpdocs folder) define('DIR_WS_CATALOG', '/cart/'); define('DIR_WS_HTTPS_CATALOG', '/cart/'); define('DIR_WS_IMAGES', 'images/'); define('DIR_WS_INCLUDES', 'includes/'); 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_WS_TEMPLATES', DIR_WS_INCLUDES . 'templates/'); define('DIR_WS_PHPBB', '/'); // * DIR_FS_* = Filesystem directories (local/physical) //the following path is a COMPLETE path to your Zen Cart files. eg: /var/www/vhost/accountname/public_html/store/ define('DIR_FS_CATALOG', '/kunden/homepages/40/d207247386/htdocs/cart/'); define('DIR_FS_DOWNLOAD', DIR_FS_CATALOG . 'download/'); define('DIR_FS_DOWNLOAD_PUBLIC', DIR_FS_CATALOG . 'pub/'); define('DIR_WS_UPLOADS', DIR_WS_IMAGES . 'uploads/'); define('DIR_FS_UPLOADS', DIR_FS_CATALOG . DIR_WS_UPLOADS); define('DIR_FS_EMAIL_TEMPLATES', DIR_FS_CATALOG . 'email/'); // define our database connection define('DB_TYPE', 'mysql'); define('DB_PREFIX', ''); define('DB_SERVER', 'db987.perfora.net'); define('DB_SERVER_USERNAME', 'dbo207323645'); define('DB_SERVER_PASSWORD', ''); define('DB_DATABASE', 'db207323645'); define('USE_PCONNECT', 'false'); // use persistent connections? define('STORE_SESSIONS', 'db'); // use 'db' for best support, or '' for file-based storage // The next 2 "defines" are for SQL cache support. // For SQL_CACHE_METHOD, you can select from: none, database, or file // If you choose "file", then you need to set the DIR_FS_SQL_CACHE to a directory where your apache // or webserver user has write privileges (chmod 666 or 777). We recommend using the "cache" folder inside the Zen Cart folder // ie: /path/to/your/webspace/public_html/zen/cache -- leave no trailing slash define('SQL_CACHE_METHOD', 'none'); define('DIR_FS_SQL_CACHE', '/kunden/homepages/40/d207247386/htdocs/cart/cache'); ?>
27 Jul 2007, 11:35 PM
#11
Kim avatar

Kim

Obaa-san

Join Date:
Jun 2003
Location:
West Coast, North America
Posts:
26,611
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

... Wrong config file - how about the one for the ADMIN

29 Jul 2007, 10:32 AM
#12
jaden avatar

jaden

New Zenner

Join Date:
Oct 2006
Posts:
63
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

I have had this happen a few time to me now. Both times I bit the bullet and completely reloaded Zen Cart and both times it worked.

30 Jul 2007, 3:58 PM
#13
matt6805 avatar

matt6805

New Zenner

Join Date:
Jan 2006
Posts:
7
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

Kim,
Thank you for your help. Your comment about the admin config file prompted me to look in there and I saw the problem was the URL paths were not matching the other config file. The reset login worked and the issue is solved. Thanks again for your prompt assistance!

Regards,
Matt

15 May 2008, 5:38 PM
#14
johnkent avatar

johnkent

New Zenner

Join Date:
May 2008
Posts:
3
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

HI,

I recently upgraded my site with a an SSL certificate, however when the server put the certificate on the page something went amuck wtih the HTaccess. When they fixed that I lost my ability to log into my zencart admin. I have tried to flush the password and reset it to the original admin password with my phpadmin, however nothing has worked. How can I log in?

1 Jun 2008, 3:16 PM
#15
shokuf avatar

shokuf

New Zenner

Join Date:
Feb 2008
Posts:
56
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

I also did as above, but still can't login.
I am using 1.3.8a.
All our admin logins were working yesterday and now today it's just not working! What's the problem.

1 Jun 2008, 3:27 PM
#16
shokuf avatar

shokuf

New Zenner

Join Date:
Feb 2008
Posts:
56
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

I think I'm not running the sql query right. Can you repost it with the zen_ added in. Thanks!

28 Jul 2008, 4:22 AM
#18
muteyaar avatar

muteyaar

Zen Follower

Join Date:
Oct 2007
Posts:
134
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

I am also having the same problem.

My password is not working. I tried to do this as described here, but still it is not working.

please help.

its urgent.

Ajeh:

Using phpMyAdmin you can fix this by dropping and recreating the admin table and adding a default login and password:

  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)
) TYPE=MyISAM;

> 
> Reset login and password to: Admin admin
> ```php
      INSERT INTO admin VALUES (1, 'Admin', 'admin@localhost', '351683ea4e19efe34874b501fdbf9792:9b', 1); 

WARNING: be sure to reset the Admin login as soon as you have access for the Admin password and email address ... in Tools ... Admin Settings ...

28 Jul 2008, 4:24 AM
#19
muteyaar avatar

muteyaar

Zen Follower

Join Date:
Oct 2007
Posts:
134
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

muteyaar:

I am also having the same problem.

My password is not working. I tried to do this as described here, but still it is not working.

please help.

its urgent.

I received two orders in the mean time and I am not able to check out even what items were purchased by which customers. please help me urgently as I have to ship the items on time.

28 Jul 2008, 4:56 AM
#20
barco57 avatar

barco57

Totally Zenned

Join Date:
Apr 2006
Location:
West Salem, IL
Posts:
2,845
Plugin Contributions:
0

Re: Admin USer & Password no loner work.

do you have a prefix on your database tables? (i.e. zen_)