[vchkpw] Re: vpopmail-5.3.28 + mysql 4.0.15 problem

2003-10-16 Thread Sérgio Manuel Rosa
OK now I found something...
vpopmail isn't connecting to mysql server. 

It gives the same error with mysql up or down.
Mysql is listening 0.0.0.0:3306 

Any help?
srosa 

Sérgio Manuel Rosa writes: 

Hi Tom,  

the perms are 600 vut that does not solved the problem.  

One question, there are no tables in the vpopmail database directory. I'm 
going to read again the README.mysql. I might messed something in the way.  

thanks
srosa  

Tom Collins writes:  

On Wednesday, October 15, 2003, at 05:48  PM, Michael Bowe wrote:
  echo "localhost|0|vpopmailuser|vpoppasswd|vpopmail" >
~vpopmail/etc/vpopmail.mysql
  chown vpopmail.vchkpw ~vpopmail/etc/vpopmail.mysql
  chmod 644 ~vpopmail/etc/vpopmail.mysql
!!! WARNING !!!  

That should be chmod 600 instead of 644.  644 allows any user on the 
system to learn the MySQL username and password.  

--
Tom Collins  -  [EMAIL PROTECTED]
Note: The Tom Logic offices will be closed October 23 to November 18.
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/  


 






[vchkpw] Re: vpopmail-5.3.28 + mysql 4.0.15 problem

2003-10-16 Thread Sérgio Manuel Rosa
Hi Tom, 

the perms are 600 vut that does not solved the problem. 

One question, there are no tables in the vpopmail database directory. I'm 
going to read again the README.mysql. I might messed something in the way. 

thanks
srosa 

Tom Collins writes: 

On Wednesday, October 15, 2003, at 05:48  PM, Michael Bowe wrote:
  echo "localhost|0|vpopmailuser|vpoppasswd|vpopmail" >
~vpopmail/etc/vpopmail.mysql
  chown vpopmail.vchkpw ~vpopmail/etc/vpopmail.mysql
  chmod 644 ~vpopmail/etc/vpopmail.mysql
!!! WARNING !!! 

That should be chmod 600 instead of 644.  644 allows any user on the 
system to learn the MySQL username and password. 

--
Tom Collins  -  [EMAIL PROTECTED]
Note: The Tom Logic offices will be closed October 23 to November 18.
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/ 







Re: [vchkpw] Re: vpopmail-5.3.28 + mysql 4.0.15 problem

2003-10-16 Thread Tom Collins
On Wednesday, October 15, 2003, at 06:00  PM, Sérgio Manuel Rosa wrote:
according with READMER.mysql I used the following lines in 
~vpopmail/etc/vpopmail.sql
read localhost|3306|vpopmailuser|vpoppasswd|vpopmail
update localhost|3306|vpopmailuser|vpoppasswd|vpopmail
Actually, the filename should be vpopmail.mysql, and the lines 
shouldn't have "read " and "update " before the localhost.

--
Tom Collins  -  [EMAIL PROTECTED]
Note: The Tom Logic offices will be closed October 23 to November 18.
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/



[vchkpw] Re: vpopmail-5.3.28 + mysql 4.0.15 problem

2003-10-15 Thread Sérgio Manuel Rosa
Hi, 

according with READMER.mysql I used the following lines in 
~vpopmail/etc/vpopmail.sql
read localhost|3306|vpopmailuser|vpoppasswd|vpopmail
update localhost|3306|vpopmailuser|vpoppasswd|vpopmail 

then I tested with your line, but also failed to work. 

I compiled it again with the correct path instead of ~vpopmail/etc/tcp.smtp 
but it failed also. 

thanks
srosa 

Michael Bowe writes:
Did you setup the
  ~vpopmail/etc/vpopmail.mysql file?
eg
  echo "localhost|0|vpopmailuser|vpoppasswd|vpopmail" >
~vpopmail/etc/vpopmail.mysql
  chown vpopmail.vchkpw ~vpopmail/etc/vpopmail.mysql
  chmod 644 ~vpopmail/etc/vpopmail.mysql 

Also note, the output of "./configure --help" is faulty with respect to
the --enable-tcpserver-file
This option needs to be done like this :
  --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp
rather than this
  --enable-tcpserver-file=~vpopmail/etc/tcp.smtp 

Michael. 

- Original Message - 
From: "Sérgio Manuel Rosa" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 16, 2003 10:42 AM
Subject: [vchkpw] vpopmail-5.3.28 + mysql 4.0.15 problem 


Hi all, 

I'm having this messages when I do a ./vadddomain xpto.com 

[EMAIL PROTECTED] bin]# ./vadddomain xpto.com
Please enter password for postmaster:
enter password again:
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
Failure while attempting to remove_line() the locals file
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[c]: MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
Error. Failed to add domain to assign file
Error: Could not update file 

When I try to create it again vpopmail screams that it's allready created,
however no domain directory was created under ~vpopmail/domain/ . 

vpopmail was compiled with the following options:
./configure \
 --enable-vpopuser=vpopmail \
 --enable-vpopgroup=vchkpw \
 --enable-tcprules-prog=/usr/local/bin/tcpserver \
 --enable-tcpserver-file=~vpopmail/etc/tcp.smtp \
 --enable-log-name=vpopmail \
 --enable-roaming-users=y \
 --enable-logging=p \
 --enable-defaultquota=52428800 \
 --enable-ip-alias-domains=n \
 --enable-passwd=n \
 --enable-clear-passwd=y \
 --enable-domain-quotas=y \
 --enable-mysql=y \
 --enable-many-domains=n \
 --enable-auth-logging=y \
 --enable-mysql-logging=y \
 --enable-valias=y \
 --enable-mysql-limits=n \
 --enable-relay-clear-minutes=30 \
 --enable-domains-dir=domains 

mysql client and server are version:
[EMAIL PROTECTED] vpopmail-5.3.28]# mysqld -V
mysqld  Ver 4.0.15-standard for pc-linux on i686
[EMAIL PROTECTED] vpopmail-5.3.28]# mysql -V
mysql  Ver 12.21 Distrib 4.0.15, for pc-linux (i686)
[EMAIL PROTECTED] vpopmail-5.3.28]# 

Vpopmail is version 5.3.28 

mysql database was created like this:
mysql> CREATE DATABASE vpopmail;
Query OK, 1 row affected (0.00 sec) 

mysql> GRANT select,insert,update,delete,create,drop ON vpopmail.*
  -> TO [EMAIL PROTECTED] IDENTIFIED BY 'vpoppasswd'; 

and I'm running REdHAt Linux 8.0 with the latest kernel, mysql is
up&running. 

I found a post on this error but was related with different versions of
server and client. What is missing around here? 

srosa 




 



_
Sérgio Rosa
Senior Partner
GoSecure
Quinta da Fonte
Edif. D. Pedro I
2770-071 Paço d'Arcos
Tel:+351 21 0001663/4
Fax:   +351 21 0001675
Telm: +351 91 6184275
email: [EMAIL PROTECTED]
Web: www.gosecure.pt 

dotWebOn - Serviços de Internet, Lda
Rua Francisco Tomás da Costa, nº51 A
1600-092 Lisboa
Tlm: +351 91 618 42 75
Mail: [EMAIL PROTECTED]