proftpd 1.24 a mod_sql (delsi diky konf vypisum)

[Zdenek Pizl]

Dne čt 8. listopad 2001 01:43 Mira Tempír napsal(a):
> Zdravim,
> no tech chyb jste tam dokazal naflakat pomerne dost.
> Mozna bych precejen prvni nahledl do dokumentace.

do dokumentace jsem vcera cucel dost dlouho, ale uz bylo pozde ...

>
> Hm, jeste poslete ip adresu toho stroje kdyz uz jste
> poslal i heslo ;-)

192.168.1.100 ;o) Vazne si myslite, 
ze bych tam dal skutecne heslo a uzivatele, 
potazmo IP ??

>
> |
> | # a ted definice anonymniho ftp pro uzivatele admin
> | <Anonymous /www>
> |
> |  User admin
>
> Tady jste (asi) nepochopil co ta direktiva dela.
> Nebo mate v passwd takoveho uzivatele ?

pardon, mohu tam dat treba uzivatele apache, t
en v /etc/passwd zcela urcite je,a chci aby to
 defaultne bezelo tedy pod nim. Ale nehleda 
nahodou mod_sql VSECHNY uzivatele v databazi ?

User apache

>
> |  AnonRequirePassword on
> |  AuthAliasOnly on
> |
> |  <Limit WRITE>
> |          DenyAll
> |  </Limit>
> | </Anonymous>
>
> Ten blok anonymous ale nema s sql autentizaci nic
> spolecneho.

to sice ne, ale vztahu s direktivami
 UserAlias admin apache
 AnonRequirePassword on
 AuthUsingAlias on
 AuthAliasOnly on

 rika pod jakym anonymnim aliasem 
se tam chci hlasit

>
> Co ty uid a gid ?
> Melo by tam byt dostatecne velke cislo (vetsi nez je
> nastavene minimum).

?? nebere si to nejaky default - bere (65533)
 Ale neco s tim je blbe. protoze takovy UID/GID
 samozrejme neexistuje.

User                            apache
Group                           apache
SQLDefaultGID 48
SQLDefaultUID 48 // to je ten uziv/skupina apache


>
> |  ALE kdyz se pokusim prihlasit, tak po zadani hesla
> | ftpserver skonci a nejak neni jasne proc. Z logu i pri
> | -d 9 moc nevyctu :( tedy jasne receno, neni tam nic
> | zajimaveho, zadne hlaseni o chybe nebo tak ...
>
> Zapnete logovani na sql serveru a hadam, ze to uvidite
> velmi rychle.

mno, psal jsem ze mam -d 9 ... Ale ted vidim, ze to ma nejake informace :

Nov 08 10:22:54 magic proftpd[2085] localhost (localhost[127.0.0.1]): FTP session opened.
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: USER admin
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: USER admin
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: entering auth_cmd_endpwent
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: exiting  auth_cmd_endpwent
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: USER admin
Nov 08 10:23:05 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: USER admin
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: PASS (hidden)
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: PASS (hidden)
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: entering auth_cmd_endpwent
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: exiting  auth_cmd_endpwent
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): received: PASS (hidden)
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: entering auth_cmd_getpwnam
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: no cache hit for user 'apache'
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql_mysql/3.2: select OK: [proftpd] "SELECT userid, uid, gid, shell, homedir, passwd FROM user WHERE (userid='apache') LIMIT 1"
Nov 08 10:23:18 magic proftpd[2085] localhost (localhost[127.0.0.1]): ProFTPD terminating (signal 11)

*********************** tohle je zajimavy, mily proftpd si klidne core-uje ???? Co je to za blbost ?

Nov 08 10:23:18 magic. proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql/3.2.4: closing backend connection
Nov 08 10:23:18 magic. proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql_mysql/3.2: close [1] for mod_sql/3.2.4
Nov 08 10:23:18 magic. proftpd[2085] localhost (localhost[127.0.0.1]): mod_sql_mysql/3.2: disconnecting:
Uptime: 3274  Threads: 1  Questions: 40  Slow queries: 0  Opens: 7  Flush tables: 1  Open tables: 1 Queries per second avg: 0.012


> Mam, od te doby, co se zmenil maintainer, uz jen dobre.
> Predtim to dokonce na nejakou dobu z proftpd vyradili
> uplne, protoze puvodni autor o to uz nejevil zajem. Ted
> to vypada docela rozumne.

muzete poslat funckcni priklad konfiguraku ??

				dik Z.P.