Jump to content
Froxlor Forum
  • 0

[solved] Keine FTP Verbindung


pbpromotion

Question

Hey,

 

 

ich habe froxlor mit nginx nach dieser Anleitung hier komplett installiert und konfiguriert.

 

 

Dann hab ich einen Kunden angelegt, aber wenn ich mich mit diesem per FTP verbinden m?chte erhalte ich immer folgende Fehlermeldung

 

 

[R] Verbindung herstellen zu 78.46.x.x -> IP=78.46.x.x PORT=21
[R] Verbunden mit 78.46.99.42
[R] 220 ProFTPD 1.3.4a Server (pbpromotion.no-ip.biz FTP Server) [::ffff:78.x.x.x]
[R] USER pbpromotion
[R] 331 Password required for pbpromotion
[R] PASS (hidden)
[R] Verbindung fehlgeschlagen (Connection closed by server)

 

 

Bei falschem PW w?rde ja als Fehlermeldung 530 Password incorrect erscheinen.

 

 

Ich hoffe ihr k?nnt mir helfen.

 

 

Hier ist noch ein kleiner Auszug aus der proftpd log

 

Jan 15 14:23:16 Debian-70-wheezy-64-minimal proftpd[3452] Debian-70-wheezy-64-minimal (frbg-5d84fb8c.pool.mediaWays.net[93.x.x.x.]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: NO)
Jan 15 14:23:16 Debian-70-wheezy-64-minimal proftpd[3452] Debian-70-wheezy-64-minimal (frbg-5d84fb8c.pool.mediaWays.net[93.x.x.x]): mod_sql/4.3: check the SQLLogFile for more details
Jan 15 14:23:16 Debian-70-wheezy-64-minimal proftpd[3452] Debian-70-wheezy-64-minimal (frbg-5d84fb8c.pool.mediaWays.net[93.x.x.x]): FTP session closed.
 

Link to comment
Share on other sites

Recommended Posts

Wenn ich mich recht erinner hattest du in einem deiner Posts dein Passwort mit drinstehen - f?ngt dein Passwort tats?chlich mit einer Raute an? Sowas w?re auch ungut denn in den meisten Konfigurationsdateien leitet man damit nur ein Kommentar ein...

Link to comment
Share on other sites

Wenn ich mich recht erinner hattest du in einem deiner Posts dein Passwort mit drinstehen - f?ngt dein Passwort tats?chlich mit einer Raute an? Sowas w?re auch ungut denn in den meisten Konfigurationsdateien leitet man damit nur ein Kommentar ein...

Ja es beginnt wirklich mit einer Raute :/

 

 

Aber ich habs ja auch schon probiert das pw in froxlor zu ?ndern und dann zu connecten auch das hat keinen erfolg gebracht.

 

 

Gibt es eine M?glichkeit froxlor zu backupen und wieder einzuspielen? weil dann hau ich mir das eben alles noch mal komplett runter und installier alles neu.

 

 

mfg

Link to comment
Share on other sites

Ich denke dein Grundproblem ist/war die Raute des Passwortes. Generier eins ohne Sonderzeichen und benutz das - wenn du das ?berall korrekt eingetragen hast sollte es gehen.

 

 

Bez?glich der Frage nach dem Backup - klar - kommt aber auch drauf an was du genau backuppen willst und ob du schon Kunden mit Daten hast. Alle Datenbanken dumpen und Kundenverzeichnisse wegsichern (web, log, mail)

 

Wenn du schon neu installierst dann bitte nach der halbwegs offiziellen Anleitung aus dem Wiki und nicht aus irgendwelchen dubiosen Foren.

Link to comment
Share on other sites

Ja du hast die entsprechenden Logs schon in den ersten Post dazugepackt. Die waren vorher nicht da. Dein Problem ist ja ersichtlich:

 

Access denied for user 'froxlor'@'localhost' (using password: NO)

 

Anscheinend wurde kein Passwort in der Proftp-SQL config angegeben. Bzw. der Benutzer+Passwort stimmt nicht (wenn du sagst, der user kann sich auch nicht verbinden). Hast du auch mal 127.0.0.1 statt localhost versucht?

Link to comment
Share on other sites

HIer mal meine sql.conf

<IfModule mod_sql.c>
DefaultRoot ~
RequireValidShell off
AuthOrder mod_sql.c

SQLBackend mysql
SQLEngine on
SQLAuthenticate on

SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo froxlor@localhost froxlor meinfroxlorpw
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"

SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users

SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users

SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb
QuotaLock /var/lock/ftpd.quotatab.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
SQLNamedQuery get-quota-limit SELECT "ftp_users.username AS name, ftp_quotalimits.quota_type, ftp_quotalimits.per_session, ftp_quotalimits.limit_type, panel_customers.diskspace*1024 AS bytes_in_avail, ftp_quotalimits.bytes_out_avail, ftp_quotalimits.bytes_xfer_avail, ftp_quotalimits.files_in_avail, ftp_quotalimits.files_out_avail, ftp_quotalimits.files_xfer_avail FROM ftp_users, ftp_quotalimits, panel_customers WHERE ftp_users.username = '%{0}' AND panel_customers.loginname = SUBSTRING_INDEX('%{0}', 'ftp', 1) AND quota_type ='%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,bytes_out_used, bytes_xfer_used, files_in_used, files_out_used,files_xfer_used FROM ftp_quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used= files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name= '%{6}' AND quota_type = '%{7}'" ftp_quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies

</IfModule>

Ich hab mal in der sql.conf localhost mit 127.0.0.1 ersetzt aber bringt auch nix.

 

 

Wie aktivier ich diese hier "mod_sql/4.3: check the SQLLogFile for more details"? Vielleicht liesse sich dann ein genauer Fehler ausmachen.

 

Ich komm einfach nicht mehr weiter....

 

 

EDIT:

 

Ich hab jetzt das sqllogfile aktiviert bekommen

