LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



Reply
 
Search this Thread
Old 10-24-2007, 12:54 AM   #1
satimis
Senior Member
 
Registered: Apr 2003
Posts: 3,428

Rep: Reputation: 53
Problem on installing MySQL


Hi folks,


Ubuntu 7.04 server amd64
MySQL 5.0.38


On installing MySQL and coming to;

$ sudo mysqladmin -h ubuntu.xyz.com root password myrootsqlpassword
Code:
mysqladmin: connect to server at 'ubuntu.satimis.com' failed
error: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 111'
$ hostname -f
Code:
ubuntu.xyz.com
$ ps aux | grep mysql
Code:
root      4557  0.0  0.0   3860   572 ?        S    20:35   0:00 /bin/sh /usr/bin/mysqld_safe
mysql     4599  0.0  1.0 160556 21992 ?        Sl   20:35   0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root      4600  0.0  0.0   3768   576 ?        S    20:35   0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld
satimis   5133  0.0  0.0   5028   828 pts/1    S+   21:15   0:00 grep mysql

$ cat /var/log/daemon.log | grep 111
No printout

$ cat /var/log/messages | grep 111
Code:
Oct 23 08:54:28 ubuntu kernel: [   24.857900] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
Oct 23 08:54:28 ubuntu kernel: [   33.667111] i2c_adapter i2c-1: nForce2 SMBus adapter at 0x1c40
Oct 23 09:50:31 ubuntu kernel: [   23.021112] io scheduler cfq registered (default)
Oct 23 09:50:31 ubuntu kernel: [   25.185695] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
Oct 23 09:50:31 ubuntu kernel: [   27.717111] sd 1:0:0:0: Attached scsi disk sda
Oct 23 09:50:31 ubuntu kernel: [   33.805111] ACPI: PCI Interrupt Link [AAZA] enabled at IRQ 21
Oct 23 19:05:48 ubuntu kernel: [   25.327627] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
Oct 23 19:43:21 ubuntu kernel: [   22.142111] ACPI: PCI Interrupt Link [LNK8] (IRQs 5 7 9 10 11 14 15) *0, disabled.
Oct 23 19:43:21 ubuntu kernel: [   25.058170] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
Oct 23 19:43:21 ubuntu kernel: [   33.379111] i2c_adapter i2c-0: nForce2 SMBus adapter at 0x1c00
Oct 23 20:35:27 ubuntu kernel: [   24.573772] ata2.00: ATA-7: Maxtor 6V160E0, VA111900, max UDMA/133
Please advise which log file I have to check? How to fix this problem? TIA


B.R.
satimis
 
Old 10-24-2007, 02:44 AM   #2
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655
You can get the exact error message if the mysqld service isn't running.

Check the connection with:
telnet ubuntu.xyz.com 3306

and

telnet localhost 3306

Is the connection rejected outright, or after a timeout?
 
Old 10-24-2007, 03:15 AM   #3
satimis
Senior Member
 
Registered: Apr 2003
Posts: 3,428

Original Poster
Rep: Reputation: 53
Quote:
Originally Posted by jschiwal View Post
You can get the exact error message if the mysqld service isn't running.

Check the connection with:
telnet ubuntu.xyz.com 3306

and

telnet localhost 3306

Is the connection rejected outright, or after a timeout?
Thanks for your advice.


$ telnet ubuntu.xyz.com 3306
Code:
Trying 127.0.1.1...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 3306
Code:
Trying 127.0.0.1...
telnet: Unable to connect to remote host: Connection timed out
What is port 3306?

$ cat /etc/mysql/my.cnf | grep 127.0.0.1
Code:
bind-address            = 127.0.0.1
# ndb-connectstring=127.0.0.1
Shall I comment it out? In doing so will it affect the running of bind9?


TIA


B.R.
satimis
 
Old 10-24-2007, 07:31 AM   #4
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655
3306 is the default port that mysql uses. According to your ps listing it is what your machine uses.

Please double check that the mysql server is running. And try the telnet command locally on the same machine. If you do it remotely you need to check the firewall settings.

The bind address has a different meaning here. This just means that the server is connected to a socket on localhost. That is normal.

I think that the mysql log in in the /var/lib/mysql/ directory.

Last edited by jschiwal; 10-24-2007 at 07:40 AM.
 
Old 10-24-2007, 11:19 AM   #5
satimis
Senior Member
 
Registered: Apr 2003
Posts: 3,428

Original Poster
Rep: Reputation: 53
Quote:
Originally Posted by jschiwal View Post
3306 is the default port that mysql uses. According to your ps listing it is what your machine uses.
Noted with thanks.


Quote:
Please double check that the mysql server is running.
$ sudo /etc/init.d/mysql status
Code:
 * /usr/bin/mysqladmin  Ver 8.41 Distrib 5.0.38, for pc-linux-gnu on x86_64
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.0.38-Ubuntu_0ubuntu1.1-log
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 10 min 24 sec

Threads: 1  Questions: 136  Slow queries: 0  Opens: 132  Flush tables: 1  Open tables: 17  Queries per second avg: 0.218
Please advise if you need me to run other commands for checking mysql status.


Quote:
And try the telnet command locally on the same machine. If you do it remotely you need to check the firewall settings.
I tried telnet on the same machine.


Tried again on the same machine with firewall stopped.

$ sudo iptables -F
No complaint.

$ telnet ubuntu.xyz.com 3306
Code:
Trying 127.0.1.1...
telnet: Unable to connect to remote host: Connection refused
$ telnet localhost 3306
Code:
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
Connection closed by foreign host.

