Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Sun, 1 Feb 2009 20:56:08 +0900
Eric Hagley <eh...@la...> wrote:

> Hello there Franky, many thanks for taking the time to share your  
> experience. It is greatly appreciated.
> 
> Sorry, just to be sure I understand, do you want me to:
> delete / drop the phpesp_designer section (whole thing) from the  
> database and remake it?
> Or do you want me to click on the structure button of the  
> phpesp_designer section, delete / drop just the admin user line and  
> add a new admin line, followed by the other info you mentioned,
> Or do you want me to just type over the old admin user name (didn't  
> work previously).
> in regard the esp password, can that be typed just as "esp" or is  
> there a string of characters for code?
> 
> Sorry to bother, but I don't want to make things any worse!

Hi Eric,

no, don't delete the whole phpesp_designer section. Just use phpmyadmin
(or whatever you have at your disposal), go to your database and into
the phpesp_designer table and remove the one line that mentions the
admin user. Then execute the sql statement: 

INSERT INTO phpesp_designer (username, password, fname, lname, realm,
pdesign, pstatus, pdata, pall, pgroup, puser, disabled) VALUES ('root',
PASSWORD('esp'), 'ESP', 'Superuser', 'superuser', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'N')

If you're unsure, give me the phpmyadmin access and I'll change it for
you.

Franky