en rajoutant une ligne uid et gid dans la table mysql maintenant avec le strace j'ai ca :
close(3) = 0
access("/usr/local/lib/mysql/libz.so.2", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/libz.so.2", F_OK) = 0
access("/usr/local/lib/mysql/libcrypt.so.2", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/libcrypt.so.2", F_OK) = 0
access("/usr/local/lib/mysql/libm.so.2", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/libm.so.2", F_OK) = 0
access("/lib/libm.so.2", F_OK) = 0
mmap(0, 1144, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 1144) = 0
mmap(0, 3904, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 3904) = 0
mmap(0, 960, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 960) = 0
mmap(0, 600, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 600) = 0
mmap(0, 30000, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 30000) = 0
mmap(0, 2000, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 2000) = 0
mprotect(0x281c4000, 790528, PROT_READ|PROT_WRITE|PROT_EXEC) = 0
mmap(0, 22008, PROT_READ|PROT_WRITE, MAP_ANON, -1, 0) = 0x2829e000
munmap(0x2829e000, 22008) = 0
mprotect(0x281c4000, 790528, PROT_READ|PROT_EXEC) = 0
syscall_416(0x4, 0xbfbfeb3c, 0xbfbfeb1c) = 0
sigprocmask(SIG_BLOCK, NULL, []) = 0
syscall_416(0x4, 0xbfbfeb1c, 0) = 0
sysarch(0x1, 0xbfbfeb4c) = 17
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
sigprocmask(SIG_SETMASK, [], NULL) = 0
syscall_416(0, 0xbfbfeb50, 0xbfbfeb30) = -1 (errno 22)
syscall_416(0x1, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x2, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x3, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x4, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x5, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x6, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x7, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x8, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x9, 0xbfbfeb50, 0xbfbfeb30) = -1 (errno 22)
syscall_416(0xa, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xb, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xc, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xd, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xe, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xf, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x10, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x11, 0xbfbfeb50, 0xbfbfeb30) = -1 (errno 22)
syscall_416(0x12, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x13, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x14, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x15, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x16, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x17, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x18, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x19, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1a, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1b, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1c, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1d, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1e, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1f, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0xd, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x1c, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x14, 0xbfbfeb50, 0xbfbfeb30) = 0
syscall_416(0x8, 0xbfbfeb50, 0xbfbfeb30) = 0
umask(07) = 022
getuid() = 0 (euid 0)
getgid() = 0 (egid 0)
getegid(0) = 0
readlink("/etc/malloc.conf", 0xbfbfe3e0, 63) = -1 ENOENT (No such file or directory)
issetugid(0x281cb44c) = 0
mmap(0, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANON, -1, 0) = 0x2829e000
break(0x8070000) = 0
break(0x8071000) = 0
break(0x8072000) = 0
open("/etc/maildropmysql.config", O_RDONLY) = 3
break(0x8073000) = 0
fstat(3, {st_mode=S_IFCHR|0145, st_rdev=makedev(73, 1668153376), ...}) = 0
break(0x8077000) = 0
read(3, "# The attributes are:\n#\n# mail -"..., 16384) = 2997
break(0x8078000) = 0
read(3, "", 16384) = 0
close(3) = 0
open("/etc/services", O_RDONLY) = 3
fstat(3, {st_mode=S_IFBLK|S_ISUID|S_ISGID|S_ISVTX|0562, st_rdev=makedev(115, 1885405294), ...}) = 0
read(3, "#\n# Network services, Internet s"..., 16384) = 16384
read(3, "pleTalk Zone Information\nat-7\t\t2"..., 16384) = 16384
read(3, "#Apertus Technologies Load Deter"..., 16384) = 16384
read(3, "nager\nsas-1\t\t1426/tcp #Satelli"..., 16384) = 16384
read(3, "web - development\nwww-dev\t\t2784/"..., 16384) = 8053
read(3, "", 16384) = 0
close(3) = 0
syscall_416(0xd, 0xbfbfe200, 0xbfbfe1e0) = 0
socket(PF_UNIX, SOCK_STREAM, 0) = 3
fcntl(3, F_GETFL) = 0x2 (flags O_RDWR)
connect(3, {sa_family=0xd0 /* AF_??? */, sa_data="\320\320\320\320\320\320\320\320\320\320\320\320\320\320"...}, 106) = 0
setsockopt(3, SOL_SOCKET, SO_KEEPALIVE, [-791621424], 4) = 0
read(3, "(\0\0\0", 4) = 4
read(3, "\n3.23.58\0\31\0\0\0>TlERKb,\0, \10\2\0\0\0\0\0\0"..., 40) = 40
open("", O_RDONLY) = 4
fstat(4, {st_mode=0150320, st_size=15046755950319947984, ...}) = 0
break(0x807c000) = 0
read(4, "# sql/share/charsets/Index\n#\n# T"..., 16384) = 549
read(4, "", 16384) = 0
close(4) = 0
write(3, "\25\0\0\1\5 \377\377\377postfix\0[PQS^LYE", 25) = 25
read(3, "\5\0\0\2", 4) = 4
read(3, "\0\0\0\2\0", 5) = 5
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
read(3, 0x8070000, 8192) = -1 EAGAIN (Resource temporarily unavailable)
fcntl(3, F_SETFL, O_RDWR) = 0
write(3, "\10\0\0\0\2postfix", 12) = 12
read(3, "\5\0\0\1", 4) = 4
read(3, "\0\0\0\2\0", 5) = 5
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
read(3, 0x8070000, 8192) = -1 EAGAIN (Resource temporarily unavailable)
fcntl(3, F_SETFL, O_RDWR) = 0
write(3, "n\0\0\0\3SELECT uid, uid, gid, maild"..., 114) = 114
read(3, "\1\0\0\1", 4) = 4
read(3, "\7", 1) = 1
read(3, "\26\0\0\2", 4) = 4
read(3, "\7mailbox\3uid\3\v\0\0\1\3\3!\0\0", 22) = 22
read(3, "\26\0\0\3", 4) = 4
read(3, "\7mailbox\3uid\3\v\0\0\1\3\3!\0\0", 22) = 22
read(3, "\26\0\0\4", 4) = 4
read(3, "\7mailbox\3gid\3\v\0\0\1\3\3!\0\0", 22) = 22
read(3, "\32\0\0\5", 4) = 4
read(3, "\7mailbox\7maildir\3\377\0\0\1\375\3\1\0\0", 26) = 26
read(3, "\32\0\0\6", 4) = 4
read(3, "\7mailbox\7maildir\3\377\0\0\1\375\3\1\0\0", 26) = 26
read(3, "\30\0\0\7", 4) = 4
read(3, "\7mailbox\5quota\3\n\0\0\1\3\3\1\0\0", 24) = 24
read(3, "\31\0\0\10", 4) = 4
read(3, "\7mailbox\6active\3\1\0\0\1\1\3\1\0\0", 25) = 25
read(3, "\1\0\0\t", 4) = 4
read(3, "\376", 1) = 1
read(3, "\1\0\0\n", 4) = 4
read(3, "\376", 1) = 1
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK) = 0
read(3, 0x8070000, 8192) = -1 EAGAIN (Resource temporarily unavailable)
fcntl(3, F_SETFL, O_RDWR) = 0
write(3, "\1\0\0\0\1", 5) = 5
shutdown(3, 2 /* send and receive */) = 0
close(3) = 0
stat("/etc/nsswitch.conf", {st_mode=021, st_size=4294967319, ...}) = 0
open("/etc/nsswitch.conf", O_RDONLY) = 3
ioctl(3, TIOCGETA, 0xbfbfe250) = -1 ENOTTY (Inappropriate ioctl for device)
fstat(3, {st_mode=021, st_size=4294967319, ...}) = 0
read(3, "group: compat\ngroup_compat: nis\n"..., 16384) = 113
read(3, "", 16384) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
access("/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/compat/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/X11R6/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/apache2/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/mysql/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/compat/pkg/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_compat.so.1", F_OK) = -1 ENOENT (No such file or directory)
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
access("/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/compat/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/X11R6/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/apache2/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/mysql/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/compat/pkg/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_nis.so.1", F_OK) = -1 ENOENT (No such file or directory)
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
access("/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/compat/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/X11R6/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/apache2/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/mysql/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/compat/pkg/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_files.so.1", F_OK) = -1 ENOENT (No such file or directory)
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
access("/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/compat/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/X11R6/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/apache2/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/mysql/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/local/lib/compat/pkg/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
access("/usr/lib/nss_dns.so.1", F_OK) = -1 ENOENT (No such file or directory)
sigprocmask(SIG_SETMASK, [], NULL) = 0
sigprocmask(SIG_BLOCK, ~[ILL TRAP ABRT EMT FPE BUS SEGV SYS], []) = 0
sigprocmask(SIG_SETMASK, [], NULL) = 0
ioctl(3, TIOCGETA, 0xbfbfe240) = -1 ENOTTY (Inappropriate ioctl for device)
close(3) = 0
geteuid(0x28291720) = 0
stat("/etc/spwd.db", {st_mode=S_IFBLK|0566, st_rdev=makedev(115, 1730150437), ...}) = 0
open("/etc/spwd.db", O_RDONLY) = 3
fcntl(3, F_SETFD, FD_CLOEXEC) = 0
read(3, "\0\6\25a\0\0\0\2\0\0\4\322\0\0\20\0\0\0\0\f\0\0\1\0\0\0"..., 260) = 260
lseek(3, 24576, SEEK_SET) = 24576
read(3, ">\0\370\17\367\17\362\17\240\17\233\17I\17D\17\n\17\5\17"..., 4096) = 4096
lseek(3, 16384, SEEK_SET) = 16384
read(3, "0\0\373\17\251\17\244\17R\17M\17\373\16\366\16\244\16\237"..., 4096) = 4096
lseek(3, 20480, SEEK_SET) = 20480
read(3, ",\0\373\17\301\17\274\17\202\17}\17,\17\'\17\326\16\321"..., 4096) = 4096
lseek(3, 28672, SEEK_SET) = 28672
read(3, ",\0\373\17\302\17\275\17\204\17\177\0177\0172\17\352\16"..., 4096) = 4096
break(0x807d000) = 0
lseek(3, 32768, SEEK_SET) = 32768
read(3, "0\0\373\17\263\17\256\17f\17a\17*\17%\17\356\16\345\16"..., 4096) = 4096
break(0x807e000) = 0
lseek(3, 4096, SEEK_SET) = 4096
read(3, "0\0\373\17\304\17\277\17\210\17\203\17J\17E\17\f\17\7\17"..., 4096) = 4096
break(0x807f000) = 0
lseek(3, 8192, SEEK_SET) = 8192
read(3, ",\0\373\17\302\17\275\17\204\17\177\0176\0171\17\350\16"..., 4096) = 4096
break(0x8080000) = 0
lseek(3, 12288, SEEK_SET) = 12288
read(3, ",\0\374\17\264\17\260\17h\17d\17-\17)\17\362\16\355\16"..., 4096) = 4096
close(3) = 0
write(2, "maildrop", 8maildrop) = 8
write(2, ": ", 2: ) = 2
write(2, "Invalid user specified.", 23Invalid user specified.) = 23
write(2, "\n", 1
) = 1
setitimer(ITIMER_REAL, {it_interval={1818326638, 1965057129}, it_value={544367987, 1667592307}}, {it_interval={1701406313, 11876}, it_value={0, 0}}) = 0
exit(75) = ?
#
Quand j'ai cree ma table mailbox j'ai fait ca :
CREATE TABLE mailbox (
username varchar(255) NOT NULL default '',
password varchar(255) NOT NULL default '',
name varchar(255) NOT NULL default '',
maildir varchar(255) NOT NULL default '',
quota int(10) NOT NULL default '-1',
domain varchar(255) NOT NULL default '',
created datetime NOT NULL default '0000-00-00 00:00:00',
modified datetime NOT NULL default '0000-00-00 00:00:00',
active tinyint(1) NOT NULL default '1',
uid int(11) unsigned NOT NULL default '1011',
gid int(11) unsigned NOT NULL default '1011',
PRIMARY KEY (username),
KEY username (username)
) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes';
et au niveau du maildropmysql.config j'ai mis :
uid_filed username
uidnumber_field uid
gidnumber_field gid
maildir_field maildir
homedirectory_field maildir
En mettant homedirectory_field concat('/home/vmail',maildir)
homedirectory_base /home/vmail/
j'ai le meme probleme.C'est rageant là j'y suis presque