RE: [vchkpw] vpopmail without mysql
I have install vpopmail without mysql. I want to install courier-imap. Can any body please tell me that courier-imap will also be configured without mysql or with mysql In the end I have to install roundcube. Regards, Salman... Date: Sat, 21 May 2011 07:22:49 -0500 From: supp...@internetpro.net To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail without mysql That information is stored in a file named vpasswd which lives in the root folder of the domain. For example, ~/vpopmail/domains/yourdomain/vpasswd It uses a similar format to /etc/passwd. Trey Nolen On 05/20/2011 11:26 PM, Salman Riaz wrote: Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... !DSPAM:4dd8cefc32715750110481!
Re: [vchkpw] vpopmail without mysql
On Sunday 22 May 2011, Salman Riaz wrote: I have install courier imap without mysql but roundcube is not working fine... Do yourself a favour and install dovecot instead of courier-imap. That will work with roundcube, squirrelmail etc. Regards, Salman... From: salmanriaz...@hotmail.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 14:53:11 +0600 Subject: RE: [vchkpw] vpopmail without mysql I have install vpopmail without mysql. I want to install courier-imap. Can any body please tell me that courier-imap will also be configured without mysql or with mysql In the end I have to install roundcube. Regards, Salman... Date: Sat, 21 May 2011 07:22:49 -0500 From: supp...@internetpro.net To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail without mysql That information is stored in a file named vpasswd which lives in the root folder of the domain. For example, ~/vpopmail/domains/yourdomain/vpasswd It uses a similar format to /etc/passwd. Trey Nolen On 05/20/2011 11:26 PM, Salman Riaz wrote: Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... -- - Bob Hutchinson Midwales dot com - !DSPAM:4dd8e74432714486521408!
RE: [vchkpw] vpopmail without mysql
There was php-version issue Now successfully installed roundcube All things are working fine But qmailadmin is not working I am unable to login qmailadmin Regards, Salman... From: hutchli...@midwales.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 11:36:48 +0100 Subject: Re: [vchkpw] vpopmail without mysql On Sunday 22 May 2011, Salman Riaz wrote: I have install courier imap without mysql but roundcube is not working fine... Do yourself a favour and install dovecot instead of courier-imap. That will work with roundcube, squirrelmail etc. Regards, Salman... From: salmanriaz...@hotmail.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 14:53:11 +0600 Subject: RE: [vchkpw] vpopmail without mysql I have install vpopmail without mysql. I want to install courier-imap. Can any body please tell me that courier-imap will also be configured without mysql or with mysql In the end I have to install roundcube. Regards, Salman... Date: Sat, 21 May 2011 07:22:49 -0500 From: supp...@internetpro.net To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail without mysql That information is stored in a file named vpasswd which lives in the root folder of the domain. For example, ~/vpopmail/domains/yourdomain/vpasswd It uses a similar format to /etc/passwd. Trey Nolen On 05/20/2011 11:26 PM, Salman Riaz wrote: Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... -- - Bob Hutchinson Midwales dot com - !DSPAM:4dd8f57a32711358614634!
RE: [vchkpw] vpopmail without mysql
vqadmin is also not running fine when we create a new domain then it give the following error: Unable to chdir to vpopmail/domains/domain directory Regards, Salman... From: salmanriaz...@hotmail.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 17:37:28 +0600 Subject: RE: [vchkpw] vpopmail without mysql There was php-version issue Now successfully installed roundcube All things are working fine But qmailadmin is not working I am unable to login qmailadmin Regards, Salman... From: hutchli...@midwales.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 11:36:48 +0100 Subject: Re: [vchkpw] vpopmail without mysql On Sunday 22 May 2011, Salman Riaz wrote: I have install courier imap without mysql but roundcube is not working fine... Do yourself a favour and install dovecot instead of courier-imap. That will work with roundcube, squirrelmail etc. Regards, Salman... From: salmanriaz...@hotmail.com To: vchkpw@inter7.com Date: Sun, 22 May 2011 14:53:11 +0600 Subject: RE: [vchkpw] vpopmail without mysql I have install vpopmail without mysql. I want to install courier-imap. Can any body please tell me that courier-imap will also be configured without mysql or with mysql In the end I have to install roundcube. Regards, Salman... Date: Sat, 21 May 2011 07:22:49 -0500 From: supp...@internetpro.net To: vchkpw@inter7.com Subject: Re: [vchkpw] vpopmail without mysql That information is stored in a file named vpasswd which lives in the root folder of the domain. For example, ~/vpopmail/domains/yourdomain/vpasswd It uses a similar format to /etc/passwd. Trey Nolen On 05/20/2011 11:26 PM, Salman Riaz wrote: Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... -- - Bob Hutchinson Midwales dot com - !DSPAM:4dd918be32718211420591!
Re: [vchkpw] vpopmail without mysql
That information is stored in a file named vpasswd which lives in the root folder of the domain. For example, ~/vpopmail/domains/yourdomain/vpasswd It uses a similar format to /etc/passwd. Trey Nolen On 05/20/2011 11:26 PM, Salman Riaz wrote: Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... !DSPAM:4dd7aeb132715493464143!
[vchkpw] vpopmail without mysql
Dear Team, I am installing Qmail without mysql. I want to know where user information will be stored as well as passwords.. Regards, Salman... !DSPAM:4dd73ede32712903919615!
[vchkpw] vpopmail with mysql
Dear All,* * i want to add few fields like pw_popenable , pw_imapenable use of these fields will be like for some user i want to disable pop3 and for few user disable imap please suggest me how to start, i will have to modify vusersinfo adduser cheking password qmailadmin field etc Regards Anil !DSPAM:4cb6de9932711336593494!
[vchkpw] vpopmail 5.4.25 + mysql + dovecot
Hi all, I'm stucked with this setup. I'm unable to authenticate through imap/imaps on my mysql backend. I'm using dovecot 1.1.2. Can anyone post a dovecot.conf /dovecot-mysql.conf that works with this type of setup. Thanks, Sérgio Rosa !DSPAM:48b8826f32316647012158!
[vchkpw] vpopmail and mysql
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
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 http://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
Re: [vchkpw] vpopmail and mysql
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. 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
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
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.
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
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';
Re: [vchkpw] vpopmail and mysql
the CSV only contain username,gecos, and clear text password. i need to build the pw_passwdhttp://localhost/phpmyadmin/sql.php?db=vpopmailtable=aduanett_hnserver=2token=c46d27c471e70da8bd9cd1cca0758e35sql_query=SELECT+%2AFROM+%60aduanett_hn%60++ORDER+BY+%60aduanett_hn%60.%60pw_passwd%60+ASC 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
Carlos Collart wrote:
the CSV only contain username,gecos, and clear text password.
i need to build the pw_passwd
http://localhost/phpmyadmin/sql.php?db=vpopmailtable=aduanett_hnserver=2token=c46d27c471e70da8bd9cd1cca0758e35sql_query=SELECT+%2AFROM+%60aduanett_hn%60++ORDER+BY+%60aduanett_hn%60.%60pw_passwd%60+ASC
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]
mailto:[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
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] mailto:[EMAIL PROTECTED]
http://www.danasoft.com/sig/CarlosCollart.jpg
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
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 http://localhost/phpmyadmin/sql.php?db=vpopmailtable=aduanett_hnserver=2token=c46d27c471e70da8bd9cd1cca0758e35sql_query=SELECT+%2AFROM+%60aduanett_hn%60++ORDER+BY+%60aduanett_hn%60.%60pw_passwd%60+ASC 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] mailto:[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 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] mailto:[EMAIL PROTECTED] http://www.danasoft.com/sig/CarlosCollart.jpg http://www.danasoft.com/sig/CarlosCollart.jpg
Re: [vchkpw] vpopmail and mysql
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_passwdhttp://localhost/phpmyadmin/sql.php?db=vpopmailtable=aduanett_hnserver=2token=c46d27c471e70da8bd9cd1cca0758e35sql_query=SELECT+%2AFROM+%60aduanett_hn%60++ORDER+BY+%60aduanett_hn%60.%60pw_passwd%60+ASC 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 problem
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]
[vchkpw] vpopmail and mysql problem
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
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
Re: [vchkpw] vpopmail and mysql problem
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
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
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
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
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
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
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]
[vchkpw] vpopmail and MySQL connection problem
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 + gentoo + mysql
Am Montag, 25. April 2005 03:55 schrieb Trever Noggle: I am not able to get courier-authlib to compile with vpopmail. i did emerge courier-imap and emerge courier-authlib and it always dies at the same place. does anyone have any idea what is causing this. below is the place where it is failing. Linking libauthvchkpw.la Linking authdaemontest /usr/lib/gcc/x86_64-pc-linux-gnu/3.4.3/../../../../x86_64-pc-linux-gnu/bin/ ld: /var/vpopmail/lib/libvpopmail.a(vpopmail.o): relocation R_X86_64_32S against `a local symbol' can not be used when making a shared object; recompile with -fPIC /var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad value collect2: ld returned 1 exit status make[2]: *** [libauthvchkpw.la] Error 1 make[2]: *** Waiting for unfinished jobs make[2]: Leaving directory `/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55' make: *** [all] Error 2 !!! ERROR: net-libs/courier-authlib-0.55 failed. !!! Function src_compile, Line 100, Exitcode 2 !!! Compile problem !!! If you need support, post the topmost build error, NOT this status message. There was somewhere a thread containing courier-authlib and AMD64 with -fPIC around in the last days. It was called compile vpopmail with -fPIC on x86_64. I am not sure if these guys found a solution because on my AMD64 it works without any problems (I am using an older version) and because of this I didn't follow this thread... There is one thing which makes me thinking that the mentioned thread _could_ be the wrong one for you... This is based on one of the error-messages you posted: /var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad value Did you already install vpopmail? IMHO courier needs some vpopmail-libraries. Because of the fact, that I installed the whole thing last time about 1 year ago, I currently don't really remember the order of installations. But maybe it's a point to have a look for... Btw: IMHO the ebuilds for qmail, vpopmail and courier provided by Gentoo aren't very good. After having some troubles while using them, I installed these thing completely by hand. irony Maybe you want to ask Jeremy Kitchen from Inter7 for his opinion about the mentioned ebuilds. /irony NB: Jeremy IS using Gentoo and very deep into qmail, vpopmail and these things... Just my $ 0.05 Greetings from Switzerland Tobias
Re: [vchkpw] vpopmail + gentoo + mysql
Matt Brookings wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tobias Orlamuende wrote:
| Am Montag, 25. April 2005 03:55 schrieb Trever Noggle:
|
|I am not able to get courier-authlib to compile with vpopmail. i did
|emerge courier-imap and emerge courier-authlib and it always dies at
the
|same place. does anyone have any idea what is causing this.
|
|below is the place where it is failing.
|
|Linking libauthvchkpw.la
|Linking authdaemontest
|/usr/lib/gcc/x86_64-pc-linux-gnu/3.4.3/../../../../x86_64-pc-linux-gnu/bin/
|ld: /var/vpopmail/lib/libvpopmail.a(vpopmail.o): relocation
R_X86_64_32S
|against `a local symbol' can not be used when making a shared object;
|recompile with -fPIC
|/var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad value
|collect2: ld returned 1 exit status
|make[2]: *** [libauthvchkpw.la] Error 1
|make[2]: *** Waiting for unfinished jobs
|make[2]: Leaving directory
|`/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55'
|make[1]: *** [all-recursive] Error 1
|make[1]: Leaving directory
|`/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55'
|make: *** [all] Error 2
|
|!!! ERROR: net-libs/courier-authlib-0.55 failed.
|!!! Function src_compile, Line 100, Exitcode 2
|!!! Compile problem
|!!! If you need support, post the topmost build error, NOT this status
|message.
|
|
| There was somewhere a thread containing courier-authlib and AMD64 with
- -fPIC
| around in the last days. It was called compile vpopmail with
-fPIC on
| x86_64. I am not sure if these guys found a solution because on my
AMD64 it
| works without any problems (I am using an older version) and because
of this
| I didn't follow this thread...
| There is one thing which makes me thinking that the mentioned thread
_could_
| be the wrong one for you... This is based on one of the error-messages
you
| posted: /var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad
value
| Did you already install vpopmail? IMHO courier needs some
vpopmail-libraries.
| Because of the fact, that I installed the whole thing last time about
1 year
| ago, I currently don't really remember the order of installations. But
maybe
| it's a point to have a look for...
| Btw: IMHO the ebuilds for qmail, vpopmail and courier provided by
Gentoo
| aren't very good. After having some troubles while using them, I
installed
| these thing completely by hand.
| irony
| Maybe you want to ask Jeremy Kitchen from Inter7 for his opinion about
the
| mentioned ebuilds.
| /irony
| NB: Jeremy IS using Gentoo and very deep into qmail, vpopmail and these
| things...
|
Yes. Jeremy got me using Gentoo as well. What you learn very quickly
is that ebuilds aren't so great for certian things. You should avoid
the qmail, vpopmail, etc ebuilds like the plague. As far as the courier
option, you probably should edit the Makefile, and add -fPIC to the
compiler options.
Good luck!
- --
/*
~Matt Brookings [EMAIL PROTECTED] GnuPG Key 7D7E5F37
~Software developer Systems technician
~Inter7 Internet Technologies, Inc. (815)776-9465
*/
banner(Support open-source!\n);
void banner(char *arg) {
~ char b[50];
~ strcpy(b, arg);
~ printf(b);
}
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
iD8DBQFCbPB//pZz8n1+XzcRAgKbAJ9AsUKdQDZpJeq/HzXVUPtoTyl+BwCfR6Mi
2xlBrHVqCtvHUIZ8DEUcz1g=
=qAkI
-END PGP SIGNATURE-
If you do this without the ebuilds how do you avoid other items being
installed such at ssmtp it appears that this is installed by default.
you have to unmerge it in order to emerge qmail. how do you keep it
from adding itself back inthere and potentially causing problems with
doing an emerge --update --deep --newuse world ?
I appologize for the questions but I am new to gentoo and still trying
to learn.
Thanks for the help,
Trever
Re: [vchkpw] vpopmail + gentoo + mysql
On Monday 25 April 2005 11:04 am, Trever Noggle wrote:
Matt Brookings wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tobias Orlamuende wrote:
| Am Montag, 25. April 2005 03:55 schrieb Trever Noggle:
|I am not able to get courier-authlib to compile with vpopmail. i did
|emerge courier-imap and emerge courier-authlib and it always dies at
the
|same place. does anyone have any idea what is causing this.
|
|below is the place where it is failing.
|
|Linking libauthvchkpw.la
|Linking authdaemontest
|/usr/lib/gcc/x86_64-pc-linux-gnu/3.4.3/../../../../x86_64-pc-linux-gnu/
|bin/
|
|ld: /var/vpopmail/lib/libvpopmail.a(vpopmail.o): relocation
R_X86_64_32S
|against `a local symbol' can not be used when making a shared object;
|recompile with -fPIC
|/var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad value
|collect2: ld returned 1 exit status
|make[2]: *** [libauthvchkpw.la] Error 1
|make[2]: *** Waiting for unfinished jobs
|make[2]: Leaving directory
|`/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55'
|make[1]: *** [all-recursive] Error 1
|make[1]: Leaving directory
|`/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55'
|make: *** [all] Error 2
|
|!!! ERROR: net-libs/courier-authlib-0.55 failed.
|!!! Function src_compile, Line 100, Exitcode 2
|!!! Compile problem
|!!! If you need support, post the topmost build error, NOT this status
|message.
|
| There was somewhere a thread containing courier-authlib and AMD64 with
- -fPIC
| around in the last days. It was called compile vpopmail with
-fPIC on
| x86_64. I am not sure if these guys found a solution because on my
AMD64 it
| works without any problems (I am using an older version) and because
of this
| I didn't follow this thread...
| There is one thing which makes me thinking that the mentioned thread
_could_
| be the wrong one for you... This is based on one of the error-messages
you
| posted: /var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad
value
| Did you already install vpopmail? IMHO courier needs some
vpopmail-libraries.
| Because of the fact, that I installed the whole thing last time about
1 year
| ago, I currently don't really remember the order of installations. But
maybe
| it's a point to have a look for...
| Btw: IMHO the ebuilds for qmail, vpopmail and courier provided by
Gentoo
| aren't very good. After having some troubles while using them, I
installed
| these thing completely by hand.
| irony
| Maybe you want to ask Jeremy Kitchen from Inter7 for his opinion about
the
| mentioned ebuilds.
| /irony
| NB: Jeremy IS using Gentoo and very deep into qmail, vpopmail and these
| things...
Yes. Jeremy got me using Gentoo as well. What you learn very quickly
is that ebuilds aren't so great for certian things. You should avoid
the qmail, vpopmail, etc ebuilds like the plague. As far as the courier
option, you probably should edit the Makefile, and add -fPIC to the
compiler options.
Good luck!
- --
/*
~Matt Brookings [EMAIL PROTECTED] GnuPG Key 7D7E5F37
~Software developer Systems technician
~Inter7 Internet Technologies, Inc. (815)776-9465
*/
banner(Support open-source!\n);
void banner(char *arg) {
~ char b[50];
~ strcpy(b, arg);
~ printf(b);
}
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.2.6 (GNU/Linux)
iD8DBQFCbPB//pZz8n1+XzcRAgKbAJ9AsUKdQDZpJeq/HzXVUPtoTyl+BwCfR6Mi
2xlBrHVqCtvHUIZ8DEUcz1g=
=qAkI
-END PGP SIGNATURE-
If you do this without the ebuilds how do you avoid other items being
installed such at ssmtp it appears that this is installed by default.
you have to unmerge it in order to emerge qmail. how do you keep it
from adding itself back inthere and potentially causing problems with
doing an emerge --update --deep --newuse world ?
gentoo has a mechanism for 'faking' the installation of a package.
unmerge ssmtp and mark either qmail or ssmtp as installed
in /etc/portage/profile/package.provided
-Jeremy
--
Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc.
[EMAIL PROTECTED] ++ inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l
kitchen @ #qmail #gentoo on EFnet IRC ++ scriptkitchen.com/qmail
GnuPG Key ID: 481BF7E2 ++ jabber:[EMAIL PROTECTED]
pgp4xHI5xZaxI.pgp
Description: PGP signature
[vchkpw] vpopmail + gentoo + mysql
I am not able to get courier-authlib to compile with vpopmail. i did emerge courier-imap and emerge courier-authlib and it always dies at the same place. does anyone have any idea what is causing this. below is the place where it is failing. Linking libauthvchkpw.la Linking authdaemontest /usr/lib/gcc/x86_64-pc-linux-gnu/3.4.3/../../../../x86_64-pc-linux-gnu/bin/ld: /var/vpopmail/lib/libvpopmail.a(vpopmail.o): relocation R_X86_64_32S against `a local symbol' can not be used when making a shared object; recompile with -fPIC /var/vpopmail/lib/libvpopmail.a: could not read symbols: Bad value collect2: ld returned 1 exit status make[2]: *** [libauthvchkpw.la] Error 1 make[2]: *** Waiting for unfinished jobs make[2]: Leaving directory `/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/var/tmp/portage/courier-authlib-0.55/work/courier-authlib-0.55' make: *** [all] Error 2 !!! ERROR: net-libs/courier-authlib-0.55 failed. !!! Function src_compile, Line 100, Exitcode 2 !!! Compile problem !!! If you need support, post the topmost build error, NOT this status message.
RE: [vchkpw] Vpopmail and MySQL
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-
[vchkpw] Vpopmail and MySQL
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
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
Re: [vchkpw] Vpopmail and MySQL
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 w/ MySQL still checking vpasswd.cdb w/ qmail-smtpd
On Oct 28, 2004, at 10:43 PM, Chris Marks wrote: We've migrated to a MySQL backend which works great for pop and IMAP, but incoming mail to the qmail-smtpd stills has to check the vpasswd.cdb if there is no .qmail-user file. We compiled and installed vpopmail, then qmail ( with ./config-fast etc) I assumed the vpopmail libs would get picked up and reflect the authmysql usage. Am I missing something obvious here? Feel free to drop a boot to my melon if so. We've had to use old vmkpasswd's and mod the vpasswd for virtual domains then mkpasswd with the old binary to get it to work. Vpopmail-5.4.7, qmail-1.03 TIA Your qmail-smtpd isn't getting rebuilt properly. After installing the new vpopmail, go into your qmail source directory and try deleting the previous qmail-smtpd and qmail-smtpd.o before rebuilding. You may also want to review the installation instructions for the chkusr patch -- I think you have to modify the Makefile if you're using MySQL. -- 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 w/ MySQL still checking vpasswd.cdb w/ qmail-smtpd
On Fri, 29 Oct 2004, Tom Collins wrote: You may also want to review the installation instructions for the chkusr patch -- I think you have to modify the Makefile if you're using MySQL. Also check all the conf-* files in there, I seem to recall needing to edit a few of those. Charles -- 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 w/ MySQL still checking vpasswd.cdb w/ qmail-smtpd
We've migrated to a MySQL backend which works great for pop and IMAP, but incoming mail to the qmail-smtpd stills has to check the vpasswd.cdb if there is no .qmail-user file. We compiled and installed vpopmail, then qmail ( with ./config-fast etc) I assumed the vpopmail libs would get picked up and reflect the authmysql usage. Am I missing something obvious here? Feel free to drop a boot to my melon if so. We've had to use old vmkpasswd's and mod the vpasswd for virtual domains then mkpasswd with the old binary to get it to work. Vpopmail-5.4.7, qmail-1.03 TIA --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.782 / Virus Database: 528 - Release Date: 10/22/2004
[vchkpw] vpopmail and mysql
-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
-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)
Re: [vchkpw] vpopmail and mysql
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
-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 with mysql authentication of installer specified database
I remember reading from the proftpd forum that a vpopmail+proftpd enthusiast was using his own defined mysql table to authenticate both vpopmail and proftpd users. Is it possible to do this without changing the source code? (I am not overly happy about changing source since the vpopmail installation will be updated with time). In proftpd.conf: (example on proftpd 1.2.9) SQLAuthenticate users SQLAuthTypesPlaintext SQLConnectInfo [EMAIL PROTECTED] dbuser dbpasswd SQLUserInfo domain_tld pw_name pw_clear_passwd NULL NULL pw_home NULL or SQLAuthenticate users SQLAuthTypesCrypt SQLConnectInfo [EMAIL PROTECTED] dbuser dbpasswd SQLUserInfo domain_tld pw_name pw_passwd NULL NULL pw_home NULL Solt
Re: [vchkpw] vpopmail with mysql authentication of installer specified database
If an FTP server gives a user open access to their directory, couldn't you have a potential security problem? Since the .qmail file is processed by the vpopmail user, any program I add to my .qmail will run as vpopmail. As a user with ftp access to my .qmail file, I could create a .qmail file that emailed a copy of ~vpopmail/etc/vpopmail.mysql to myself. I'm sure we can think of even worse scenarios, but won't share them on the list (we don't need script kiddies picking up the idea and running with it). This is the main reason we've had to be careful with qmailadmin to make sure users can't create new program delivery lines when adding forwards. Unfortunately, we end up removing program delivery lines that weren't qmailadmin generated (like tmda (tdma?) stuff). -- 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 with mysql authentication of installer specified database
Hi to vpopmail users, I remember reading from the proftpd forum that a vpopmail+proftpd enthusiast was using his own defined mysql table to authenticate both vpopmail and proftpd users. Is it possible to do this without changing the source code? (I am not overly happy about changing source since the vpopmail installation will be updated with time). Regards, Phillip Lucs
Re: [vchkpw] vpopmail with mysql authentication of installer specified database
On Fri, 2004-03-05 at 01:12, [EMAIL PROTECTED] wrote: Hi to vpopmail users, I remember reading from the proftpd forum that a vpopmail+proftpd enthusiast was using his own defined mysql table to authenticate both vpopmail and proftpd users. Is it possible to do this without changing the source code? (I am not overly happy about changing source since the vpopmail installation will be updated with time). pure-ftpd has support for vpopmail authentication, and it also doesn't have the security record of proftpd. You might give it a shot. -Jeremy -- Jeremy Kitchen Systems Administrator [EMAIL PROTECTED] Kitchen @ #qmail on EFNet - Join the party! . Inter7 Internet Technologies, Inc. www.inter7.com 866.528.3530 toll free 847.492.0470 int'l 847.492.0632 fax GNUPG key ID: 93BDD6CE
[vchkpw] vpopmail and mysql configuration problems
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: error:
Re: [vchkpw] vpopmail and mysql configuration problems
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 with mysql documentation
Is there some documentation on how vpopmail works with mysql? I have it set-up succesfully, but I'm curious as to how exactly I can take advantage of the 'valias' table and also the relay table information etc. ron == Ron Dyck Webbtech www.webbtech.net ==
RE: [vchkpw] vpopmail 5.3.27 + mysql + mac osx mail
On Thursday, October 16, 2003, at 04:14 PM, Russell Mann wrote: On Thursday, October 16, 2003, at 09:55 AM, Russell Mann wrote: When a Mac OS X Mail.app client POP's in for mail, I always get an error log message like this: vchkpw-pop3: password fail (pass: 'd502e3b49fb33d7f7d419d469b51a5a0') EMAIL ADDRESS:IP ADDRESS Have them launch Mail.app, go into Preferences, select Accounts, go to the Advanced tab and check the Authentication popup. I'm able to use MD5 Challenge-Response or Password on my system. See if they have it set to one of the Kerberos options. Or, if it's set to MD5, have them try Password. I checked the Authentication preferences. They were already set to password. I set them to MD5 to see what happens and the MUA wasn't able to POP in. Any other ideas? What version of vpopmail are you using, and which POP3 server? -- Tom Collins - [EMAIL PROTECTED] Vpopmail 5.3.27 ./configure \ --enable-roaming-users=y \ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp \ --enable-tcprules-prog=/usr/local/bin/tcprules \ --enable-relay-clear-minutes=180 \ --enable-auth-logging=y \ --enable-logging=p \ --enable-learn-passwords=y \ --enable-clear-passwd=y \ --enable-mysql=y \ --enable-incdir=/usr/include/mysql \ --enable-libdir=/usr/lib/mysql \ --enable-mysql-logging=y \ --enable-valias=y \ --enable-mysql-limits=n \ --enable-many-domains=n \ --enable-qmail-ext=y \ --enable-defaultquota=5000 [EMAIL PROTECTED] bin]# more /service/qmail-pop3d/run #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 400 \ /usr/local/bin/tcpserver -H -R -v \ -u$VPOPMAILUID -g$VPOPMAILGID \ -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21
Re: [vchkpw] vpopmail-5.3.28 + mysql 4.0.15 problem
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] vpopmail 5.3.28 + mysql + mac osx mail
On Thursday, October 16, 2003, at 09:55 AM, Russell Mann wrote: When a Mac OS X Mail.app client POP's in for mail, I always get an error log message like this: vchkpw-pop3: password fail (pass: 'd502e3b49fb33d7f7d419d469b51a5a0') EMAIL ADDRESS:IP ADDRESS Have them launch Mail.app, go into Preferences, select Accounts, go to the Advanced tab and check the Authentication popup. I'm able to use MD5 Challenge-Response or Password on my system. See if they have it set to one of the Kerberos options. Or, if it's set to MD5, have them try 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] vpopmail-5.3.28 + mysql 4.0.15 problem
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. Thanks Tom You are correct I haved fixed that bug in my setup guides now http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm http://www.pipeline.com.au/staff/mbowe/isp/webmail-server.htm Anyone who has used my guide recently should also check their permissions on that file Michael.
RE: [vchkpw] vpopmail 5.3.28 + mysql + mac osx mail
On Thursday, October 16, 2003, at 09:55 AM, Russell Mann wrote: When a Mac OS X Mail.app client POP's in for mail, I always get an error log message like this: vchkpw-pop3: password fail (pass: 'd502e3b49fb33d7f7d419d469b51a5a0') EMAIL ADDRESS:IP ADDRESS Have them launch Mail.app, go into Preferences, select Accounts, go to the Advanced tab and check the Authentication popup. I'm able to use MD5 Challenge-Response or Password on my system. See if they have it set to one of the Kerberos options. Or, if it's set to MD5, have them try Password. I checked the Authentication preferences. They were already set to password. I set them to MD5 to see what happens and the MUA wasn't able to POP in. Any other ideas? -Russell
Re: [vchkpw] vpopmail 5.3.28 + mysql + mac osx mail
On Thursday, October 16, 2003, at 04:14 PM, Russell Mann wrote: On Thursday, October 16, 2003, at 09:55 AM, Russell Mann wrote: When a Mac OS X Mail.app client POP's in for mail, I always get an error log message like this: vchkpw-pop3: password fail (pass: 'd502e3b49fb33d7f7d419d469b51a5a0') EMAIL ADDRESS:IP ADDRESS Have them launch Mail.app, go into Preferences, select Accounts, go to the Advanced tab and check the Authentication popup. I'm able to use MD5 Challenge-Response or Password on my system. See if they have it set to one of the Kerberos options. Or, if it's set to MD5, have them try Password. I checked the Authentication preferences. They were already set to password. I set them to MD5 to see what happens and the MUA wasn't able to POP in. Any other ideas? What version of vpopmail are you using, and which POP3 server? -- 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] 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 uprunning. I found a post on this error but was related with different versions of server and client. What is missing around here? srosa
Re: [vchkpw] vpopmail-5.3.28 + mysql 4.0.15 problem
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 uprunning. I found a post on this error but was related with different versions of server and client. What is missing around here? srosa
RE: [vchkpw] vpopmail 5.3.27 + mysql
Russ, Try changing these lines in vpopmail.mysql. FROM localhost|0|vpopmail_read|password|vpopmail localhost|0|vpopmail_edit|password|vpopmail TO localhost|mysql|vpopmailuser|vpoppasswd|vpopmail localhost|mysql|vpopmailuser|vpoppasswd|vpopmail -Tom Tom, Thanks, I made those changes - still having the same issue. The fact that the vlog table fills up with errors when I use the mysql vpopmail would seem to indicate that at least one of these usernames would be working correctly. I did test them both with mysql at the command line. Thanks, Russell (sending this to the list because I think it previously went to the default reply-to) To recap... I am trying to upgrade my working 5.3.27 CDB installation to a 5.3.27 MYSQL installation. I have 10 domains currently running on this system through CDB databases. RedHat 2.2.16-3 kernel mysqld -v outputs this: mysqld Ver 3.23.40 for pc-linux-gnu on i686 This is what I've done: create database vpopmail; grant update, create, delete, insert on vpopmail.* to [EMAIL PROTECTED] identified by password; grant select on vpopmail.* to [EMAIL PROTECTED] identified by password; flush privileges; (for each of the 10 domains) ./vconvert-cdb-sql-big.pl (for each of the 10 domains) ALTER TABLE domain_dom ADD COLUMN pw_clear_passwd char(16); in ~vpopmail/etc/vpopmail.mysql localhost|mysql|vpopmail_read|password|vpopmail localhost|mysql|vpopmail_edit|password|vpopmail chmod 600 /home/vpopmail/etc/vpopmail.mysql tar -xzpf vpopmail-5.3.27.tar.gz cd vpopmail-5.3.27 ./configure \ --enable-roaming-users=y \ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp \ --enable-tcprules-prog=/usr/local/bin/tcprules \ --enable-relay-clear-minutes=180 \ --enable-auth-logging=y \ --enable-logging=p \ --enable-learn-passwords=y \ --enable-clear-passwd=y \ --enable-mysql=y \ --enable-incdir=/usr/include/mysql \ --enable-libdir=/usr/lib/mysql \ --enable-mysql-logging=y \ --enable-valias=y \ --enable-mysql-limits=n \ --enable-many-domains=n \ --enable-qmail-ext=y \ --enable-defaultquota=5000 make cp -R ~vpopmail/bin ~vpopmail/old.bin make install-strip Here's my /service/qmail-pop3d/run file: #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v \ -u$VPOPMAILUID -g$VPOPMAILGID \ -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 My qmail install includes the patch qmail-maildir++.patch. -- Everything installs and appears to be ready to go. mysql logging works and this is what I get in all my logs: vchkpw-pop3: vpopmail user not found user@domain:ip address In the error column of vlog, it says: 1 If I do the exact same thing, changing --enable-mysql=y to --enable-mysql=n and (obviously) not running the vconvert, everything is peachy, although not using mysql. Any suggestions? Is there something I'm not seeing? Any particular logs that I should be checking?
RE: [vchkpw] vpopmail 5.3.27 + mysql
Russ, This may be because you are setting the pop3 user in your run script. Look at mine and try removing the vpopmail user. #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver \ -H -l mailhost.net \ -v -x /etc/tcp.pop3.cdb -c 50 -R 0 pop3 \ /var/qmail/bin/qmail-popup mailhost.net \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 21 Also, you don't need to use the /etc/tcp.pop3.cdb file. I just choose to. -- Regards, Tom Here's my /service/qmail-pop3d/run file: #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v \ -u$VPOPMAILUID -g$VPOPMAILGID \ -c100 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 My qmail install includes the patch qmail-maildir++.patch. -- Everything installs and appears to be ready to go. mysql logging works and this is what I get in all my logs: vchkpw-pop3: vpopmail user not found user@domain:ip address In the error column of vlog, it says: 1 If I do the exact same thing, changing --enable-mysql=y to --enable-mysql=n and (obviously) not running the vconvert, everything is peachy, although not using mysql. Any suggestions? Is there something I'm not seeing? Any particular logs that I should be checking?
RE: [vchkpw] vpopmail 5.3.27 + mysql
I know this may sound redundant or silly but check your permissions on qmail-pop3d and the vckpwd binary. Maybe your permissions on those files are the problem. Cuz by the looks of what you sent in email so far you have done it right. It's gotta be something stupid. Yes, tcp.pop3 file is for pop3 auth. Just a little extra precaution. I believe the qmail-pop3d runs under root. What version of MySQL are you using? -- Regards, Tom [EMAIL PROTECTED] mysqld -v mysqld Ver 3.23.40 for pc-linux-gnu on i686 /var/qmail/bin/qmail-pop3d -rwxr-xr-x 1 root qmail 26k Sep 25 15:54 qmail-pop3d /home/vpopmail/bin/vchkpw -rwxr-xr-x 1 root root 51k Sep 30 11:04 vchkpw* -- I've tried several options in the pop3d run file, as per official instructions, instructions on this email list etc. #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v \ -u$VPOPMAILUID -g$VPOPMAILGID \ -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver \ -H -l judah.khouse.org -v \ -c 100 -R 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 - None of them seem to change it. What is the tcp.pop3.cdb file for? Is it an IP permissions file for popping email? Also, what user/group should qmail-pop3d run under in order to validate users correctly? Thanks, Russell
RE: [vchkpw] vpopmail 5.3.27 + mysql
On Thursday, September 25, 2003, at 04:38 PM, Russell Mann wrote: Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 21 Try this instead (includes vpopmail user and group): #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 -- Tom Collins Thanks Tom, I made that change but am still having the same issue. Any other ideas? I just noticed that the difference between the MYSQL and non-MYSQL bin dirs is fairly huge: new.bin: (WITH MYSQL) total 4.1M -rwxr-xr-x 1 root root 181k Sep 25 16:11 clearopensmtp* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vaddaliasdomain* -rwxr-xr-x 1 root root 184k Sep 25 16:11 vadddomain* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vadduser* -rwxr-xr-x 1 root root 183k Sep 25 16:11 valias* -rwxr-xr-x 1 root root 189k Sep 25 16:11 vchkpw* -rwxr-xr-x 1 root root 185k Sep 25 16:12 vconvert* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeldomain* -rwxr-xr-x 1 root root 198k Sep 25 16:11 vdelivermail* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vdeloldusers* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeluser* -rwxr-xr-x 1 root root 183k Sep 25 16:12 vdominfo* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vipmap* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vkill* -rwxr-xr-x 1 root root 181k Sep 25 16:12 vmkpasswd* -rwxr-xr-x 1 root root 190k Sep 25 16:12 vmoddomlimits* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vmoduser* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vpasswd* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vpopbull* -rwxr-xr-x 1 root root 188k Sep 25 16:12 vqmaillocal* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vsetuserquota* -rwxr-xr-x 1 root root 192k Sep 25 16:11 vuserinfo* old.bin: (WITHOUT MYSQL) total 1.1M -rwxr-xr-x 1 root root 43k Sep 25 16:15 clearopensmtp* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vaddaliasdomain* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vadddomain* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vadduser* -rwxr-xr-x 1 root root 47k Sep 25 16:15 valias* -rwxr-xr-x 1 root root 51k Sep 25 16:15 vchkpw* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vconvert* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vdeldomain* -rwxr-xr-x 1 root root 59k Sep 25 16:15 vdelivermail* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdeloldusers* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vdeluser* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdominfo* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vipmap* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vkill* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vmkpasswd* -rwxr-xr-x 1 root root 52k Sep 25 16:15 vmoddomlimits* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vmoduser* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vpasswd* -rwxr-xr-x 1 root root 47k Sep 25 16:15 vpopbull* -rwxr-xr-x 1 root root 49k Sep 25 16:15 vqmaillocal* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vsetuserquota* -rwxr-xr-x 1 root root 54k Sep 25 16:15 vuserinfo* Does everyone see the same type of file size increase by including MYSQL? -Russell P.S. - List Owner - your list software is set to reply to the original sender rather than the list address - in case you weren't aware of it.
Re: [vchkpw] vpopmail 5.3.27 + mysql
Russell Mann wrote: snip P.S. - List Owner - your list software is set to reply to the original sender rather than the list address - in case you weren't aware of it. I think they did this on purpose, so that there is less mail for the list to handle, but then again its annoying because you got to edit what email adress to send it to :). As with your MySQL it being bigger, i have seen this as well. Might be because it has to include all the MySQL connection and database queries, thus making it bigger, as functions like get_pass() (NOTE: JUST AN EXAMPLE, NOT TAKEN FROM SOURCE CODE) have not to be rewritten so they work with MySQL.
RE: [vchkpw] vpopmail 5.3.27 + mysql
Mine looks the same, almost.. total 4.1M drwxr-xr-x2 vpopmail vchkpw 4.0K Sep 17 07:00 . drwxr-xr-x8 vpopmail vchkpw 4.0K Sep 24 14:07 .. -rwxr-xr-x1 root root 177K Sep 17 07:00 clearopensmtp -rwxr-xr-x1 root root 177K Sep 17 07:00 vaddaliasdomain -rwxr-xr-x1 root root 179K Sep 17 07:00 vadddomain -rwxr-xr-x1 root root 178K Sep 17 07:00 vadduser -rwxr-xr-x1 root root 178K Sep 17 07:00 valias -rwxr-xr-x1 root root 185K Sep 17 07:00 vchkpw -rwxr-xr-x1 root root 181K Sep 17 07:00 vconvert -rwxr-xr-x1 root root 177K Sep 17 07:00 vdeldomain -rwxr-xr-x1 root root 192K Sep 17 07:00 vdelivermail -rwxr-xr-x1 root root 178K Sep 17 07:00 vdeloldusers -rwxr-xr-x1 root root 177K Sep 17 07:00 vdeluser -rwxr-xr-x1 root root 178K Sep 17 07:00 vdominfo -rwxr-xr-x1 root root 177K Sep 17 07:00 vipmap -rwxr-xr-x1 root root 176K Sep 17 07:00 vkill -rwxr-xr-x1 root root 176K Sep 17 07:00 vmkpasswd -rwxr-xr-x1 root root 185K Sep 17 07:00 vmoddomlimits -rwxr-xr-x1 root root 180K Sep 17 07:00 vmoduser -rwxr-xr-x1 root root 177K Sep 17 07:00 vpasswd -rwxr-xr-x1 root root 181K Sep 17 07:00 vpopbull -rwxr-xr-x1 root root 182K Sep 17 07:00 vqmaillocal -rwxr-xr-x1 root root 177K Sep 17 07:00 vsetuserquota -rwxr-xr-x1 root root 188K Sep 17 07:00 vuserinfo -Tom Thanks Tom, I made that change but am still having the same issue. Any other ideas? I just noticed that the difference between the MYSQL and non-MYSQL bin dirs is fairly huge: new.bin: (WITH MYSQL) total 4.1M -rwxr-xr-x 1 root root 181k Sep 25 16:11 clearopensmtp* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vaddaliasdomain* -rwxr-xr-x 1 root root 184k Sep 25 16:11 vadddomain* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vadduser* -rwxr-xr-x 1 root root 183k Sep 25 16:11 valias* -rwxr-xr-x 1 root root 189k Sep 25 16:11 vchkpw* -rwxr-xr-x 1 root root 185k Sep 25 16:12 vconvert* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeldomain* -rwxr-xr-x 1 root root 198k Sep 25 16:11 vdelivermail* -rwxr-xr-x 1 root root 183k Sep 25 16:11 vdeloldusers* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vdeluser* -rwxr-xr-x 1 root root 183k Sep 25 16:12 vdominfo* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vipmap* -rwxr-xr-x 1 root root 182k Sep 25 16:12 vkill* -rwxr-xr-x 1 root root 181k Sep 25 16:12 vmkpasswd* -rwxr-xr-x 1 root root 190k Sep 25 16:12 vmoddomlimits* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vmoduser* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vpasswd* -rwxr-xr-x 1 root root 185k Sep 25 16:11 vpopbull* -rwxr-xr-x 1 root root 188k Sep 25 16:12 vqmaillocal* -rwxr-xr-x 1 root root 182k Sep 25 16:11 vsetuserquota* -rwxr-xr-x 1 root root 192k Sep 25 16:11 vuserinfo* old.bin: (WITHOUT MYSQL) total 1.1M -rwxr-xr-x 1 root root 43k Sep 25 16:15 clearopensmtp* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vaddaliasdomain* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vadddomain* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vadduser* -rwxr-xr-x 1 root root 47k Sep 25 16:15 valias* -rwxr-xr-x 1 root root 51k Sep 25 16:15 vchkpw* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vconvert* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vdeldomain* -rwxr-xr-x 1 root root 59k Sep 25 16:15 vdelivermail* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdeloldusers* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vdeluser* -rwxr-xr-x 1 root root 45k Sep 25 16:15 vdominfo* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vipmap* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vkill* -rwxr-xr-x 1 root root 43k Sep 25 16:15 vmkpasswd* -rwxr-xr-x 1 root root 52k Sep 25 16:15 vmoddomlimits* -rwxr-xr-x 1 root root 46k Sep 25 16:15 vmoduser* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vpasswd* -rwxr-xr-x 1 root root 47k Sep 25 16:15 vpopbull* -rwxr-xr-x 1 root root 49k Sep 25 16:15 vqmaillocal* -rwxr-xr-x 1 root root 44k Sep 25 16:15 vsetuserquota* -rwxr-xr-x 1 root root 54k Sep 25 16:15 vuserinfo* Does everyone see the same type of file size increase by including MYSQL? -Russell P.S. - List Owner - your list software is set to reply to the
[vchkpw] vpopmail 5.3.27 + mysql
Hello, I am new to this list but not new to qmail/vpopmail, etc. I am trying to upgrade my working 5.3.27 CDB installation to a 5.3.27 MYSQL installation. I have 10 domains currently running on this system through CDB databases. RedHat 2.2.16-3 kernel mysqld -v outputs this: mysqld Ver 3.23.40 for pc-linux-gnu on i686 This is what I've done: create database vpopmail; grant update, create, delete, insert on vpopmail.* to [EMAIL PROTECTED] identified by password; grant select on vpopmail.* to [EMAIL PROTECTED] identified by password; flush privileges; (for each of the 10 domains) ./vconvert-cdb-sql-big.pl (for each of the 10 domains) ALTER TABLE domain_dom ADD COLUMN pw_clear_passwd char(16); in ~vpopmail/etc/vpopmail.mysql localhost|0|vpopmail_read|password|vpopmail localhost|0|vpopmail_edit|password|vpopmail chmod 600 /home/vpopmail/etc/vpopmail.mysql tar -xzpf vpopmail-5.3.27.tar.gz cd vpopmail-5.3.27 ./configure \ --enable-roaming-users=y \ --enable-tcpserver-file=/home/vpopmail/etc/tcp.smtp \ --enable-tcprules-prog=/usr/local/bin/tcprules \ --enable-relay-clear-minutes=180 \ --enable-auth-logging=y \ --enable-logging=p \ --enable-learn-passwords=y \ --enable-clear-passwd=y \ --enable-mysql=y \ --enable-incdir=/usr/include/mysql \ --enable-libdir=/usr/lib/mysql \ --enable-mysql-logging=y \ --enable-valias=y \ --enable-mysql-limits=n \ --enable-many-domains=n \ --enable-qmail-ext=y \ --enable-defaultquota=5000 make cp -R ~vpopmail/bin ~vpopmail/old.bin make install-strip cd ~vpopmail/bin ./vconvert -c -m Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 21 My qmail install includes the patch qmail-maildir++.patch. -- Everything installs and appears to be ready to go. mysql logging works and this is what I get in all my logs: vchkpw-pop3: vpopmail user not found user@domain:ip address If I do the exact same thing, changing --enable-mysql=y to --enable-mysql=n and (obviously) not running the vconvert, everything is peachy, although not using mysql. Any suggestions? Is there something I'm not seeing? Any particular logs that I should be checking? Thanks, Russell
Re: [vchkpw] vpopmail 5.3.27 + mysql
On Thursday, September 25, 2003, at 04:38 PM, Russell Mann wrote: Here's my /service/qmail-pop3d/run file: #!/bin/sh exec /usr/local/bin/softlimit -m 300 \ /usr/local/bin/tcpserver -H -R -v -c100 0 pop3 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw /var/qmail/bin/qmail-pop3d Maildir 21 Try this instead (includes vpopmail user and group): #!/bin/sh VPOPMAILUID=`id -u vpopmail` VPOPMAILGID=`id -g vpopmail` exec /usr/local/bin/tcpserver -l 0 -R -H -v \ -u$VPOPMAILUID -g$VPOPMAILGID 0 110 \ /var/qmail/bin/qmail-popup judah.khouse.org \ /home/vpopmail/bin/vchkpw \ /var/qmail/bin/qmail-pop3d Maildir 21 -- 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 replication
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
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 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. Hope that helps, Nick Harring System Administrator Webley Systems, Inc.
Re: [vchkpw] vpopmail and mysql replication
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
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
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 (with MySQL courier imap hack)
yea, please send it to me i hope i become not an open relay - Original Message - From: Evren Yurtesen [EMAIL PROTECTED] To: eLgino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 7:13 PM Subject: Re: [vchkpw] vpopmail (with MySQL courier imap hack) would you prefer to use smtp auth? which is actually better than using these hacks? (at least from my point of view) then there is some instructions hmm I use on FreeBSD too with mysql, I made my installation in a log format. I can just give it to you On Wed, 13 Aug 2003, eLgino wrote: Hi there, I'm running qmail with vpopmail, courier imap/bla. It works nice under FreeBSD 4.8 But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a courier-imap hack see here: THE HACK http://www.pofo.de/HOWTO/qmail/files/open_relay.c env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps $VPOPMAILDIR/lib_deps` -lcrypt' install -o root -g wheel -m 755 open_relay /usr/local/bin/ its a smtp after imap/pop3 hack but now i will deinstall vpopmail and install with MySQL support, but that its not the problem 1. How can i delete the hack? 2. How can i setup the hack to work with vpopmail AND MySQL? thanks in advance! eLgino PS: sorry for my poor english
Re: [vchkpw] vpopmail (with MySQL courier imap hack)
would you prefer to use smtp auth? which is actually better than using these hacks? (at least from my point of view) then there is some instructions hmm I use on FreeBSD too with mysql, I made my installation in a log format. I can just give it to you On Wed, 13 Aug 2003, eLgino wrote: Hi there, I'm running qmail with vpopmail, courier imap/bla. It works nice under FreeBSD 4.8 But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a courier-imap hack see here: THE HACK http://www.pofo.de/HOWTO/qmail/files/open_relay.c env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps $VPOPMAILDIR/lib_deps` -lcrypt' install -o root -g wheel -m 755 open_relay /usr/local/bin/ its a smtp after imap/pop3 hack but now i will deinstall vpopmail and install with MySQL support, but that its not the problem 1. How can i delete the hack? 2. How can i setup the hack to work with vpopmail AND MySQL? thanks in advance! eLgino PS: sorry for my poor english
[vchkpw] vpopmail (with MySQL courier imap hack)
Hi there, I'm running qmail with vpopmail, courier imap/bla. It works nice under FreeBSD 4.8 But i have one problem i have compiled vpopmail WITHOUT mysql, and WITH a courier-imap hack see here: THE HACK http://www.pofo.de/HOWTO/qmail/files/open_relay.c env VPOPMAILDIR=`pw usershow vpopmail | cut -f9 -d':'`/etc \ /bin/sh -c 'gcc -o open_relay open_relay.c `cat $VPOPMAILDIR/inc_deps $VPOPMAILDIR/lib_deps` -lcrypt' install -o root -g wheel -m 755 open_relay /usr/local/bin/ its a smtp after imap/pop3 hack but now i will deinstall vpopmail and install with MySQL support, but that its not the problem 1. How can i delete the hack? 2. How can i setup the hack to work with vpopmail AND MySQL? thanks in advance! eLgino PS: sorry for my poor english
[vchkpw] vpopmail with mysql problem
hi i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away 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 vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Error: Unable to chdir to vpopmail/users directory Is there anything wrong. Tx ZaFAr
Re: [vchkpw] vpopmail with mysql problem
hmmm you have not compiled vpopmail with user that can connect to mysql databases. I will suggest better to study FAQs and then create username and password in databases compile vpopmail with username that can create modify delete vpopmail database -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) - Original Message - From: zafar rizvi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 12:20 PM Subject: [vchkpw] vpopmail with mysql problem | hi | i am installing vpopmail-5.2.1 with mysql centralized database ports, | I successfully compile everything but when adding the domain it give me | error like that | | [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com | Please enter password for postmaster: | enter password again: | could not connect to mysql update server Access denied for user: | '[EMAIL PROTECTED]' (Using password: YES) with database | could not connect to mysql update server Access denied for user: | '[EMAIL PROTECTED]' (Using password: YES) | vmysql: sql error[c]: MySQL server has gone away | vmysql: sql error[b]: MySQL server has gone away | vmysql: sql error[3]: MySQL server has gone away | 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 | vmysql: sql error[3]: MySQL server has gone away | vmysql: sql error[2]: MySQL server has gone away | Error: Unable to chdir to vpopmail/users directory | | Is there anything wrong. | | Tx | ZaFAr | | |
Re: [vchkpw] vpopmail with mysql problem
Is Mysql started? -John - Original Message - From: zafar rizvi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 12:20 AM Subject: [vchkpw] vpopmail with mysql problem hi i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away 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 vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Error: Unable to chdir to vpopmail/users directory Is there anything wrong. Tx ZaFAr
Re: [vchkpw] vpopmail with mysql problem
zafar rizvi wrote: i am installing vpopmail-5.2.1 with mysql centralized database ports, I successfully compile everything but when adding the domain it give me error like that [EMAIL PROTECTED] vpopmail-5.2.1]# /home/vpopmail/bin/vadddomain example.com Please enter password for postmaster: enter password again: could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) with database could not connect to mysql update server Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) vmysql: sql error[c]: MySQL server has gone away vmysql: sql error[b]: MySQL server has gone away vmysql: sql error[3]: MySQL server has gone away 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 vmysql: sql error[3]: MySQL server has gone away vmysql: sql error[2]: MySQL server has gone away Error: Unable to chdir to vpopmail/users directory Is there anything wrong. A whole bunch of things could be wrong - you have to do some troubleshooting yourself to check these: 1. MySQL isn't running at the remote end. and/or 2. Your MySQL username or password is/are incorrect. and/or 3. You haven't given permission on the remote MySQL server to connect to it from your server (i.e. GRANT ALL PRIVILEGES ON vpopmail.* TO [EMAIL PROTECTED] IDENTIFIED BY password etc etc etc). and/or 4. There is a firewall running on either or both machines preventing communication. Again, as I suggested in a previous email, you can test these things yourself easily enough using simple things like telnet, the mysql client, etc etc. -- Aj. Systems Administrator / Developer
[vchkpw] vpopmail with mysql support
hi ppl i am using qmail on linux with vpopmail(5.3.14) support with mysql. But getting error like that when using with mysql support. Any body has idea about that error. vauth.c: In function `vget_lastauth': vauth.c:1132: `mysql_update' undeclared (first use in this function) vauth.c:1139: warning: assignment makes integer from pointer without a cast vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vget_lastauthip': vauth.c:1157: `mysql_update' undeclared (first use in this function) vauth.c:1164: warning: assignment makes integer from pointer without a cast vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vcreate_lastauth_table': vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this function) vauth.c:1179: `mysql_update' undeclared (first use in this function) vauth.c:1183: warning: assignment makes integer from pointer without a cast vauth.c: In function `logmysql': vauth.c:1352: `mysql_update' undeclared (first use in this function) vauth.c:1359: warning: assignment makes integer from pointer without a cast vauth.c: In function `vcreate_vlog_table': vauth.c:1372: `mysql_update' undeclared (first use in this function) vauth.c:1376: warning: assignment makes integer from pointer without a cast make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make: *** [all-recursive-am] Error 2 ** Waiting for a reply Tx Zafar
Re: [vchkpw] vpopmail with mysql support
I think problem can be in mysql lib files better to check it via ldconfig or make sure password and username is okk for mysql database. Error message which you have attatched with mail is too low. Better to show us output above these lines... -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: zafar rizvi [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 11:23 AM Subject: [vchkpw] vpopmail with mysql support | hi ppl | i am using qmail on linux with vpopmail(5.3.14) support with mysql. But | getting error like that when using with mysql support. | Any body has idea about that error. | | vauth.c: In function `vget_lastauth': | vauth.c:1132: `mysql_update' undeclared (first use in this function) | vauth.c:1139: warning: assignment makes integer from pointer without a cast | vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from | integer without a cast | vauth.c: In function `vget_lastauthip': | vauth.c:1157: `mysql_update' undeclared (first use in this function) | vauth.c:1164: warning: assignment makes integer from pointer without a cast | vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from | integer without a cast | vauth.c: In function `vcreate_lastauth_table': | vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this | function) | vauth.c:1179: `mysql_update' undeclared (first use in this function) | vauth.c:1183: warning: assignment makes integer from pointer without a cast | vauth.c: In function `logmysql': | vauth.c:1352: `mysql_update' undeclared (first use in this function) | vauth.c:1359: warning: assignment makes integer from pointer without a cast | vauth.c: In function `vcreate_vlog_table': | vauth.c:1372: `mysql_update' undeclared (first use in this function) | vauth.c:1376: warning: assignment makes integer from pointer without a cast | make[2]: *** [vauth.o] Error 1 | make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' | make[1]: *** [all-recursive] Error 1 | make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' | make: *** [all-recursive-am] Error 2 | ** | | Waiting for a reply | Tx | Zafar | | |
Re: [vchkpw] vpopmail with mysql support
hi here is the all output of make command * cdbmake_add.o make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c In file included from vauth.c:32: vmysql.h:26:29: warning: multi-line string literals are deprecated vmysql.h:27:35: warning: multi-line string literals are deprecated vmysql.h:29:39: warning: multi-line string literals are deprecated vmysql.h:30:35: warning: multi-line string literals are deprecated vmysql.h:31:35: warning: multi-line string literals are deprecated vmysql.h:36:38: warning: multi-line string literals are deprecated vmysql.h:37:33: warning: multi-line string literals are deprecated vmysql.h:39:39: warning: multi-line string literals are deprecated vmysql.h:51:35: warning: multi-line string literals are deprecated In file included from vauth.c:32: vmysql.h:55: syntax error before char vmysql.h:60:35: warning: multi-line string literals are deprecated vmysql.h:71:24: warning: multi-line string literals are deprecated vmysql.h:79:24: warning: multi-line string literals are deprecated vmysql.h:84:42: warning: multi-line string literals are deprecated vmysql.h:91:27: warning: multi-line string literals are deprecated vmysql.h:59: stray '\' in program vmysql.h:118:2: #else without #if vmysql.h:130:2: #endif without #if vmysql.h:243:2: #endif without #if vauth.c: In function `vauth_open_update': vauth.c:108: `mysql_update' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:112: parse error before rizvi vauth.c:122: parse error before rizvi vauth.c: At top level: vauth.c:133: parse error before numeric constant vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' vauth.c:134: warning: data definition has no type or storage class vauth.c:143: warning: type defaults to `int' in declaration of `res_update' vauth.c:143: conflicting types for `res_update' vauth.c:54: previous declaration of `res_update' vauth.c:143: `mysql_update' undeclared here (not in a function) vauth.c:143: warning: initialization makes integer from pointer without a cast vauth.c:143: initializer element is not constant vauth.c:143: warning: data definition has no type or storage class vauth.c:144: warning: type defaults to `int' in declaration of `mysql_free_result' vauth.c:144: warning: parameter names (without types) in function declaration vauth.c:144: conflicting types for `mysql_free_result' /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' vauth.c:144: warning: data definition has no type or storage class vauth.c:147: parse error before if vauth.c: In function `vauth_open_read_getall': vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) vauth.c:205: parse error before rizvi vauth.c: At top level: vauth.c:214: parse error before return vauth.c: In function `vauth_adddomain': vauth.c:228: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:232: `TABLE_LAYOUT' undeclared (first use in this function) vauth.c:234: `mysql_update' undeclared (first use in this function) vauth.c:239: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_adduser': vauth.c:269: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:272: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:311: warning: int format, pointer arg (arg 7) vauth.c:311: warning: format argument is not a pointer (arg 8) vauth.c:311: warning: too many arguments for format vauth.c:313: `mysql_update' undeclared (first use in this function) vauth.c:317: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_getpw': vauth.c:351: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:355: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:365: `mysql_update' undeclared (first use in this function) vauth.c:370: warning: assignment makes integer from pointer without a cast vauth.c:375: warning: passing arg 1 of `mysql_num_rows' makes pointer from integer without a cast vauth.c:394: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vauth_deldomain': vauth.c:425: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:430: `mysql_update' undeclared (first use
Re: [vchkpw] vpopmail with mysql support
hmmm it seems when u added you login name rizvi and password rizvi.. you had done something wrong with syntex of this file.. I will suggest better to untar again source and put username and password as it will... Always becareful for syntex when adding something to source sorry for spell mistake due to lake of time :) -- Best Regs, Masood Ahmad Shah System Administrator ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ | * * * * * * * * * * * * * * * * * * * * * * * * | Fibre Net (Pvt) Ltd. Lahore, Pakistan | Tel: +92-42-6677024 | Mobile: +92-300-4277367 | http://www.fibre.net.pk | * * * * * * * * * * * * * * * * * * * * * * * * ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ ^ Unix is very simple, but it takes a genius to understand the simplicity. (Dennis Ritchie) All I want is a few minutes alone with the source code for the universe and a quick recompile. - Original Message - From: zafar rizvi [EMAIL PROTECTED] To: Ahmad Masood Shah [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 12:27 PM Subject: Re: [vchkpw] vpopmail with mysql support | hi | here is the all output of make command | * | cdbmake_add.o | make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' | make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c | gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c | In file included from vauth.c:32: | vmysql.h:26:29: warning: multi-line string literals are deprecated | vmysql.h:27:35: warning: multi-line string literals are deprecated | vmysql.h:29:39: warning: multi-line string literals are deprecated | vmysql.h:30:35: warning: multi-line string literals are deprecated | vmysql.h:31:35: warning: multi-line string literals are deprecated | vmysql.h:36:38: warning: multi-line string literals are deprecated | vmysql.h:37:33: warning: multi-line string literals are deprecated | vmysql.h:39:39: warning: multi-line string literals are deprecated | vmysql.h:51:35: warning: multi-line string literals are deprecated | In file included from vauth.c:32: | vmysql.h:55: syntax error before char | vmysql.h:60:35: warning: multi-line string literals are deprecated | vmysql.h:71:24: warning: multi-line string literals are deprecated | vmysql.h:79:24: warning: multi-line string literals are deprecated | vmysql.h:84:42: warning: multi-line string literals are deprecated | vmysql.h:91:27: warning: multi-line string literals are deprecated | vmysql.h:59: stray '\' in program | vmysql.h:118:2: #else without #if | vmysql.h:130:2: #endif without #if | vmysql.h:243:2: #endif without #if | vauth.c: In function `vauth_open_update': | vauth.c:108: `mysql_update' undeclared (first use in this function) | vauth.c:108: (Each undeclared identifier is reported only once | vauth.c:108: for each function it appears in.) | vauth.c:112: parse error before rizvi | vauth.c:122: parse error before rizvi | vauth.c: At top level: | vauth.c:133: parse error before numeric constant | vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' | vauth.c:134: warning: data definition has no type or storage class | vauth.c:143: warning: type defaults to `int' in declaration of `res_update' | vauth.c:143: conflicting types for `res_update' | vauth.c:54: previous declaration of `res_update' | vauth.c:143: `mysql_update' undeclared here (not in a function) | vauth.c:143: warning: initialization makes integer from pointer without a | cast | vauth.c:143: initializer element is not constant | vauth.c:143: warning: data definition has no type or storage class | vauth.c:144: warning: type defaults to `int' in declaration of | `mysql_free_result' | vauth.c:144: warning: parameter names (without types) in function | declaration | vauth.c:144: conflicting types for `mysql_free_result' | /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' | vauth.c:144: warning: data definition has no type or storage class | vauth.c:147: parse error before if | vauth.c: In function `vauth_open_read_getall': | vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) | vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) | vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) | vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) | vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) | vauth.c:205: parse error before rizvi | vauth.c: At top level: | vauth.c:214: parse error before return | vauth.c: In function `vauth_adddomain': | vauth.c:228: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) | vauth.c:232: `TABLE_LAYOUT' undeclared (first use in this function) | vauth.c:234: `mysql_update' undeclared (first use in this function) | vauth.c:239: warning
Re: [vchkpw] vpopmail with mysql support
zafar rizvi wrote: hi ppl i am using qmail on linux with vpopmail(5.3.14) support with mysql. But getting error like that when using with mysql support. Any body has idea about that error. vauth.c: In function `vget_lastauth': vauth.c:1132: `mysql_update' undeclared (first use in this function) vauth.c:1139: warning: assignment makes integer from pointer without a cast vauth.c:1141: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vget_lastauthip': vauth.c:1157: `mysql_update' undeclared (first use in this function) vauth.c:1164: warning: assignment makes integer from pointer without a cast vauth.c:1165: warning: passing arg 1 of `mysql_fetch_row' makes pointer from integer without a cast vauth.c: In function `vcreate_lastauth_table': vauth.c:1178: `LASTAUTH_TABLE_LAYOUT' undeclared (first use in this function) vauth.c:1179: `mysql_update' undeclared (first use in this function) vauth.c:1183: warning: assignment makes integer from pointer without a cast vauth.c: In function `logmysql': vauth.c:1352: `mysql_update' undeclared (first use in this function) vauth.c:1359: warning: assignment makes integer from pointer without a cast vauth.c: In function `vcreate_vlog_table': vauth.c:1372: `mysql_update' undeclared (first use in this function) vauth.c:1376: warning: assignment makes integer from pointer without a cast make[2]: *** [vauth.o] Error 1 make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/vpopmail-5.2.1' make: *** [all-recursive-am] Error 2 ** Did you edit vmysql.h (as it says in README.mysql) ? Also, is MySQL installed from RPM? -- Aj. Systems Administrator / Developer
Re: [vchkpw] vpopmail with mysql support
Hi, Zafar. Try the latest development release of vpopmail. As you can see below, it's stating there is a syntax error in the header file. This could be a result of your system, or the older version of vpopmail. If you get the latest development release and this occurs, make sure you have the latest MySQL-devel, and latest MySQL installed, and that you're running the latest stable GNU compiler. Hope that helps! zafar rizvi wrote: hi here is the all output of make command * cdbmake_add.o make[2]: Leaving directory `/usr/local/src/vpopmail-5.2.1/cdb' make[2]: Entering directory `/usr/local/src/vpopmail-5.2.1' gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vpopmail.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c md5.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c bigdir.c gcc -I. -I/usr/include/mysql -g -O2 -Wall -c vauth.c In file included from vauth.c:32: vmysql.h:26:29: warning: multi-line string literals are deprecated vmysql.h:27:35: warning: multi-line string literals are deprecated vmysql.h:29:39: warning: multi-line string literals are deprecated vmysql.h:30:35: warning: multi-line string literals are deprecated vmysql.h:31:35: warning: multi-line string literals are deprecated vmysql.h:36:38: warning: multi-line string literals are deprecated vmysql.h:37:33: warning: multi-line string literals are deprecated vmysql.h:39:39: warning: multi-line string literals are deprecated vmysql.h:51:35: warning: multi-line string literals are deprecated In file included from vauth.c:32: vmysql.h:55: syntax error before char vmysql.h:60:35: warning: multi-line string literals are deprecated vmysql.h:71:24: warning: multi-line string literals are deprecated vmysql.h:79:24: warning: multi-line string literals are deprecated vmysql.h:84:42: warning: multi-line string literals are deprecated vmysql.h:91:27: warning: multi-line string literals are deprecated vmysql.h:59: stray '\' in program vmysql.h:118:2: #else without #if vmysql.h:130:2: #endif without #if vmysql.h:243:2: #endif without #if vauth.c: In function `vauth_open_update': vauth.c:108: `mysql_update' undeclared (first use in this function) vauth.c:108: (Each undeclared identifier is reported only once vauth.c:108: for each function it appears in.) vauth.c:112: parse error before rizvi vauth.c:122: parse error before rizvi vauth.c: At top level: vauth.c:133: parse error before numeric constant vauth.c:134: warning: type defaults to `int' in declaration of `snprintf' vauth.c:134: warning: data definition has no type or storage class vauth.c:143: warning: type defaults to `int' in declaration of `res_update' vauth.c:143: conflicting types for `res_update' vauth.c:54: previous declaration of `res_update' vauth.c:143: `mysql_update' undeclared here (not in a function) vauth.c:143: warning: initialization makes integer from pointer without a cast vauth.c:143: initializer element is not constant vauth.c:143: warning: data definition has no type or storage class vauth.c:144: warning: type defaults to `int' in declaration of `mysql_free_result' vauth.c:144: warning: parameter names (without types) in function declaration vauth.c:144: conflicting types for `mysql_free_result' /usr/include/mysql/mysql.h:271: previous declaration of `mysql_free_result' vauth.c:144: warning: data definition has no type or storage class vauth.c:147: parse error before if vauth.c: In function `vauth_open_read_getall': vauth.c:199: `MYSQL_READ_SERVER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_USER' undeclared (first use in this function) vauth.c:200: `MYSQL_READ_PASSWD' undeclared (first use in this function) vauth.c:200: `MYSQL_DATABASE' undeclared (first use in this function) vauth.c:201: `MYSQL_VPORT' undeclared (first use in this function) vauth.c:205: parse error before rizvi vauth.c: At top level: vauth.c:214: parse error before return vauth.c: In function `vauth_adddomain': vauth.c:228: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:232: `TABLE_LAYOUT' undeclared (first use in this function) vauth.c:234: `mysql_update' undeclared (first use in this function) vauth.c:239: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_adduser': vauth.c:269: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:272: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:311: warning: int format, pointer arg (arg 7) vauth.c:311: warning: format argument is not a pointer (arg 8) vauth.c:311: warning: too many arguments for format vauth.c:313: `mysql_update' undeclared (first use in this function) vauth.c:317: warning: assignment makes integer from pointer without a cast vauth.c: In function `vauth_getpw': vauth.c:351: `MYSQL_DEFAULT_TABLE' undeclared (first use in this function) vauth.c:355: `MYSQL_LARGE_USERS_TABLE' undeclared (first use in this function) vauth.c:365: `mysql_update' undeclared (first use in this function)
[vchkpw] Vpopmail with mysql and md5-apop/md5-cram auth
Hello, on an old server i've got a vpopmail-installation without mysql-support. On this system the auth with md5-apop/md5-cram worked well. Now I have a new system with mysql-support (./configure --enable-clear-passwords=y --enable-valias --enable-roaming-users=y --enable-logging=y --enable-defaultquota=1000M --enable-relay-clear-minutes=60 --enable-md5-passwords --enable-auth-logging --enable-log-name=/var/log/vpopmail.log --enable-qmail-ext --enable-mysql=y --enable-mysql-replication=y --enable-large-site=y --enable-libdir=/usr/lib --enable-mysql-logging=y --enable-vpopgroup=vchkpw --enable-apop=y --enable-learn-passwords=y) But md5-driven auth fails, because the auth-process log into the system with a md5-key, which is not the same as the normal password of the user. How can I solve this problem? - Mit freundlichen Grüssen Christian Michel webdesign-centre webdesign-centre Christian Michel Königsbrücker Str. 121b 01099 Dresden Tel.: +49 700 24764243* Fax.: +49 700 24764243* Mobil: +49 177 6762777 Email: [EMAIL PROTECTED] Website: www.w-d-c.net * Hauptzeit : 12 Cent/min Nebenzeit : 6 Cent/min
RE: [vchkpw] Vpopmail w/ MySQL, courier-imap issue
Heya, For the archives, the reason for this is that vpopmail was not built with the --enable-incdir and --enable-libdir options. Vpopmail itself was able to find the necessary MySQL files, however this information was not available to Courier via vpopmail.a - for this reason, courier could not find the mysql header files. Andre -Original Message- From: Jesse Guardiani [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 14, 2002 12:57 PM To: Andre Fortin; vpopmail Subject: Re: [vchkpw] Vpopmail w/ MySQL, courier-imap issue That's strange. Did you: gmake install-strip on vpopmail before compiling courier-imap? I wonder why it's referencing your vpopmail src directory? Jesse Guardiani, Systems Administrator WingNET Internet Services, P.O. Box 2605 // Cleveland, TN 37320-2605 423-559-LINK (v) 423-559-5145 (f) http://www.wingnet.net We are actively looking for companies that do a lot of long distance faxing and want to cut their long distance bill by up to 50%. Contact [EMAIL PROTECTED] for more info. - Original Message - From: Andre Fortin [EMAIL PROTECTED] To: vpopmail [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 2:37 AM Subject: [vchkpw] Vpopmail w/ MySQL, courier-imap issue Heya.. Having some issues with courier-imap. I am using vpopmail w/ MySQL auth, and all works well.. However, when trying to compile Courier (running 'make' as normal user, and ~vpopmail/lib is readable), I get the error at the end of this email (it is long so I wont put it in the middle of my message). OS: FreeBSD 4.7 Vpopmail configure line: /configure --enable-default-domain=personainternet.com --enable-clear-passw d=y --enable-ip-alias-domains=y --enable-hard-quota --enable-defaultquota=50 00 --enable-mysql=y --enable-mysql-replication=y Courier configure line: ./configure --prefix=/usr/local/courier-imap --disable-root-check --without- authpam --without-authldap --without-authpwd --without-authmysql --without-a uthpgsql --without-authshadow --without-authuserdb --without-authcustom --wi thout-authcram --without-authdaemon --with-authvchkpw Any help is appreciated, thanks in advance. Andre - Error: Compiling modauthvchkpw.c gcc -I/var/vpopmail/include -g -O2 -Wall -I.. -I./.. -o authvchkpw modauthvchkpw.o libauthmod.a libauth.a ../numlib/libnumlib.a ../md5/libmd5.a ../sha1/libsha1.a -L/var/vpopmail/lib -lvpopmail -lm -lcrypt /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_update': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x30): undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x54): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x6f): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0xa3): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0xba): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x10b): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x122): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x141): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x14f): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x164): undefined reference to `mysql_select_db' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_read': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x1b6): undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x1da): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x205): undefined reference to `mysql_real_connect' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_read_getall': /usr/src/vpopmail-5.2.1/vauth.c:234: undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c:239: undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c:243: undefined reference to `mysql_real_connect' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_adddomain': /usr/src/vpopmail-5.2.1/vauth.c:239: undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c:240: undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c:242: undefined reference to `mysql_free_result' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_adduser': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x4f5): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x509): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x517): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x52c): undefined reference to `mysql_error' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_getpw': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x605): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x61e
[vchkpw] Vpopmail w/ MySQL, courier-imap issue
Heya.. Having some issues with courier-imap. I am using vpopmail w/ MySQL auth, and all works well.. However, when trying to compile Courier (running 'make' as normal user, and ~vpopmail/lib is readable), I get the error at the end of this email (it is long so I wont put it in the middle of my message). OS: FreeBSD 4.7 Vpopmail configure line: /configure --enable-default-domain=personainternet.com --enable-clear-passw d=y --enable-ip-alias-domains=y --enable-hard-quota --enable-defaultquota=50 00 --enable-mysql=y --enable-mysql-replication=y Courier configure line: ./configure --prefix=/usr/local/courier-imap --disable-root-check --without- authpam --without-authldap --without-authpwd --without-authmysql --without-a uthpgsql --without-authshadow --without-authuserdb --without-authcustom --wi thout-authcram --without-authdaemon --with-authvchkpw Any help is appreciated, thanks in advance. Andre - Error: Compiling modauthvchkpw.c gcc -I/var/vpopmail/include -g -O2 -Wall -I.. -I./.. -o authvchkpw modauthvchkpw.o libauthmod.a libauth.a ../numlib/libnumlib.a ../md5/libmd5.a ../sha1/libsha1.a -L/var/vpopmail/lib -lvpopmail -lm -lcrypt /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_update': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x30): undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x54): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x6f): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0xa3): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0xba): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x10b): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x122): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x141): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x14f): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x164): undefined reference to `mysql_select_db' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_read': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x1b6): undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x1da): undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x205): undefined reference to `mysql_real_connect' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_open_read_getall': /usr/src/vpopmail-5.2.1/vauth.c:234: undefined reference to `mysql_init' /usr/src/vpopmail-5.2.1/vauth.c:239: undefined reference to `mysql_real_connect' /usr/src/vpopmail-5.2.1/vauth.c:243: undefined reference to `mysql_real_connect' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_adddomain': /usr/src/vpopmail-5.2.1/vauth.c:239: undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c:240: undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c:242: undefined reference to `mysql_free_result' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_adduser': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x4f5): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x509): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x517): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x52c): undefined reference to `mysql_error' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_getpw': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x605): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x61e): undefined reference to `mysql_error' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x635): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x661): undefined reference to `mysql_num_rows' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x706): undefined reference to `mysql_fetch_row' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x82e): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x842): undefined reference to `mysql_free_result' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_deldomain': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x8a2): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x8b6): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x8c4): undefined reference to `mysql_free_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x8ee): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x902): undefined reference to `mysql_store_result' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x910): undefined reference to `mysql_free_result' /var/vpopmail/lib/libvpopmail.a(vauth.o): In function `vauth_deluser': /usr/src/vpopmail-5.2.1/vauth.c(.text+0x97a): undefined reference to `mysql_query' /usr/src/vpopmail-5.2.1/vauth.c(.text+0x993): undefined reference to
[vchkpw] Vpopmail and mysql limits
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
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
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
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
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 LOL -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