Jan 15 15:58:19 mod_sql/4.3[5402]: defaulting to 'mysql' backend
Jan 15 15:58:19 mod_sql/4.3[5402]: backend module 'mod_sql_mysql/4.0.8'
Jan 15 15:58:19 mod_sql/4.3[5402]: backend api    'mod_sql_api_v1'
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> sql_sess_init
Jan 15 15:58:19 mod_sql/4.3[5402]: entering     mysql cmd_defineconnection
Jan 15 15:58:19 mod_sql/4.3[5402]:   name: 'default'
Jan 15 15:58:19 mod_sql/4.3[5402]:   user: 'froxlor'
Jan 15 15:58:19 mod_sql/4.3[5402]:   host: 'localhost'
Jan 15 15:58:19 mod_sql/4.3[5402]:     db: 'froxlor'
Jan 15 15:58:19 mod_sql/4.3[5402]:   port: '3306'
Jan 15 15:58:19 mod_sql/4.3[5402]:    ttl: '0'
Jan 15 15:58:19 mod_sql/4.3[5402]: exiting     mysql cmd_defineconnection
Jan 15 15:58:19 mod_sql/4.3[5402]: connection 'default' successfully established
Jan 15 15:58:19 mod_sql/4.3[5402]: mod_sql engine     : on
Jan 15 15:58:19 mod_sql/4.3[5402]: negative_cache     : off
Jan 15 15:58:19 mod_sql/4.3[5402]: authenticate       : users groups userset groupset
Jan 15 15:58:19 mod_sql/4.3[5402]: usertable          : ftp_users
Jan 15 15:58:19 mod_sql/4.3[5402]: userid field       : username
Jan 15 15:58:19 mod_sql/4.3[5402]: password field     : password
Jan 15 15:58:19 mod_sql/4.3[5402]: UID field          : uid
Jan 15 15:58:19 mod_sql/4.3[5402]: GID field          : gid
Jan 15 15:58:19 mod_sql/4.3[5402]: homedir field      : homedir
Jan 15 15:58:19 mod_sql/4.3[5402]: shell field        : shell
Jan 15 15:58:19 mod_sql/4.3[5402]: group table        : ftp_groups
Jan 15 15:58:19 mod_sql/4.3[5402]: groupname field    : groupname
Jan 15 15:58:19 mod_sql/4.3[5402]: grp GID field      : gid
Jan 15 15:58:19 mod_sql/4.3[5402]: grp members field  : members
Jan 15 15:58:19 mod_sql/4.3[5402]: SQLMinUserUID      : 999
Jan 15 15:58:19 mod_sql/4.3[5402]: SQLMinUserGID      : 999
Jan 15 15:58:19 mod_sql/4.3[5402]: SQLDefaultUID      : 65533
Jan 15 15:58:19 mod_sql/4.3[5402]: SQLDefaultGID      : 65533
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< sql_sess_init
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> cmd_endpwent
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< cmd_endpwent
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> cmd_endgrent
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< cmd_endgrent
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> sql_pre_pass
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< sql_pre_pass
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> cmd_endpwent
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< cmd_endpwent
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> cmd_endgrent
Jan 15 15:58:19 mod_sql/4.3[5402]: <<< cmd_endgrent
Jan 15 15:58:19 mod_sql/4.3[5402]: >>> cmd_getpwnam
Jan 15 15:58:19 mod_sql/4.3[5402]: entering     mysql cmd_escapestring
Jan 15 15:58:19 mod_sql/4.3[5402]: entering     mysql cmd_open
Jan 15 15:58:19 mod_sql/4.3[5402]: exiting     mysql cmd_open
Jan 15 15:58:19 mod_sql/4.3[5402]: exiting     mysql cmd_escapestring
Jan 15 15:58:19 mod_sql/4.3[5402]: unrecoverable backend error
Jan 15 15:58:19 mod_sql/4.3[5402]: error: '1045'
Jan 15 15:58:19 mod_sql/4.3[5402]: message: 'Access denied for user 'froxlor'@'localhost' (using password: NO)'
Jan 15 15:58:19 mod_sql/4.3[5402]: entering     mysql cmd_exit
Jan 15 15:58:19 mod_sql/4.3[5402]: exiting     mysql cmd_exit
Jan 15 16:00:21 mod_sql/4.3[5417]: defaulting to 'mysql' backend
Jan 15 16:00:21 mod_sql/4.3[5417]: backend module 'mod_sql_mysql/4.0.8'
Jan 15 16:00:21 mod_sql/4.3[5417]: backend api    'mod_sql_api_v1'
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> sql_sess_init
Jan 15 16:00:21 mod_sql/4.3[5417]: entering     mysql cmd_defineconnection
Jan 15 16:00:21 mod_sql/4.3[5417]:   name: 'default'
Jan 15 16:00:21 mod_sql/4.3[5417]:   user: 'froxlor'
Jan 15 16:00:21 mod_sql/4.3[5417]:   host: 'localhost'
Jan 15 16:00:21 mod_sql/4.3[5417]:     db: 'froxlor'
Jan 15 16:00:21 mod_sql/4.3[5417]:   port: '3306'
Jan 15 16:00:21 mod_sql/4.3[5417]:    ttl: '0'
Jan 15 16:00:21 mod_sql/4.3[5417]: exiting     mysql cmd_defineconnection
Jan 15 16:00:21 mod_sql/4.3[5417]: connection 'default' successfully established
Jan 15 16:00:21 mod_sql/4.3[5417]: mod_sql engine     : on
Jan 15 16:00:21 mod_sql/4.3[5417]: negative_cache     : off
Jan 15 16:00:21 mod_sql/4.3[5417]: authenticate       : users groups userset groupset
Jan 15 16:00:21 mod_sql/4.3[5417]: usertable          : ftp_users
Jan 15 16:00:21 mod_sql/4.3[5417]: userid field       : username
Jan 15 16:00:21 mod_sql/4.3[5417]: password field     : password
Jan 15 16:00:21 mod_sql/4.3[5417]: UID field          : uid
Jan 15 16:00:21 mod_sql/4.3[5417]: GID field          : gid
Jan 15 16:00:21 mod_sql/4.3[5417]: homedir field      : homedir
Jan 15 16:00:21 mod_sql/4.3[5417]: shell field        : shell
Jan 15 16:00:21 mod_sql/4.3[5417]: group table        : ftp_groups
Jan 15 16:00:21 mod_sql/4.3[5417]: groupname field    : groupname
Jan 15 16:00:21 mod_sql/4.3[5417]: grp GID field      : gid
Jan 15 16:00:21 mod_sql/4.3[5417]: grp members field  : members
Jan 15 16:00:21 mod_sql/4.3[5417]: SQLMinUserUID      : 999
Jan 15 16:00:21 mod_sql/4.3[5417]: SQLMinUserGID      : 999
Jan 15 16:00:21 mod_sql/4.3[5417]: SQLDefaultUID      : 65533
Jan 15 16:00:21 mod_sql/4.3[5417]: SQLDefaultGID      : 65533
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< sql_sess_init
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> cmd_endpwent
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< cmd_endpwent
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> cmd_endgrent
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< cmd_endgrent
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> sql_pre_pass
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< sql_pre_pass
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> cmd_endpwent
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< cmd_endpwent
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> cmd_endgrent
Jan 15 16:00:21 mod_sql/4.3[5417]: <<< cmd_endgrent
Jan 15 16:00:21 mod_sql/4.3[5417]: >>> cmd_getpwnam
Jan 15 16:00:21 mod_sql/4.3[5417]: entering     mysql cmd_escapestring
Jan 15 16:00:21 mod_sql/4.3[5417]: entering     mysql cmd_open
Jan 15 16:00:21 mod_sql/4.3[5417]: exiting     mysql cmd_open
Jan 15 16:00:21 mod_sql/4.3[5417]: exiting     mysql cmd_escapestring
Jan 15 16:00:21 mod_sql/4.3[5417]: unrecoverable backend error
Jan 15 16:00:21 mod_sql/4.3[5417]: error: '1045'
Jan 15 16:00:21 mod_sql/4.3[5417]: message: 'Access denied for user 'froxlor'@'localhost' (using password: NO)'
Jan 15 16:00:21 mod_sql/4.3[5417]: entering     mysql cmd_exit
Jan 15 16:00:21 mod_sql/4.3[5417]: exiting     mysql cmd_exit
Jan 15 16:02:23 mod_sql/4.3[5433]: defaulting to 'mysql' backend
Jan 15 16:02:23 mod_sql/4.3[5433]: backend module 'mod_sql_mysql/4.0.8'
Jan 15 16:02:23 mod_sql/4.3[5433]: backend api    'mod_sql_api_v1'
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> sql_sess_init
Jan 15 16:02:23 mod_sql/4.3[5433]: entering     mysql cmd_defineconnection
Jan 15 16:02:23 mod_sql/4.3[5433]:   name: 'default'
Jan 15 16:02:23 mod_sql/4.3[5433]:   user: 'froxlor'
Jan 15 16:02:23 mod_sql/4.3[5433]:   host: 'localhost'
Jan 15 16:02:23 mod_sql/4.3[5433]:     db: 'froxlor'
Jan 15 16:02:23 mod_sql/4.3[5433]:   port: '3306'
Jan 15 16:02:23 mod_sql/4.3[5433]:    ttl: '0'
Jan 15 16:02:23 mod_sql/4.3[5433]: exiting     mysql cmd_defineconnection
Jan 15 16:02:23 mod_sql/4.3[5433]: connection 'default' successfully established
Jan 15 16:02:23 mod_sql/4.3[5433]: mod_sql engine     : on
Jan 15 16:02:23 mod_sql/4.3[5433]: negative_cache     : off
Jan 15 16:02:23 mod_sql/4.3[5433]: authenticate       : users groups userset groupset
Jan 15 16:02:23 mod_sql/4.3[5433]: usertable          : ftp_users
Jan 15 16:02:23 mod_sql/4.3[5433]: userid field       : username
Jan 15 16:02:23 mod_sql/4.3[5433]: password field     : password
Jan 15 16:02:23 mod_sql/4.3[5433]: UID field          : uid
Jan 15 16:02:23 mod_sql/4.3[5433]: GID field          : gid
Jan 15 16:02:23 mod_sql/4.3[5433]: homedir field      : homedir
Jan 15 16:02:23 mod_sql/4.3[5433]: shell field        : shell
Jan 15 16:02:23 mod_sql/4.3[5433]: group table        : ftp_groups
Jan 15 16:02:23 mod_sql/4.3[5433]: groupname field    : groupname
Jan 15 16:02:23 mod_sql/4.3[5433]: grp GID field      : gid
Jan 15 16:02:23 mod_sql/4.3[5433]: grp members field  : members
Jan 15 16:02:23 mod_sql/4.3[5433]: SQLMinUserUID      : 999
Jan 15 16:02:23 mod_sql/4.3[5433]: SQLMinUserGID      : 999
Jan 15 16:02:23 mod_sql/4.3[5433]: SQLDefaultUID      : 65533
Jan 15 16:02:23 mod_sql/4.3[5433]: SQLDefaultGID      : 65533
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< sql_sess_init
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> cmd_endpwent
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< cmd_endpwent
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> cmd_endgrent
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< cmd_endgrent
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> sql_pre_pass
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< sql_pre_pass
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> cmd_endpwent
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< cmd_endpwent
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> cmd_endgrent
Jan 15 16:02:23 mod_sql/4.3[5433]: <<< cmd_endgrent
Jan 15 16:02:23 mod_sql/4.3[5433]: >>> cmd_getpwnam
Jan 15 16:02:23 mod_sql/4.3[5433]: entering     mysql cmd_escapestring
Jan 15 16:02:23 mod_sql/4.3[5433]: entering     mysql cmd_open
Jan 15 16:02:23 mod_sql/4.3[5433]: exiting     mysql cmd_open
Jan 15 16:02:23 mod_sql/4.3[5433]: exiting     mysql cmd_escapestring
Jan 15 16:02:23 mod_sql/4.3[5433]: unrecoverable backend error
Jan 15 16:02:23 mod_sql/4.3[5433]: error: '1045'
Jan 15 16:02:23 mod_sql/4.3[5433]: message: 'Access denied for user 'froxlor'@'localhost' (using password: NO)'
Jan 15 16:02:23 mod_sql/4.3[5433]: entering     mysql cmd_exit
Jan 15 16:02:23 mod_sql/4.3[5433]: exiting     mysql cmd_exit
 

