ProFTPD Server Software

phptes>I read this wase a bug but it is fixed in this release.

What does your my.cnf file look like?

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   The split in you is clear.  There is a part of you that knows what it
   should do, and a part that does what it feels like doing.

   	-John Cantwell Kiley

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hi TJ=20

My mysql config file (/var/lib/mysql/my.cnf)

# This will be passed to all mysql clients
[client]
#password       =3D my_password
port            =3D 3306
socket          =3D /var/run/mysqld/mysqld.sock


TJ Saunders <tj@...> =EDrta:

>=20
> phptes>I read this wase a bug but it is fixed in this release.
>=20
> What does your my.cnf file look like?
>=20
> TJ

phptes>My mysql config file (/var/lib/mysql/my.cnf)

What OS/version are you using?  Can you use strace to see which .cnf file
proftpd+mod_sql is looking for?

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   Force is not a remedy.

   	-John Bright

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

I have debian 3.0, mysql 4.0.13.
I don't know this program (strace), how can is use it ?

TJ Saunders <tj@...> =EDrta:

>=20
> phptes>My mysql config file (/var/lib/mysql/my.cnf)
>=20
> What OS/version are you using?  Can you use strace to see=20
which .cnf file
> proftpd+mod_sql is looking for?
>=20
> TJ
>

phptes>I have debian 3.0, mysql 4.0.13.
phptes>I don't know this program (strace), how can is use it ?

As root, start proftpd this way:

  strace -f -o proftpd.strace /path/to/proftpd

Then attempt a login.  After that, you can stop proftpd, and restart it
(without the strace).  strace will dump its output into the indicated file
(proftpd.strace), which will be quite large.

Next, you can search the strace output file to see which .cnf files were
opened:

  grep open proftpd.strace | grep cnf

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   Absence is to love what wind is to fire: it extinguishes the small, it
   enkindles the great.

   	-Comte de Bussy-Rabutin

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

THX a lot for your help TJ,  i made what you have write here is the result

