Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1722
  • Last Modified:

phpmyadmin + config.inc.php + http authtype says try again buddy

Ok I have just configured WAMP (Windows Apache MySQL and PHP) development
server. I posted in Misc but got no response so I will try my luck here.

MySQL 4.1
php 4.3.9
apache 1.3.31
phpmyadmin 2.6.0 pl2

Configured phpmyadmin to match similar setups i have on other computers.
config and cookie auth types work fine but http is giving me a headache
that i just don't need and it just so happens to be the one i need at the moment. Everytime i enter the http authentication username and password it just keeps asking me for them in a loop until i cancel and get a wrong username/password error access denied.

What am i forgetting?
0
ricbax
Asked:
ricbax
  • 8
  • 7
1 Solution
 
thecode101Commented:
How do you have your htaccess file set up? Is it pointing to the correct location of the .htpasswd file?
0
 
ricbaxAuthor Commented:
I know that an .htaccess and .htpasswd files are a possibility however I am trying to get the http authtype within phpmyadmin to work and comunicate with mysql.
0
 
thecode101Commented:
Is your AllowOverride directive in apache set up correctly?
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
ricbaxAuthor Commented:
What would that be?
0
 
thecode101Commented:
Where ever your apache is set up there should be a conf folder with a file called httpd.conf. In that file there should be a directive called AllowOverride. AllowOverride controls what directives may be placed in .htaccess files.
0
 
ricbaxAuthor Commented:
yes I understand that you want me to go with the htaccess/htpasswd directive, however I am 99.9% positive that this is not necessary with phpmyadmin if the authtype is set within the config.php to "http"

I know your solution works but it is not what I am trying to achieve.
0
 
thecode101Commented:
Ok, I think I understand now. Let me check out my phpmyadmin config and see what I can find.
0
 
thecode101Commented:
So you set up a MySQL user account and it is not working when you enter that username and password?
0
 
ricbaxAuthor Commented:
MySQL is setup as root as user and has a password ... MySQL works fine from the cmd prompt with the username and password.

HTTP Authentication will not work when the username and password are entered for phpmyadmin.

0
 
thecode101Commented:
Just to test, try setting up another user and password and give that a try. We will have to do some troubleshooting to find out exactly where the problem is. You can also try setting the authtype to config and seeing if you are actually able to connect to the databases that way.
0
 
ricbaxAuthor Commented:
Config works before I add a password for root, after adding the pasword i get the following error

#1045 - Access denied for user 'ODBC'@'localhost' (using password: NO)

http will not accept a username and password.

0
 
ricbaxAuthor Commented:
Why is ODBC more important than root? and why is it if you delete all users from the mysql database that ODBC@localhost likes to hang around even after you kill the process 1000 times and it renews itself.

Simply frustrating...
0
 
thecode101Commented:
I had a similar problem when my 'controluser' and 'controlpass' variables where incorrect. Make sure you have these filled in with a valid user account/password.
0
 
ricbaxAuthor Commented:
Solution:

Installation order of older version of MySQL 4.1.4 (not 4.1.5), Apache 1.3.31 and PHP 4.3.9 seemed to solve my problem and thoroughly reading the phpMyAdmin documentation. Any other order of installation and I would have a problem where I would get ODBC@localhost errors rather than root@localhost (row order in mysql database) and password errors as mentioned above.

I like to thank thecode101 for the effort in providing me with possible solutions. In the end I found my own solution that worked.

ricbax
0
 
thecode101Commented:
No objections, glad you got it worked out.
0
 
RomModCommented:
PAQ'd points refunded.
RomMod
Community Support Moderator
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

  • 8
  • 7
Tackle projects and never again get stuck behind a technical roadblock.
Join Now