Was mich stutzig macht ist das hier

 

message: 'Access denied for user 'froxlor'@'localhost' (using password: NO)'

Link to comment
Share on other sites

Naja, er sagt doch wo das problem ist, der benutzer "froxlor" kann sich nich bei der DB anmelden. Pr?fe doch bitte jede config wo der user und das password eingetragen wurde und pr?fe auch auf der console ob der benutzer sich bei mysql einloggen kann.

Link to comment
Share on other sites

Der User kann sich ?ber die console verbinden siehe auch

 

 

root@Debian-70-wheezy-64-minimal ~ # mysql --user=froxlor --password=froxlorpw
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 756
Server version: 5.5.33-0+wheezy1 (Debian)

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
 

 

Die einzigste config wo das Passwort eingetragen wird f?r proftpd ist doch die sql.conf#

 

Ich habe Sonderzeichen im Passwort k?nnte das eventuell der Ausschlaggebende Punkt sein?

 

mfg

Link to comment
Share on other sites

M?glich, versuche es mal tempor?r mit einem "einfachen" passwort. wenn das klappt, weisst du woran es scheitert :)

Wo muss ich dann ?berall das PW ?ndern?

 

 

aber das hat ich zuletzt schonmal probiert gehabt und es hat nicht funktioniert weil ich es glaub nicht ?berall ge?ndert hab :D

 

Ich hatte es in der /var/www/htdocs/froxlor/lib/userdata.inc.php ge?ndert und in der sql.conf aber das hat nichts gebracht.

 

 

mfg

Link to comment
Share on other sites

Die fehlermeldung kommt doch vom proftpd, also ?nder doch erstmal nur da die config ab und schau ob es funktioniert...

So ich habs mal wieder in den 2 Dateien ge?ndert also in der sql.conf und in der userdata.inc.php

Status:    Verbinde mit 78.46.99.42:21...
Status:    Verbindung hergestellt, warte auf Willkommensnachricht...
Antwort:    220 ProFTPD 1.3.4a Server (pbpromotion.no-ip.biz FTP Server) [::ffff:78.46.99.42]
Befehl:    USER pbpromotion
Antwort:    331 Password required for pbpromotion
Befehl:    PASS *********
Fehler:    Herstellen der Verbindung zum Server fehlgeschlagen

hier die proftpd.log

Jan 17 12:42:12 Debian-70-wheezy-64-minimal proftpd[21220] Debian-70-wheezy-64-minimal: received SIGHUP -- master server reparsing configuration file
Jan 17 12:42:17 Debian-70-wheezy-64-minimal proftpd[21330] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a (maint) (built Sat Sep 28 2013 19:26:56 UTC) standalone mode STARTUP
Jan 17 12:42:24 Debian-70-wheezy-64-minimal proftpd[21330] Debian-70-wheezy-64-minimal: ProFTPD killed (signal 15)
Jan 17 12:42:24 Debian-70-wheezy-64-minimal proftpd[21330] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a standalone mode SHUTDOWN
Jan 17 12:42:30 Debian-70-wheezy-64-minimal proftpd[21387] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a (maint) (built Sat Sep 28 2013 19:26:56 UTC) standalone mode STARTUP
Jan 17 12:43:07 Debian-70-wheezy-64-minimal proftpd[21405] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 12:43:07 Debian-70-wheezy-64-minimal proftpd[21405] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 12:43:07 Debian-70-wheezy-64-minimal proftpd[21405] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 12:43:07 Debian-70-wheezy-64-minimal proftpd[21405] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 12:43:13 Debian-70-wheezy-64-minimal proftpd[21407] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 12:43:13 Debian-70-wheezy-64-minimal proftpd[21407] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 12:43:13 Debian-70-wheezy-64-minimal proftpd[21407] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 12:43:13 Debian-70-wheezy-64-minimal proftpd[21407] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
 

hier die sql.log