:~# strace -f -o proftpd.strace proftpd
upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not permitted
:~# grep open proftpd.strace | grep cnf
no match for this :(

i have try to mysql
:~# grep open proftpd.strace | grep mysql
187   open("/usr/local/lib/mysql/libmysqlclient.so.12", O_RDONLY) =3D 3



TJ Saunders <tj@...> =EDrta:

>=20
> phptes>I have debian 3.0, mysql 4.0.13.
> phptes>I don't know this program (strace), how can is use it ?
>=20
> As root, start proftpd this way:
>=20
>   strace -f -o proftpd.strace /path/to/proftpd
>=20
> Then attempt a login.  After that, you can stop proftpd, and restart it
> (without the strace).  strace will dump its output into the indicated fil=
e
> (proftpd.strace), which will be quite large.
>=20
> Next, you can search the strace output file to see which .cnf files were
> opened:
>=20
>   grep open proftpd.strace | grep cnf
>=20
> Cheers,
> TJ
>=20

phptes>:~# strace -f -o proftpd.strace proftpd
phptes>upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not permitted

Interesting.

phptes>:~# grep open proftpd.strace | grep cnf
phptes>no match for this :(

How about just 'grep open proftpd.strace'?

What version of proftpd is running?

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   It is a strange desire to seek power and to lose liberty.

   	-Francis Bacon

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Version is - ProFTPD Version 1.2.9rc1

I have compiled whit this configure

./configure --sysconfdir=3D/etc/proftpd --localstatedir=3D/var/run=20
--with-
modules=3Dmod_sql:mod_sql_mysql:mod_quotatab:mod_quotatab_sql:m
od_auth_pam:mod_readme=20
--with-includes=3D/usr/local/include/mysql --with-
libraries=3D/usr/local/lib/mysql

and i have no error on configure or make.


grep open proftpd.strace
187   open("/etc/ld.so.preload", O_RDONLY) =3D -1 ENOENT (No such file=20
or directory)
187   open("/etc/ld.so.cache", O_RDONLY) =3D 3
187   open("/lib/libcrypt.so.1", O_RDONLY) =3D 3
187   open("/lib/libpam.so.0", O_RDONLY) =3D 3
187   open("/lib/libm.so.6", O_RDONLY)  =3D 3
187   open("/usr/lib/libz.so.1", O_RDONLY) =3D 3
187   open("/usr/local/lib/mysql/libmysqlclient.so.12", O_RDONLY) =3D 3
187   open("/lib/libc.so.6", O_RDONLY)  =3D 3
187   open("/lib/libdl.so.2", O_RDONLY) =3D 3
187   open("/lib/libnsl.so.1", O_RDONLY) =3D 3
187   open("/etc/localtime", O_RDONLY)  =3D 3
187   open("/dev/log", O_WRONLY|O_LARGEFILE) =3D -1 ENXIO (No such=20
device or address)
187   open("/etc/nsswitch.conf", O_RDONLY) =3D 3
187   open("/etc/ld.so.cache", O_RDONLY) =3D 3
187   open("/lib/libnss_db.so.2", O_RDONLY) =3D 3
187   open("/lib/libnss_files.so.2", O_RDONLY) =3D 3
187   open("/usr/lib/libdb3.so.3", O_RDONLY) =3D 3
187   open("/var/lib/misc/protocols.db", O_RDWR|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/var/lib/misc/protocols.db", O_RDONLY|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/etc/protocols", O_RDONLY)  =3D 3
187   open("/var/lib/misc/protocols.db", O_RDWR|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/var/lib/misc/protocols.db", O_RDONLY|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/var/lib/misc/services.db", O_RDWR|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/var/lib/misc/services.db", O_RDONLY|O_LARGEFILE) =3D -1=20
ENOENT (No such file or directory)
187   open("/etc/services", O_RDONLY)   =3D 3
187   open("/etc/proftpd/proftpd.conf", O_RDONLY|O_LARGEFILE) =3D 3
187   open("/etc/passwd", O_RDONLY|O_LARGEFILE) =3D 4
187   open("/etc/group", O_RDONLY|O_LARGEFILE) =3D 5
187   open("/etc/resolv.conf", O_RDONLY) =3D 3
187   open("/etc/host.conf", O_RDONLY)  =3D 3
187   open("/etc/hosts", O_RDONLY)      =3D 3
187   open("/etc/hosts", O_RDONLY)      =3D 3
187   open("/etc/ld.so.cache", O_RDONLY) =3D 3
187   open("/lib/libnss_compat.so.2", O_RDONLY) =3D 3

I can't see my.cnf :(

TJ Saunders <tj@...> =EDrta:

>=20
> phptes>:~# strace -f -o proftpd.strace proftpd
> phptes>upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not=20
permitted
>=20
> Interesting.
>=20
> phptes>:~# grep open proftpd.strace | grep cnf
> phptes>no match for this :(
>=20
> How about just 'grep open proftpd.strace'?
>=20
> What version of proftpd is running?
>=20
> TJ
>=20
=20

phptes>I can't see my.cnf :(

And you did a login before ending the strace, yes?  mod_sql_mysql attempts
to open that MySQL configuration file when a client connects, not when the
server starts up...

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   Who can separate his faith from his actions, or his belief from his
   occupations?

     -Kahlil Gibran

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

When i start with this command strace -f -o proftpd.strace proftpd and i=20
see the running procces the proftd is not there.
But if i start only prftpd then is running, but i can't connct while this=
=20
socket trouble.

I don't know what i made wrong, perhaps same files right are wrong ?

TJ Saunders <tj@...> =EDrta:

>=20
> phptes>I can't see my.cnf :(
>=20
> And you did a login before ending the strace, yes?  mod_sql_mysql=20
attempts
> to open that MySQL configuration file when a client connects, not=20
when the
> server starts up...
>=20
> TJ
>=20

Hi TJ

I have try samething
i change in the config file this two line to root
User                            ftp
Group                          ftp
and then proftpd can connect with socket, now i have the lines what=20
you have ask

25425 stat64("/etc/my.cnf", {st_mode=3DS_IFREG|0604,=20
st_size=3D1976, ...}) =3D 0
25425 open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) =3D 8
25425 stat64("/var/lib/mysql/my.cnf", {st_mode=3DS_IFREG|0604,=20
st_size=3D1976, ...}) =3D 0
25425 open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) =3D 8
25425 stat64("/root/.my.cnf", 0xbfffdac0) =3D -1 ENOENT (No such file or=20
directory)

But if i set the user and group back to ftp then the

strace -f -o proftpd.strace proftpd=20

commend stopd with this

upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not permitted


TJ Saunders <tj@...> =EDrta:

>=20
> phptes>I can't see my.cnf :(
>=20
> And you did a login before ending the strace, yes?  mod_sql_mysql=20
attempts
> to open that MySQL configuration file when a client connects, not=20
when the
> server starts up...
>=20
> TJ

phptes>25425 stat64("/etc/my.cnf", {st_mode=S_IFREG|0604,
phptes>st_size=1976, ...}) = 0
phptes>25425 open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) = 8
phptes>25425 stat64("/var/lib/mysql/my.cnf", {st_mode=S_IFREG|0604,
phptes>st_size=1976, ...}) = 0
phptes>25425 open("/var/lib/mysql/my.cnf", O_RDONLY|O_LARGEFILE) = 8

OK.  This implies that the correct MySQL config file is found and read in.
Do you also see open()s for the configured local socket file?

phptes>But if i set the user and group back to ftp then the
phptes>
phptes>strace -f -o proftpd.strace proftpd
phptes>
phptes>commend stopd with this
phptes>
phptes>upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not permitted

This sounds like something that involves the real and effective IDs of
processes, and ptrace()/debugging permissions.  Not a bug in proftpd, but
related to the Linux kernel ptrace() stuff.

TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   The worst sin towards our fellow creatures is not to hate them, but
   to be indifferent to them: that's the essence of inhumanity.

   	-George Bernard Shaw

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

THX all your answers TJ, one of my trouble is solved :)

