#4 Setting up Advanced Authentication

closed
Robin Johnson
4
2001-08-29
2001-08-23
Ben Davis
No

Whenever I enable Advanced Authentication, I get an
internal server error (500) and it wont work. I have
the user name and password set for the advanced
authentication, but it just doenst work. It works on
my old version of PHPMyAdmin (2.1.?) but not on this
one. Anyone else have this problem

Discussion

  • Robin Johnson
    Robin Johnson
    2001-08-24

    Logged In: YES
    user_id=30201

    Could you provide some details as to what web server you
    are using (on what platform too), as well as the version of
    PHP you are running?

     
  • Robin Johnson
    Robin Johnson
    2001-08-24

    • priority: 5 --> 4
    • assigned_to: nobody --> robbat2
     
  • Logged In: NO

    I am running Windows 2000 SP2, my webserver is Apache
    1.3.20 for Win32 systems. PHP version 4.0.6 for Windows.
    And I am trying to use PHPMyAdmin 2.2.0rc4-php
    Here is the config file: (or at least the part that i
    changed)

    $cfgServers[1]['host'] = 'localhost'; // MySQL
    hostname
    $cfgServers[1]['port'] = ''; // MySQL
    port - leave blank for default port
    $cfgServers[1]['adv_auth'] = true; // Use
    advanced authentication?
    $cfgServers[1]['stduser'] = 'DigDog'; //
    MySQL standard user (only needed with advanced auth)
    $cfgServers[1]['stdpass'] = 'pwd'; // MySQL
    standard password (only needed with advanced auth)
    $cfgServers[1]['user'] = 'DigDog'; // MySQL
    user (only needed with basic auth)
    $cfgServers[1]['password'] = 'pwd'; // MySQL
    password (only needed with basic auth)
    $cfgServers[1]['only_db'] = ''; // If set to
    a db-name, only this db is accessible
    $cfgServers[1]['verbose'] = ''; // Verbose
    name for this host - leave blank to show the hostname
    $cfgServers[1]['bookmarkdb'] = ''; // Bookmark
    db - leave blank for no bookmark support
    $cfgServers[1]['bookmarktable'] = ''; // Bookmark
    table - leave blank for no bookmark support

    $cfgServers[2]['host'] = 'localhost';
    $cfgServers[2]['port'] = '';
    $cfgServers[2]['adv_auth'] = true;
    $cfgServers[2]['stduser'] = 'colin';
    $cfgServers[2]['stdpass'] = 'pwd';
    $cfgServers[2]['user'] = 'colin';
    $cfgServers[2]['password'] = 'pwd';
    $cfgServers[2]['only_db'] = '';
    $cfgServers[2]['verbose'] = '';
    $cfgServers[2]['bookmarkdb'] = '';
    $cfgServers[2]['bookmarktable'] = '';

    And i get the 500 internal server error when I run it. I
    installed PHP with the php4.0.6 installer. Its a binary
    distribution for windows. Its the first time i have ever
    setup php using the installer, i usually use the zip file
    and go from there. It came with fewer extensions so maybe
    something is missing that isnt allowing the http
    authentication. Thats as much help as i can give. Hope it
    helps

     
  • Robin Johnson
    Robin Johnson
    2001-08-28

    Logged In: YES
    user_id=30201

    are you using the CGI version of php in your apache config?
    thats what it sounds like based on the error 500.

    you can't use advanced auth with the cgi php, it doesn't
    work due to limitations of php.

     
  • Loïc Chapeaux
    Loïc Chapeaux
    2001-08-29

    Logged In: YES
    user_id=144058

    Hi!

    It seems to me that the php win32 installer setups php as a
    cgi and not an Apache module. The advanced authentication
    can be run in this case (see the phpMyAdmin documentation).

    Loc

     
  • Ben Davis
    Ben Davis
    2001-08-29

    Logged In: YES
    user_id=306171

    I think thats it, Im running in cgi mode. Thanks folks.

     
  • Loïc Chapeaux
    Loïc Chapeaux
    2001-08-29

    • status: open --> closed
     
  • Loïc Chapeaux
    Loïc Chapeaux
    2001-08-29

    Logged In: YES
    user_id=144058

    OK, closing this request.