Connecting Tech Pros Worldwide Help | Site Map

phpMyAdmin: tbl_replace.php: Missing db

Daniel Mercier
Guest
 
Posts: n/a
#1: Jul 20 '05
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[color=blue]
>= 4.3.0)[/color]
$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
Guest
 
Posts: n/a
#2: Jul 20 '05

re: phpMyAdmin: tbl_replace.php: Missing db


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
<daniel.mercier6@videotron.ca> a écrit :
[color=blue]
>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[color=green]
>>= 4.3.0)[/color]
>$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'[/color]

Daniel Mercier
Guest
 
Posts: n/a
#3: Jul 20 '05

re: phpMyAdmin: tbl_replace.php: Missing db


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
<daniel.mercier6@videotron.ca> a écrit :
[color=blue]
>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[color=green]
>>= 4.3.0)[/color]
>$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'[/color]

Closed Thread