mysql dumper issue

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
new_member
Forum Newbie
Posts: 8
Joined: Sat Sep 28, 2013 12:49 am

mysql dumper issue

Post 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??
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: mysql dumper issue

Post by requinix »

Stop giving the wrong username and/or password, or fix the auth file to use the credentials you're entering.
new_member
Forum Newbie
Posts: 8
Joined: Sat Sep 28, 2013 12:49 am

Re: mysql dumper issue

Post by new_member »

I am giving the right username and password only but its not accepting
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: mysql dumper issue

Post 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.
new_member
Forum Newbie
Posts: 8
Joined: Sat Sep 28, 2013 12:49 am

Re: mysql dumper issue

Post 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
User avatar
requinix
Spammer :|
Posts: 6617
Joined: Wed Oct 15, 2008 2:35 am
Location: WA, USA

Re: mysql dumper issue

Post 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.
Post Reply