proftpd 1.24 a mod_sql (delsi diky konf vypisum)

[Zdenek Pizl]

Dne čt 8. listopad 2001 18:47 Mira Tempír napsal(a):
> | diky, vyzkousim, ale jestli jste se dival do toho
> | vypisu, co jsem posilal, tak tak proftpd padlo na
> | signal 11, tj. SIGSEGV - to me desi. A nedela to je
> | posledni 1.2.4, ale i 1.2.2, ktera spolehlive na jinem
> | stroji funguje, i kdyz tam ma plaintext soubor s
> | uzivateli. SQL auth jsem zkousel az ted na nove masine,
> | kde nechci mit ani jednoho uzivatele ...
>
> No vsiml jsem si. Zkuste to strace-ovat. Vypada to, ze to
> zuchne jakmile nenajde v db toho uzivatele, pod kterym ma
> server bezet.

nejak to nechapu :(

Obslehl jsem doslova ten konfig od Vas. 

<Global>
        RequireValidshell off
        SQLAuthTypes Backend
        SQLConnectInfo proftpd na localhost proftpd modsql

        SQLMinID 40
        SQLDefaultUID 48
        SQLDefaultGID 48

        #SQLGroupTable proftpdgrpA
        SQLUserTable user

        SQLUsernameField userid
        SQLHomedirField homedir
        SQLLoginCountField count
        SQLPasswordField passwd
        SQLShellField shell

        SQLProcessPwEnt off

        SQLDoAuth on
        SQLDoGroupAuth off
        SQLAuthoritative on
        SQLLogStats on
        SQLHomedirOnDemand off

        AuthPAMAuthoritative off
</Global>

<Anonymous /www>
 UserAlias admin apache
 AnonRequirePassword on
 AuthUsingAlias on
 AuthAliasOnly on

 <Limit WRITE>
         DenyAll
 </Limit>
</Anonymous>

 - je to tedy nastaveni, aby bral alias, autorizoval JEHO heslem a ono to
dela tohle :


Nov 09 09:34:55 magic proftpd[1625] localhost: FTP session opened.
Nov 09 09:34:58 magic proftpd[1625] localhost: received: USER admin
Nov 09 09:34:58 magic proftpd[1625] localhost: received: USER admin
Nov 09 09:34:58 magic proftpd[1625] localhost: received: USER admin
Nov 09 09:34:58 magic proftpd[1625] localhost: received: USER admin
Nov 09 09:35:01 magic proftpd[1625] localhost: received: PASS (hidden)
Nov 09 09:35:01 magic proftpd[1625] localhost: received: PASS (hidden)
Nov 09 09:35:01 magic proftpd[1625] localhost: received: PASS (hidden)
Nov 09 09:35:01 magic proftpd[1625] localhost: mod_sql/3.2.4: entering auth_cmd_getpwnam
Nov 09 09:35:01 magic proftpd[1625] localhost: mod_sql/3.2.4: no cache hit for user 'apache'
Nov 09 09:35:01 magic proftpd[1625] localhost: mod_sql_mysql/3.2: select OK: [proftpd] "SELECT userid, uid, gid, shell, homedir, passwd FROM user WHERE (userid='apache') LIMIT 1"
Nov 09 09:35:01 magic proftpd[1625] localhost: mod_sql/3.2.4: exiting  auth_cmd_getpwnam
Nov 09 09:35:01 magic proftpd[1625] localhost: no such user 'apache'
Nov 09 09:35:01 magic proftpd[1625] localhost: USER apache: no such user found from localhost.localdomain [127.0.0.1] to 127.0.0.1:21
Nov 09 09:35:01 magic proftpd[1625] localhost: received: SYST

proc to hleda uzivatele admin ? Sakra co to je za kravinu ...

						Z.P.


>
> Ja pouzivam proftpd s sql autentizaci na 4 masinach
> a s timto problemy nikdy nebyly. Kdyz tak patram pameti,
> vzpominam si jen na to, ze se kdysi pred cca pul rokem
> menila dost vyrazne konfigurace, jinak to bezi jak jsem
> to nainstaloval (s vyjimkou bezp. problemu s proftpd jako
> takovym ale to jine povidani).