Jan 17 12:41:05 mod_sql/4.3[21257]: defaulting to 'mysql' backend
Jan 17 12:41:05 mod_sql/4.3[21257]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:41:05 mod_sql/4.3[21257]: backend api    'mod_sql_api_v1'
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> sql_sess_init
Jan 17 12:41:05 mod_sql/4.3[21257]: entering     mysql cmd_defineconnection
Jan 17 12:41:05 mod_sql/4.3[21257]:   name: 'default'
Jan 17 12:41:05 mod_sql/4.3[21257]:   user: 'froxlor'
Jan 17 12:41:05 mod_sql/4.3[21257]:   host: 'localhost'
Jan 17 12:41:05 mod_sql/4.3[21257]:     db: 'froxlor'
Jan 17 12:41:05 mod_sql/4.3[21257]:   port: '3306'
Jan 17 12:41:05 mod_sql/4.3[21257]:    ttl: '0'
Jan 17 12:41:05 mod_sql/4.3[21257]: exiting     mysql cmd_defineconnection
Jan 17 12:41:05 mod_sql/4.3[21257]: connection 'default' successfully established
Jan 17 12:41:05 mod_sql/4.3[21257]: mod_sql engine     : on
Jan 17 12:41:05 mod_sql/4.3[21257]: negative_cache     : off
Jan 17 12:41:05 mod_sql/4.3[21257]: authenticate       : users groups userset groupset
Jan 17 12:41:05 mod_sql/4.3[21257]: usertable          : ftp_users
Jan 17 12:41:05 mod_sql/4.3[21257]: userid field       : username
Jan 17 12:41:05 mod_sql/4.3[21257]: password field     : password
Jan 17 12:41:05 mod_sql/4.3[21257]: UID field          : uid
Jan 17 12:41:05 mod_sql/4.3[21257]: GID field          : gid
Jan 17 12:41:05 mod_sql/4.3[21257]: homedir field      : homedir
Jan 17 12:41:05 mod_sql/4.3[21257]: shell field        : shell
Jan 17 12:41:05 mod_sql/4.3[21257]: group table        : ftp_groups
Jan 17 12:41:05 mod_sql/4.3[21257]: groupname field    : groupname
Jan 17 12:41:05 mod_sql/4.3[21257]: grp GID field      : gid
Jan 17 12:41:05 mod_sql/4.3[21257]: grp members field  : members
Jan 17 12:41:05 mod_sql/4.3[21257]: SQLMinUserUID      : 999
Jan 17 12:41:05 mod_sql/4.3[21257]: SQLMinUserGID      : 999
Jan 17 12:41:05 mod_sql/4.3[21257]: SQLDefaultUID      : 65533
Jan 17 12:41:05 mod_sql/4.3[21257]: SQLDefaultGID      : 65533
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< sql_sess_init
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> cmd_endpwent
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< cmd_endpwent
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> cmd_endgrent
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< cmd_endgrent
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> sql_pre_pass
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< sql_pre_pass
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> cmd_endpwent
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< cmd_endpwent
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> cmd_endgrent
Jan 17 12:41:05 mod_sql/4.3[21257]: <<< cmd_endgrent
Jan 17 12:41:05 mod_sql/4.3[21257]: >>> cmd_getpwnam
Jan 17 12:41:05 mod_sql/4.3[21257]: entering     mysql cmd_escapestring
Jan 17 12:41:05 mod_sql/4.3[21257]: entering     mysql cmd_open
Jan 17 12:41:05 mod_sql/4.3[21257]: exiting     mysql cmd_open
Jan 17 12:41:05 mod_sql/4.3[21257]: exiting     mysql cmd_escapestring
Jan 17 12:41:05 mod_sql/4.3[21257]: unrecoverable backend error
Jan 17 12:41:05 mod_sql/4.3[21257]: error: '1045'
Jan 17 12:41:05 mod_sql/4.3[21257]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:41:05 mod_sql/4.3[21257]: entering     mysql cmd_exit
Jan 17 12:41:05 mod_sql/4.3[21257]: exiting     mysql cmd_exit
Jan 17 12:41:11 mod_sql/4.3[21259]: defaulting to 'mysql' backend
Jan 17 12:41:11 mod_sql/4.3[21259]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:41:11 mod_sql/4.3[21259]: backend api    'mod_sql_api_v1'
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> sql_sess_init
Jan 17 12:41:11 mod_sql/4.3[21259]: entering     mysql cmd_defineconnection
Jan 17 12:41:11 mod_sql/4.3[21259]:   name: 'default'
Jan 17 12:41:11 mod_sql/4.3[21259]:   user: 'froxlor'
Jan 17 12:41:11 mod_sql/4.3[21259]:   host: 'localhost'
Jan 17 12:41:11 mod_sql/4.3[21259]:     db: 'froxlor'
Jan 17 12:41:11 mod_sql/4.3[21259]:   port: '3306'
Jan 17 12:41:11 mod_sql/4.3[21259]:    ttl: '0'
Jan 17 12:41:11 mod_sql/4.3[21259]: exiting     mysql cmd_defineconnection
Jan 17 12:41:11 mod_sql/4.3[21259]: connection 'default' successfully established
Jan 17 12:41:11 mod_sql/4.3[21259]: mod_sql engine     : on
Jan 17 12:41:11 mod_sql/4.3[21259]: negative_cache     : off
Jan 17 12:41:11 mod_sql/4.3[21259]: authenticate       : users groups userset groupset
Jan 17 12:41:11 mod_sql/4.3[21259]: usertable          : ftp_users
Jan 17 12:41:11 mod_sql/4.3[21259]: userid field       : username
Jan 17 12:41:11 mod_sql/4.3[21259]: password field     : password
Jan 17 12:41:11 mod_sql/4.3[21259]: UID field          : uid
Jan 17 12:41:11 mod_sql/4.3[21259]: GID field          : gid
Jan 17 12:41:11 mod_sql/4.3[21259]: homedir field      : homedir
Jan 17 12:41:11 mod_sql/4.3[21259]: shell field        : shell
Jan 17 12:41:11 mod_sql/4.3[21259]: group table        : ftp_groups
Jan 17 12:41:11 mod_sql/4.3[21259]: groupname field    : groupname
Jan 17 12:41:11 mod_sql/4.3[21259]: grp GID field      : gid
Jan 17 12:41:11 mod_sql/4.3[21259]: grp members field  : members
Jan 17 12:41:11 mod_sql/4.3[21259]: SQLMinUserUID      : 999
Jan 17 12:41:11 mod_sql/4.3[21259]: SQLMinUserGID      : 999
Jan 17 12:41:11 mod_sql/4.3[21259]: SQLDefaultUID      : 65533
Jan 17 12:41:11 mod_sql/4.3[21259]: SQLDefaultGID      : 65533
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< sql_sess_init
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> cmd_endpwent
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< cmd_endpwent
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> cmd_endgrent
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< cmd_endgrent
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> sql_pre_pass
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< sql_pre_pass
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> cmd_endpwent
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< cmd_endpwent
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> cmd_endgrent
Jan 17 12:41:11 mod_sql/4.3[21259]: <<< cmd_endgrent
Jan 17 12:41:11 mod_sql/4.3[21259]: >>> cmd_getpwnam
Jan 17 12:41:11 mod_sql/4.3[21259]: entering     mysql cmd_escapestring
Jan 17 12:41:11 mod_sql/4.3[21259]: entering     mysql cmd_open
Jan 17 12:41:11 mod_sql/4.3[21259]: exiting     mysql cmd_open
Jan 17 12:41:11 mod_sql/4.3[21259]: exiting     mysql cmd_escapestring
Jan 17 12:41:11 mod_sql/4.3[21259]: unrecoverable backend error
Jan 17 12:41:11 mod_sql/4.3[21259]: error: '1045'
Jan 17 12:41:11 mod_sql/4.3[21259]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:41:11 mod_sql/4.3[21259]: entering     mysql cmd_exit
Jan 17 12:41:11 mod_sql/4.3[21259]: exiting     mysql cmd_exit
Jan 17 12:41:16 mod_sql/4.3[21261]: defaulting to 'mysql' backend
Jan 17 12:41:16 mod_sql/4.3[21261]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:41:16 mod_sql/4.3[21261]: backend api    'mod_sql_api_v1'
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> sql_sess_init
Jan 17 12:41:16 mod_sql/4.3[21261]: entering     mysql cmd_defineconnection
Jan 17 12:41:16 mod_sql/4.3[21261]:   name: 'default'
Jan 17 12:41:16 mod_sql/4.3[21261]:   user: 'froxlor'
Jan 17 12:41:16 mod_sql/4.3[21261]:   host: 'localhost'
Jan 17 12:41:16 mod_sql/4.3[21261]:     db: 'froxlor'
Jan 17 12:41:16 mod_sql/4.3[21261]:   port: '3306'
Jan 17 12:41:16 mod_sql/4.3[21261]:    ttl: '0'
Jan 17 12:41:16 mod_sql/4.3[21261]: exiting     mysql cmd_defineconnection
Jan 17 12:41:16 mod_sql/4.3[21261]: connection 'default' successfully established
Jan 17 12:41:16 mod_sql/4.3[21261]: mod_sql engine     : on
Jan 17 12:41:16 mod_sql/4.3[21261]: negative_cache     : off
Jan 17 12:41:16 mod_sql/4.3[21261]: authenticate       : users groups userset groupset
Jan 17 12:41:16 mod_sql/4.3[21261]: usertable          : ftp_users
Jan 17 12:41:16 mod_sql/4.3[21261]: userid field       : username
Jan 17 12:41:16 mod_sql/4.3[21261]: password field     : password
Jan 17 12:41:16 mod_sql/4.3[21261]: UID field          : uid
Jan 17 12:41:16 mod_sql/4.3[21261]: GID field          : gid
Jan 17 12:41:16 mod_sql/4.3[21261]: homedir field      : homedir
Jan 17 12:41:16 mod_sql/4.3[21261]: shell field        : shell
Jan 17 12:41:16 mod_sql/4.3[21261]: group table        : ftp_groups
Jan 17 12:41:16 mod_sql/4.3[21261]: groupname field    : groupname
Jan 17 12:41:16 mod_sql/4.3[21261]: grp GID field      : gid
Jan 17 12:41:16 mod_sql/4.3[21261]: grp members field  : members
Jan 17 12:41:16 mod_sql/4.3[21261]: SQLMinUserUID      : 999
Jan 17 12:41:16 mod_sql/4.3[21261]: SQLMinUserGID      : 999
Jan 17 12:41:16 mod_sql/4.3[21261]: SQLDefaultUID      : 65533
Jan 17 12:41:16 mod_sql/4.3[21261]: SQLDefaultGID      : 65533
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< sql_sess_init
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> cmd_endpwent
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< cmd_endpwent
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> cmd_endgrent
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< cmd_endgrent
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> sql_pre_pass
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< sql_pre_pass
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> cmd_endpwent
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< cmd_endpwent
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> cmd_endgrent
Jan 17 12:41:16 mod_sql/4.3[21261]: <<< cmd_endgrent
Jan 17 12:41:16 mod_sql/4.3[21261]: >>> cmd_getpwnam
Jan 17 12:41:16 mod_sql/4.3[21261]: entering     mysql cmd_escapestring
Jan 17 12:41:16 mod_sql/4.3[21261]: entering     mysql cmd_open
Jan 17 12:41:16 mod_sql/4.3[21261]: exiting     mysql cmd_open
Jan 17 12:41:16 mod_sql/4.3[21261]: exiting     mysql cmd_escapestring
Jan 17 12:41:16 mod_sql/4.3[21261]: unrecoverable backend error
Jan 17 12:41:16 mod_sql/4.3[21261]: error: '1045'
Jan 17 12:41:16 mod_sql/4.3[21261]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:41:16 mod_sql/4.3[21261]: entering     mysql cmd_exit
Jan 17 12:41:16 mod_sql/4.3[21261]: exiting     mysql cmd_exit
Jan 17 12:41:21 mod_sql/4.3[21263]: defaulting to 'mysql' backend
Jan 17 12:41:21 mod_sql/4.3[21263]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:41:21 mod_sql/4.3[21263]: backend api    'mod_sql_api_v1'
Jan 17 12:41:21 mod_sql/4.3[21263]: >>> sql_sess_init
Jan 17 12:41:21 mod_sql/4.3[21263]: entering     mysql cmd_defineconnection
Jan 17 12:41:21 mod_sql/4.3[21263]:   name: 'default'
Jan 17 12:41:21 mod_sql/4.3[21263]:   user: 'froxlor'
Jan 17 12:41:21 mod_sql/4.3[21263]:   host: 'localhost'
Jan 17 12:41:21 mod_sql/4.3[21263]:     db: 'froxlor'
Jan 17 12:41:21 mod_sql/4.3[21263]:   port: '3306'
Jan 17 12:41:21 mod_sql/4.3[21263]:    ttl: '0'
Jan 17 12:41:21 mod_sql/4.3[21263]: exiting     mysql cmd_defineconnection
Jan 17 12:41:21 mod_sql/4.3[21263]: connection 'default' successfully established
Jan 17 12:41:21 mod_sql/4.3[21263]: mod_sql engine     : on
Jan 17 12:41:21 mod_sql/4.3[21263]: negative_cache     : off
Jan 17 12:41:21 mod_sql/4.3[21263]: authenticate       : users groups userset groupset
Jan 17 12:41:21 mod_sql/4.3[21263]: usertable          : ftp_users
Jan 17 12:41:21 mod_sql/4.3[21263]: userid field       : username
Jan 17 12:41:21 mod_sql/4.3[21263]: password field     : password
Jan 17 12:41:21 mod_sql/4.3[21263]: UID field          : uid
Jan 17 12:41:21 mod_sql/4.3[21263]: GID field          : gid
Jan 17 12:41:21 mod_sql/4.3[21263]: homedir field      : homedir
Jan 17 12:41:21 mod_sql/4.3[21263]: shell field        : shell
Jan 17 12:41:21 mod_sql/4.3[21263]: group table        : ftp_groups
Jan 17 12:41:21 mod_sql/4.3[21263]: groupname field    : groupname
Jan 17 12:41:21 mod_sql/4.3[21263]: grp GID field      : gid
Jan 17 12:41:21 mod_sql/4.3[21263]: grp members field  : members
Jan 17 12:41:21 mod_sql/4.3[21263]: SQLMinUserUID      : 999
Jan 17 12:41:21 mod_sql/4.3[21263]: SQLMinUserGID      : 999
Jan 17 12:41:21 mod_sql/4.3[21263]: SQLDefaultUID      : 65533
Jan 17 12:41:21 mod_sql/4.3[21263]: SQLDefaultGID      : 65533
Jan 17 12:41:21 mod_sql/4.3[21263]: <<< sql_sess_init
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> cmd_endpwent
Jan 17 12:41:22 mod_sql/4.3[21263]: <<< cmd_endpwent
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> cmd_endgrent
Jan 17 12:41:22 mod_sql/4.3[21263]: <<< cmd_endgrent
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> sql_pre_pass
Jan 17 12:41:22 mod_sql/4.3[21263]: <<< sql_pre_pass
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> cmd_endpwent
Jan 17 12:41:22 mod_sql/4.3[21263]: <<< cmd_endpwent
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> cmd_endgrent
Jan 17 12:41:22 mod_sql/4.3[21263]: <<< cmd_endgrent
Jan 17 12:41:22 mod_sql/4.3[21263]: >>> cmd_getpwnam
Jan 17 12:41:22 mod_sql/4.3[21263]: entering     mysql cmd_escapestring
Jan 17 12:41:22 mod_sql/4.3[21263]: entering     mysql cmd_open
Jan 17 12:41:22 mod_sql/4.3[21263]: exiting     mysql cmd_open
Jan 17 12:41:22 mod_sql/4.3[21263]: exiting     mysql cmd_escapestring
Jan 17 12:41:22 mod_sql/4.3[21263]: unrecoverable backend error
Jan 17 12:41:22 mod_sql/4.3[21263]: error: '1045'
Jan 17 12:41:22 mod_sql/4.3[21263]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:41:22 mod_sql/4.3[21263]: entering     mysql cmd_exit
Jan 17 12:41:22 mod_sql/4.3[21263]: exiting     mysql cmd_exit
Jan 17 12:43:07 mod_sql/4.3[21405]: defaulting to 'mysql' backend
Jan 17 12:43:07 mod_sql/4.3[21405]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:43:07 mod_sql/4.3[21405]: backend api    'mod_sql_api_v1'
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> sql_sess_init
Jan 17 12:43:07 mod_sql/4.3[21405]: entering     mysql cmd_defineconnection
Jan 17 12:43:07 mod_sql/4.3[21405]:   name: 'default'
Jan 17 12:43:07 mod_sql/4.3[21405]:   user: 'froxlor'
Jan 17 12:43:07 mod_sql/4.3[21405]:   host: 'localhost'
Jan 17 12:43:07 mod_sql/4.3[21405]:     db: 'froxlor'
Jan 17 12:43:07 mod_sql/4.3[21405]:   port: '3306'
Jan 17 12:43:07 mod_sql/4.3[21405]:    ttl: '0'
Jan 17 12:43:07 mod_sql/4.3[21405]: exiting     mysql cmd_defineconnection
Jan 17 12:43:07 mod_sql/4.3[21405]: connection 'default' successfully established
Jan 17 12:43:07 mod_sql/4.3[21405]: mod_sql engine     : on
Jan 17 12:43:07 mod_sql/4.3[21405]: negative_cache     : off
Jan 17 12:43:07 mod_sql/4.3[21405]: authenticate       : users groups userset groupset
Jan 17 12:43:07 mod_sql/4.3[21405]: usertable          : ftp_users
Jan 17 12:43:07 mod_sql/4.3[21405]: userid field       : username
Jan 17 12:43:07 mod_sql/4.3[21405]: password field     : password
Jan 17 12:43:07 mod_sql/4.3[21405]: UID field          : uid
Jan 17 12:43:07 mod_sql/4.3[21405]: GID field          : gid
Jan 17 12:43:07 mod_sql/4.3[21405]: homedir field      : homedir
Jan 17 12:43:07 mod_sql/4.3[21405]: shell field        : shell
Jan 17 12:43:07 mod_sql/4.3[21405]: group table        : ftp_groups
Jan 17 12:43:07 mod_sql/4.3[21405]: groupname field    : groupname
Jan 17 12:43:07 mod_sql/4.3[21405]: grp GID field      : gid
Jan 17 12:43:07 mod_sql/4.3[21405]: grp members field  : members
Jan 17 12:43:07 mod_sql/4.3[21405]: SQLMinUserUID      : 999
Jan 17 12:43:07 mod_sql/4.3[21405]: SQLMinUserGID      : 999
Jan 17 12:43:07 mod_sql/4.3[21405]: SQLDefaultUID      : 65533
Jan 17 12:43:07 mod_sql/4.3[21405]: SQLDefaultGID      : 65533
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< sql_sess_init
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> cmd_endpwent
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< cmd_endpwent
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> cmd_endgrent
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< cmd_endgrent
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> sql_pre_pass
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< sql_pre_pass
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> cmd_endpwent
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< cmd_endpwent
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> cmd_endgrent
Jan 17 12:43:07 mod_sql/4.3[21405]: <<< cmd_endgrent
Jan 17 12:43:07 mod_sql/4.3[21405]: >>> cmd_getpwnam
Jan 17 12:43:07 mod_sql/4.3[21405]: entering     mysql cmd_escapestring
Jan 17 12:43:07 mod_sql/4.3[21405]: entering     mysql cmd_open
Jan 17 12:43:07 mod_sql/4.3[21405]: exiting     mysql cmd_open
Jan 17 12:43:07 mod_sql/4.3[21405]: exiting     mysql cmd_escapestring
Jan 17 12:43:07 mod_sql/4.3[21405]: unrecoverable backend error
Jan 17 12:43:07 mod_sql/4.3[21405]: error: '1045'
Jan 17 12:43:07 mod_sql/4.3[21405]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:43:07 mod_sql/4.3[21405]: entering     mysql cmd_exit
Jan 17 12:43:07 mod_sql/4.3[21405]: exiting     mysql cmd_exit
Jan 17 12:43:13 mod_sql/4.3[21407]: defaulting to 'mysql' backend
Jan 17 12:43:13 mod_sql/4.3[21407]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 12:43:13 mod_sql/4.3[21407]: backend api    'mod_sql_api_v1'
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> sql_sess_init
Jan 17 12:43:13 mod_sql/4.3[21407]: entering     mysql cmd_defineconnection
Jan 17 12:43:13 mod_sql/4.3[21407]:   name: 'default'
Jan 17 12:43:13 mod_sql/4.3[21407]:   user: 'froxlor'
Jan 17 12:43:13 mod_sql/4.3[21407]:   host: 'localhost'
Jan 17 12:43:13 mod_sql/4.3[21407]:     db: 'froxlor'
Jan 17 12:43:13 mod_sql/4.3[21407]:   port: '3306'
Jan 17 12:43:13 mod_sql/4.3[21407]:    ttl: '0'
Jan 17 12:43:13 mod_sql/4.3[21407]: exiting     mysql cmd_defineconnection
Jan 17 12:43:13 mod_sql/4.3[21407]: connection 'default' successfully established
Jan 17 12:43:13 mod_sql/4.3[21407]: mod_sql engine     : on
Jan 17 12:43:13 mod_sql/4.3[21407]: negative_cache     : off
Jan 17 12:43:13 mod_sql/4.3[21407]: authenticate       : users groups userset groupset
Jan 17 12:43:13 mod_sql/4.3[21407]: usertable          : ftp_users
Jan 17 12:43:13 mod_sql/4.3[21407]: userid field       : username
Jan 17 12:43:13 mod_sql/4.3[21407]: password field     : password
Jan 17 12:43:13 mod_sql/4.3[21407]: UID field          : uid
Jan 17 12:43:13 mod_sql/4.3[21407]: GID field          : gid
Jan 17 12:43:13 mod_sql/4.3[21407]: homedir field      : homedir
Jan 17 12:43:13 mod_sql/4.3[21407]: shell field        : shell
Jan 17 12:43:13 mod_sql/4.3[21407]: group table        : ftp_groups
Jan 17 12:43:13 mod_sql/4.3[21407]: groupname field    : groupname
Jan 17 12:43:13 mod_sql/4.3[21407]: grp GID field      : gid
Jan 17 12:43:13 mod_sql/4.3[21407]: grp members field  : members
Jan 17 12:43:13 mod_sql/4.3[21407]: SQLMinUserUID      : 999
Jan 17 12:43:13 mod_sql/4.3[21407]: SQLMinUserGID      : 999
Jan 17 12:43:13 mod_sql/4.3[21407]: SQLDefaultUID      : 65533
Jan 17 12:43:13 mod_sql/4.3[21407]: SQLDefaultGID      : 65533
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< sql_sess_init
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> cmd_endpwent
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< cmd_endpwent
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> cmd_endgrent
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< cmd_endgrent
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> sql_pre_pass
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< sql_pre_pass
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> cmd_endpwent
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< cmd_endpwent
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> cmd_endgrent
Jan 17 12:43:13 mod_sql/4.3[21407]: <<< cmd_endgrent
Jan 17 12:43:13 mod_sql/4.3[21407]: >>> cmd_getpwnam
Jan 17 12:43:13 mod_sql/4.3[21407]: entering     mysql cmd_escapestring
Jan 17 12:43:13 mod_sql/4.3[21407]: entering     mysql cmd_open
Jan 17 12:43:13 mod_sql/4.3[21407]: exiting     mysql cmd_open
Jan 17 12:43:13 mod_sql/4.3[21407]: exiting     mysql cmd_escapestring
Jan 17 12:43:13 mod_sql/4.3[21407]: unrecoverable backend error
Jan 17 12:43:13 mod_sql/4.3[21407]: error: '1045'
Jan 17 12:43:13 mod_sql/4.3[21407]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 12:43:13 mod_sql/4.3[21407]: entering     mysql cmd_exit
Jan 17 12:43:13 mod_sql/4.3[21407]: exiting     mysql cmd_exit
 

