Disable admin password?

[Avium]

Hi guys,

 

I've had some problems recently. My admin password and username combinations have been messed up quite badly, so I need to remove them and change them again. However, I've had trouble trying to find out exactly where the code is located.

 

Can anyone please point me to the file(s) where I have to go into in order to change my store's admin password and username?

 

Thank you!!

[Guest]

osCommerce provides no password protection whatsoever for the Administration Tool.

 

However, most people implement it by creating an .htaccess file for Apache to do the authentication.

[Avium]

Okay, I understand that part now. I do recognise the .htaccess file on my server, so how should I modify it in order to be able to overwrite the present admin name and passwords? Because the file only shows the admin username, but not the password.

 

I know this sounds rather simple, but I'd really appreciate help in this!

 

Thanks in advance!

[mattice]

ftp / telnet / ssh in and see where the .htpasswd is located.

Just remove/replace the .htpassword file with a newly generated one.

[Avium]

Nope - my host doesn't give us telnet access. Is there a way I can modify the file itself? Some actual codes as examples would be very helpful for a greenhorn like me :)

[mattice]

Do you have a control panel? If so delete the .htaccess / .htpasswd and upload a new one.

[Guest]

I do recognise the .htaccess file on my server

...

Because the file only shows the admin username, but not the password.

 

It depends on your server setup.

 

One way to do it is with a file that contains the user:password pairs. You should see a reference to this file in the .htaccess file. http://httpd.apache.org/docs/mod/mod_auth.html

 

If you dont have any references to a password file in .htaccess, you may be using PAM (for example RaQ's do this, with mod_pam_auth). In which case you password will be the same as you system password.

 

In any case, contact your hosting provider, he should be able to help.

[Avium]

I got the .htaccess file deleted and modified the username and password, but now I get this error instead:

 

=======begin error========

Warning: Access denied for user: '[email protected]' (Using password: YES) in /web/fansdome/public_html/storeadmin/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: '[email protected]' (Using password: YES) in /web/fansdome/public_html/storeadmin/includes/functions/database.php on line 19

Unable to connect to database server!

=========end error=========

 

NOTE: I replaced my username with ABC as an eg of the error :wink:

 

Seems like there might have been some problems with the php files themselves instead of the htaccess now. Is anyone familiar with such a problem?

[mattice]

Its an mysql error.. you're not allowed to access mysql with the username / password you have set in configure.php

[Avium]

Oh, so what would be the solution to this?

 

I know this is starting to sound silly, but after working with the problem on and off for several days in a row, I can't really think anymore :(

 

Also, which config file is the problem in? In catalog or admin?

[Avium]

It's okay - I've got it all solved now! Thank you very much for all the help so far! I really appreciated it!

[Guest]

It's okay - I've got it all solved now!

 

Could you share with us how you solved it?

 

Thanks!

[Aodhan]

Oh, so what would be the solution to this?

 

I know this is starting to sound silly, but after working with the problem on and off for several days in a row, I can't really think anymore :(

 

Also, which config file is the problem in? In catalog or admin?

 

Well, the access that it is trying to get is shown in your error message, and gives the line number.

 

What I think is the problem, is that your username/password that you now have don't match the username/password pair that your database was originally set up with. That you will have to change on your server itself, if I am reading the errors and the messages correctly. I could be wrong, it's been known to happen...once or twice... :lol:

 

Aodhan