I have compiled a new kernel and now i can run normali with user and=20
group ftp, and use the right socket file.

I have another question you know what is wron i have quote modul=20
with sql support and in the log file are this line


mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook=20
symbol 'sql_lookup'
mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook=20
symbol 'sql_lookup'
mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook=20
symbol 'sql_lookup'
mod_quotatab/1.2.7.1[6544]: no quota entry found, turning=20
QuotaEngine off

TJ Saunders <tj@...> =EDrta:

>=20
> phptes>25425 stat64("/etc/my.cnf", {st_mode=3DS_IFREG|0604,
> phptes>st_size=3D1976, ...}) =3D 0
> phptes>25425 open("/etc/my.cnf", O_RDONLY|O_LARGEFILE) =3D 8
> phptes>25425 stat64("/var/lib/mysql/my.cnf",=20
{st_mode=3DS_IFREG|0604,
> phptes>st_size=3D1976, ...}) =3D 0
> phptes>25425 open("/var/lib/mysql/my.cnf",=20
O_RDONLY|O_LARGEFILE) =3D 8
>=20
> OK.  This implies that the correct MySQL config file is found and read=20
in.
> Do you also see open()s for the configured local socket file?
>=20
> phptes>But if i set the user and group back to ftp then the
> phptes>
> phptes>strace -f -o proftpd.strace proftpd
> phptes>
> phptes>commend stopd with this
> phptes>
> phptes>upeek: ptrace(PTRACE_PEEKUSER, ... ): Operation not=20
permitted
>=20
> This sounds like something that involves the real and effective IDs of
> processes, and ptrace()/debugging permissions.  Not a bug in=20
proftpd, but
> related to the Linux kernel ptrace() stuff.
>=20
> TJ

phptes>I have another question you know what is wron i have quote modul
phptes>with sql support and in the log file are this line

phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
phptes>symbol 'sql_lookup'
phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
phptes>symbol 'sql_lookup'
phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
phptes>symbol 'sql_lookup'
phptes>mod_quotatab/1.2.7.1[6544]: no quota entry found, turning
phptes>QuotaEngine off

If you're using proftpd-1.2.9rc1, you need mod_quotatab-1.2.8.

Cheers,
TJ

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

   I hate and I love: why I do so you may well ask.  I do not know, but I feel
   it happen and am in agony.

   	-Catullus

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

THX TJ !

I have not see this before on the modules list site.
But now everything  run fine .

TJ Saunders <tj@...> =EDrta:

>=20
> phptes>I have another question you know what is wron i have quote=20
modul
> phptes>with sql support and in the log file are this line
>=20
> phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
> phptes>symbol 'sql_lookup'
> phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
> phptes>symbol 'sql_lookup'
> phptes>mod_quotatab/1.2.7.1[6544]: error: unable to find SQL hook
> phptes>symbol 'sql_lookup'
> phptes>mod_quotatab/1.2.7.1[6544]: no quota entry found, turning
> phptes>QuotaEngine off
>=20
> If you're using proftpd-1.2.9rc1, you need mod_quotatab-1.2.8.
>=20
> Cheers,
> TJ