und hier meine sql.conf

<IfModule mod_sql.c>
DefaultRoot ~
RequireValidShell off
AuthOrder mod_sql.c

SQLBackend mysql
SQLEngine on
SQLAuthenticate on
SQLLogFile /var/log/proftpd/sql.log

SQLAuthTypes Crypt
SQLAuthenticate users* groups*
SQLConnectInfo froxlor@localhost froxlor froxlor
SQLUserInfo ftp_users username password uid gid homedir shell
SQLGroupInfo ftp_groups groupname gid members
SQLUserWhereClause "login_enabled = 'y'"

SQLLog PASS login
SQLNamedQuery login UPDATE "last_login=now(), login_count=login_count+1 WHERE username='%u'" ftp_users

SQLLog RETR download
SQLNamedQuery download UPDATE "down_count=down_count+1, down_bytes=down_bytes+%b WHERE username='%u'" ftp_users

SQLLog STOR upload
SQLNamedQuery upload UPDATE "up_count=up_count+1, up_bytes=up_bytes+%b WHERE username='%u'" ftp_users

QuotaEngine on
QuotaShowQuotas on
QuotaDisplayUnits Mb
QuotaLock /var/lock/ftpd.quotatab.lock
QuotaLimitTable sql:/get-quota-limit
QuotaTallyTable sql:/get-quota-tally/update-quota-tally/insert-quota-tally
SQLNamedQuery get-quota-limit SELECT "ftp_users.username AS name, ftp_quotalimits.quota_type, ftp_quotalimits.per_session, ftp_quotalimits.limit_type, panel_customers.diskspace*1024 AS bytes_in_avail, ftp_quotalimits.bytes_out_avail, ftp_quotalimits.bytes_xfer_avail, ftp_quotalimits.files_in_avail, ftp_quotalimits.files_out_avail, ftp_quotalimits.files_xfer_avail FROM ftp_users, ftp_quotalimits, panel_customers WHERE ftp_users.username = '%{0}' AND panel_customers.loginname = SUBSTRING_INDEX('%{0}', 'ftp', 1) AND quota_type ='%{1}'"
SQLNamedQuery get-quota-tally SELECT "name, quota_type, bytes_in_used,bytes_out_used, bytes_xfer_used, files_in_used, files_out_used,files_xfer_used FROM ftp_quotatallies WHERE name = '%{0}' AND quota_type = '%{1}'"
SQLNamedQuery update-quota-tally UPDATE "bytes_in_used = bytes_in_used + %{0}, bytes_out_used = bytes_out_used + %{1}, bytes_xfer_used = bytes_xfer_used + %{2}, files_in_used = files_in_used + %{3}, files_out_used= files_out_used + %{4}, files_xfer_used = files_xfer_used + %{5} WHERE name= '%{6}' AND quota_type = '%{7}'" ftp_quotatallies
SQLNamedQuery insert-quota-tally INSERT "%{0}, %{1}, %{2}, %{3}, %{4},%{5}, %{6}, %{7}" ftp_quotatallies

