Re-5: [stunnel-users] Problem with mysql

Thu Jul 21 10:00:12 CEST 2005

Sorry, i doesn't look in the good stunnel.log, there is a SIGTERM because i stop the box!

So here is my stunnel.log :

2005.07.21 11:48:25 LOG5[230:1]: stunnel 4.11 on i686-pc-linux-gnu UCONTEXT+POLL+IPv4 with OpenSSL 0.9.7g 11 Apr 2005
2005.07.21 11:48:26 LOG7[230:1]: RAND_status claims sufficient entropy for the PRNG
2005.07.21 11:48:26 LOG6[230:1]: PRNG seeded successfully
2005.07.21 11:48:26 LOG6[230:1]: file ulimit = 1024 (can be changed with 'ulimit -n')
2005.07.21 11:48:26 LOG6[230:1]: poll() used - no FD_SETSIZE limit for file descriptors
2005.07.21 11:48:26 LOG5[230:1]: 500 clients allowed
2005.07.21 11:48:26 LOG7[230:1]: FD 4 in non-blocking mode
2005.07.21 11:48:26 LOG7[230:1]: FD 5 in non-blocking mode
2005.07.21 11:48:26 LOG7[230:1]: FD 6 in non-blocking mode
2005.07.21 11:48:26 LOG7[230:1]: SO_REUSEADDR option set on accept socket
2005.07.21 11:48:26 LOG7[230:1]: mysql bound to 127.0.0.1:3306
2005.07.21 11:48:26 LOG7[231:1]: Created pid file /stunnel.pid

So it seems to run properly but telnet 192.168.1.121 3306 ot telnet localhost 3306 doesn't work, i get a time out!

I will give you more informations :

stunnel-4.11 on an lfs system (Kernel 2.4.30 with the bridge patch and the SSP patch)

gcc -v :

Reading specs from /home/lmarcilly/lfs_install/build/usr/bin/../lib/gcc-lib/i686-pc-linux-gnu/3.3.3/specs
Configured with: ../gcc-3.3.3/configure --prefix=/usr --enable-shared --enable-threads=posix --enable-__cxa_atexit --enable-clocale=gnu --enable-languages=c,c++ --disable-nls
Thread model: posix
gcc version 3.3.3

When compiling :

./configure --prefix=/usr --disable-libwrap
make
make install

stunnel.conf :

chroot = /usr/var/stunnel/
pid = /stunnel.pid
socket = l:TCP_NODELAY=1
socket = r:TCP_NODELAY=1
debug = 7
output = /var/log/stunnel.log
client = yes
[mysql]
accept  = localhost:3306
connect = 192.168.1.104:3307

I've also tried with accept = 3306 and accept = 127.0.0.1:3306 but with no success...

I'm sorry but i have no idea and i don't know how resolve my problem so please help me...

Thanks in advance!

lm.

-------- Original Message --------
Subject: Re-4: [stunnel-users] Problem with mysql (21-juil.-2005 9:26)
From:    lmarcilly at aressi.fr
To:      lmarcilly at aressi.fr

> I try :
> 
> mysql -h 192.168.1.121 --protocol=TCP -u user --password=xxx
> 
> and i get this message :
> 
> Can't connect to MySQL server on '192.168.1.121'
> 
> I also try :
> 
> telnet 192.168.1.121 3306
> 
> and i get :
> 
> telnet : Unable to connect to remote host : Connection timed out
> 
> Here is my stunnel.log : 
> 
> 2005.07.21 11:13:07 LOG5[2462:1]: stunnel 4.11 on i686-pc-linux-gnu 
> UCONTEXT+POLL+IPv4 with OpenSSL 0.9.7g 11 Apr 2005
> 2005.07.21 11:13:07 LOG7[2462:1]: Snagged 64 random bytes from /root/.rnd
> 2005.07.21 11:13:07 LOG7[2462:1]: Wrote 1024 new random bytes to /root/.rnd
> 2005.07.21 11:13:07 LOG7[2462:1]: RAND_status claims sufficient entropy for 
> the PRNG
> 2005.07.21 11:13:07 LOG6[2462:1]: PRNG seeded successfully
> 2005.07.21 11:13:07 LOG6[2462:1]: file ulimit = 1024 (can be changed with '
> ulimit -n')
> 2005.07.21 11:13:07 LOG6[2462:1]: poll() used - no FD_SETSIZE limit for 
> file descriptors
> 2005.07.21 11:13:07 LOG5[2462:1]: 500 clients allowed
> 2005.07.21 11:13:07 LOG7[2462:1]: FD 4 in non-blocking mode
> 2005.07.21 11:13:07 LOG7[2462:1]: FD 5 in non-blocking mode
> 2005.07.21 11:13:07 LOG7[2462:1]: FD 6 in non-blocking mode
> 2005.07.21 11:13:07 LOG7[2462:1]: SO_REUSEADDR option set on accept socket
> 2005.07.21 11:13:07 LOG7[2462:1]: mysql bound to 127.0.0.1:3306
> 2005.07.21 11:13:07 LOG7[2463:1]: Created pid file /stunnel.pid
> 2005.07.21 11:15:58 LOG5[2463:0]: Received signal 15; terminating
> 2005.07.21 11:15:58 LOG7[2463:0]: removing pid file /stunnel.pid
> 
> And i think the last 2 lines are not normal!!
> But how can i see from where come the SIGTERM ?? There is always a stunnel 
> process but it doesn't work properly...
> 
> Any idea?
> 
> -------- Original Message --------
> Subject: Re: Re-2: [stunnel-users] Problem with mysql (21-juil.-2005 9:13)
> From:    bri at stunnel.org
> To:      lmarcilly at aressi.fr
> 
> > 
> > 
> > > How to do this? I try with :
> > > mysql --port=3306 --protocol=TCP -u user --password=xxx
> > > 
> > > but it won't work...
> > > 
> > > When i try telnet localhost 3306, i can't establish connection but i can on 
> > > 
> > > my windows box... I also try to analyse traffic with tcpdump and there is 
> > > no packet when i try with stunnel...
> > 
> > I've found in the past that mysql when pointing to localhost has
> > used the socket in spite of the arguments you put on the command line.
> > 
> > Try pointing to the ethernet IP address instead of 127.0.0.1 and
> > see if it's happy then.  You never know...
> > 
> > -- 
> > Brian Hatch                  "I've decided I'm not keen on
> >    Systems and                preterm labour."
> >    Security Engineer         "I'll write that down in our
> > http://www.ifokr.org/bri/     birthing plan..."
> >                              --Bree and Bri, in L&D.
> > Every message PGP signed
> > 
> 
> 
> To: bri at stunnel.org
> Cc: Michal.Trojnara at mobi-com.net
>     stunnel-users at mirt.net
> 
> 
> 
> _______________________________________________
> stunnel-users mailing list
> stunnel-users at mirt.net
> http://stunnel.mirt.net/mailman/listinfo/stunnel-users

To: lmarcilly at aressi.fr
    bri at stunnel.org
Cc: stunnel-users at mirt.net