Question about Virtual Hosting With Proftpd And MySQL (Incl. Quota) On Debian Etch

Discussion in 'HOWTO-Related Questions' started by ikkem, Feb 21, 2008.

  1. ikkem

    ikkem New Member

    I followed the instructions from this how to http://www.howtoforge.com/proftpd_mysql_virtual_hosting_debian_etch

    When I try to login to proftpd I get this error message....

    Code:
     Status:	Connecting to myipadress:21...
    Error:	Could not connect to server
    Code:
    Status:	Connecting to 127.0.0.1:21...
    Status:	Connection established, waiting for welcome message...
    Response:	220 My FTPD
    Command:	USER ikkem
    Response:	331 Password required for ikkem.
    Command:	PASS ********
    Response:	530 Login incorrect.
    Error:	Could not connect to server 
    Could someone please help me to solve this problem i have been at it for almost a week now.
    Thanks in advance...
     
  2. topdog

    topdog New Member HowtoForge Supporter

    The first problem could be a firewall blocking access or your ftp server binding only to localhost.

    As for the second one, are there any errors in the logs ?
     
  3. ikkem

    ikkem New Member

    @topdog thanks for reacting

    I use shorewall behind a speedtouch router could you point me into the right direction in how to make contact with the net through the right routes.
    A noob question where should i look for the log files also which comands should i give to check proftpd...
    I tried to connect to proftpd through a other computer in the lan area but I could not connect also....

    thanks in advance

    ikkem
     
  4. topdog

    topdog New Member HowtoForge Supporter

    You need to allow ftp on shorewall then port forward ftp from the speedtouch router.

    The problem is an authentication on so check, /var/log/syslog and also the proftpd server logs
     
  5. ikkem

    ikkem New Member

    hi these are the rules in my /etc/shorewall/rules

    Code:
    FTP/ACCEPT     net       loc	tcp
    
    ACCEPT    net    fw    tcp    20
    ACCEPT    net    fw    tcp    21
    ACCEPT    net    fw    tcp    2900 
    /var/log/syslog info

    Code:
     Shorewall:logflags:DROP:IN=eth0 OUT= MAC=00:1a:92:55:09:5c:00:18:f6:05:40:6f:08:00 SRC=202.10.89.8 DST=192.168.1.72 LEN=40 TOS=0x00 PREC=0x00 TTL=235 ID=0 DF PROTO=TCP SPT=51099 DPT=50847 WINDOW=32768 RES=0x00 URGP=0 
    Feb 21 08:44:26 localhost kernel: Shorewall:logflags:DROP:IN=eth0 OUT= MAC=00:1a:92:55:09:5c:00:18:f6:05:40:6f:08:00 SRC=220.233.122.214 DST=192.168.1.72 LEN=40 TOS=0x00 PREC=0x00 TTL=239 ID=0 DF PROTO=TCP SPT=2254 DPT=46261 WINDOW=32768 RES=0x00 URGP=0 
    Feb 21 08:44:29 localhost last message repeated 3 times
    Feb 21 08:50:09 localhost root: Shorewall restarted
    Feb 21 09:00:03 localhost root: Shorewall restarted
    Feb 21 09:04:23 localhost kernel: Shorewall:logflags:DROP:IN=eth0 OUT= MAC=00:1a:92:55:09:5c:00:18:f6:05:40:6f:08:00 SRC=220.233.122.214 DST=192.168.1.72 LEN=40 TOS=0x00 PREC=0x00 TTL=239 ID=0 DF PROTO=TCP SPT=2254 DPT=57781 WINDOW=32768 RES=0x00 URGP=0 
    Feb 21 09:04:32 localhost last message repeated 8 times
    Feb 21 09:09:01 localhost /USR/SBIN/CRON[19995]: (root) CMD (  [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -r -0 rm)
    Feb 21 09:17:01 localhost /USR/SBIN/CRON[20213]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    Feb 21 09:34:57 localhost -- MARK --
    Feb 21 09:39:01 localhost /USR/SBIN/CRON[20838]: (root) CMD (  [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -r -0 rm)
    Feb 21 09:54:58 localhost -- MARK --
    Feb 21 10:09:01 localhost /USR/SBIN/CRON[22096]: (root) CMD (  [ -d /var/lib/php5 ] && find /var/lib/php5/ -type f -cmin +$(/usr/lib/php5/maxlifetime) -print0 | xargs -r -0 rm)
    Feb 21 10:17:01 localhost /USR/SBIN/CRON[22399]: (root) CMD  

    /var/log/proftpd/proftpd.log info

    Code:
    Feb 21 05:36:07 server1 proftpd[19377] localhost: error setting IPV6_V6ONLY: Protocol not available
    Feb 21 05:36:07 server1 proftpd[19377] localhost: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone mode STARTUP
    Feb 21 05:59:51 server1 proftpd[19377] localhost: ProFTPD killed (signal 15)
    Feb 21 05:59:51 server1 proftpd[19377] localhost: ProFTPD 1.3.0 standalone mode SHUTDOWN
    Feb 21 05:59:53 server1 proftpd[20593] localhost: error setting IPV6_V6ONLY: Protocol not available
    Feb 21 05:59:53 server1 proftpd[20593] localhost: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone mode STARTUP
    Feb 21 06:13:54 server1 proftpd[20593] localhost: ProFTPD killed (signal 15)
    Feb 21 06:13:54 server1 proftpd[20593] localhost: ProFTPD 1.3.0 standalone mode SHUTDOWN
    Feb 21 06:15:05 server1 proftpd[5026] localhost: error setting IPV6_V6ONLY: Protocol not available
    Feb 21 06:15:05 server1 proftpd[5026] localhost: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone mode STARTUP
    Feb 21 06:32:16 server1 proftpd[5026] localhost: ProFTPD killed (signal 15)
    Feb 21 06:32:16 server1 proftpd[5026] localhost: ProFTPD 1.3.0 standalone mode SHUTDOWN
    Feb 21 06:32:18 server1 proftpd[11118] localhost: error setting IPV6_V6ONLY: Protocol not available
    Feb 21 06:32:18 server1 proftpd[11118] localhost: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone mode STARTUP
    Feb 21 08:14:16 server1 proftpd[13640] localhost (localhost[::ffff:127.0.0.1]): FTP session closed.
    Feb 21 08:20:33 server1 proftpd[13882] localhost (localhost[::ffff:127.0.0.1]): FTP session closed.
    Feb 21 08:50:35 server1 proftpd[18090] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 08:50:40 server1 proftpd[18093] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 08:50:45 server1 proftpd[18096] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 08:52:34 server1 proftpd[18145] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:52:39 server1 proftpd[18148] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:52:44 server1 proftpd[18151] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:54:07 server1 proftpd[18183] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:54:12 server1 proftpd[18186] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:54:17 server1 proftpd[18189] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:55:09 server1 proftpd[18210] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:55:14 server1 proftpd[18213] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 08:55:19 server1 proftpd[18216] localhost (Unknown-00-c0-a8-f0-7e-71.lan[::ffff:192.168.1.70]): FTP session closed.
    Feb 21 09:01:33 server1 proftpd[19782] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 09:01:38 server1 proftpd[19785] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 09:01:43 server1 proftpd[19788] localhost (::ffff:77.163.218.144[::ffff:77.163.218.144]): FTP session closed.
    Feb 21 09:03:25 server1 proftpd[11118] localhost: ProFTPD killed (signal 15)
    Feb 21 09:03:25 server1 proftpd[11118] localhost: ProFTPD 1.3.0 standalone mode SHUTDOWN
    Feb 21 09:03:27 server1 proftpd[19844] localhost: ProFTPD 1.3.0 (stable) (built mar gen 2 10:57:47 CET 2007) standalone mode STARTUP
    Feb 21 09:03:40 server1 proftpd[19859] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:03:45 server1 proftpd[19862] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:03:50 server1 proftpd[19865] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:06:41 server1 proftpd[19935] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:06:47 server1 proftpd[19938] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:06:52 server1 proftpd[19941] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:13:58 server1 proftpd[20127] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:14:03 server1 proftpd[20130] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:14:09 server1 proftpd[20133] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 09:14:35 server1 proftpd[20146] localhost (Unknown-00-c0-a8-f0-7e-71.lan[192.168.1.70]): FTP session closed.
    Feb 21 09:14:40 server1 proftpd[20149] localhost (Unknown-00-c0-a8-f0-7e-71.lan[192.168.1.70]): FTP session closed.
    Feb 21 09:14:45 server1 proftpd[20152] localhost (Unknown-00-c0-a8-f0-7e-71.lan[192.168.1.70]): FTP session closed.
    Feb 21 09:35:28 server1 proftpd[20724] localhost (Unknown-00-1a-92-55-09-5c.lan[192.168.1.72]): FTP session closed.
    Feb 21 10:05:46 server1 proftpd[21694] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:46 server1 proftpd[21695] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:46 server1 proftpd[21696] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:46 server1 proftpd[21697] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:49 server1 proftpd[21702] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:49 server1 proftpd[21703] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:49 server1 proftpd[21704] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:49 server1 proftpd[21705] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:52 server1 proftpd[21708] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:52 server1 proftpd[21710] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:52 server1 proftpd[21711] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:52 server1 proftpd[21709] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:54 server1 proftpd[21716] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:54 server1 proftpd[21717] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:54 server1 proftpd[21718] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:54 server1 proftpd[21719] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:55 server1 proftpd[21722] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:55 server1 proftpd[21723] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:55 server1 proftpd[21724] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:05:55 server1 proftpd[21725] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:03 server1 proftpd[21732] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:03 server1 proftpd[21733] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:03 server1 proftpd[21734] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:03 server1 proftpd[21735] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:55 server1 proftpd[21758] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:55 server1 proftpd[21759] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:55 server1 proftpd[21760] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:06:55 server1 proftpd[21761] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:21 server1 proftpd[21774] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:21 server1 proftpd[21776] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:21 server1 proftpd[21775] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:21 server1 proftpd[21777] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:22 server1 proftpd[21780] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:22 server1 proftpd[21781] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:22 server1 proftpd[21782] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:22 server1 proftpd[21783] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:28 server1 proftpd[21791] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:28 server1 proftpd[21790] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:28 server1 proftpd[21792] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:28 server1 proftpd[21793] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21796] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21797] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21798] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21799] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21802] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21804] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21805] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:29 server1 proftpd[21803] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21808] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21809] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21810] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21811] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21815] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21816] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21817] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:31 server1 proftpd[21814] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:32 server1 proftpd[21820] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:32 server1 proftpd[21821] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:32 server1 proftpd[21822] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:32 server1 proftpd[21823] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21828] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21829] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21830] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21831] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21834] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21835] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21837] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:33 server1 proftpd[21836] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:34 server1 proftpd[21840] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:34 server1 proftpd[21841] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:34 server1 proftpd[21842] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:34 server1 proftpd[21843] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:38 server1 proftpd[21848] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:38 server1 proftpd[21849] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:38 server1 proftpd[21850] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:07:38 server1 proftpd[21851] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:14 server1 proftpd[21868] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:14 server1 proftpd[21869] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:14 server1 proftpd[21870] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:14 server1 proftpd[21871] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:15 server1 proftpd[21875] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:15 server1 proftpd[21876] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:15 server1 proftpd[21877] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:15 server1 proftpd[21874] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:16 server1 proftpd[21880] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:16 server1 proftpd[21881] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:16 server1 proftpd[21882] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:16 server1 proftpd[21883] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:17 server1 proftpd[21886] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:17 server1 proftpd[21887] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:17 server1 proftpd[21888] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:17 server1 proftpd[21889] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:18 server1 proftpd[21894] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:18 server1 proftpd[21896] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:18 server1 proftpd[21897] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:18 server1 proftpd[21895] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:21 server1 proftpd[21903] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:21 server1 proftpd[21904] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:21 server1 proftpd[21905] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:08:21 server1 proftpd[21906] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:09:26 server1 proftpd[22124] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 10:09:37 server1 proftpd[22132] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 10:09:54 server1 proftpd[22143] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:09:54 server1 proftpd[22144] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:09:54 server1 proftpd[22145] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:09:54 server1 proftpd[22146] localhost (localhost[127.0.0.1]): FTP session closed.
    Feb 21 10:11:03 server1 proftpd[22180] localhost (77.163.218.144[77.163.218.144]): FTP session closed.
    Feb 21 10:11:14 server1 proftpd[22207] localhost (Unknown-00-1a-92-55-09-5c.lan[192.168.1.72]): FTP session closed.
      
     
    Last edited: Feb 21, 2008
  6. topdog

    topdog New Member HowtoForge Supporter

    The logs are not very helpfull the exact issue is not being logged. Please verify that mysql is running and that you can connect as the user proftpd is connecting as.

    If you can connect then check the proftpd user table to double check if the username and password you are using are in there.
     
  7. ikkem

    ikkem New Member

    @topdog thanks for reacting....
    if i type mysql in the user terminal i get....
    Code:
     ERROR 1045 (28000): Access denied for user 'ikkem'@'localhost' (using password: NO)
     
    ftp connection....
    Code:
    ftp 127.0.0.1
    Connected to 127.0.0.1.
    421 Service not available, remote server has closed connection
    ftp>
      
    thanks in advance
     
  8. topdog

    topdog New Member HowtoForge Supporter

    It may be mysql related but the command you typed is wrong try this
    Code:
    mysql -u the_user_proftp_connects_ass -p
    
     
  9. ikkem

    ikkem New Member

    the output of the command is :

    Code:
    ikkem@server1:~$ mysql -u proftpduser -p
    Enter password:
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 16
    Server version: 5.0.32-Debian_7etch5-log Debian etch distribution
    
    Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
    
    mysql>
    thanks in advance....
     
  10. topdog

    topdog New Member HowtoForge Supporter

    Code:
    use ftp;
    select userid,passwd,homedir from ftpuser;
    
    Do you see user name ikkem and your password in there ?
     
  11. ikkem

    ikkem New Member

    @topdog could you please be more specific i am not that fast :)
     
  12. topdog

    topdog New Member HowtoForge Supporter

    I mean connect to the mysql server like i showed you in the previous post then run those sql queries to verify that the user name and password you are using to login in to the ftp server are correct in the database since i have seen that the ftpuser can connect to the db without a problem.
     
  13. ikkem

    ikkem New Member

    @topdog Thanks for the code this is the output...
     
  14. topdog

    topdog New Member HowtoForge Supporter

    can ftpuser/ftpgroup write to /var/proftp/ikkem, further that that i cannot think of anything else :(
     
  15. ikkem

    ikkem New Member

    again I must say I am not that fast please talk slowly:D
    which commands should I use to check or make ftpuser/ftpgroup write to /var/proftp/ikkem...

    thanks in advance
     
  16. topdog

    topdog New Member HowtoForge Supporter

    Code:
    ls -l /var/proftp
    ls -l /var/
    
     
  17. ikkem

    ikkem New Member

    @topdog Thanks for pointing me in the right direction

    thanks in advance....
     
  18. topdog

    topdog New Member HowtoForge Supporter

    Okay i think i know what the problem is i have just glanced through the howto, i think the system expects clear text passwords and your password in the db is encrypted. You need to change the password to cleartext then test.
    http://www.howtoforge.com/proftpd_mysql_virtual_hosting_debian_etch_p3

    remember to reload proftpd after you have made the change.
     
  19. ikkem

    ikkem New Member

    thanks again topdog I have tried changing it to clear text but I still get the error message....

    Code:
    Status:	Connecting to 127.0.0.1:21...
    Status:	Connection established, waiting for welcome message...
    
    Status:	Connecting to myip:21...
    Status:	Connection established, waiting for welcome message...
    Error:	Could not connect to server
    Error:	Could not connect to server  
    Thanks in advance....
    ikkem
     
  20. topdog

    topdog New Member HowtoForge Supporter

    Isn't it a different error now as even the welcome message is not being displayed.
     

Share This Page