phpMyAdmin: tbl_replace.php: Missing db

[Daniel Mercier]

Hi,

I'm new to mysql and just installed phpmyadmin.

Here is the versions info:

System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1

PHP Version 4.3.8

Apache/2.0.50 (Fedora)

Client API version 3.23.58

Welcome to phpMyAdmin 2.5.7-pl1

MySQL 3.23.58 running on localhost as root@localhost

************************************************** ************************************************** ***
********** Error messages *******************************************
************************************************** ************************************************** ***

When creating database:

Server localhost

db_create.php: Missing db

When inserting new row in user table:

tbl_replace.php: Missing db
tbl_replace.php: Missing table
tbl_replace.php: Missing goto

Accessing phpMyAdmin from LAN:

Connection refused (that's OK)

Where can i start with to solve my pb with phpMyAdmin ?

Thank you.

************************************************** ************************************************** ***********
***************** Following is part of my config.inc.php file: *******
************************************************** ************************************************** ***********
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the
socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect
to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed
protocol for the MySQL connection
// (requires PHP

= 4.3.0)

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control
user settings
// (this user must
have read-only

$cfg['Servers'][$i]['controlpass'] = ''; // access to the
"mysql/user"
// and "mysql/db"
tables).
// The controluser
is also
// used for all
relational
// features
(pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
(only needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a
db-name, only
// this db is
displayed in left frame
// It may also be
an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name
for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb'] = ''; // Database used
for Relation, Bookmark and PDF Features
// (see
scripts/create_tables.sql)
// - leave blank
for no support
// DEFAULT:
'phpmyadmin'

[Daniel Mercier]

Never mind.. I found the solution. hope this will help...

Other Info:

- Using dynamic IP
- Using no-ip.com services
- prt 80 closed = using 8080

solution:

Change $cfg['PmaAbsoluteUri'] variable as posted by www.linboost.org
(thank you guys) to:

$cfg['PmaAbsoluteUri'] = (!empty($_SERVER['HTTPS']) ? 'https' :
'http')
. '://' . $_SERVER['HTTP_HOST'] . (!empty($_SERVER['SERVER_PORT'])
? ':'
. $_SERVER['SERVER_PORT'] : '')
. substr($_SERVER['PHP_SELF'], 0, strrpos($_SERVER['PHP_SELF'],
'/')+1);

But even there, because no-ip was appending the port number, it was
included in the $_SERVER['HTTP_HOST'] variable,
so i had to take it off to:

$cfg['PmaAbsoluteUri'] = (!empty($_SERVER['HTTPS']) ? 'https' :
'http') . '://' . $_SERVER['HTTP_HOST']
. substr($_SERVER['PHP_SELF'], 0,
strrpos($_SERVER['PHP_SELF'], '/')+1);

Et voila!
Le Wed, 18 Aug 2004 07:21:19 -0400, Daniel Mercier
<da*************@videotron.ca> a écrit :

Hi,

I'm new to mysql and just installed phpmyadmin.

Here is the versions info:

System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1

PHP Version 4.3.8

Apache/2.0.50 (Fedora)

Client API version 3.23.58

Welcome to phpMyAdmin 2.5.7-pl1

MySQL 3.23.58 running on localhost as root@localhost

************************************************* ************************************************** ****
********** Error messages *******************************************
************************************************* ************************************************** ****

When creating database:

Server localhost

db_create.php: Missing db

When inserting new row in user table:

tbl_replace.php: Missing db
tbl_replace.php: Missing table
tbl_replace.php: Missing goto

Accessing phpMyAdmin from LAN:

Connection refused (that's OK)

Where can i start with to solve my pb with phpMyAdmin ?

Thank you.

************************************************* ************************************************** ************
***************** Following is part of my config.inc.php file: *******
************************************************* ************************************************** ************
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the
socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect
to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed
protocol for the MySQL connection
// (requires PHP

= 4.3.0)

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control
user settings
// (this user must
have read-only

$cfg['Servers'][$i]['controlpass'] = ''; // access to the
"mysql/user"
// and "mysql/db"
tables).
// The controluser
is also
// used for all
relational
// features
(pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
(only needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a
db-name, only
// this db is
displayed in left frame
// It may also be
an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name
for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb'] = ''; // Database used
for Relation, Bookmark and PDF Features
// (see
scripts/create_tables.sql)
// - leave blank
for no support
// DEFAULT:
'phpmyadmin'

[Daniel Mercier]

Never mind...

I found out myself. But I would have appreciated some help on this
since I lost lots of time.

Answer:

Additionnal info:

- dynamic ip from ISP ;
- closed port 80 by ISP so using 8080 instead ;
- using no-ip.com services that was adding the 8080 port in
directing to my host ;

Solution:

Had to change the $cfg['PmaAbsoluteUri'] variable in config.inc.php
to:
$cfg['PmaAbsoluteUri'] = (!empty($_SERVER['HTTPS']) ? 'https' :'http')
.. '://' . $_SERVER['HTTP_HOST'] . (!empty($_SERVER['SERVER_PORT']) ?
':' . $_SERVER['SERVER_PORT'] : '') . substr($_SERVER['PHP_SELF'],
0, strrpos($_SERVER['PHP_SELF'], '/')+1); ##### found on
www.linboost.org (thank you guys).

But even there had to remove the (!empty($_SERVER['SERVER_PORT']) ?
':' . $_SERVER['SERVER_PORT'] : '') part since no-ip was already
adding the port and the port was included in the $_SERVER['HTTP_HOST']
variable.

Hope this will help.

Daniel

Le Wed, 18 Aug 2004 07:21:19 -0400, Daniel Mercier
<da*************@videotron.ca> a écrit :

Hi,

I'm new to mysql and just installed phpmyadmin.

Here is the versions info:

System Linux linlyne.spider.sense 2.4.22-1.2199.nptl #1

PHP Version 4.3.8

Apache/2.0.50 (Fedora)

Client API version 3.23.58

Welcome to phpMyAdmin 2.5.7-pl1

MySQL 3.23.58 running on localhost as root@localhost

************************************************* ************************************************** ****
********** Error messages *******************************************
************************************************* ************************************************** ****

When creating database:

Server localhost

db_create.php: Missing db

When inserting new row in user table:

tbl_replace.php: Missing db
tbl_replace.php: Missing table
tbl_replace.php: Missing goto

Accessing phpMyAdmin from LAN:

Connection refused (that's OK)

Where can i start with to solve my pb with phpMyAdmin ?

Thank you.

************************************************* ************************************************** ************
***************** Following is part of my config.inc.php file: *******
************************************************* ************************************************** ************
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
or IP address
$cfg['Servers'][$i]['port'] = ''; // MySQL port -
leave blank for default port
$cfg['Servers'][$i]['socket'] = ''; // Path to the
socket - leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect
to MySQL server ('tcp' or 'socket')
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed
protocol for the MySQL connection
// (requires PHP

= 4.3.0)

$cfg['Servers'][$i]['controluser'] = ''; // MySQL control
user settings
// (this user must
have read-only

$cfg['Servers'][$i]['controlpass'] = ''; // access to the
"mysql/user"
// and "mysql/db"
tables).
// The controluser
is also
// used for all
relational
// features
(pmadb)
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication
method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
(only needed
// with 'config'
auth_type)
$cfg['Servers'][$i]['only_db'] = ''; // If set to a
db-name, only
// this db is
displayed in left frame
// It may also be
an array of db-names, where sorting order is relevant.
$cfg['Servers'][$i]['verbose'] = ''; // Verbose name
for this host - leave blank to show the hostname

$cfg['Servers'][$i]['pmadb'] = ''; // Database used
for Relation, Bookmark and PDF Features
// (see
scripts/create_tables.sql)
// - leave blank
for no support
// DEFAULT:
'phpmyadmin'