Uite si tabela :
mysql> select * from proftpd;
+----------+------+------+----------+------------+-------+
| username | uid | gid | password | homedir | count |
+----------+------+------+----------+------------+-------+
| gigi | 1100 | 10 | gigi | /home/gigi | 13 |
+----------+------+------+----------+------------+-------+
si uite si ls -la in /home/gigi :
bash-2.04# pwd
/home/gigi
bash-2.04# ls -la
total 5996
drwxr-xr-x 5 gigi users 512 Jun 14 21:07 .
drwxr-xr-x 4 root wheel 512 Jun 20 10:29 ..
-r--r--r-- 1 root users 17728 Jun 12 16:20 fdimage.exe
-r--r--r-- 1 root users 1474560 Jun 12 16:20 kern.flp
drwx------ 2 gigi users 512 Jun 12 15:16 mail
-r--r--r-- 1 root users 1474560 Jun 12 16:23 mfsroot.flp
drwx------ 2 gigi users 512 Jun 14 21:07 nsmail
-r--r--r-- 1 root users 36064 Jun 12 16:16 rawrite.exe
Acum nu mai stiu ....
userul gigi exista ... (uid=1002(gigi) gid=10(users) groups=10(users))
iar pt ftp am : uid=1003(ftp) gid=1001(ftp) groups=1001(ftp)
Oricum nu prea inteleg ... id din tabel trebuie sa existe real sau ... nu
oricum am mai adugat :
SQLDoGroupAuth on
SQLMinID 900
SQLDefaultGID 1001
SQLDefaultUID 1003
in proftpd.conf!
Dupa parerea mea nu trebuie sa existe uid si gid din tables pe masina;
altfel nu mai fac cu mysql si fac clasic cu /bin/false!
Oricum prin docace am tot cautat si nu am gasit ceva concret la mysql;
On Wed, 20 Jun 2001, Mihai RUSU wrote:
>
> On Wed, 20 Jun 2001, A.Berdan wrote:
>
> >
> > Hi,
> > Am instalat proftpd 1.2.1 + msyql 3.23.38
> > si cu scriptuletul:
> >
> > ....
> >
> > SQLConnectInfo proftpd@localhost root xxxx
> >
> > SQLUserTable proftpd
> > SQLUsernameField username
> > SQLUidField uid
> > SQLGidField gid
> > SQLPasswordField password
> > SQLHomedirField homedir
> > SQLLoginCountField count
> > SQLLogStats on
> > SQLAuthoritative on
> > SQLPlaintextPasswords on
> >
> > RequireValidShell off
> > .....
> nice ... poate intr-o zi ma apuc sa pun si io unul cu sql support :)
>
> >
> > Merge sa ma autentific si sa ma loghez la server ...
> > Acum vine partea cu buba: cand dau ls imi zice ceva de genul :
> >
> > 227 Entering Passive Mode (127,0,0,1,58,90).
> > 150 Opening ASCII mode data connection for file list
> > -r--r--r-- 1 ERROR ERROR 17728 Jun 12 13:20 fdimage.exe
> > -r--r--r-- 1 ERROR ERROR 1474560 Jun 12 13:20 kern.flp
> > drwx------ 2 ERROR ERROR 512 Jun 12 12:16 mail
> > -r--r--r-- 1 ERROR ERROR 1474560 Jun 12 13:23 mfsroot.flp
> > drwx------ 2 ERROR ERROR 512 Jun 14 18:07 nsmail
> > -r--r--r-- 1 ERROR ERROR 36064 Jun 12 13:16 rawrite.exe
> > 226 Transfer complete.
> >
> > Pot sa fac download dar nu stiu ce mama masii este cu ERROR!!!
> > By the way fara RequireValidShell off
> > nu merge si imi da :
> > babube.alex.ro (localhost[127.0.0.1]) - USER gigi (Login failed): Invalid
> > shell
> > chiar daca ii dau SQLShellField /usr/local/bin/bash!!!
> >
> > Care sa fie problema???
> > Tks
> >
> hmm
> deci tu ai in sql user-ul al carui UID este owner si group-owner pe
> fisierele alea???
> adica daca ai fisiere ale root-ului ele au uid=gid=0. in acest caz tre sa
> ai in sql un user care sa aiba uid=0 si un group cu gid=0.
> deci ai asa ceva?
>
> ----------------------------
> Mihai RUSU
> "... and what if this is as good as it gets ?"
>
> ---
> Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
> unsubscribe from this list.
>
---
Send e-mail to '[EMAIL PROTECTED]' with 'unsubscribe rlug' to
unsubscribe from this list.
