phpMyAdmin

Support Requests item #1629834, was opened at 2007-01-07 13:12
Message generated for change (Comment added) made by mkdfx
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Open
Priority: 5
Private: No
Submitted By: defekt (mkdfx)
Assigned to: Nobody/Anonymous (nobody)
Summary: 'only_db' does not accept value from PHP_AUTH_USER

Initial Comment:
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

----------------------------------------------------------------------

>Comment By: defekt (mkdfx)
Date: 2007-01-13 20:46

Message:
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?

----------------------------------------------------------------------

Comment By: Michal Čihař (nijel)
Date: 2007-01-10 13:03

Message:
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?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Support Requests item #1629834, was opened at 2007-01-07 07:12
Message generated for change (Comment added) made by lem9
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: defekt (mkdfx)
>Assigned to: Marc Delisle (lem9)
Summary: 'only_db' does not accept value from PHP_AUTH_USER

Initial Comment:
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

----------------------------------------------------------------------

>Comment By: Marc Delisle (lem9)
Date: 2007-01-13 17:18

Message:
Logged In: YES 
user_id=210714
Originator: NO

Does FAQ 6.20 apply to your case?

----------------------------------------------------------------------

Comment By: defekt (mkdfx)
Date: 2007-01-13 14:46

Message:
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?

----------------------------------------------------------------------

Comment By: Michal Čihař (nijel)
Date: 2007-01-10 07:03

Message:
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?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Support Requests item #1629834, was opened at 2007-01-07 13:12
Message generated for change (Comment added) made by mkdfx
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: defekt (mkdfx)
Assigned to: Marc Delisle (lem9)
Summary: 'only_db' does not accept value from PHP_AUTH_USER

Initial Comment:
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

----------------------------------------------------------------------

>Comment By: defekt (mkdfx)
Date: 2007-01-15 23:23

Message:
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.

----------------------------------------------------------------------

Comment By: Marc Delisle (lem9)
Date: 2007-01-13 23:18

Message:
Logged In: YES 
user_id=210714
Originator: NO

Does FAQ 6.20 apply to your case?

----------------------------------------------------------------------

Comment By: defekt (mkdfx)
Date: 2007-01-13 20:46

Message:
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?

----------------------------------------------------------------------

Comment By: Michal Čihař (nijel)
Date: 2007-01-10 13:03

Message:
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?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Support Requests item #1629834, was opened at 2007-01-07 13:12
Message generated for change (Settings changed) made by mkdfx
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Priority: 5
Private: No
Submitted By: defekt (mkdfx)
Assigned to: Marc Delisle (lem9)
Summary: 'only_db' does not accept value from PHP_AUTH_USER

Initial Comment:
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

----------------------------------------------------------------------

Comment By: defekt (mkdfx)
Date: 2007-01-15 23:23

Message:
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.

----------------------------------------------------------------------

Comment By: Marc Delisle (lem9)
Date: 2007-01-13 23:18

Message:
Logged In: YES 
user_id=210714
Originator: NO

Does FAQ 6.20 apply to your case?

----------------------------------------------------------------------

Comment By: defekt (mkdfx)
Date: 2007-01-13 20:46

Message:
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?

----------------------------------------------------------------------

Comment By: Michal Čihař (nijel)
Date: 2007-01-10 13:03

Message:
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?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=377409&aid=1629834&group_id=23067