</IfModule>

Das einzigste was sich ge?ndert hat ist f?r mich das hier

 

message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'

 

davor wars immer using password: NO, was ich aber auch nicht versteh...

 

 

 

EDIT:

 

jetzt bekomm ich noch folgenden Fehler beim starten

root@Debian-70-wheezy-64-minimal ~ # /etc/init.d/proftpd restart
[ ok ] Stopping ftp server: proftpd.
[....] Starting ftp server: proftpdDebian-70-wheezy-64-minimal proftpd[21470]: warning: handling possibly truncated configuration data at line 37 of '/etc/proftpd/sql.conf'
. ok
 

Line 37 sollte die letzte sein.

 

Aber der Dienst startet wie man hier sehen kann

Jan 17 12:56:51 Debian-70-wheezy-64-minimal proftpd[21471] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a (maint) (built Sat Sep 28 2013 19:26:56 UTC) standalone mode STARTUP
 

EDIT2:

 

ProFTP startet wieder ganz normal.

 

root@Debian-70-wheezy-64-minimal ~ # /etc/init.d/proftpd restart
[ ok ] Stopping ftp server: proftpd.
[ ok ] Starting ftp server: proftpd.
 

 

Ich hab mal versucht die SQLAuthTypes auf Plaintext zu stellen und das PW in der DB im Klartext gespeichert, aber auch ohne Erfolg.

 