Quote:
I think that the mysql log in in the /var/lib/mysql/ directory.
$ ls /var/lib/mysql
Code:
debian-5.0.flag  ibdata1  ib_logfile0  ib_logfile1  mysql  mysql_upgrade_info
$ ls /var/lib/mysql/mysql
Code:
columns_priv.frm   help_relation.MYI  time_zone_leap_second.frm
columns_priv.MYD   help_topic.frm     time_zone_leap_second.MYD
columns_priv.MYI   help_topic.MYD     time_zone_leap_second.MYI
db.frm             help_topic.MYI     time_zone.MYD
db.MYD             host.frm           time_zone.MYI
db.MYI             host.MYD           time_zone_name.frm
func.frm           host.MYI           time_zone_name.MYD
func.MYD           proc.frm           time_zone_name.MYI
func.MYI           proc.MYD           time_zone_transition.frm
help_category.frm  proc.MYI           time_zone_transition.MYD
help_category.MYD  procs_priv.frm     time_zone_transition.MYI
help_category.MYI  procs_priv.MYD     time_zone_transition_type.frm
help_keyword.frm   procs_priv.MYI     time_zone_transition_type.MYD
help_keyword.MYD   tables_priv.frm    time_zone_transition_type.MYI
help_keyword.MYI   tables_priv.MYD    user.frm
help_relation.frm  tables_priv.MYI    user.MYD
help_relation.MYD  time_zone.frm      user.MYI
Seems it is not there.


Others noted with thanks.


satimis
 
Old 10-24-2007, 02:30 PM   #6
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655
My mysql log is in /var/lib/mysql and not /var/lib/mysql/mysql. The latter is where the tables are stored.

Did you try to log into mysql either without the -h option or using "-h localhost"? That is the one that may work and if you can access it that way, you can add your hostname and a regular user.
Use, "mysql -u root", if you haven't added a password for root;
mysql -u root -p
<password>
otherwise.

---
Quote:
Trying 127.0.0.1...
Connected to localhost.localdomain.
Escape character is '^]'.
This indicates that using localhost at least that the connection isn't rejected outright.
Could you check if /etc/hosts.allow or /etc/hosts.deny are causing a problem.

Also check your /etc/hosts file. I've seen where "localhost" uses an IPV6 type address near the end of the file. Check that the first uncommented line is "127.0.0.1 localhost". If not you could have problems it you edit /etc/hosts.allow or /etc/hosts.deny.

Last edited by jschiwal; 10-24-2007 at 04:14 PM.
 
Old 10-24-2007, 09:27 PM   #7
satimis
Senior Member
 
Registered: Apr 2003
Posts: 3,428

Original Poster
Rep: Reputation: 53
Quote:
Originally Posted by jschiwal View Post
My mysql log is in /var/lib/mysql and not /var/lib/mysql/mysql. The latter is where the tables are stored.

Did you try to log into mysql either without the -h option or using "-h localhost"? That is the one that may work and if you can access it that way, you can add your hostname and a regular user.
Use, "mysql -u root", if you haven't added a password for root;
mysql -u root -p
<password>
otherwise.
I'm trying to find mysql log file in order to discover the cause of problem in running "mysqladmin -h ubuntu.xyz.com root password myrootsqlpassword"

I followed this link to proceed;
SHOW mysqld LOG FILES;
http://dev.mysql.com/doc/refman/5.0/...-commands.html

$ mysql --user=root --password=mysqlpassword
Code:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.38-Ubuntu_0ubuntu1.1-log Ubuntu 7.04 
distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW mysql LOG FILES;
ERROR 1064 (42000): You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'mysql LOG 
FILES' at line 1
Read "man mysql". The syntax is correct. It generates another problem. I can't figure out how to correct it. Any advice? TIA.


# find / -name mysql.log
Code:
/var/log/mysql.log

But it is an empty file;
# cat /var/log/mysql.log
No printout


Quote:
This indicates that using localhost at least that the connection isn't rejected outright.
Could you check if /etc/hosts.allow or /etc/hosts.deny are causing a problem.

Also check your /etc/hosts file. I've seen where "localhost" uses an IPV6 type address near the end of the file. Check that the first uncommented line is "127.0.0.1 localhost". If not you could have problems it you edit /etc/hosts.allow or /etc/hosts.deny.
$ cat /etc/hosts.allow
Code:
sshd: 127.0.0.1

# Domain
sshd: .xyz.com

# Pacific from home
sshd: *.myISP.com

sshd sshd1 sshd2 : ALL : ALLOW

$ cat /etc/hosts.deny
Code:
sshd:ALL EXCEPT localhost \
: spawn /bin/echo `/bin/date` access denied for %a %h>>/var/log/sshd.log

ALL:ALL
$ cat /etc/hosts
Code:
127.0.0.1       localhost.localdomain   localhost
127.0.1.1       ubuntu.xyz.com      ubuntu

# The following lines are desirable for IPv6 capable hosts
::1     ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

B.R.
satimis

Last edited by satimis; 10-24-2007 at 09:29 PM.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem installing Mysql 5.0 on SUSE 10 eys_linux Linux - Software 1 01-31-2007 01:40 PM
Problem with installing mysql desperatly Disku Linux - Newbie 2 11-21-2006 06:56 PM
problem installing Mysql from rpm. hottdogg Slackware 8 06-24-2006 10:54 PM
Problem installing mysql using DotDeb slashdotdash Debian 1 12-08-2004 02:32 AM
Problem Installing MySQL kaplan71 Mandriva 1 05-12-2004 10:35 PM


All times are GMT -5. The time now is 01:00 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration