#994 'only_db' does not accept value from PHP_AUTH_USER

closed
None
5
2007-01-15
2007-01-07
Tim Taylor
No

The following entry in config.inc.php does not seem to work with Version 2.9.1.1:

$cfg['Servers'][$i]['only_db'] = $_SERVER['PHP_AUTH_USER'];

I'm using this for a long time and numerous versions of PHPMyAdmin. But actually PHPMyAdmin shows all databases without taking care of this parameter. Rest of the config as followed:

$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['Servers'][$i]['only_db'] = $_SERVER['PHP_AUTH_USER'];

Serversystem:

PHP Version 4.4.4
MySQL 4.1.21-max-log

Discussion

  • Michal Čihař

    Michal Čihař - 2007-01-10

    Logged In: YES
    user_id=192186
    Originator: NO

    It does not accept this as configuration is stored in session and on session init you are not logged in. Why do you need this setting? Don't you have proper privileges set in MySQL?

     
  • Michal Čihař

    Michal Čihař - 2007-01-10
    • labels: 509095 -->
    • milestone: 663202 -->
    • status: open --> pending
     
  • Tim Taylor

    Tim Taylor - 2007-01-13
    • status: pending --> open
     
  • Tim Taylor

    Tim Taylor - 2007-01-13

    Logged In: YES
    user_id=1685648
    Originator: YES

    I need this because my databases are hosted on a multiple user server and there are lots of databases served. Always when i log on with my user I get the databases of all users listed in the dropdown field.
    As it is a mess to search for the database I like to modify, I decided to use above configuration to get always the suitable database to the actual logged in user displayed.

    Do you have a workaround for me?

     
  • Marc Delisle

    Marc Delisle - 2007-01-13

    Logged In: YES
    user_id=210714
    Originator: NO

    Does FAQ 6.20 apply to your case?

     
  • Marc Delisle

    Marc Delisle - 2007-01-13
    • assigned_to: nobody --> lem9
     
  • Tim Taylor

    Tim Taylor - 2007-01-15

    Logged In: YES
    user_id=1685648
    Originator: YES

    Thanks! FAQ 6.20 described exactly the problem. My hoster changed the global CREATE TEMPORARY TABLES privileges and everything works as usual now.

     
  • Tim Taylor

    Tim Taylor - 2007-01-15
    • status: open --> closed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks