subject:"\[vchkpw\] Vpopmail and MySQL"

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Carlos Collart

i will swap directories 1at time with a bash scritp


#!/bin/bash
echo mv $1 $1temp # temporal rename of the folder
mv $1 $1temp
echo ../../bin/vadduser -c \" $2 \" $1 $3  # creation of the username inside
mysql
../../bin/vadduser -c \" $2 \" $1 $3
echo mv $1temp $1 # restoration of the mails
mv $1temp $1



usage:
./scritp.sh usernamexx "greco comment" password

for each line in the csv file



On 10/1/07, Carlos Collart <[EMAIL PROTECTED]> wrote:
>
> the CSV only contain username,gecos, and clear text password.
>
> i need to build the 
> pw_passwd
>
> On 10/1/07, Quey <[EMAIL PROTECTED]> wrote:
> >
> > Rick Widmer wrote:
> > > Carlos Collart wrote:
> > >> I am the dumbest person alive, and in charge of a vpopmail server,
> > >> I manage to drop database vpopmail
> > >
> > > Not good...  Before you do anything else it might be wise to stop
> > > qmail, and all qmail-smtp processes then back up the mail store.
> > >
> > >> the system was a production one, under the domain
> > xx_at_aduanett_dot_hn
> > >> I have a backup with the username, name, password in a CVS format
> > >
> > > Just one domain, or many?
> > >
> > >
> > >> how could i re-poblate the mysql directly?
> > >> insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
> > >> < http://aduanett.hn>'.vpopmail or crypt?
> > >
> > > This may be the easiest method available.  You will have to write a
> > > Perl, php or whatever program to populate the database.  The password
> > > hash method depends on your ./configure options.  It is pretty easy
> > > unless you have to track down hashed directories.
> > >
> > >
> >
> > He could use mysql itself, depending on making sure the fields are in
> > the right order, and one user per line
> >
> > mysql, use database vpopmail, then :
> > LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS
> > TERMINATED BY ',' LINES TERMINATED BY '\n';
> >
> >
> >
>
>
> --
> atte.
> [EMAIL PROTECTED]
> http://www.danasoft.com/sig/CarlosCollart.jpg
>



-- 
atte.
[EMAIL PROTECTED]
http://www.danasoft.com/sig/CarlosCollart.jpg

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Quey


Que wrote:

oh crap! I'm glad you started this thread, i've just noticed the scp 
section to another machine is going to an old location LOL


/slaps himself silly and fixes it fast... must been like that for a 
couple weeks /ducks




Carlos Collart wrote:

the CSV only contain username,gecos, and clear text password.

i need to build the pw_passwd 
 





I hope you don't have many users :)

Invest in a little time now running a mysqldump, attached is what I 
run  *hourly*
just replace the hostnames, database names and password and whatever 
else thats mine with yours, and make sure the perms are 700 since you 
need to include the mysql root pass in it (assuming your roots mysql 
pass is set)

It uses sys::syslog and mail::sendmail perl mods as well for notification

Cheers


On 10/1/07, *Quey* <[EMAIL PROTECTED] 
> wrote:


Rick Widmer wrote:
> Carlos Collart wrote:
>> I am the dumbest person alive, and in charge of a vpopmail 
server,

>> I manage to drop database vpopmail
>
> Not good...  Before you do anything else it might be wise to stop
> qmail, and all qmail-smtp processes then back up the mail store.
>
>> the system was a production one, under the domain
xx_at_aduanett_dot_hn
>> I have a backup with the username, name, password in a CVS format
>
> Just one domain, or many?
>
>
>> how could i re-poblate the mysql directly?
>> insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn

>> < http://aduanett.hn>'.vpopmail or crypt?
>
> This may be the easiest method available.  You will have to 
write a

> Perl, php or whatever program to populate the database.  The
password
> hash method depends on your ./configure options.  It is pretty 
easy

> unless you have to track down hashed directories.
>
>

He could use mysql itself, depending on making sure the fields 
are in

the right order, and one user per line

mysql, use database vpopmail, then :
LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n';





--
atte.
[EMAIL PROTECTED] 
http://www.danasoft.com/sig/CarlosCollart.jpg

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Quey


Carlos Collart wrote:

the CSV only contain username,gecos, and clear text password.

i need to build the pw_passwd 





I hope you don't have many users :)

Invest in a little time now running a mysqldump, attached is what I run  
*hourly*
just replace the hostnames, database names and password and whatever 
else thats mine with yours, and make sure the perms are 700 since you 
need to include the mysql root pass in it (assuming your roots mysql 
pass is set)

It uses sys::syslog and mail::sendmail perl mods as well for notification

Cheers


On 10/1/07, *Quey* <[EMAIL PROTECTED] 
> wrote:


Rick Widmer wrote:
> Carlos Collart wrote:
>> I am the dumbest person alive, and in charge of a vpopmail server,
>> I manage to drop database vpopmail
>
> Not good...  Before you do anything else it might be wise to stop
> qmail, and all qmail-smtp processes then back up the mail store.
>
>> the system was a production one, under the domain
xx_at_aduanett_dot_hn
>> I have a backup with the username, name, password in a CVS format
>
> Just one domain, or many?
>
>
>> how could i re-poblate the mysql directly?
>> insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn

>> < http://aduanett.hn>'.vpopmail or crypt?
>
> This may be the easiest method available.  You will have to write a
> Perl, php or whatever program to populate the database.  The
password
> hash method depends on your ./configure options.  It is pretty easy
> unless you have to track down hashed directories.
>
>

He could use mysql itself, depending on making sure the fields are in
the right order, and one user per line

mysql, use database vpopmail, then :
LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS
TERMINATED BY ',' LINES TERMINATED BY '\n';





--
atte.
[EMAIL PROTECTED] 
http://www.danasoft.com/sig/CarlosCollart.jpg 
 
#!/usr/bin/perl -w
use Sys::Syslog;
use Mail::Sendmail;
$HRFILE = `date +'%u.%H'`;
chomp($HRFILE);

$SIG{ALRM} = \&Timeout;
sub Timeout {
&DTBFail(RetryTimeOut);
kill('HUP', -$$);
`rm -f "/var/tmp/.sqlhr"`;
exit(1);
}

if (-e "/var/tmp/.sqlhr") {
&DTBFail(LCK);
print "waiting for sql lockfile to go away...\n";
alarm(1800);
sleep 60 until !-e "/var/tmp/.sqlhr";
};

`touch "/var/tmp/.sqlhr"`;

alarm(600);

#backup locally
system("/usr/bin/mysqldump -u root -pPASSWORD --databases vpopmail squirrelmail 
squirrelmail_calendar > /backups/vpopmail/SQL/$HRFILE.vpopmail_dbase.fox.sql") 
== 0 or die &DTBFail("sqldmp"); 

#send copy of backup to another machine
system("/usr/local/bin/scp -p /backups/sql/fox/$HRFILE.vpopmail_dbase.fox.sql 
colt:/opt/fox-sql");

alarm(0);


`rm -f "/var/tmp/.sqlhr"`;

sub DTBFail {
  my ($dfail) = @_;
$FDMSG = qq[
Hourly backup of DB files has failed to complete.
Error report says: $dfail
];

%mailnu = ( To  => '[EMAIL PROTECTED]',
From=> '[EMAIL PROTECTED]',
Subject => 'SQL DB Hourly Backup Failure',
Message => $FDMSG
);

sendmail(%mailnu);
syslog("info", "DB Hourly Backups FAILED - $dfail");
};

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Carlos Collart

the CSV only contain username,gecos, and clear text password.

i need to build the
pw_passwd

On 10/1/07, Quey <[EMAIL PROTECTED]> wrote:
>
> Rick Widmer wrote:
> > Carlos Collart wrote:
> >> I am the dumbest person alive, and in charge of a vpopmail server,
> >> I manage to drop database vpopmail
> >
> > Not good...  Before you do anything else it might be wise to stop
> > qmail, and all qmail-smtp processes then back up the mail store.
> >
> >> the system was a production one, under the domain xx_at_aduanett_dot_hn
> >> I have a backup with the username, name, password in a CVS format
> >
> > Just one domain, or many?
> >
> >
> >> how could i re-poblate the mysql directly?
> >> insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
> >> '.vpopmail or crypt?
> >
> > This may be the easiest method available.  You will have to write a
> > Perl, php or whatever program to populate the database.  The password
> > hash method depends on your ./configure options.  It is pretty easy
> > unless you have to track down hashed directories.
> >
> >
>
> He could use mysql itself, depending on making sure the fields are in
> the right order, and one user per line
>
> mysql, use database vpopmail, then :
> LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS
> TERMINATED BY ',' LINES TERMINATED BY '\n';
>
>
>


-- 
atte.
[EMAIL PROTECTED]
http://www.danasoft.com/sig/CarlosCollart.jpg

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Quey


Rick Widmer wrote:

Carlos Collart wrote:

I am the dumbest person alive, and in charge of a vpopmail server,
I manage to drop database vpopmail


Not good...  Before you do anything else it might be wise to stop 
qmail, and all qmail-smtp processes then back up the mail store.



the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format


Just one domain, or many?



how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn 
'.vpopmail or crypt?


This may be the easiest method available.  You will have to write a 
Perl, php or whatever program to populate the database.  The password 
hash method depends on your ./configure options.  It is pretty easy 
unless you have to track down hashed directories.





He could use mysql itself, depending on making sure the fields are in 
the right order, and one user per line


mysql, use database vpopmail, then :
LOAD DATA INFILE '/path/to/FILENAME.CSV' INTO TABLE vpopmail FIELDS 
TERMINATED BY ',' LINES TERMINATED BY '\n';

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Carlos Collart

On 10/1/07, Rick Widmer <[EMAIL PROTECTED]> wrote:
>
> Carlos Collart wrote:
> > I am the dumbest person alive, and in charge of a vpopmail server,
> > I manage to drop database vpopmail

Not good...  Before you do anything else it might be wise to stop qmail,
> and all qmail-smtp processes then back up the mail store.


Donne...

> the system was a production one, under the domain xx_at_aduanett_dot_hn
> > I have a backup with the username, gecos ,cleartext password in a CVS
> format
>
> Just one domain, or many?

 2 domains (aduanett_dot_hn and fenaduanah_dot_hn)
defaultdomain= aduanett_dot_hn
and users in the other domain login
username_at_fenaduanah_dot_hn

>
>
> > how could i re-poblate the mysql directly?
> > insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
> > '.vpopmail or crypt?
>
> This may be the easiest method available.  You will have to write a
> Perl, php or whatever program to populate the database.  The password
> hash method depends on your ./configure options.  It is pretty easy
> unless you have to track down hashed directories.


i am currently building a sql insert script using openoffice calc
insert into aduanett_hn
values('postmaster',md5('passw0rd'),89,89,'Postmaster','/home/vpopmail/domains/aduanett.hn/postmaster','','passw0rd')

but qmail fail to authenticate maybe md5('passwr0rd') need tweaks


Another way is to save the mail and re-create the mail accounts...  If
> you have hashed directories, it is unlikely that the same accounts will
> end up in the same hash directories, so this will not work.
>
>
>
> Stop mail delivery //   The mail store will be inconsistent during
> this process, and it is already broken.
>
> Backup the mail store to disk or tape, so you have a place to fallback
> to if this process fails.


i am doing this thru sFTP to another Server just in case (slow process btw)

cd ~vpopmail/domains//   Move to the domain storage directory
>
> mv targetdomain.com targetdomain.com.old   //  save the mail
>
> vdeldomain targetdomain.com//  clean out all records of domain
>
> vadddomain targetdomain.com//  recreate a new empty domain
>
> vadduser - all users from your list  //  restore the users
>
> compare the structure of targetdomain.com and targetdomain.com.old
>
> if it exists in targetdomain.com but not targetdomain.com.old you may
> want to delete the user, or find out why it is missing.
>
> if it exists in targetdomain.com.old but not in targetdomain.com you may
> need to vadduser it.
>
>
> Once you have reconciled the domain directories:
>
> rm -r targetdomain.com//   Delete the new directory tree
>
> mv targetdomain.com.old targetdomain.com   //   put the old mail back
>
> repeat the steps after "cd ~vpopmail/domains" for each affected domain
>
> restart mail delivery.
>
>
>
>


-- 
atte.
[EMAIL PROTECTED]
http://www.danasoft.com/sig/CarlosCollart.jpg

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Rick Widmer


Carlos Collart wrote:

I am the dumbest person alive, and in charge of a vpopmail server,
I manage to drop database vpopmail


Not good...  Before you do anything else it might be wise to stop qmail, 
and all qmail-smtp processes then back up the mail store.



the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format


Just one domain, or many?



how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn 
'.vpopmail or crypt?


This may be the easiest method available.  You will have to write a 
Perl, php or whatever program to populate the database.  The password 
hash method depends on your ./configure options.  It is pretty easy 
unless you have to track down hashed directories.




Another way is to save the mail and re-create the mail accounts...  If 
you have hashed directories, it is unlikely that the same accounts will 
end up in the same hash directories, so this will not work.




Stop mail delivery //   The mail store will be inconsistent during 
this process, and it is already broken.


Backup the mail store to disk or tape, so you have a place to fallback 
to if this process fails.


cd ~vpopmail/domains//   Move to the domain storage directory

mv targetdomain.com targetdomain.com.old   //  save the mail

vdeldomain targetdomain.com//  clean out all records of domain

vadddomain targetdomain.com//  recreate a new empty domain

vadduser - all users from your list  //  restore the users

compare the structure of targetdomain.com and targetdomain.com.old

if it exists in targetdomain.com but not targetdomain.com.old you may 
want to delete the user, or find out why it is missing.


if it exists in targetdomain.com.old but not in targetdomain.com you may 
need to vadduser it.



Once you have reconciled the domain directories:

rm -r targetdomain.com//   Delete the new directory tree

mv targetdomain.com.old targetdomain.com   //   put the old mail back

repeat the steps after "cd ~vpopmail/domains" for each affected domain

restart mail delivery.

Re: [vchkpw] vpopmail and mysql

2007-10-01 Thread Rick Macdougall


Carlos Collart wrote:

I am the dumbest person alive, and in charge of a vpopmail server,
I manage to drop database vpopmail
the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format

I am trying and getting:
[EMAIL PROTECTED] bin]# ./vadduser -q 10 -c "Carlos Collart" ccollart 
'password'

Error: User's directory already exists?

i am googling for alternatives
./vadduser -ignoredirectory

or

how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn 
'.vpopmail or crypt?



[EMAIL PROTECTED] bin]# ./vadduser -v
version: 5.4.13


Hi,

If all you have is user, pass and domain name (what's the difference 
between username and name in your post ?  gecos perhaps ?), you'll need 
a script to find the users homedir.


You can then take the information gathered above and add it directly to 
the mysql database.  If all you have is the plain text password, you'll 
have to have a routine to encrypt it to MD5 before storing it.


If you don't care about losing the users existing email, just remove all 
the users directories in the/home/vpopmail/domains/domain.com directory 
and let vpopmail automagically add them.


If you need help, just ask.

Regards,

Rick

[vchkpw] vpopmail and mysql

2007-10-01 Thread Carlos Collart

I am the dumbest person alive, and in charge of a vpopmail server,
I manage to drop database vpopmail
the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format

I am trying and getting:
[EMAIL PROTECTED] bin]# ./vadduser -q 10 -c "Carlos Collart" ccollart
'password'
Error: User's directory already exists?

i am googling for alternatives
./vadduser -ignoredirectory

or

how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn'.vpopmail or crypt?