hier der auszug aus der sql.log

 

 

Jan 17 13:10:43 mod_sql/4.3[22467]: defaulting to 'mysql' backend
Jan 17 13:10:43 mod_sql/4.3[22467]: backend module 'mod_sql_mysql/4.0.8'
Jan 17 13:10:43 mod_sql/4.3[22467]: backend api    'mod_sql_api_v1'
Jan 17 13:10:43 mod_sql/4.3[22467]: >>> sql_sess_init
Jan 17 13:10:43 mod_sql/4.3[22467]: entering     mysql cmd_defineconnection
Jan 17 13:10:43 mod_sql/4.3[22467]:   name: 'default'
Jan 17 13:10:43 mod_sql/4.3[22467]:   user: 'froxlor'
Jan 17 13:10:43 mod_sql/4.3[22467]:   host: 'localhost'
Jan 17 13:10:43 mod_sql/4.3[22467]:     db: 'froxlor'
Jan 17 13:10:43 mod_sql/4.3[22467]:   port: '3306'
Jan 17 13:10:43 mod_sql/4.3[22467]:    ttl: '0'
Jan 17 13:10:43 mod_sql/4.3[22467]: exiting     mysql cmd_defineconnection
Jan 17 13:10:43 mod_sql/4.3[22467]: connection 'default' successfully established
Jan 17 13:10:43 mod_sql/4.3[22467]: mod_sql engine     : on
Jan 17 13:10:43 mod_sql/4.3[22467]: negative_cache     : off
Jan 17 13:10:43 mod_sql/4.3[22467]: authenticate       : users groups userset groupset
Jan 17 13:10:43 mod_sql/4.3[22467]: usertable          : ftp_users
Jan 17 13:10:43 mod_sql/4.3[22467]: userid field       : username
Jan 17 13:10:43 mod_sql/4.3[22467]: password field     : password
Jan 17 13:10:43 mod_sql/4.3[22467]: UID field          : uid
Jan 17 13:10:43 mod_sql/4.3[22467]: GID field          : gid
Jan 17 13:10:43 mod_sql/4.3[22467]: homedir field      : homedir
Jan 17 13:10:43 mod_sql/4.3[22467]: shell field        : shell
Jan 17 13:10:43 mod_sql/4.3[22467]: group table        : ftp_groups
Jan 17 13:10:43 mod_sql/4.3[22467]: groupname field    : groupname
Jan 17 13:10:43 mod_sql/4.3[22467]: grp GID field      : gid
Jan 17 13:10:43 mod_sql/4.3[22467]: grp members field  : members
Jan 17 13:10:43 mod_sql/4.3[22467]: SQLMinUserUID      : 999
Jan 17 13:10:43 mod_sql/4.3[22467]: SQLMinUserGID      : 999
Jan 17 13:10:43 mod_sql/4.3[22467]: SQLDefaultUID      : 65533
Jan 17 13:10:43 mod_sql/4.3[22467]: SQLDefaultGID      : 65533
Jan 17 13:10:43 mod_sql/4.3[22467]: <<< sql_sess_init
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> cmd_endpwent
Jan 17 13:10:44 mod_sql/4.3[22467]: <<< cmd_endpwent
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> cmd_endgrent
Jan 17 13:10:44 mod_sql/4.3[22467]: <<< cmd_endgrent
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> sql_pre_pass
Jan 17 13:10:44 mod_sql/4.3[22467]: <<< sql_pre_pass
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> cmd_endpwent
Jan 17 13:10:44 mod_sql/4.3[22467]: <<< cmd_endpwent
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> cmd_endgrent
Jan 17 13:10:44 mod_sql/4.3[22467]: <<< cmd_endgrent
Jan 17 13:10:44 mod_sql/4.3[22467]: >>> cmd_getpwnam
Jan 17 13:10:44 mod_sql/4.3[22467]: entering     mysql cmd_escapestring
Jan 17 13:10:44 mod_sql/4.3[22467]: entering     mysql cmd_open
Jan 17 13:10:44 mod_sql/4.3[22467]: exiting     mysql cmd_open
Jan 17 13:10:44 mod_sql/4.3[22467]: exiting     mysql cmd_escapestring
Jan 17 13:10:44 mod_sql/4.3[22467]: unrecoverable backend error
Jan 17 13:10:44 mod_sql/4.3[22467]: error: '1045'
Jan 17 13:10:44 mod_sql/4.3[22467]: message: 'Access denied for user 'froxlor'@'localhost' (using password: YES)'
Jan 17 13:10:44 mod_sql/4.3[22467]: entering     mysql cmd_exit
Jan 17 13:10:44 mod_sql/4.3[22467]: exiting     mysql cmd_exit
 

 

 

