View unanswered posts    View active topics

All times are UTC - 6 hours





Post new topic Reply to topic  [ 43 posts ] 
Go to page Previous  1, 2, 3  Next

Print view Previous topic   Next topic  
Author Message
Search for:
 Post subject:
PostPosted: Mon Dec 26, 2005 11:28 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Mon Dec 26, 2005 11:35 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 4:12 am 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 12:00 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 12:38 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 12:53 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 7:03 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 7:39 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 7:40 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 7:50 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 8:20 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:36 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
How about a netstst -nr and cat /etc/hosts?


Top
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:41 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:43 pm 
Offline
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
 Profile  
 
 Post subject:
PostPosted: Tue Dec 27, 2005 9:45 pm 
Offline
Joined: Thu Mar 25, 2004 11:00 am
Posts: 9551
Location: Arlington, MA
Or:
Code:
netstat -an | grep 3306


Top
 Profile  
 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 43 posts ] 
Go to page Previous  1, 2, 3  Next



All times are UTC - 6 hours




Who is online

Users browsing this forum: No registered users and 22 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group

Theme Created By ceyhansuyu