Get real mysqld hostname

[Mike Broxterman]

I'm looking for a programatic way to obtain the real FQDN of the myqld
server, not the one used to connect to the server. Here's the scenario,
several servers running mysqld are behind a virtual IP so when you connect
to mysqld you do not know which server you are really connected to. The
get_host_info only returns the name used to connect to the virtual
address.

I've checked the variables table but the hostname is not there either. I
can solve the problem by creating a database with the name of the host but
that's not very elegant nor can I use dots for the IP or FQDN as the db
name.





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Can't find file: './mysql/host.frm' (errno: 13)

[Mike Broxterman]

Neglected to mention the host.frm file _does_ exist.

@ ls -al /usr/local/pkg/mysql/var/mysql/
total 134
drwx--   2 root other512 Jun  1 07:53 .
drwxr-xr-x   4 mysqlmysql512 Jun  4 09:17 ..
-rw-rw   1 root other  0 Jun  1 07:53 columns_priv.MYD
-rw-rw   1 root other   1024 Jun  1 07:53 columns_priv.MYI
-rw-rw   1 root other   8778 Jun  1 07:53 columns_priv.frm
-rw-rw   1 root other302 Jun  1 07:53 db.MYD
-rw-rw   1 root other   3072 Jun  1 07:53 db.MYI
-rw-rw   1 root other   8982 Jun  1 07:53 db.frm
-rw-rw   1 root other  0 Jun  1 07:53 func.MYD
-rw-rw   1 root other   1024 Jun  1 07:53 func.MYI
-rw-rw   1 root other   8641 Jun  1 07:53 func.frm
-rw-rw   1 root other  0 Jun  1 07:53 host.MYD
-rw-rw   1 root other   1024 Jun  1 07:53 host.MYI
-rw-rw   1 root other   8958 Jun  1 07:53 host.frm
-rw-rw   1 root other  0 Jun  1 07:53 tables_priv.MYD
-rw-rw   1 root other   1024 Jun  1 07:53 tables_priv.MYI
-rw-rw   1 root other   8877 Jun  1 07:53 tables_priv.frm
-rw-rw   1 root other428 Jun  1 07:53 user.MYD
-rw-rw   1 root other   2048 Jun  1 07:53 user.MYI
-rw-rw   1 root other   9148 Jun  1 07:53 user.frm



On Mon, 4 Jun 2001, Mike Broxterman wrote:

 
 Downloaded, compiled, installed, ran mysql_install_db. However, when I try
 to start using safe_mysqld I get the Can't find file error.
 
 root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld
 Starting mysqld daemon with databases from /usr/local/pkg/mysql/var
 010604 08:44:28  mysqld ended
 
 root@qsv-cmxdb1:...pkg/mysql tail var/qsv-cmxdb1.err
 010604 08:44:28  mysqld started
 010604  8:44:28  /usr/local/pkg/mysql/libexec/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
 010604  8:44:28  /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown
 010604 08:44:28  mysqld ended
 
 
 mysqld  Ver 3.23.38 for sun-solaris2.6 on sparc
 
 basedir: /usr/local/pkg/mysql/
 datadir: /usr/local/pkg/mysql/var/
 tmpdir:  /var/tmp/
 language:/usr/local/pkg/mysql/share/mysql/english/
 pid file:/usr/local/pkg/mysql/var/qsv-cmxdb1.pid
 binary log:  replication.log
 binary log index:  
 TCP port:3306
 Unix socket: /tmp/mysql.sock
 
 
 Options used to build mysql;
 
 sh CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3  ./configure
 --prefix=/usr/local/pkg/mysql --without-bench --without-debug
 --with-mysqld-user=mysql 
 
 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Can't find file: './mysql/host.frm' (errno: 13)

[Mike Broxterman]

Downloaded, compiled, installed, ran mysql_install_db. However, when I try
to start using safe_mysqld I get the Can't find file error.

root@qsv-cmxdb1:...pkg/mysql bin/safe_mysqld
Starting mysqld daemon with databases from /usr/local/pkg/mysql/var
010604 08:44:28  mysqld ended

root@qsv-cmxdb1:...pkg/mysql tail var/qsv-cmxdb1.err
010604 08:44:28  mysqld started
010604  8:44:28  /usr/local/pkg/mysql/libexec/mysqld: Can't find file: 
'./mysql/host.frm' (errno: 13)
010604  8:44:28  /usr/local/pkg/mysql/libexec/mysqld: Normal shutdown
010604 08:44:28  mysqld ended


mysqld  Ver 3.23.38 for sun-solaris2.6 on sparc

basedir: /usr/local/pkg/mysql/
datadir: /usr/local/pkg/mysql/var/
tmpdir:  /var/tmp/
language:/usr/local/pkg/mysql/share/mysql/english/
pid file:/usr/local/pkg/mysql/var/qsv-cmxdb1.pid
binary log:  replication.log
binary log index:  
TCP port:3306
Unix socket: /tmp/mysql.sock


Options used to build mysql;

sh CFLAGS=-O3 CXX=gcc CXXFLAGS=-O3  ./configure
--prefix=/usr/local/pkg/mysql --without-bench --without-debug
--with-mysqld-user=mysql 


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php