und hier noch proftpd.log

 

 

Jan 17 13:10:28 Debian-70-wheezy-64-minimal proftpd[22457] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:28 Debian-70-wheezy-64-minimal proftpd[22457] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:28 Debian-70-wheezy-64-minimal proftpd[22457] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:28 Debian-70-wheezy-64-minimal proftpd[22457] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22459] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22460] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22459] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22459] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22459] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22460] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22460] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:33 Debian-70-wheezy-64-minimal proftpd[22460] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22463] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22464] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22463] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22463] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22463] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22464] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22464] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:38 Debian-70-wheezy-64-minimal proftpd[22464] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:10:43 Debian-70-wheezy-64-minimal proftpd[22467] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session opened.
Jan 17 13:10:44 Debian-70-wheezy-64-minimal proftpd[22467] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: unrecoverable backend error: (1045) Access denied for user 'froxlor'@'localhost' (using password: YES)
Jan 17 13:10:44 Debian-70-wheezy-64-minimal proftpd[22467] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): mod_sql/4.3: check the SQLLogFile for more details
Jan 17 13:10:44 Debian-70-wheezy-64-minimal proftpd[22467] Debian-70-wheezy-64-minimal (195.243.202.162[195.243.202.162]): FTP session closed.
Jan 17 13:14:49 Debian-70-wheezy-64-minimal proftpd[22439] Debian-70-wheezy-64-minimal: received SIGHUP -- master server reparsing configuration file
Jan 17 13:14:54 Debian-70-wheezy-64-minimal proftpd[22539] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a (maint) (built Sat Sep 28 2013 19:26:56 UTC) standalone mode STARTUP
Jan 17 13:14:57 Debian-70-wheezy-64-minimal proftpd[22539] Debian-70-wheezy-64-minimal: ProFTPD killed (signal 15)
Jan 17 13:14:57 Debian-70-wheezy-64-minimal proftpd[22539] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a standalone mode SHUTDOWN
Jan 17 13:14:59 Debian-70-wheezy-64-minimal proftpd[22591] Debian-70-wheezy-64-minimal: ProFTPD 1.3.4a (maint) (built Sat Sep 28 2013 19:26:56 UTC) standalone mode STARTUP

 

 

 

 

 

 

mfg

Link to comment
Share on other sites

So ich hab mal komplett proftpd runtergeschmissen und komplett neu nach template aus froxlor installiert und die configs aus dem template direkt genommen.

 

 

Aber genau das selbe problem.

 

 

Was mich auch ein bisschen stutzig macht, im froxlor adminmen? steht das hier

 

 

FTP-Konten
0 genutzt
0 zugewiesen

 

 

Also irgendwas stimmt da nicht....

 

 

 

mfg

Link to comment
Share on other sites

Hast du denn einen Kunden angelegt ?berhaupt? Denn nur Kunden bekommen nat?rlich einen FTP account. oder versucht du etwa die ganze zeit als "admin" auf den FTP zu kommen?

Nat?rlich hab ich einen Kunden angelegt.

 

Ich versuche mich st?ndig mit dem Kunden per FTP zu verbinden, Domain ist auch unter dem Kunden erreichbar etc. Bisher funktioniert nur der FTP Server nicht und Mails hab ich noch nicht ausprobiert.

 

 

Aber das Hauptaugenmerk liegt erstmal auf dem FTP Server und dann kommt der Mailserver dran.

 

 

Auch wenn ich unter dem Kunden nochmal speziell einen FTP Account anlege funktioniert es nicht.

 

 

mfg

Link to comment
Share on other sites

F?r mich sieht das nach genauerem durchschauen deiner Logfiles aus als ob deine MySQL Passw?rter in den Files nicht richtig gesetzt sind. Es ist jedesmal MySQL, das den ersten Fehler ausgiebt.

Dachte ich zuerst auch.

 

Aber kann ich mittlerweile zu mehr als 1000% ausschliessen. Ich habe es wieder und wieder richtig eingetragen.

 

Ich hab es ja auhc schon mit einem einfacheren PW versucht aber auch das blieb ohne Erfolg, die einzigste ?nderung war, das Using Password sich auf YES ge?ndert hat.

 

 

Ich vermute dass er sich das pw falsch aus der sql.conf zieht und vermutlich ein leerzeichen vor beginn des pw macht, so ist es mir passiert als ich per shell auf den mysql verbinden wollte

 

hab mysql -u froxlor -p froxlor eingeben kam noch eine pw abfrage, richtig wars dann mysql -u froxlor -pfroxlor

 

Wenn ich aber das leerzeichen in der sql.conf weglasse glaubt der proftpd der user best?nde aus user und pw.

 

 

Gibt es hier ?berhaupt jemanden der froxlor mit nginx, php-fpm und proftpd zum laufen bekommen hat?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.



×
×
  • Create New...