On 4/25/05, Nick Rout <[EMAIL PROTECTED]> wrote:
>
> On Mon, 25 Apr 2005 15:03:35 -0700
> Mark Knecht wrote:
> >
> > Does mysql require some sort of network protocol that mightnot be
> > running? Samba, NFS, etc.?
>
> Thats what the startup scripts are for. They should automatically start
> required scripts. If in doubt take a look at the init script. In my
> /etc/init.d/mysql it says:
>
> depend() {
> use dns net
>
> That means mysql will use the network and dns resolution operating, but
> doesn't need them.
>
> see http://www.gentoo.org/doc/en/handbook/handbook-x86.xml?part=2&chap=4
>
> As someone else said, look in your logs.
>
> To check that mysql is actually running try the ps command.
>
> ps ax|grep mysql
>
Thanks for the info.
OK, using ps aux | grep mysql returned nothing so it wasn't running.
To eliviate my frustration I rebuilt mysql along with all of MythTV,
or at least the parts I had installed before. I'm sure that was
overkill but now mysql and MythTV are starting to work again:
dragonfly ~ # ps aux | grep mysql
root 21769 0.0 0.2 2084 1048 ? Ss 16:10 0:00
/bin/sh /usr/bin/mysqld_safe
mysql 21804 0.0 1.4 39200 7200 ? Sl 16:10 0:00
/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql
--pid-file=/var/run/mysqld/mysqld.pid --skip-locking --port=3306
--socket=/var/run/mysqld/mysqld.sock
root 21935 0.0 0.0 1476 464 pts/0 R+ 16:19 0:00 grep mysql
dragonfly ~ #
and I can log in when on the backend machine:
dragonfly ~ # mysql -u root -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14 to server version: 4.0.24
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> quit
Bye
dragonfly ~ #
And I can also get into mythtv-setup and even the front end, to some extent.
The place I'm a bit stalled at right now, and I'm sure it's a config
issue only, is that I need mysql to be bound to the network address of
the machine it's running on (dragonfly) so that I can access the
mythbackend from other parts of the house. (XBox running Linux when
this works, but my laptop for now) To that end I changed
/etc/mysql/my.cnf like this:
# keep secure by default!
#bind-address = 127.0.0.1
bind-address = 192.168.10.55
port = 3306
# this can make it even more secure:
and restarted mysql. Now netstat shows it listening, I think:
dragonfly ~ # netstat -apn | grep mysql
tcp 0 0 192.168.10.55:3306 0.0.0.0:*
LISTEN 21804/mysqld
unix 2 [ ACC ] STREAM LISTENING 90716 21804/mysqld
/var/run/mysqld/mysqld.sock
dragonfly ~ #
Nowever, when I try to log in from any machine on the network I don't
seem to be able to get in:
dragonfly ~ # mysql -h 192.168.10.55 -u root -p mythconverg
Enter password:
ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)
dragonfly ~ #
I ran these commands within mysql to hopefully open it up to other
tcp/ip addresses:
dragonfly ~ # mysql -u root -p mythconverg
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 16 to server version: 4.0.24
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> quit
Bye
dragonfly ~ #
But it still doesn't let me in. Teh same thing happens in mythfrontend
judging from what I see in the terminal:
2005-04-25 16:14:11.368 Changing from None to None
2005-04-25 16:14:37.991 Writing settings file /home/mark/.mythtv/mysql.txt
2005-04-25 16:14:38.001 Connecting to backend server:
192.168.10.55:6543 (try 1 of 5)
Connection timed out.
You probably should modify the Master Server settings
in the setup program and set the proper IP address.
2005-04-25 16:15:08.192 Connecting to backend server:
192.168.10.55:6543 (try 1 of 5)
Connection timed out.
You probably should modify the Master Server settings
in the setup program and set the proper IP address.
2005-04-25 16:15:09.230 Changing from None to None
2005-04-25 16:15:13.607 Connecting to backend server:
192.168.10.55:6543 (try 1 of 5)
Connection timed out.
You probably should modify the Master Server settings
in the setup program and set the proper IP address.
[EMAIL PROTECTED] ~ $
/var/log/mysql/mysql.err shows only:
050425 16:10:45 mysqld started
/var/log/mysql/mysqld.log shows only:
/usr/sbin/mysqld: ready for connections.
Version: '4.0.24' socket: '/var/run/mysqld/mysqld.sock' port: 3306
Gentoo Linux mysql-4.0.24
Do I possibly just have the format of the remote login command wrong?
Any ideas?
Thanks much,
Mark
--
[email protected] mailing list
