Page 1 of 1

mysql dumper issue

Posted: Tue Oct 22, 2013 7:01 am
by new_member
Hi,

I want to use mysql dumper database. For that i have applied password protected encryption. Before it was giving 404 error but later on modifying the roor htaccess files by adding

AuthName "MySQLDumper"
AuthType Basic
AuthUserFile "myfilepath"
require valid-user

or

Errordocument 401 error.html
Errordocument 403 error.html

prompts for the user login. But on adding the login credentials it is taking to same window again and again asking for login info again. Any idea how to solve this??

Re: mysql dumper issue

Posted: Tue Oct 22, 2013 1:03 pm
by requinix
Stop giving the wrong username and/or password, or fix the auth file to use the credentials you're entering.

Re: mysql dumper issue

Posted: Tue Oct 22, 2013 10:47 pm
by new_member
I am giving the right username and password only but its not accepting

Re: mysql dumper issue

Posted: Tue Oct 22, 2013 10:58 pm
by requinix
Then apparently you have to fix the auth file to use the credentials you're entering.

Also check Apache's error log to (possibly) see the exact reason for the 401s.

Re: mysql dumper issue

Posted: Thu Oct 24, 2013 1:05 am
by new_member
Problem is not with password authentication as mysqldump provides password protection facility. After applying that it itself creates htaccess and htpass files for that folder. Main problem is after applying password security it does not ask for login info rather gives 404 page. this was issue of htaccess on root.To resolve that i have inserted the line i mentioned above but now it asks for username and password but not accepting it nor giving error rather asking for login again and again

Re: mysql dumper issue

Posted: Thu Oct 24, 2013 3:37 am
by requinix
You being repeatedly presented with a login dialog is precisely why it is a problem with authentication.

Try this: use the htaccess utility (as in the command-line application bundled with Apache) to add your own special username and password to the "myfilepath" file, then attempt to log in with those credentials.