Author |
Message |
cesman
|
Posted: Mon Dec 26, 2005 11:28 pm |
|
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location:
Fontana, Ca
|
Can you connect to mysql?mysql -u mythtv -pmythtv
_________________ cesman
When the source is open, the possibilities are endless!
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Mon Dec 26, 2005 11:35 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
Yes, I can. Output from that command is:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5 to server version: 4.0.22-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
nigelpearson
|
Posted: Tue Dec 27, 2005 4:12 am |
|
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location:
Sydney, Australia
|
Weird. Local mysql works.
Try this one: Code: mysql -h 192.168.0.80 -u mythtv -pmythtv
_________________ | Nigel Pearson, nigel.pearson.au@gmail.com| "Things you own end up owning you" - Tyler, Fight Club
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 12:00 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
strange Output is:
ERROR 2003: Can't connect to MySQL server on '192.168.0.80' (111)
That does not require X-Term, right?
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
cesman
|
Posted: Tue Dec 27, 2005 12:38 pm |
|
Joined: Fri Sep 19, 2003 7:05 pm
Posts: 5088
Location:
Fontana, Ca
|
Why would it require xterm? Edit my.cnf and remove or comment skip-networking then restart mysql and try again.
_________________ cesman
When the source is open, the possibilities are endless!
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 12:53 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
As you know, I don't know when X-Term is required, because I'm not as educated as you are in this realm.
I commented out skip-networking then ran '/etc/init.d/mysql restart' as root. Same errors, so I rebooted, and still have the same errors.
Thanks to all for your help.
Do you chaps have an idea as to what went wrong?
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
tjc
|
Posted: Tue Dec 27, 2005 7:03 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
nigelpearson wrote: Weird. Local mysql works. Try this one: Code: mysql -h 192.168.0.80 -u mythtv -pmythtv
Nigel, did you talk to ThisPage... seperately to determine what the IP address is? I don't see it anywhere in this thread...
If not (and you didn't autotranslate to the correct IP) I'd try 127.0.0.1 to use the loopback or the real IP address of the machine.
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 7:39 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
Thank you very much. Output as follows:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 136 to server version: 4.0.22-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 7:40 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
The IP is 192.168.0.80.
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
tjc
|
Posted: Tue Dec 27, 2005 7:50 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
Well if 127.0.0.1 works and 192.168.0.80 doesn't... Let's just say I'm suspicious. What does ifconfig show? For example:
Code: root@black2:~# ifconfig eth0 Link encap:Ethernet HWaddr 00:04:61:92:7E:F6 inet addr:192.168.1.103 Bcast:192.168.1.255 Mask:255.255.255.0 inet6 addr: fe80::204:61ff:fe92:7ef6/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:269230 errors:0 dropped:0 overruns:0 frame:0 TX packets:295454 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:39995710 (38.1 MiB) TX bytes:167391966 (159.6 MiB) Interrupt:19 Base address:0x2000
lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:9708150 errors:0 dropped:0 overruns:0 frame:0 TX packets:9708150 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:933317584 (890.0 MiB) TX bytes:933317584 (890.0 MiB)
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 8:20 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
eth0 Link encap:Ethernet HWaddr 00:11:09:8F:39:D7
inet addr:192.168.0.80 Bcast:192.168.0.255 Mask:255.255.255.0
inet6 addr: fe80::211:9ff:fe8f:39d7/64 Scope:Link
UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1
RX packets:9391 errors:0 dropped:0 overruns:0 frame:0
TX packets:202 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:1000
RX bytes:1365277 (1.3 MiB) TX bytes:16780 (16.3 KiB)
Interrupt:16 Base address:0xe000
lo Link encap:Local Loopback
inet addr:127.0.0.1 Mask:255.0.0.0
inet6 addr: ::1/128 Scope:Host
UP LOOPBACK RUNNING MTU:16436 Metric:1
RX packets:1381 errors:0 dropped:0 overruns:0 frame:0
TX packets:1381 errors:0 dropped:0 overruns:0 carrier:0
collisions:0 txqueuelen:0
RX bytes:93437 (91.2 KiB) TX bytes:93437 (91.2 KiB)
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
tjc
|
Posted: Tue Dec 27, 2005 9:36 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
How about a netstst -nr and cat /etc/hosts?
|
|
Top |
|
 |
nigelpearson
|
Posted: Tue Dec 27, 2005 9:41 pm |
|
Joined: Wed Mar 03, 2004 7:43 pm
Posts: 748
Location:
Sydney, Australia
|
tjc wrote: Nigel, did you talk to ThisPage... seperately to determine what the IP address is? I don't see it anywhere in this thread... 'Twas early in the thread (frontend verbose output?) Quote: I'd try 127.0.0.1 to use the loopback.
Good suggestion, but I think the local mysql client already uses that?
ThisPageInten.., give the following a go: Code: ping -c 5 192.168.0.80 telnet 192.168.0.80 3306
followed by a few returns
The first will check your networking, and the second will check if MySQL is really listening for incoming connections. I suspect that "skip-networking" is still enabled in /etc/mysql/my.cnf like Cecil suggested.
_________________ | Nigel Pearson, nigel.pearson.au@gmail.com| "Things you own end up owning you" - Tyler, Fight Club
|
|
Top |
|
 |
ThisPageIntentionallyLeft
|
Posted: Tue Dec 27, 2005 9:43 pm |
|
Joined: Fri Jun 24, 2005 3:22 pm
Posts: 124
|
127.0.0.1 overturetv localhost
# The following lines are desirable for IPv6 capable hosts
# (added automatically by netbase upgrade)
::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
_________________ AMD Athlon XP 2800+
MSI K7N2 Delta2 ATX w/FX5200 AGP video
2X256MB PC3200 RAM
Maxtor 250GB drive (master on IDE 1)
Pioneer DVR-109 (master on IDE 2)
Antec Overture II ATX case with 330watts
Hauppauge 250 in PCI slot 2
|
|
Top |
|
 |
tjc
|
Posted: Tue Dec 27, 2005 9:45 pm |
|
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location:
Arlington, MA
|
Or: Code: netstat -an | grep 3306
|
|
Top |
|
 |