[EMAIL PROTECTED] bin]# ./vadduser -v
version: 5.4.13

RE: [vchkpw] vpopmail and mysql problem

2005-10-04 Thread Ingo Claro

you use mysql 4.1, have you enabled use old passwords? maybe its that. 


regards,
ingo



-Mensaje original-
De: Wes Hegge [mailto:[EMAIL PROTECTED] 
Enviado el: Lunes, 03 de Octubre de 2005 20:45
Para: vchkpw@inter7.com
Asunto: Re: [vchkpw] vpopmail and mysql problem

On Mon, 2005-10-03 at 20:02 -0400, Rick Macdougall wrote:
> Wes Hegge wrote:
> 
> >On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote:
> >  
> >
> >>Wes Hegge wrote:
> >>
> >>
> >>>Hello everyone,
> >>>
> >>>Hopefully someone can help me with this problem I am having.  I 
> >>>spent all day yesterday looking for an answer.  I found some that 
> >>>were close but still no luck.
> >>>
> >>>Here is the error I am getting:
> >>>vmysql: error creating table 'dir_control': MySQL server has gone 
> >>>away
> >>>vmysql: sql error[b]: MySQL server has gone away
> >>>vmysql: error creating table 'signalblast_com': MySQL server has 
> >>>gone away Error. Failed while attempting to add domain to auth 
> >>>backend
> >>>vmysql: error creating table 'dir_control': MySQL server has gone 
> >>>away
> >>>vmysql: error creating table 'dir_control': MySQL server has gone 
> >>>away
> >>>vmysql: sql error[b]: MySQL server has gone away
> >>>vmysql: error creating table 'dir_control': MySQL server has gone 
> >>>away
> >>>vmysql: sql error[e]: MySQL server has gone away
> >>>Warning: Failed to delete dir_control for signalblast.com
> >>>Error: no auth connection
> >>>
> >>>I am installing this on a Debian Sarge install:
> >>>Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc 
> >>>version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005
> >>>
> >>>I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then 
> >>>made a symbolic link for mysql pointing to the above directory.
> >>>
> >>>Qmail, daemontools, and tcuspi is installed.
> >>>
> >>>Here is my vpopmail.mysql:
> >>>localhost|0|vpopmailuser|vpoppasswd|vpopmail
> >>>
> >>>I can connect and make a test table using the above user and password.
> >>>
> >>>I cannot figure out what the problem is.
> >>>
> >>>Any help would be greatly appreciated.
> >>>  
> >>>
> >>make sure the vpopmailuser has permission to create tables in the 
> >>vpopmail database.
> >>
> >>Ken Jones
> >>
> >>
> >I have checked this.  I mentioned this just above, by creating a test 
> >table.
> >  
> >
> >
> >  
> >
> Is qmail-smtpd running as the vpopmail user ?  Does it have the 
> permissions to read the vpopmail.mysql file in vpopmail/etc ?
Sorry, did not get this before your other email.  But as I have said,
qmail-smtpd is not part of the problem at this time.  But just to be
sure I 'chmod 644 vpopmail.mysql'.   Still the same problem.


> 
> Regards,
> 
> Rick
> 
> 
--
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Wes Hegge

On Mon, 2005-10-03 at 20:02 -0400, Rick Macdougall wrote:
> Wes Hegge wrote:
> 
> >On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote:
> >  
> >
> >>Wes Hegge wrote:
> >>
> >>
> >>>Hello everyone,
> >>>
> >>>Hopefully someone can help me with this problem I am having.  I spent
> >>>all day yesterday looking for an answer.  I found some that were close
> >>>but still no luck.
> >>>
> >>>Here is the error I am getting:
> >>>vmysql: error creating table 'dir_control': MySQL server has gone away
> >>>vmysql: sql error[b]: MySQL server has gone away
> >>>vmysql: error creating table 'signalblast_com': MySQL server has gone
> >>>away
> >>>Error. Failed while attempting to add domain to auth backend
> >>>vmysql: error creating table 'dir_control': MySQL server has gone away
> >>>vmysql: error creating table 'dir_control': MySQL server has gone away
> >>>vmysql: sql error[b]: MySQL server has gone away
> >>>vmysql: error creating table 'dir_control': MySQL server has gone away
> >>>vmysql: sql error[e]: MySQL server has gone away
> >>>Warning: Failed to delete dir_control for signalblast.com
> >>>Error: no auth connection
> >>>
> >>>I am installing this on a Debian Sarge install:
> >>>Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
> >>>version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005
> >>>
> >>>I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
> >>>symbolic link for mysql pointing to the above directory.
> >>>
> >>>Qmail, daemontools, and tcuspi is installed.
> >>>
> >>>Here is my vpopmail.mysql:
> >>>localhost|0|vpopmailuser|vpoppasswd|vpopmail
> >>>
> >>>I can connect and make a test table using the above user and password.
> >>>
> >>>I cannot figure out what the problem is.
> >>>
> >>>Any help would be greatly appreciated.
> >>>  
> >>>
> >>make sure the vpopmailuser has permission to create tables
> >>in the vpopmail database.
> >>
> >>Ken Jones
> >>
> >>
> >I have checked this.  I mentioned this just above, by creating a test
> >table.
> >  
> >
> >
> >  
> >
> Is qmail-smtpd running as the vpopmail user ?  Does it have the 
> permissions to read the vpopmail.mysql file in vpopmail/etc ?
Sorry, did not get this before your other email.  But as I have said,
qmail-smtpd is not part of the problem at this time.  But just to be
sure I 'chmod 644 vpopmail.mysql'.   Still the same problem.


> 
> Regards,
> 
> Rick
> 
> 
-- 
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Wes Hegge

On Mon, 2005-10-03 at 20:13 -0400, Rick Macdougall wrote:
> Wes Hegge wrote:
> 
> >I added this to my.cnf in the [mysqld]
> >
> >set-variable=max_connection=250
> >
> >Did not work.
> >
> >Any ideas on debugging I can do?  Is there anything for vpopmail?
> >
> >  
> >
> Hi,
> 
> As stated earlier, it really sound like qmail-smtpd is running as qmail 
> and not vpopmail.  I think the qmail side of things can not read your 
> vpopmail.mysql file.
What does qmail-smtpd have to do with vaddomain and the error I am
getting?  All I have tried to do so far is add a domain.

> 
> 
> Regards,
> 
> Rick
> 
> 
-- 
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Rick Macdougall


Wes Hegge wrote:


I added this to my.cnf in the [mysqld]

set-variable=max_connection=250

Did not work.

Any ideas on debugging I can do?  Is there anything for vpopmail?

 


Hi,

As stated earlier, it really sound like qmail-smtpd is running as qmail 
and not vpopmail.  I think the qmail side of things can not read your 
vpopmail.mysql file.



Regards,

Rick

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Wes Hegge

I added this to my.cnf in the [mysqld]

set-variable=max_connection=250

Did not work.

Any ideas on debugging I can do?  Is there anything for vpopmail?

Thanks,

Wes

On Mon, 2005-10-03 at 18:17 +0100, Sergio Rosa wrote:
> Hi,
> 
> increase the max_connections = 250 variable in my.cnf.
> 
> I had the same problem and this worked for me.
> 
> regards,
> srosa
> 
> 
> Wes Hegge wrote:
> 
> >Hello everyone,
> >
> >Hopefully someone can help me with this problem I am having.  I spent
> >all day yesterday looking for an answer.  I found some that were close
> >but still no luck.
> >
> >Here is the error I am getting:
> >vmysql: error creating table 'dir_control': MySQL server has gone away
> >vmysql: sql error[b]: MySQL server has gone away
> >vmysql: error creating table 'signalblast_com': MySQL server has gone
> >away
> >Error. Failed while attempting to add domain to auth backend
> >vmysql: error creating table 'dir_control': MySQL server has gone away
> >vmysql: error creating table 'dir_control': MySQL server has gone away
> >vmysql: sql error[b]: MySQL server has gone away
> >vmysql: error creating table 'dir_control': MySQL server has gone away
> >vmysql: sql error[e]: MySQL server has gone away
> >Warning: Failed to delete dir_control for signalblast.com
> >Error: no auth connection
> >
> >I am installing this on a Debian Sarge install:
> >Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
> >version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005
> >
> >I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
> >symbolic link for mysql pointing to the above directory.
> >
> >Qmail, daemontools, and tcuspi is installed.
> >
> >Here is my vpopmail.mysql:
> >localhost|0|vpopmailuser|vpoppasswd|vpopmail
> >
> >I can connect and make a test table using the above user and password.
> >
> >I cannot figure out what the problem is.
> >
> >Any help would be greatly appreciated.
> >  
> >
-- 
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Rick Macdougall


Wes Hegge wrote:


On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote:
 


Wes Hegge wrote:
   


Hello everyone,

Hopefully someone can help me with this problem I am having.  I spent
all day yesterday looking for an answer.  I found some that were close
but still no luck.

Here is the error I am getting:
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'signalblast_com': MySQL server has gone
away
Error. Failed while attempting to add domain to auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Warning: Failed to delete dir_control for signalblast.com
Error: no auth connection

I am installing this on a Debian Sarge install:
Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005

I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
symbolic link for mysql pointing to the above directory.

Qmail, daemontools, and tcuspi is installed.

Here is my vpopmail.mysql:
localhost|0|vpopmailuser|vpoppasswd|vpopmail

I can connect and make a test table using the above user and password.

I cannot figure out what the problem is.

Any help would be greatly appreciated.
 


make sure the vpopmailuser has permission to create tables
in the vpopmail database.

Ken Jones
   


I have checked this.  I mentioned this just above, by creating a test
table.
 



 

Is qmail-smtpd running as the vpopmail user ?  Does it have the 
permissions to read the vpopmail.mysql file in vpopmail/etc ?


Regards,

Rick

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Wes Hegge

On Mon, 2005-10-03 at 12:22 -0500, Ken Jones wrote:
> Wes Hegge wrote:
> > Hello everyone,
> > 
> > Hopefully someone can help me with this problem I am having.  I spent
> > all day yesterday looking for an answer.  I found some that were close
> > but still no luck.
> > 
> > Here is the error I am getting:
> > vmysql: error creating table 'dir_control': MySQL server has gone away
> > vmysql: sql error[b]: MySQL server has gone away
> > vmysql: error creating table 'signalblast_com': MySQL server has gone
> > away
> > Error. Failed while attempting to add domain to auth backend
> > vmysql: error creating table 'dir_control': MySQL server has gone away
> > vmysql: error creating table 'dir_control': MySQL server has gone away
> > vmysql: sql error[b]: MySQL server has gone away
> > vmysql: error creating table 'dir_control': MySQL server has gone away
> > vmysql: sql error[e]: MySQL server has gone away
> > Warning: Failed to delete dir_control for signalblast.com
> > Error: no auth connection
> > 
> > I am installing this on a Debian Sarge install:
> > Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
> > version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005
> > 
> > I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
> > symbolic link for mysql pointing to the above directory.
> > 
> > Qmail, daemontools, and tcuspi is installed.
> > 
> > Here is my vpopmail.mysql:
> > localhost|0|vpopmailuser|vpoppasswd|vpopmail
> > 
> > I can connect and make a test table using the above user and password.
> > 
> > I cannot figure out what the problem is.
> > 
> > Any help would be greatly appreciated.
> 
> make sure the vpopmailuser has permission to create tables
> in the vpopmail database.
> 
> Ken Jones
I have checked this.  I mentioned this just above, by creating a test
table.
> 

-- 
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Ken Jones


Wes Hegge wrote:

Hello everyone,

Hopefully someone can help me with this problem I am having.  I spent
all day yesterday looking for an answer.  I found some that were close
but still no luck.

Here is the error I am getting:
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'signalblast_com': MySQL server has gone
away
Error. Failed while attempting to add domain to auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Warning: Failed to delete dir_control for signalblast.com
Error: no auth connection

I am installing this on a Debian Sarge install:
Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005

I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
symbolic link for mysql pointing to the above directory.

Qmail, daemontools, and tcuspi is installed.

Here is my vpopmail.mysql:
localhost|0|vpopmailuser|vpoppasswd|vpopmail

I can connect and make a test table using the above user and password.

I cannot figure out what the problem is.

Any help would be greatly appreciated.


make sure the vpopmailuser has permission to create tables
in the vpopmail database.

Ken Jones

Re: [vchkpw] vpopmail and mysql problem

2005-10-03 Thread Sergio Rosa


Hi,

increase the max_connections = 250 variable in my.cnf.

I had the same problem and this worked for me.

regards,
srosa


Wes Hegge wrote:


Hello everyone,

Hopefully someone can help me with this problem I am having.  I spent
all day yesterday looking for an answer.  I found some that were close
but still no luck.

Here is the error I am getting:
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'signalblast_com': MySQL server has gone
away
Error. Failed while attempting to add domain to auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Warning: Failed to delete dir_control for signalblast.com
Error: no auth connection

I am installing this on a Debian Sarge install:
Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005

I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
symbolic link for mysql pointing to the above directory.

Qmail, daemontools, and tcuspi is installed.

Here is my vpopmail.mysql:
localhost|0|vpopmailuser|vpoppasswd|vpopmail

I can connect and make a test table using the above user and password.

I cannot figure out what the problem is.

Any help would be greatly appreciated.
 

begin:vcard
fn;quoted-printable:S=C3=A9rgio Manuel Rosa
n;quoted-printable:Rosa;S=C3=A9rgio Manuel
org;quoted-printable:Dotwebon - Servi=C3=A7os de Internet, Lda;Internet Services
adr;quoted-printable:;;Rua Francisco Tom=C3=A1s da Costa, 51-A;Lisboa;Lisboa;1600-092;Portugal
email;internet:[EMAIL PROTECTED]
title:Consultant
tel;work:+351 21 793 50 28
tel;fax:+351 21 781 77 49
tel;cell:+351 91 618 42 75
x-mozilla-html:TRUE
url:http://www.dotwebon.pt
version:2.1
end:vcard

[vchkpw] vpopmail and mysql problem

2005-10-03 Thread Wes Hegge

Hello everyone,

Hopefully someone can help me with this problem I am having.  I spent
all day yesterday looking for an answer.  I found some that were close
but still no luck.

Here is the error I am getting:
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'signalblast_com': MySQL server has gone
away
Error. Failed while attempting to add domain to auth backend
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[e]: MySQL server has gone away
Warning: Failed to delete dir_control for signalblast.com
Error: no auth connection

I am installing this on a Debian Sarge install:
Linux version 2.4.27-2-386 ([EMAIL PROTECTED]) (gcc
version 3.3.5 (Debian 1:3.3.5-12)) #1 Mon May 16 16:47:51 JST 2005

I have installed mysql-standard-4.1.14-pc-linux-gnu-i686 and then made a
symbolic link for mysql pointing to the above directory.

Qmail, daemontools, and tcuspi is installed.

Here is my vpopmail.mysql:
localhost|0|vpopmailuser|vpoppasswd|vpopmail

I can connect and make a test table using the above user and password.

I cannot figure out what the problem is.

Any help would be greatly appreciated.
-- 
Wes Hegge
Technical Engineer
SignalBlast.Com, Inc.

p: (815) 397-1700
e: [EMAIL PROTECTED]

[vchkpw] vpopmail and MySQL connection problem

2005-08-10 Thread Mike Ruskai

I'm attempting to configure a backup mail server on a Gentoo Linux server 
machine.


I've been repeating the steps I took to set up the primary server on a 
separate Gentoo Linux machine, but am unable to add domains to vpopmail.


Upon running vadddomain, I get this:

vmysql: error creating table 'dir_control': MySQL server has gone away
vmysql: sql error[b]: MySQL server has gone away
vmysql: sql error[3]: MySQL server has gone away
vmysql: error creating table 'limits': MySQL server has gone away
vmysql: sql error[p]: MySQL server has gone away
Error: (vadduser) can't read domain limits

The database connection parameters are correct.  I can log into the 
database as the vpopmail user with the same password in the config file, 
and have complete access to the vpopmail database.


The config file has this:

localhost|0|vpopmail|[password]|vpopmail

I tried changing the host to an IP address, to see if connecting via TCP 
would work, but it did not.


The server listens on port 3392 instead of 3306, but that is in the my.cnf 
file, and I also specified that port when I tried using the IP address.


The configuration in use created /tmp/mysql.sock for Unix socket access. 
I did try moving this to /var/run/mysqld/mysqld.sock (with a concurrent 
my.cnf change in the client section), and linked it back to /tmp as well.


Each time I try to use vadddomain or vdeldomain (the latter necessary to 
repeat the attempt at an addition), the Aborted_connects value of the 
server goes up.


With the primary mail server machine, I used the default Gentoo ebuild of 
MySQL 4.0.x.


But with this machine, which is a production database server, the MySQL 
version is 4.1.1 alpha.  It's a custom compile from source, with a few bug 
fixes that had not yet been added at the time (it was the latest version 
when implemented - version 4.1 features are required for the production 
database).


Beyond that, the only discernible differences are that the database server 
in question is an Opteron box running the 64-bit version of Linux, and it 
began life as a 2004.x installation which has been upgraded to 2005.0.


Any clues as to why vpopmail is unable to connect to this database?

Would I be better served by running a second copy of MySQL 4.0.x (the 
normal Gentoo ebuild) than trying to figure this out?

RE: [vchkpw] Vpopmail and MySQL

2005-02-02 Thread Jason Wilkinson

Bill Wichers wrote:
>> If I increase the connection limit in qmail to 100, when the limit
>> hits about 60 I get the following :
>> 
>> 2005-01-25 01:01:34.011714500 vmysql: error creating table
>> 'dir_control': MySQL server has gone away
>> 2005-01-25 01:01:34.011775500 vmysql: sql error[b]: MySQL server has
>> gone away 
>> 
>> Any idea how to fix this problem?
> 
> You probably need to up the max number of connections allowed by
> MySQL. If I am remembering correctly, it defaults to 100 simultaneous
> connections. Remember that with a MySQL backend, vpopmail will be
> doing a *lot* of db activity that MySQL is going to be involved in.
> 
>  -Bill
> 

I had horrible load problems when logging to MySQL. I started logging to
syslog and everything ran much more smoothly. Then again...I take in about
3-7 pop connections a second and don't have a beefy MySQL server.

Unless you have a specific reason to log to MySQL, I would recommend that
you log to syslog and be done with it.

If you must log to MySQL, I'm sure that max connections are the problem.

-jw-

Re: [vchkpw] Vpopmail and MySQL

2005-02-01 Thread Jason 'XenoPhage' Frisvold

Bill Wichers wrote:
You probably need to up the max number of connections allowed by MySQL. If
I am remembering correctly, it defaults to 100 simultaneous connections.
Remember that with a MySQL backend, vpopmail will be doing a *lot* of db
activity that MySQL is going to be involved in.
 

Yeah..  you're right..  I should have checked that.. dammit..  *sigh*
Thanks for the wake-up call...
-Bill
*
Waveform Technology
UNIX Systems Administrator
 


--
---
Jason 'XenoPhage' Frisvold
Engine / Technology Programmer
[EMAIL PROTECTED]
RedHat Certified - RHCE # 803004140609871
MySQL Pro Certified - ID# 207171862
MySQL Core Certified - ID# 205982910
---
"Something mysterious is formed, born in the silent void. Waiting alone and 
unmoving, it is at once still and yet in constant motion. It is the source of all 
programs. I do not know its name, so I will call it the Tao of Programming."

Re: [vchkpw] Vpopmail and MySQL

2005-02-01 Thread Bill Wichers

> If I increase the connection limit in qmail to 100, when the limit hits
> about 60 I get the following :
>
> 2005-01-25 01:01:34.011714500 vmysql: error creating table
> 'dir_control': MySQL server has gone away
> 2005-01-25 01:01:34.011775500 vmysql: sql error[b]: MySQL server has
> gone away
>
> Any idea how to fix this problem?

You probably need to up the max number of connections allowed by MySQL. If
I am remembering correctly, it defaults to 100 simultaneous connections.
Remember that with a MySQL backend, vpopmail will be doing a *lot* of db
activity that MySQL is going to be involved in.

 -Bill

*
Waveform Technology
UNIX Systems Administrator

[vchkpw] Vpopmail and MySQL

2005-02-01 Thread Jason 'XenoPhage' Frisvold

Hi all,
   I'm having a problem with vpopmail and MySQL ...  I'm running 
vpopmail 5.4.9 with MySQL 4.1.9.  Vpopmail is configured as follows :

./configure --enable-logging=v --enable-clear-passwd 
--enable-auth-module=mysql --enable-auth-logging --enable-sql-logging 
--disable-passwd --enable-valias
--disable-mysql-limits

If I increase the connection limit in qmail to 100, when the limit hits 
about 60 I get the following :

2005-01-25 01:01:34.011714500 vmysql: error creating table 
'dir_control': MySQL server has gone away
2005-01-25 01:01:34.011775500 vmysql: sql error[b]: MySQL server has 
gone away

Any idea how to fix this problem?
Thanks!
--
---
Jason 'XenoPhage' Frisvold
Engine / Technology Programmer
[EMAIL PROTECTED]
RedHat Certified - RHCE # 803004140609871
MySQL Pro Certified - ID# 207171862
MySQL Core Certified - ID# 205982910
---
"Something mysterious is formed, born in the silent void. Waiting alone and 
unmoving, it is at once still and yet in constant motion. It is the source of all 
programs. I do not know its name, so I will call it the Tao of Programming."

Re: [vchkpw] vpopmail and mysql

2004-06-09 Thread Franck

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

> > But, table vlimit is still empty and in ~vpopmail/domain/my_domain,
> > i've
> > the .qmailadmin-limits and nothing in MySQL :( and i've too etc/
> > vlimits.default
> >
> > Could anyone has a solution ?
>
> Have you run vmoddomlimits to try setting limits on a domain?
>
> I don't think there's any code to convert .qmailadmin-limits files into
> the MySQL table, if that's what you were expecting.


No, i'm only use qmailadmin + vqadmin to manage vpopmail but, if 
- --enable-mysql-limits is defined, all values must be in MySQL and not in the 
file no ???

- -- 
Franck

http://www.linuxpourtous.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAx1141zwfep5k9qERAhOhAKC+SaDEbbFlUxg2psXptjSXWdmzGQCfQN2i
6hd+gD2fNaosqSoO6ylPo8Y=
=8lmP
-END PGP SIGNATURE-

Re: [vchkpw] vpopmail and mysql

2004-06-09 Thread Tom Collins

On Jun 9, 2004, at 10:35 AM, Franck wrote:
But, table vlimit is still empty and in ~vpopmail/domain/my_domain, 
i've
the .qmailadmin-limits and nothing in MySQL :( and i've too etc/
vlimits.default

Could anyone has a solution ?
Have you run vmoddomlimits to try setting limits on a domain?
I don't think there's any code to convert .qmailadmin-limits files into 
the MySQL table, if that's what you were expecting.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/

Re: [vchkpw] vpopmail and mysql

2004-06-09 Thread Christopher Tarricone

> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> 
> Hello,
> 
> vlimit don't work with MySQL :(
> ./configure \
> - --prefix=/var/qmail \
> - --enable-qmail-newu=/var/qmail/bin/qmail-newu \
> - --enable-vpopuser=VPOPUSER \
> - --enable-vpopgroup=VPOPGROUP \
> - --enable-roaming-users \
> - --enable-tcprules-prog=pacth_tcprule \
> - --enable-relay-clear-minutes=90 \
> - --enable-sqwebmail-pass \
> - --enable-qmail-ext \
> - --enable-ip-alias-domains \
> - --enable-domainquotas \
> - --enable-auth-module=mysql \
> - --enable-logging=p \
> - --enable-auth-logging \
> - --enable-mysql-logging \
> - --enable-libdir=path_mysql_lib \
> - --enable-valias \
> - --enable-mysql-logging \
> - --enable-clear-passwd \
> - --enable-mysql-limits
> 
> But, table vlimit is still empty and in ~vpopmail/domain/my_domain, i've
> the .qmailadmin-limits and nothing in MySQL :( and i've too etc/
> vlimits.default
> 
> Could anyone has a solution ?
> 
> Regards
> - -- 
> Franck
> 
> http://www.linuxpourtous.com
> -BEGIN PGP SIGNATURE-
> Version: GnuPG v1.2.4 (GNU/Linux)
> 
> iD8DBQFAx0pJ1zwfep5k9qERAtHqAJ9ilbIiu5fDVEyaF/KLrYY21x/3zgCeLx9E
> mnaqJwll3CbYsIT1gZu1acM=
> =kV9I
> -END PGP SIGNATURE-
> 
> 
I use MySQL with vpopmail and I do not have a vlimit table. I do have a file
in ~/vpopmail/etc/vlimits.default that is read vpopmail and used when I add
users via the command line or qmailadmin.

I just set mine up this morning and it seems to work for me...
./configure \
--enable-roaming-users=y \
--enable-logging=y  \
--enable-clear-passwd=y \
--enable-auth-module=mysql

And got this for a result:

   vpopmail 5.4.4
Current settings
---

vpopmail directory = /var/vpopmail
   uid = 518
   gid = 520
 roaming users = ON  --enable-roaming-users
tcpserver file = /var/vpopmail/etc/tcp.smtp
open_smtp file = /var/vpopmail/etc/open-smtp
rebuild tcpserver file = ON  --enable-rebuild-tcpserver-file (default)
 password learning = OFF --disable-learn-passwords (default)
 md5 passwords = ON  --enable-md5-passwords (default)
  file locking = ON  --enable-file-locking (default)
vdelivermail fsync = OFF --disable-file-sync (default)
 make seekable = ON  --enable-make-seekable (default)
  clear passwd = ON  --enable-clear-passwd (default)
 user dir hashing  = ON  --enable-users-big-dir (default)
address extensions = OFF --disable-qmail-ext (default)
  ip alias = OFF --disable-ip-alias-domains (default)
 domain quotas = OFF --disable-domainquotas (default)
   auth module = mysql --enable-auth-module=mysql
 mysql replication = OFF --disable-mysql-replication (default)
 mysql logging = OFF --disable-mysql-logging (default)
  mysql limits = OFF --disable-mysql-limits (default)
  MySQL valias = OFF --disable-valias (default)
  auth inc = -I/usr/include/mysql
  auth lib = -L/usr/lib/mysql  -lmysqlclient -lz -lm
  system passwords = OFF --disable-passwd (default)
pop syslog = show successful and failed login attempts
 --enable-logging=y
  auth logging = ON  --enable-auth-logging (default)
all domains in one SQL table = --enable-many-domains (default)

[vchkpw] vpopmail and mysql

2004-06-09 Thread Franck

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hello,

vlimit don't work with MySQL :(
./configure \
- --prefix=/var/qmail \
- --enable-qmail-newu=/var/qmail/bin/qmail-newu \
- --enable-vpopuser=VPOPUSER \
- --enable-vpopgroup=VPOPGROUP \
- --enable-roaming-users \
- --enable-tcprules-prog=pacth_tcprule \
- --enable-relay-clear-minutes=90 \
- --enable-sqwebmail-pass \
- --enable-qmail-ext \
- --enable-ip-alias-domains \
- --enable-domainquotas \
- --enable-auth-module=mysql \
- --enable-logging=p \
- --enable-auth-logging \
- --enable-mysql-logging \
- --enable-libdir=path_mysql_lib \
- --enable-valias \
- --enable-mysql-logging \
- --enable-clear-passwd \
- --enable-mysql-limits

But, table vlimit is still empty and in ~vpopmail/domain/my_domain, i've 
the .qmailadmin-limits and nothing in MySQL :( and i've too etc/
vlimits.default

Could anyone has a solution ?

Regards
- -- 
Franck

http://www.linuxpourtous.com
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFAx0pJ1zwfep5k9qERAtHqAJ9ilbIiu5fDVEyaF/KLrYY21x/3zgCeLx9E
mnaqJwll3CbYsIT1gZu1acM=
=kV9I
-END PGP SIGNATURE-

Re: [vchkpw] vpopmail and mysql configuration problems

2004-01-08 Thread Tom Collins

On Jan 8, 2004, at 11:08 AM, Ronnie Samuel wrote:
--enable-incdir=/usr/include/
This needs to be the include directory for the MySQL libs.

Something like "/usr/local/include/mysql".  Try leaving it blank, as 
vpopmail will search multiple locations for the correct directory.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/

[vchkpw] vpopmail and mysql configuration problems

2004-01-08 Thread Ronnie Samuel

Hi everyone -- can some light be shed on this situation and a possible 
recommendation of how to rectify this please?
Any suggestions / assistance will be greatly appreciated. 
Thanks in advance
Regards,
Ronnie. 

My /home/vpopmail/etc/vpopmail.mysql file looks like this:

localhost|0|vpopmailusername|vpopmailpasswd|vpopmail
localhost|0|root|rootpasswd|vpopmail
My configuration is as follows:

./configure --enable-roaming-users=y --enable-logging=p 
--enable-default-quota=20971520S --enable-ip-alias-domains=n 
--enable-passwd=n --enable-clear-passwd=y --enable-domain-quotas=n 
--enable-mysql=y --enable-many-domains=y --enable-auth-logging=y 
--enable-mysql-logging=y --enable-valias=y --enable-mysql-limits=y 
--enable-incdir=/usr/include/

When I type make -- i get the following error during the make:

chmod 755 makelib
./makelib cdb.a cdb_hash.o cdb_unpack.o cdb_seek.o
./makelib cdbmake.a cdbmake_pack.o cdbmake_hash.o \
cdbmake_add.o
make[2]: Leaving directory `/home/techdoc/qmail/vpopmail-5.3.30/cdb'
make[2]: Entering directory `/home/techdoc/qmail/vpopmail-5.3.30'
gcc -I. -I/usr/include/  -I. -I. -I. -g -O2 -Wall -c `test -f 
'vauth.c' || echo './'`vauth.c
vauth.c:33:19: mysql.h: No such file or directory
vauth.c:40: error: syntax error before "mysql_update"
vauth.c:40: warning: type defaults to `int' in declaration of `mysql_update'
vauth.c:40: warning: data definition has no type or storage class
vauth.c:41: error: syntax error before "mysql_read_getall"
vauth.c:41: warning: type defaults to `int' in declaration of 
`mysql_read_getall'
vauth.c:41: warning: data definition has no type or storage class
vauth.c:59: error: syntax error before '*' token
vauth.c:59: warning: type defaults to `int' in declaration of `res_update'
vauth.c:59: warning: data definition has no type or storage class
vauth.c:60: error: syntax error before '*' token
vauth.c:60: warning: type defaults to `int' in declaration of 
`res_read_getall'
vauth.c:60: warning: data definition has no type or storage class
vauth.c:68: error: syntax error before "row"
vauth.c:68: warning: type defaults to `int' in declaration of `row'
vauth.c:68: warning: data definition has no type or storage class
vauth.c:69: error: syntax error before "row_getall"
vauth.c:69: warning: type defaults to `int' in declaration of `row_getall'
vauth.c:69: warning: data definition has no type or storage class
vauth.c: In function `vauth_open_update':
vauth.c:203: warning: implicit declaration of function `mysql_init'
vauth.c:204: warning: implicit declaration of function `mysql_options'
vauth.c:204: error: `MYSQL_OPT_CONNECT_TIMEOUT' undeclared (first use in 
this function)
vauth.c:204: error: (Each undeclared identifier is reported only once
vauth.c:204: error: for each function it appears in.)
vauth.c:207: warning: implicit declaration of function `mysql_real_connect'
vauth.c:226: warning: implicit declaration of function `mysql_query'
vauth.c:231: warning: implicit declaration of function `mysql_error'
vauth.c:231: warning: format argument is not a pointer (arg 3)
vauth.c:236: warning: implicit declaration of function `mysql_select_db'
vauth.c: In function `vauth_adduser':
vauth.c:403: warning: format argument is not a pointer (arg 3)
vauth.c: In function `vauth_getpw':
vauth.c:454: warning: format argument is not a pointer (arg 3)
vauth.c:458: warning: implicit declaration of function `mysql_store_result'
vauth.c:458: warning: assignment makes pointer from integer without a cast
vauth.c:463: warning: implicit declaration of function `mysql_num_rows'
vauth.c:464: warning: implicit declaration of function `mysql_free_result'
vauth.c:482: warning: implicit declaration of function `mysql_fetch_row'
vauth.c:483: error: subscripted value is neither array nor pointer
vauth.c:483: error: subscripted value is neither array nor pointer
vauth.c:483: error: subscripted value is neither array nor pointer
vauth.c:483: error: subscripted value is neither array nor pointer
vauth.c:483: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:484: error: subscripted value is neither array nor pointer
vauth.c:485: error: subscripted value is neither array nor pointer
vauth.c:485: error: subscripted value is neither array nor pointer
vauth.c:486: error: subscripted value is neither array nor pointer
vauth.c:486: error: subscripted value is neither array nor pointer
vauth.c:487: error: subscripted value is neither array nor pointer
vauth.c:487: error: subscripted value is neither array nor pointer
vauth.c:487: error: subscripted value is neither array nor pointer
vauth.c:487: error: subscripted value is neither array nor pointer
vauth.c:487: erro

Re: [vchkpw] vpopmail and mysql replication

2003-09-05 Thread Nick Harring

Doug Clements wrote:

On Fri, Sep 05, 2003 at 02:31:39PM -0500, Nick Harring wrote:

I'm about to tackle this same problem myself, since I'm about to ditch a
pair of Solaris boxes for my NFS mounted mail spools and instead move to
filers. My plan is to instead use Linux HA to have two machines as a
failover cluster mounting the database via NFS. I think this'll be a
lot cleaner, and will also integrate in a nicer fashion with the concept
vpopmail has of mysql replication.
Your other option, if you've got money to spend on the problem, is to
get a database server which is both supported by vpopmail and supports
more flexible replication. I'd recommend Sybase, since they support real
two way replication, and their replication speed is amazing.

Thanks for the input. I would assume Sybase also supports concurrent access to the DB files over NFS, since you're planning to use that. I know mysql specifically doesn't allow that (at least with MyISAM tables). Unfortunately, Sybase pricing is probably greater than the cost of labor in setting up a dedicated mysql server. What is a typical Sybase price for a setup like yours?

--Doug

I've not yet actually priced out Sybase for this, and probably wouldn't
do concurrent NFS access, since with two way replication it'd be easier
to just have two servers with a virtual IP for failover (makes it
totally transparent to the clients). Sybase licensing is typically on a
per CPU basis though, so if you have low load the pricing shouldn't be
too bad.
Also, with MySQL I'm not planning on doing concurrent access, but
active/passive failover. The scenario plays out roughly like this:
Server A is primary, and thus active. Server B is secondary, and thus
passive.
Servers A and B mount the nfs share, but only Server A starts MySQL and
takes ownership of the virtual IP.
Server A chugs along happily for an arbitrary period of time, serving
requests and keeping the table files up to date.
Server A fails, server B fails to receive a heartbeat and immediately
assumes the virtual IP, forcibly arps to notify the switch, and then
starts MySQL, loading the tables via NFS.
When Server A resumes it sees that B is primary, and stays passive,
waiting for a heartbeat failure in order to fail back over.

The other option, one that I'm also considering, is instead of using
shared storage is to have two configuration files on each server, one
with it being the master, and the other with it being the slave. You
still use a virtual IP, but both servers run all the time. Which ever
is the slave just connects to the master as a slave and pulls updates
from it, only restarting in master mode in order to server updates
properly to the rest of the cluster.

In the first scenario, if you're leery of NFS (which is a reasonable
thing for databases), the other option is to hang one storage array
with two scsi host channels off of two boxes and have them mount/umount
based on their active or passive role. In either scenario you need to
be 100% positive that you'll completely fail rather than have both
sides become active, as split brain syndrome is incredibly difficult to
recover from. You might want to look at Veritas Cluster Services for
this sort of setup, as they're pretty reasonable to manage and they
offer the flexibility to do a lot of fail over scenarios.

I'd definitely advise looking at the Linux HA tools and see what kind
of reliability and flexibility you need. I have had very, very positive
experiences with both LVS and Pirahna in the past, including doing it
with MySQL. The upfront effort is a little on the high side, especially
for dynamically reconfiguring MySQL servers to flip from master to
slave and back, but its well worth it when you get an essentially
bulletproof cluster.

Nick

Re: [vchkpw] vpopmail and mysql replication

2003-09-05 Thread Doug Clements

On Fri, Sep 05, 2003 at 02:31:39PM -0500, Nick Harring wrote:
> I'm about to tackle this same problem myself, since I'm about to ditch a 
> pair of Solaris boxes for my NFS mounted mail spools and instead move to 
> filers. My plan is to instead use Linux HA to have two machines as a 
> failover cluster mounting the database via NFS.  I think this'll be a 
> lot cleaner, and will also integrate in a nicer fashion with the concept 
> vpopmail has of mysql replication.
> Your other option, if you've got money to spend on the problem, is to 
> get a database server which is both supported by vpopmail and supports 
> more flexible replication. I'd recommend Sybase, since they support real 
> two way replication, and their replication speed is amazing.

Thanks for the input. I would assume Sybase also supports concurrent access to the DB 
files over NFS, since you're planning to use that. I know mysql specifically doesn't 
allow that (at least with MyISAM tables). Unfortunately, Sybase pricing is probably 
greater than the cost of labor in setting up a dedicated mysql server. What is a 
typical Sybase price for a setup like yours?

--Doug

Re: [vchkpw] vpopmail and mysql replication

2003-09-05 Thread Dave Richardson - Lists

You could potentially code in a multiple call update from vpopmail to
some IFDEF'd in mysql servers.
I'm thinking that you could make certain update calls to as many MySQL
servers as you wanted, sending the same SQL statement to each.

I imagine some critical thinking in the process could lead to judgement
on what would be the "essential" updates to "multi-home" and which
updates could be written to the "master" for later replication.

My $0.02USD, before taxes.

Doug Clements wrote:

Greetings,
I've got a working mysql and vpopmail setup going, with replication support. For those that don't know, replication support in vpopmail means that all updates go to a single server, where lookups can be sent to another server. I have a local copy of the replicated database on each machine to spread the load out and to be more robust in the face of other machine failure. Unfortunately, this makes each machine dependant on the mysql update server, since each login triggers an update to the lastauth table. How have other people solved this, without just disabling mysql logging? Has anyone used any of the more rare multiple-master ring topologys in mysql to let each server update?

I really don't want to setup a dedicated "mysql server" just to handle updates like this. I'm also planning to start using spamassassin mysql preferences, so I'd like any server to be able to update the database with user preferences, and the change replicate around. Does anyone have any input on this? Anyone use squirrelmail with their preferences in the database as well?

Thanks!

--Doug

Re: [vchkpw] vpopmail and mysql replication

2003-09-05 Thread Nick Harring

Doug Clements wrote:

Thanks!

--Doug

[vchkpw] vpopmail and mysql replication

2003-09-05 Thread Doug Clements

Greetings,
   I've got a working mysql and vpopmail setup going, with replication support. For 
those that don't know, replication support in vpopmail means that all updates go to a 
single server, where lookups can be sent to another server. I have a local copy of the 
replicated database on each machine to spread the load out and to be more robust in 
the face of other machine failure. Unfortunately, this makes each machine dependant on 
the mysql update server, since each login triggers an update to the lastauth table. 
How have other people solved this, without just disabling mysql logging? Has anyone 
used any of the more rare multiple-master ring topologys in mysql to let each server 
update?
  
I really don't want to setup a dedicated "mysql server" just to handle updates like 
this. I'm also planning to start using spamassassin mysql preferences, so I'd like any 
server to be able to update the database with user preferences, and the change 
replicate around. Does anyone have any input on this? Anyone use squirrelmail with 
their preferences in the database as well?
  
Thanks!

--Doug

RE: [vchkpw] Vpopmail and mysql limits

2002-10-23 Thread John Johnson

 Thanks... As for waiting 10 months, we didn't know it was around so we
really were
Not waiting and you know us bitchy sysadmins we want it and we want it
Yesterday 

-John

-Original Message-
From: Brian Kolaci [mailto:bk@;Kola.com] 
Sent: Wednesday, October 23, 2002 4:38 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vpopmail and mysql limits

  > On Wednesday, October 23, 2002, at 03:28  PM, John Johnson wrote:
  > 
  > >  ok to use mysql-limits is there a convert program to convert the 
  > > limits
  > > I have
  > > Or do I have to start over with them and reset them.. I guess I
will
  > > also have
  > > To recompile vqadmin and qmailadmin for this as well?
  > 
  > Qmailadmin and vqadmin do not support the new vlimits functions yet.

  > vqadmin has its own code to modify the limits file only (not sql).  
  > Brian, the author of this patch, does have his own patches for 
  > qmailadmin I think.  So you really can't do anything with them until

  > you have code to use them.  Not sure if Brian is planning to publish

  > his qmailadmin patch...
  > 
  > Regards,
  > 
  > Bill
  > 

I see there's been alot of traffic on this today.  I've
been out (working) most of the day and haven't been able to keep up.  It
should be easy to put together a utility to convert the limits, not an
issue.

As for several of the other comments, I'd like to take tonight to think
about several of the suggestions and post one myself.  I've been running
with the current patched API since vpopmail 4.9.6 and its been working
well.  I also have a patched qmailadmin-1.0.4 with quotas (I forgot who
wrote the quota patch), and a patched version of vdelivermail.  Both of
these use a recursive stat() to determine usage & quota since it was
before the Maildir++ quotas were in there, so I always had *regular*
disk usage quotas enforced which I believe may differ from the Maildir++
quotas.

My intent was to get the API into the library before updating the
programs/utilities to actually use the API.  I've been sitting on this
for about 10 months now (with a working system), and now finally got it
into the distribution.  Now it seems (from all the traffic on it today)
that nobody can wait for it...  I think it would be best to get the base
correct and sound before actually using it in the utilities and
programs.  I have some pros/cons (and I'd like to extend the list and
send it out to everyone) about the current implementation and want to
get some feedback before moving on it.  (Its waited 10 months already,
another day or two won't hurt).  I'll compile and post some questions 
in a bit to see what people really want/need and make sure this gets
done properly.

Thanks,

Brian

Re: [vchkpw] Vpopmail and mysql limits

2002-10-23 Thread Brian Kolaci

  > On Wednesday, October 23, 2002, at 03:28  PM, John Johnson wrote:
  > 
  > >  ok to use mysql-limits is there a convert program to convert the 
  > > limits
  > > I have
  > > Or do I have to start over with them and reset them.. I guess I will
  > > also have
  > > To recompile vqadmin and qmailadmin for this as well?
  > 
  > Qmailadmin and vqadmin do not support the new vlimits functions yet.  
  > vqadmin has its own code to modify the limits file only (not sql).  
  > Brian, the author of this patch, does have his own patches for 
  > qmailadmin I think.  So you really can't do anything with them until 
  > you have code to use them.  Not sure if Brian is planning to publish 
  > his qmailadmin patch...
  > 
  > Regards,
  > 
  > Bill
  > 

I see there's been alot of traffic on this today.  I've
been out (working) most of the day and haven't been able to
keep up.  It should be easy to put together a utility to convert
the limits, not an issue.

As for several of the other comments, I'd like to take tonight to
think about several of the suggestions and post one myself.  I've
been running with the current patched API since vpopmail 4.9.6 and
its been working well.  I also have a patched qmailadmin-1.0.4
with quotas (I forgot who wrote the quota patch), and a patched
version of vdelivermail.  Both of these use a recursive stat()
to determine usage & quota since it was before the Maildir++ quotas
were in there, so I always had *regular* disk usage quotas enforced
which I believe may differ from the Maildir++ quotas.

My intent was to get the API into the library before updating the
programs/utilities to actually use the API.  I've been sitting on
this for about 10 months now (with a working system), and now finally
got it into the distribution.  Now it seems (from all the traffic on
it today) that nobody can wait for it...  I think it would be best to
get the base correct and sound before actually using it in the utilities
and programs.  I have some pros/cons (and I'd like to extend the list
and send it out to everyone) about the current implementation and want
to get some feedback before moving on it.  (Its waited 10 months already,
another day or two won't hurt).  I'll compile and post some questions 
in a bit to see what people really want/need and make sure this gets
done properly.

Thanks,

Brian

RE: [vchkpw] Vpopmail and mysql limits

2002-10-23 Thread John Johnson

Well it would be nice if the patch was out there.. I guess I will hold
off
On my make install till I get more info on what is going to happen with 
Qmailadmin and vqadmin

-John

-Original Message-
From: Bill Shupp [mailto:hostmaster@;shupp.org] 
Sent: Wednesday, October 23, 2002 3:29 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Vpopmail and mysql limits

On Wednesday, October 23, 2002, at 03:28  PM, John Johnson wrote:

>  ok to use mysql-limits is there a convert program to convert the
> limits
> I have
> Or do I have to start over with them and reset them.. I guess I will
> also have
> To recompile vqadmin and qmailadmin for this as well?

Qmailadmin and vqadmin do not support the new vlimits functions yet.  
vqadmin has its own code to modify the limits file only (not sql).  
Brian, the author of this patch, does have his own patches for 
qmailadmin I think.  So you really can't do anything with them until 
you have code to use them.  Not sure if Brian is planning to publish 
his qmailadmin patch...

Regards,

Bill

Re: [vchkpw] Vpopmail and mysql limits

2002-10-23 Thread Bill Shupp

On Wednesday, October 23, 2002, at 03:28  PM, John Johnson wrote:


 ok to use mysql-limits is there a convert program to convert the 
limits
I have
Or do I have to start over with them and reset them.. I guess I will
also have
To recompile vqadmin and qmailadmin for this as well?

Qmailadmin and vqadmin do not support the new vlimits functions yet.  
vqadmin has its own code to modify the limits file only (not sql).  
Brian, the author of this patch, does have his own patches for 
qmailadmin I think.  So you really can't do anything with them until 
you have code to use them.  Not sure if Brian is planning to publish 
his qmailadmin patch...

Regards,

Bill

[vchkpw] Vpopmail and mysql limits

2002-10-23 Thread John Johnson

 ok to use mysql-limits is there a convert program to convert the limits
I have
Or do I have to start over with them and reset them.. I guess I will
also have
To recompile vqadmin and qmailadmin for this as well?

-John

40 matches

Mail list logo