Bem foi instalado com suporte ao mysql
Instalamos cyrrus-sasl2 con soporte para MySQL.
HellFire# cd /usr/ports/security/cyrrus-sasl2
HellFire# make WITH_MYSQL=yes install clean clean-depends
Mas creio que o problema seja permissões mesmo , mesmo o postfixadmin so
ta entrando qdo coloco pra logar de root do mysql, por isso creio que a
encrenca ta ligada a permissão no mysql , ta assim:
INSERT INTO `user` VALUES ('localhost', 'root', '', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('mscbsd', 'root', 'xxxxxxxxxx', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y',
'Y', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('localhost', '', 'xxxxxxxxxxxx', 'Y', 'Y', 'Y', 'Y',
'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('mscbsd', '', 'xxxxxxxxxxx', 'Y', 'Y', 'Y', 'Y',
'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('localhost', 'postfix', 'xxxxxxxxa', 'Y', 'Y', 'Y',
'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('localhost', 'postfixadmin', 'xxxxxxxxxxxxa', 'Y',
'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('mscbsd', 'postfixadmin', 'xxxxxxxxxxxxba', 'Y',
'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', 'N', 'N', '', '', '', '', 0, 0, 0);
INSERT INTO `user` VALUES ('mscbsd', 'postfix', 'xxxxxxxxxxxa', 'Y', 'Y', 'Y',
'Y', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N', 'N',
'N', 'N', '', '', '', '', 0, 0, 0);
A principio tanto os usuarios root, postfix e postfixadmin pode conectar na base
os logs agora estão assim :
Mar 17 16:53:56 mscbsd authdaemond.mysql: failed to connect to mysql server
(server=localhost, userid=postfix)
Mar 17 16:54:01 mscbsd pop3d: LOGIN FAILED, ip=[::ffff:10.4.0.10]
Mar 17 16:54:02 mscbsd pop3d: LOGOUT, ip=[::ffff:10.4.0.10]
Mar 17 16:54:21 mscbsd postfix/trivial-rewrite[1516]: warning: connect to mysql
server localhost: Access denied for user: '[EMAIL PROTECTED]' (Using password:
YES)
Mar 17 16:54:21 mscbsd postfix/trivial-rewrite[1516]: fatal:
mysql:/usr/local/etc/postfix/cnf/transport_maps.cnf(0,100): table lookup problem
Mar 17 16:54:22 mscbsd postfix/smtpd[1381]: warning: premature end-of-input on
private/rewrite socket while reading input attribute name
Mar 17 16:54:22 mscbsd postfix/smtpd[1381]: warning: problem talking to service
rewrite: Unknown error: 0
Mar 17 16:54:22 mscbsd postfix/master[466]: warning: process
/usr/local/libexec/postfix/trivial-rewrite pid 1516 exit status 1
Mar 17 16:54:22 mscbsd postfix/master[466]: warning:
/usr/local/libexec/postfix/trivial-rewrite: bad command startup -- throttling
senha que é na encriptação da senha ???
Marcelo
On Thu, 2005-03-17 at 16:35, Bruno Bandeira wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Já instalou o pam_mysql ???
>
_______________________________________________________________
Para enviar um novo email para a lista: freebsd@fug.com.br
Sair da Lista: http://mail.fug.com.br/mailman/listinfo/freebsd_fug.com.br
Historico: http://www4.fugspbr.org/lista/html/FUG-BR/
