Pure-ftpd on Debian Lenny - updated and now login problem

Discussion in 'Installation/Configuration' started by DKLeader, Jan 7, 2011.

  1. DKLeader

    DKLeader New Member

    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 :) ?
     
  2. DKLeader

    DKLeader New Member

    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.
    
     
  3. falko

    falko Super Moderator

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

    Also, is this a physical server or a virtual machine?
     
  4. DKLeader

    DKLeader New Member

    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
    
     
  5. falko

    falko Super Moderator

    Can you make MySQL listen on all interfaces? This setting is in /etc/mysql/my.cnf.
     
  6. DKLeader

    DKLeader New Member

    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
    
     
  7. falko

    falko Super Moderator

    What's the output of
    Code:
    netstat -tap 
    now?
     
  8. DKLeader

    DKLeader New Member

    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
     
  9. falko

    falko Super Moderator

  10. DKLeader

    DKLeader New Member

    [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.
     

Share This Page