Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 7th January 2011, 08:22
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default Pure-ftpd on Debian Lenny - updated and now login problem

Hi,

Running a multiserver setup on Debian Lenny.
ISPConfig version : 3.0.3.1

I am not sure if my problem started after I updated ISPConfig or after a Debian update.

My problem is that ftp users get :
Code:
[R] Connecting to ftp.24-timerssejlads.dk -> DNS=ftp.24-timerssejlads.dk IP=92.62.196.69 PORT=21 (attempt # 10)
[R] Connected to ftp.24-timerssejlads.dk
[R] 220---------- Welcome to Pure-FTPd [privsep] [TLS] ----------
[R] 220-You are user number 1 of 50 allowed.
[R] 220-Local time is now 08:15. Server port: 21.
[R] 220-This is a private system - No anonymous login
[R] 220-IPv6 connections are also welcome on this server.
[R] 220 You will be disconnected after 15 minutes of inactivity.
[R] USER czgames_dkdkleader
[R] 331 User XXXXXXXXXXX OK. Password required
[R] PASS (hidden)
[R] 530 Login authentication failed
[R] Connection failed
I have tried to change the password just to make sure it was a typo.
In the DontResolve it says "Yes".

Any ideas to tests I can do or just a solution ?
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
Sponsored Links
  #2  
Old 7th January 2011, 23:31
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default syslog

Just checked syslog and I am getting this :
Code:
Jan  7 08:15:43 web pure-ftpd: (?@92.62.xxx.xx) [INFO] New connection from 92.62.xxx.xx
Jan  7 08:15:43 web pure-ftpd: (?@92.62.xxx.xx) [ERROR] The SQL server seems to be down [Can't connect to MySQL server on '127.0.0.1' (111)]
Jan  7 08:15:43 web pure-ftpd: (?@92.62.xxx.xx) [INFO] PAM_RHOST enabled. Getting the peer address
Jan  7 08:15:44 web pure-ftpd: (?@92.62.xxx.xx) [WARNING] Authentication failed for user [czgames_dkdkleader]
Jan  7 08:15:50 web pure-ftpd: (?@92.62.xxx.xx) [INFO] Logout.
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
  #3  
Old 8th January 2011, 12:23
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

What's the output of
Code:
netstat -tap
?

Also, is this a physical server or a virtual machine?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 8th January 2011, 14:36
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default

It is a physical server.

Output :
Code:
web:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:9000                  *:*                     LISTEN      9590/znc
tcp        0      0 localhost:10024         *:*                     LISTEN      2371/amavisd (maste
tcp        0      0 localhost:10025         *:*                     LISTEN      3054/master
tcp        0      0 db9.superweb.dk:mysql   *:*                     LISTEN      6725/mysqld
tcp        0      0 db9.superweb.dk:ircd    *:*                     LISTEN      17107/inspircd
tcp        0      0 *:submission            *:*                     LISTEN      3054/master
tcp        0      0 localhost:spamd         *:*                     LISTEN      2531/spamd.pid
tcp        0      0 *:sunrpc                *:*                     LISTEN      1985/portmap
tcp        0      0 *:ftp                   *:*                     LISTEN      27016/pure-ftpd (SE
tcp        0      0 localhost:ipp           *:*                     LISTEN      2966/cupsd
tcp        0      0 *:smtp                  *:*                     LISTEN      3054/master
tcp        0      0 *:27                    *:*                     LISTEN      16392/sshd
tcp        0      0 *:38492                 *:*                     LISTEN      1996/rpc.statd
tcp        0      0 localhost:733           *:*                     LISTEN      3101/famd
tcp        0      0 db9.superweb.dk:57463   92-62-196-69.custo:ircd ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   db2.superweb.dk:49866   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:58472   quakenet.underworl:ircd ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   vps.superweb.dk:50214   TIME_WAIT   -
tcp        0    300 db9.superweb.dk:27      92-62-196-68.cust:56095 ESTABLISHED 19941/1
tcp        0      0 db9.superweb.dk:58473   quakenet.underworl:ircd ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   ns3.superweb.dk:50795   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:60977   db3.superweb.dk:mysql   ESTABLISHED 8987/php-cgi
tcp        0      0 db9.superweb.dk:mysql   db1.superweb.dk:51970   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:34171   quakenet.underworl:ircd ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:ircd    92-62-196-69.cust:57463 ESTABLISHED 17107/inspircd
tcp6       0      0 [::]:www                [::]:*                  LISTEN      6346/apache2
tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN      6346/apache2
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      27016/pure-ftpd (SE
tcp6       0      0 [::]:5911               [::]:*                  LISTEN      16411/vino-server
tcp6       0      0 localhost:ipp           [::]:*                  LISTEN      2966/cupsd
tcp6       0      0 [::]:https              [::]:*                  LISTEN      6346/apache2
tcp6       0      0 [::]:27                 [::]:*                  LISTEN      16392/sshd
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
  #5  
Old 9th January 2011, 19:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Can you make MySQL listen on all interfaces? This setting is in /etc/mysql/my.cnf.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 10th January 2011, 19:37
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default

When I changed bind to # bind in /etc/mysql/my.cnf it seemed to remove the problem.

I have an other issue related to this (both problems started at the same time). I get the following when I try to connect to the databases using phpmyadmin :

Code:
#2013 - Lost connection to MySQL server at 'reading initial communication packet', system error: 111
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
  #7  
Old 11th January 2011, 14:20
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

What's the output of
Code:
netstat -tap
now?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #8  
Old 11th January 2011, 14:48
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
Default

Output is now

Code:
web:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 *:9000                  *:*                     LISTEN      9590/znc
tcp        0      0 localhost:10024         *:*                     LISTEN      2371/amavisd (maste
tcp        0      0 localhost:10025         *:*                     LISTEN      3054/master
tcp        0      0 *:mysql                 *:*                     LISTEN      13955/mysqld
tcp        0      0 db9.superweb.dk:ircd    *:*                     LISTEN      17107/inspircd
tcp        0      0 *:submission            *:*                     LISTEN      3054/master
tcp        0      0 localhost:spamd         *:*                     LISTEN      2531/spamd.pid
tcp        0      0 *:sunrpc                *:*                     LISTEN      1985/portmap
tcp        0      0 *:ftp                   *:*                     LISTEN      14139/pure-ftpd (SE
tcp        0      0 localhost:ipp           *:*                     LISTEN      2966/cupsd
tcp        0      0 *:smtp                  *:*                     LISTEN      3054/master
tcp        0      0 *:27                    *:*                     LISTEN      16392/sshd
tcp        0      0 *:38492                 *:*                     LISTEN      1996/rpc.statd
tcp        0      0 localhost:733           *:*                     LISTEN      3101/famd
tcp        0      0 db9.superweb.dk:57463   92-62-196-69.custo:ircd ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   vps.superweb.dk:57648   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:58567   83.140.172.212:ircd     ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:53837   83.140.172.212:ircd     ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   ns3.superweb.dk:54417   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:33543   db8.superweb.dk:mysql   ESTABLISHED 17175/smtp
tcp        0      0 db9.superweb.dk:58565   83.140.172.212:ircd     ESTABLISHED 9590/znc
tcp        0      0 db9.superweb.dk:mysql   db2.superweb.dk:53961   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:33541   db8.superweb.dk:mysql   TIME_WAIT   -
tcp        0      0 db9.superweb.dk:33540   db8.superweb.dk:mysql   TIME_WAIT   -
tcp        0    148 db9.superweb.dk:27      92-62-196-68.cust:58124 ESTABLISHED 17161/1
tcp        0      0 db9.superweb.dk:ircd    92-62-196-69.cust:57463 ESTABLISHED 17107/inspircd
tcp        0      0 db9.superweb.dk:33542   db8.superweb.dk:mysql   TIME_WAIT   -
tcp6       0      0 [::]:www                [::]:*                  LISTEN      14123/apache2
tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN      14123/apache2
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN      14139/pure-ftpd (SE
tcp6       0      0 [::]:5911               [::]:*                  LISTEN      16411/vino-server
tcp6       0      0 localhost:ipp           [::]:*                  LISTEN      2966/cupsd
tcp6       0      0 [::]:https              [::]:*                  LISTEN      14123/apache2
tcp6       0      0 [::]:27                 [::]:*                  LISTEN      16392/sshd
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
  #9  
Old 12th January 2011, 13:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Looks good. Please try this: http://imdad.wordpress.com/2008/11/0...tem-error-111/
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #10  
Old 12th January 2011, 14:49
DKLeader DKLeader is offline
Senior Member
 
Join Date: Sep 2010
Location: Ishoej, Denmark
Posts: 113
Thanks: 6
Thanked 0 Times in 0 Posts
 
Default [solved]

Thanks for the link - it didnt directly solve my problem but made me check the my.cnf again and what I hadnt seen was that during the lastest debian apt-get update the port setting in my.cnf had been changed back to 3306 - since I have multiple servers behind a router all running mysql I had changed the ports.
__________________
VoiceMe
Communications


Hosted at :
SuperWeb.dk
a part of VoiceMe
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 17:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.