socket exception

[Chaya' <cr...@gmail.com>]

i've tried roller 1.2 with Fedora Core 4 using tomcat Mysql and i've
got socket exception.I've read in
http://www.rollerweblogger.org/wiki/Wiki.jsp?page=DebianMySQL and i've
found the solution to comment out the skip-network.The problem is i
can't found skip-network on my.cnf file.

Here is all my.cnf :

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Thx before

Re: socket exception

[Anil Gangolli <an...@busybuddha.org>]

I'd suggest checking

% netstat -an | grep 3306

and verifying that something is listening on the normal mysql port.

or as root

# lsof -i :3306

which will tell you what. 

If it appears to be listening as expected, then try:

% mysql --protocol=TCP --port=3306 -uUSER -pPASSWORD

but replacing USER and PASSWORD in the above with the database username and
password that you have in your Roller configuration.  If it connects, it's working; if not, it will give you some additional info.

--a.




----- Original Message ----- 
From: "Chaya'" <cr...@gmail.com>
To: <ro...@incubator.apache.org>
Sent: Tuesday, July 05, 2005 12:51 AM
Subject: socket exception


> i've tried roller 1.2 with Fedora Core 4 using tomcat Mysql and i've
> got socket exception.I've read in
> http://www.rollerweblogger.org/wiki/Wiki.jsp?page=DebianMySQL and i've
> found the solution to comment out the skip-network.The problem is i
> can't found skip-network on my.cnf file.
> 
> Here is all my.cnf :
> 
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> # Default to using old password format for compatibility with mysql 3.x
> # clients (those using the mysqlclient10 compatibility package).
> old_passwords=1
>     
> [mysql.server]
> user=mysql
> basedir=/var/lib
> 
> [mysqld_safe]
> err-log=/var/log/mysqld.log
> pid-file=/var/run/mysqld/mysqld.pid
> 
> Thx before
>

Re: socket exception

[Allen Gilliland <Al...@Sun.COM>]

if you don't see the skip-network property in your my.cnf then that 
isn't your problem.  the other way to test it is to connect to your 
mysql instance from another computer ... if you can do that then 
skip-network isn't enabled.

you'll have to give more output from your problem so we can try and 
figure out what is happening.

-- Allen


Chaya' wrote:

>i've tried roller 1.2 with Fedora Core 4 using tomcat Mysql and i've
>got socket exception.I've read in
>http://www.rollerweblogger.org/wiki/Wiki.jsp?page=DebianMySQL and i've
>found the solution to comment out the skip-network.The problem is i
>can't found skip-network on my.cnf file.
>
>Here is all my.cnf :
>
>[mysqld]
>datadir=/var/lib/mysql
>socket=/var/lib/mysql/mysql.sock
># Default to using old password format for compatibility with mysql 3.x
># clients (those using the mysqlclient10 compatibility package).
>old_passwords=1
>     
>[mysql.server]
>user=mysql
>basedir=/var/lib
>
>[mysqld_safe]
>err-log=/var/log/mysqld.log
>pid-file=/var/run/mysqld/mysqld.pid
>
>Thx before
>  
>