Zen Cart Logo
Forums / Basic Configuration / Cant Log into my admin

Cant Log into my admin

Locked

Views: 2,110

Results 1 to 10 of 10
This thread is locked. New replies are disabled.
12 Oct 2010, 4:04 AM
#1
anirealm avatar

anirealm

New Zenner

Join Date:
Nov 2004
Posts:
7
Plugin Contributions:
0

Cant Log into my admin

I have never had a problem logging into my admin before, now today it tells me either my user name or password are incorrect, this is not the case cause I know them well, when I ask for the password to be resent it tells me the email is incorrect this email I have had for 10years so it is correct. Can some please help me and tell me what is happening, and how to get into my site again.

Thanks

Sam

12 Oct 2010, 4:51 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Cant Log into my admin

What version of Zencart are you using?

You might have been hacked

18 Oct 2010, 1:48 AM
#3
rainbows avatar

rainbows

New Zenner

Join Date:
Nov 2005
Location:
Australia
Posts:
26
Plugin Contributions:
0

Re: Cant Log into my admin

I have had a similar problem, although when I asked for a reset password, it was sent to my email, although the new password wont work. I dont know what version I am using, as I cannot log in to tell, I dont know if you can tell from somewhere else? :( I think 1.3.8 but not sure?

So I found an article: How do I change or reset my Admin Password? (I lost it) at https://www.zen-cart.com/tutorials/index.php?article=2. Obviously I cant change it in admin, so I tried running the query in PHPMyAdmin as detailed, however I get :

MySQL said:

#1046 - No database selected

The there is this part: If you are using a prefix for your database tables, you'll naturally need to add that prefix to the table name above.
ie. "... FROM/INTO prefix_admin ...".

So perhaps I have a prefix, but have no idea what it would be!

Gosh, sorry for sounding so dumb.

Really appreciate your help!

Rachel

18 Oct 2010, 2:18 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Cant Log into my admin

MySQL said:

#1046 - No database selected
When in phpmyadmin you must select/load a database
From there you can view the tables and their name
Would be like
address_book
or if a prefix might be like
zen_address_book

From there you can run/select fo the top menu sql and run the reset pass sql code

18 Oct 2010, 2:28 AM
#5
rainbows avatar

rainbows

New Zenner

Join Date:
Nov 2005
Location:
Australia
Posts:
26
Plugin Contributions:
0

Re: Cant Log into my admin

Thanks Kobra for your fast reply. That is something I should have realised, I usually wait and try to figure things about before I post and sound dumb, but alas, not this time.

I have managed to login now with the Admin reset and I have gone to Admin settings and now I realise what has gone wrong. I must have been hacked as my Admin name had been changed to 'Henry'. I will change it back & reset the pw but im guessing I must be vulnerable. I have checked my payments module settings and all looks ok as if it still has my details.

I'm guessing an upgrade is needed? I try to avoid this as long as possible as I always have trouble :(

18 Oct 2010, 2:31 AM
#6
rainbows avatar

rainbows

New Zenner

Join Date:
Nov 2005
Location:
Australia
Posts:
26
Plugin Contributions:
0

Re: Cant Log into my admin

There was another admin on there also ... Name: Adminz with email: [email protected]. I'm guessing this is how they got in, I will delete this now....

18 Oct 2010, 2:31 AM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Cant Log into my admin

They are already in and most likely have set ways to access even now that you have changed things

FOLLOW ALL STEPS
http://www.zen-cart.com/wiki/index.php/Recovering_From_Hacks

18 Oct 2010, 2:43 AM
#8
rainbows avatar

rainbows

New Zenner

Join Date:
Nov 2005
Location:
Australia
Posts:
26
Plugin Contributions:
0

Re: Cant Log into my admin

some people are rotten :(

Thanks for your help, will take your advice.

Thanks again,

Rachel

19 Oct 2010, 1:49 AM
#9
shortysclimbin avatar

shortysclimbin

New Zenner

Join Date:
Oct 2010
Location:
San Juan Puerto Rico
Posts:
62
Plugin Contributions:
0

Re: Cant Log into my admin

Well this sucks!

It looks like after a week of work and reading on here I had not even had the site fully up and someone decided to break a few things.

Host IP: 124.115.6.13 and 124.115.0.156 GRRR I will catch you!

Ended up killing the whole project down to start fresh... Reloaded zencart and still cannot log in! Any ideas?

31 Oct 2010, 5:55 PM
#10
kramerr avatar

kramerr

New Zenner

Join Date:
Jun 2009
Posts:
50
Plugin Contributions:
0

Re: Cant Log into my admin

I have the same problem. I cannot log into my Admin page. I tried looking at the databse tables using myPHPAdmin, but I am not too sure as to what to look for.

information_schema (17)

* Browse CHARACTER_SETS
* Browse COLLATIONS
* Browse COLLATION_CHARACTER_SET_APPLICABILITY
* Browse COLUMNS
* Browse COLUMN_PRIVILEGES
* Browse KEY_COLUMN_USAGE
* Browse PROFILING
* Browse ROUTINES
* Browse SCHEMATA
* Browse SCHEMA_PRIVILEGES
* Browse STATISTICS
* Browse TABLES
* Browse TABLE_CONSTRAINTS
* Browse TABLE_PRIVILEGES
* Browse TRIGGERS
* Browse USER_PRIVILEGES
* Browse VIEWS

This is what comes up on the first page of myPHPAdmin.

When I select 'Tables", this is what comes up:

Type 	Collation 	Attributes 	Null 	Default 	Extra 	View
TABLE_CATALOG 	varchar(512) 	utf8_general_ci 		Yes 	NULL 		Browse distinct values
TABLE_SCHEMA 	varchar(64) 	utf8_general_ci 		No 			Browse distinct values
TABLE_NAME 	varchar(64) 	utf8_general_ci 		No 			Browse distinct values
TABLE_TYPE 	varchar(64) 	utf8_general_ci 		No 			Browse distinct values
ENGINE 	varchar(64) 	utf8_general_ci 		Yes 	NULL 		Browse distinct values
VERSION 	bigint(21) 			Yes 	NULL 		Browse distinct values
ROW_FORMAT 	varchar(10) 	utf8_general_ci 		Yes 	NULL 		Browse distinct values
TABLE_ROWS 	bigint(21) 			Yes 	NULL 		Browse distinct values
AVG_ROW_LENGTH 	bigint(21) 			Yes 	NULL 		Browse distinct values
DATA_LENGTH 	bigint(21) 			Yes 	NULL 		Browse distinct values
MAX_DATA_LENGTH 	bigint(21) 			Yes 	NULL 		Browse distinct values
INDEX_LENGTH 	bigint(21) 			Yes 	NULL 		Browse distinct values
DATA_FREE 	bigint(21) 			Yes 	NULL 		Browse distinct values
AUTO_INCREMENT 	bigint(21) 			Yes 	NULL 		Browse distinct values
CREATE_TIME 	datetime 			Yes 	NULL 		Browse distinct values
UPDATE_TIME 	datetime 			Yes 	NULL 		Browse distinct values
CHECK_TIME 	datetime 			Yes 	NULL 		Browse distinct values
TABLE_COLLATION 	varchar(64) 	utf8_general_ci 		Yes 	NULL 		Browse distinct values
CHECKSUM 	bigint(21) 			Yes 	NULL 		Browse distinct values
CREATE_OPTIONS 	varchar(255) 	utf8_general_ci 		Yes 	NULL 		Browse distinct values
TABLE_COMMENT

I am totally lost with this. Can anyone help out ???