Re: [vchkpw] mysql auth

2009-02-25 Thread Remo Mattei
2nd graffitiist: Why? Use bill shupp toaster you will have not problem with this. Just my 2 cents. Remo > From: Mohsen Pahlevanzadeh > Reply-To: > Date: Wed, 25 Feb 2009 20:14:27 +0330 > To: > Subject: [vchkpw] mysql auth > > Dear all, > At first i installed qmail from LWQ on Debian.Then i

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Jordi Prats
On Thu, Sep 25, 2008 at 6:24 PM, Rick Macdougall <[EMAIL PROTECTED]> wrote: > > Have a network monitor login to IMAP every half hour to keep the connection > open ? That's a good workaround because I can check it is dovecot alive while I'm keeping the connection open. I like it :) Anyway this is

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Rick Macdougall
Jordi Prats wrote: I'm using dovecot 1.1.3 with MySQL 5.0.67. I think that disabling idle timeout it's not a good idea since MySQL could die for too many useless idle conections too. There is not any better solution? Any vpopmail parameter that I'm missing? Thank you ! Have a network monitor

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Jordi Prats
Restarting dovecote solve the problem, yes. Also if I restart MySQL I must restart dovecot too. regards, On Thu, Sep 25, 2008 at 6:01 PM, Jordi Prats <[EMAIL PROTECTED]> wrote: > I'm using dovecot 1.1.3 with MySQL 5.0.67. > > I think that disabling idle timeout it's not a good idea since MySQL >

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Jordi Prats
I'm using dovecot 1.1.3 with MySQL 5.0.67. I think that disabling idle timeout it's not a good idea since MySQL could die for too many useless idle conections too. There is not any better solution? Any vpopmail parameter that I'm missing? Thank you ! On Thu, Sep 25, 2008 at 5:57 PM, Evren Yurte

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Evren Yurtesen
Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server)

Re: [vchkpw] MySQL server has gone away

2008-09-25 Thread Rick Macdougall
Jordi Prats wrote: Hi all, I'm facing this error: dovecot: auth(default): vmysql: sql error[3]: MySQL server has gone away I've been googling about this but it seems to be a resolved issuem(back to 2005), so it should just reconnect but it does not so. If I just restart dovecot (my IMAP server)

Re: [vchkpw] Mysql, vlog entries (or table) not being created

2008-02-26 Thread Steve
Steve wrote: Anyone know why no vlog entries, or even table when using MySQL5 and vpopmail? Using vpopmail 5.4.25, courier-authlib 0.60.2, Looking in the courier-authlib code, it appears to be a courier-authlib issue. At least the way I read it. !DSPAM:47c516ce310548528217500!

Re: [vchkpw] mysql sourcing read/update server config file

2007-12-06 Thread Hartmut Wernisch
On 05 Dec 07, Tom Collins wrote: > On Dec 5, 2007, at 2:51 AM, Hartmut Wernisch wrote: > >So now I am wondering why line 197-202 is setting the values to > >MYSQL_READ_SOCKET and MYSQL_READ_PORT instead of MYSQL_UPDATE_SOCKET > >and MYSQL_UPDATE_PORT? > > > >In my opinion these values should be set

Re: [vchkpw] mysql sourcing read/update server config file

2007-12-05 Thread Tom Collins
On Dec 5, 2007, at 5:49 PM, Rick Widmer wrote: Tom: Do you have the tracker number? I did not see anything that jumped out at me from the open reports, or even the first 50 any entries. Maybe it was something that I saw on the list. I went in and looked at the trackers and didn't see a

Re: [vchkpw] mysql sourcing read/update server config file

2007-12-05 Thread Rick Widmer
Tom Collins wrote: On Dec 5, 2007, at 2:51 AM, Hartmut Wernisch wrote: So now I am wondering why line 197-202 is setting the values to MYSQL_READ_SOCKET and MYSQL_READ_PORT instead of MYSQL_UPDATE_SOCKET and MYSQL_UPDATE_PORT? In my opinion these values should be set to MYSQL_UPDATE_SOCKET an

Re: [vchkpw] mysql sourcing read/update server config file

2007-12-05 Thread Tom Collins
On Dec 5, 2007, at 2:51 AM, Hartmut Wernisch wrote: So now I am wondering why line 197-202 is setting the values to MYSQL_READ_SOCKET and MYSQL_READ_PORT instead of MYSQL_UPDATE_SOCKET and MYSQL_UPDATE_PORT? In my opinion these values should be set to MYSQL_UPDATE_SOCKET and MYSQL_UPDATE_PORT?

Re: [vchkpw] Mysql table

2007-09-21 Thread Tom Collins
On Sep 20, 2007, at 12:56 PM, Rick Widmer wrote: If I remember right, speed was the reason for separate tables, but testing showed it was not faster. I think the single table works better because all your mail users are accessing the same table, and its indexes so they stay loaded all the t

Re: [vchkpw] Mysql table

2007-09-20 Thread Ken Jones
Rick Widmer wrote: mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name "a(63 times).com" IS a valid domain name, but "a(63 times)_com" is NOT a valid table name. Definitely a design f

Re: [vchkpw] Mysql table

2007-09-20 Thread mlist
Rick Widmer wrote: mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name "a(63 times).com" IS a valid domain name, but "a(63 times)_com" is NOT a valid table name. Definitely a design f

Re: [vchkpw] Mysql table

2007-09-20 Thread Rick Widmer
mlist wrote: John Simpson wrote: and since mysql has a limit of 64 bytes for a table name, you have a... maybe not a bug, but a design flaw. the name "a(63 times).com" IS a valid domain name, but "a(63 times)_com" is NOT a valid table name. Definitely a design flaw, even before the

Re: [vchkpw] Mysql table

2007-09-20 Thread mlist
John Simpson wrote: On 2007-09-19, at 1532, mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. ... I did as you said and I recieved errors. Here is the command I used and the errors returned. ... vmysql: error creating table 'aa

Re: [vchkpw] Mysql table

2007-09-19 Thread John Simpson
On 2007-09-19, at 1532, mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. ... I did as you said and I recieved errors. Here is the command I used and the errors returned. ... vmysql: error creating table '

Re: [vchkpw] Mysql table

2007-09-19 Thread mlist
mlist wrote: Please try creating a domain with a long name, up around 80-90 characters long. Then try to add a user, delete that user then delete that domain. If it all works, you are in good shape and I'll change the note in INSTALL to say you don't have to do anything special if you are

Re: [vchkpw] Mysql table

2007-09-19 Thread Joshua Megerman
> qmail-newu: fatal: bad format in users/assign Before pursuing anything else, check this out - qmail-newu (part of qmail, and simply called by vpopmail) is telling you that your /var/qmail/users/assign file is incorrect/corrupted, and that it can't create the users.cdb file from it. Vpopmail use

Re: [vchkpw] Mysql table

2007-09-19 Thread mlist
Please try creating a domain with a long name, up around 80-90 characters long. Then try to add a user, delete that user then delete that domain. If it all works, you are in good shape and I'll change the note in INSTALL to say you don't have to do anything special if you are using --disabl

Re: [vchkpw] Mysql table

2007-09-18 Thread Rick Widmer
mlist wrote: Hello, I'm upgrading vpopmail to version 5.4.21. The documentation states that I need to alter some tables. ALTER TABLE `dir_control` CHANGE `pw_domain` `pw_domain` CHAR(96) NOT NULL; ALTER TABLE `ip_alias_map` CHANGE pw_domain pw_domain CHAR(96) NOT NULL; ... I read on a p

RE: [vchkpw] MySQL going down results in 5xx error

2006-02-09 Thread Ed McLain
ailto:[EMAIL PROTECTED] > > Sent: Wednesday, January 25, 2006 3:48 AM > > To: vchkpw@inter7.com > > Subject: Re: [vchkpw] MySQL going down results in 5xx error > > > > > > > Hello, > > > > > > I have recently inherited a qmail server. This serve

RE: [vchkpw] MySQL going down results in 5xx error

2006-02-09 Thread Jennifer Abel
> -Original Message- > From: Tonix [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 25, 2006 3:48 AM > To: vchkpw@inter7.com > Subject: Re: [vchkpw] MySQL going down results in 5xx error > > > > Hello, > > > > I have recently inherited a

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-29 Thread Rick Widmer
Joshua Megerman wrote: Yes, here are changes. I've already tried them and it works. Just FYI - with MySQL it's vauth_open_read not vauth_open. I'm thinking of submitting a patch to vpopmail to unify the call, so that it can be published globally. It would be nice if vauth_open would work no ma

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-28 Thread tonix (Antonio Nati)
At 20.18 27/01/2006, you wrote: > Yes, here are changes. I've already tried them and it works. Just studying the name of calls it may be adapted to Postgres also (it should be enough to use vauth_open() ). > > In chkuser_settings.h enable > #define CHKUSER_ENABLE_VAUTH_OPEN > and add one of the f

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-28 Thread tonix (Antonio Nati)
At 21.30 27/01/2006, you wrote: > #if defined CHKUSER_ENABLE_VAUTH_OPEN >  if (db_already_open != 1) { >  if (CHKUSER_VAUTH_OPEN_CALL () == 0) { >  db_already_open == 1; >  } else { >  

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-27 Thread Joshua Megerman
> #if defined CHKUSER_ENABLE_VAUTH_OPEN > if (db_already_open != 1) { > if (CHKUSER_VAUTH_OPEN_CALL () == 0) { > db_already_open == 1; > } else { > retstat = CHKUSER_

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-27 Thread Joshua Megerman
> Yes, here are changes. I've already tried them and it works. Just studying the name of calls it may be adapted to Postgres also (it should be enough to use vauth_open() ). > > In chkuser_settings.h enable > #define CHKUSER_ENABLE_VAUTH_OPEN > and add one of the following lines: > /* use this if y

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-27 Thread tonix (Antonio Nati)
At 15.15 25/01/2006, you wrote: > If you are using chkuser, there is a small change you can do (I'm going to > publish nextly this change with next version of chkuser). > > If you are interested I'll anticipate this small change so it may help > people to handle this error. > Can you post the cha

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-25 Thread Joshua Megerman
> If you are using chkuser, there is a small change you can do (I'm going to > publish nextly this change with next version of chkuser). > > If you are interested I'll anticipate this small change so it may help > people to handle this error. > Can you post the change here so that those of us who w

Re: [vchkpw] MySQL going down results in 5xx error

2006-01-25 Thread Tonix
> Hello, > > I have recently inherited a qmail server. This server is utilizing > vpopmail version: 5.4.6 and MySQL Ver 4.0.25. We are currently suffering > from the problem mentioned here: > http://marc.theaimsgroup.com/?l=vchkpw&m=108925077224259&w=2 and > https://sourceforge.net/tracker/index.ph

Re: [vchkpw] MySQL 4.0.x frequent database corruption?

2005-11-08 Thread Jimmy
Hello, Jack Kerouac wrote: I've got a Debian stable box (Sarge) with vpopmail-5.4.10 and MySQL version 4.0.24-10serge1. About 1,000 users and a few dozen domains. The MySQL database is frequently (several times a month) getting corrupted - which of course makes for very angry users. I

Re: [vchkpw] MySQL 4.0.x frequent database corruption?

2005-11-07 Thread Shane Chrisp
On Mon, 2005-11-07 at 16:04 -0700, Jack Kerouac wrote: > I've got a Debian stable box (Sarge) with vpopmail-5.4.10 and MySQL > version 4.0.24-10serge1. About 1,000 users and a few dozen domains. > The MySQL database is frequently (several times a month) getting > corrupted - which of course

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread Rick Widmer
John Simpson wrote: i don't know that i'll have the free time, but i'm certainly willing to look at it. so what's actually needed would be: That sounds about right... I'll give it a closer look later tonight. This is getting pretty close to off topic for this list. Maybe we should

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread Tom Collins
This is a known limitation of valiases. I've wanted to do something about it for a long time, but don't have the spare time to do so. It would be great if John and perhaps others could pitch in to make it happen. On Jul 19, 2005, at 3:57 PM, John Simpson wrote: i don't know that i'll have th

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread John Simpson
On Jul 19, 2005, at 6:03 PM, Rick Widmer wrote: John Simpson wrote: and if so, does mysql have any guaranteed order that it will present the records with an explicit ORDER BY clause in the query? There is no ORDER BY clause in the query, so the order the records is random. They may appear

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread Rick Widmer
DAve wrote: John Simpson wrote: i wanted to ask this here before reporting it as a bug on the sourceforge site. Not really a bug as I believe the valias was intended as a forwarding tool, I may be wrong. Ken or Tom would be able to answer better. I only know what I know as I had discuss

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread Rick Widmer
John Simpson wrote: howdy- while answering a question for somebody on another mailing list i happened to notice that, at least as of vpopmail 5.4.10, the structure of the "valias" table created in a mysql database does not have any provision for sequencing the entries attached to a give

Re: [vchkpw] mysql - valias sequence?

2005-07-19 Thread DAve
John Simpson wrote: howdy- while answering a question for somebody on another mailing list i happened to notice that, at least as of vpopmail 5.4.10, the structure of the "valias" table created in a mysql database does not have any provision for sequencing the entries attached to a given a

Re: [vchkpw] Mysql replica

2005-03-16 Thread Riccardo Bini
Alle 17:39, mercoledì 16 marzo 2005, Tom Collins ha scritto: > On Mar 16, 2005, at 6:52 AM, Riccardo Bini wrote: > > I have installed vpopmail 5.4.6 whith mysql database. I found a bug in > > vadduser. > > When I add a user I get Segmentation Fault. I debugged whith core dump > > and I > > found in

Re: [vchkpw] Mysql replica

2005-03-16 Thread Tom Collins
On Mar 16, 2005, at 6:52 AM, Riccardo Bini wrote: I have installed vpopmail 5.4.6 whith mysql database. I found a bug in vadduser. When I add a user I get Segmentation Fault. I debugged whith core dump and I found in line 1567 in vpopmail.c (remove_maildirsize(mypw->pw_dir);) the bug. mypw has

Re: [vchkpw] mysql int and C's int limit

2005-03-12 Thread Rick Macdougall
ceg ryan wrote: I find the maximum quota I could set is 2GB. Exactly, the Mysql int and C's int limits at the same size. Is it be possible to increase the limit ? could I simply change the quota's type to bigint and the int to unsiged long int to solve it ? Hi, No, it is not as simple as that b

Re: [vchkpw] mysql and valias_insert()

2005-02-12 Thread Tom Collins
On Feb 12, 2005, at 3:33 PM, James Whitt wrote: I'm currently using vpopmail version 5.4.6 (from FreeBSD ports) and i'm curious about how vpopmail handles aliases while using mysql. I have build vpopmail with --enable-valias and --enable-auth-module=mysql (using the USE_MYSQL and WITH_VALIAS setti

Re: [vchkpw] Mysql-Vpopmail-Outlook trouble???

2005-01-27 Thread Ajai Khattri
On Thu, 27 Jan 2005, David Diaz wrote: > I have an issue with my mail server, I have qmail, vpopmail 5.4.0 and MySQL > 4.0.18 everything is fine, but when an user try to conect to mail server > using outlook as mail client in the morning or after a long time of > inactivity period, the outlook

Re: [vchkpw] MySql load causes bounced mail

2004-11-17 Thread Rick Macdougall
Tom Collins wrote: On Nov 17, 2004, at 4:33 PM, Rick Macdougall wrote: Speaking of which, Tom I do have a patch to correct courier-imap's authvckpw to work with the new webmail, no_imap code. Should I submit that to the dev list and we can include it in the contrib directory, binc imap really

Re: [vchkpw] MySql load causes bounced mail

2004-11-17 Thread Tom Collins
On Nov 17, 2004, at 4:33 PM, Rick Macdougall wrote: Speaking of which, Tom I do have a patch to correct courier-imap's authvckpw to work with the new webmail, no_imap code. Should I submit that to the dev list and we can include it in the contrib directory, binc imap really didn't work out for

Re: [vchkpw] MySql load causes bounced mail

2004-11-17 Thread Rick Macdougall
Rainer Duffner wrote: Jason Wilkinson wrote: Jason Wilkinson wrote: Hello all, I've searched and wasn't able to come up with an answer to this question. Though I did see a reference to it in the Bug Lists ( http://tinyurl.com/59gos ). We're hitting a wall with our MySql install and our traffic is

Re: [vchkpw] MySql load causes bounced mail

2004-11-17 Thread Rainer Duffner
Jason Wilkinson wrote: Jason Wilkinson wrote: Hello all, I've searched and wasn't able to come up with an answer to this question. Though I did see a reference to it in the Bug Lists ( http://tinyurl.com/59gos ). We're hitting a wall with our MySql install and our traffic is filling up all availabl

RE: [vchkpw] MySql load causes bounced mail

2004-11-17 Thread Jason Wilkinson
Jason Wilkinson wrote: > Hello all, > > I've searched and wasn't able to come up with an answer to this > question. Though I did see a reference to it in the Bug Lists ( > http://tinyurl.com/59gos ). > > We're hitting a wall with our MySql install and our traffic is > filling up all available MyS

Re: [vchkpw] MySql load causes bounced mail

2004-10-27 Thread tonix (Antonio Nati)
At 25/10/2004 25/10/2004 -0400, you wrote: I feel it could be time to redesign qmail and use atexit() functions. This could be a lengthy process. But if you are willing to undertake it, and write the patches for it, then it is certainly worth it. I'm willing to do it, but I've no time shortly. An

Re: [vchkpw] MySql load causes bounced mail

2004-10-25 Thread X-Istence
On Oct 25, 2004, at 4:08 PM, tonix (Antonio Nati) wrote: At 22/10/2004 22/10/2004 -0400, you wrote: On Oct 22, 2004, at 8:13 AM, tonix (Antonio Nati) wrote: Any comment? Tonino Why is qMail calling _exit() and not exit()? Is there a reason it does not want its files closed, and other stuff properl

Re: [vchkpw] MySql load causes bounced mail

2004-10-25 Thread tonix (Antonio Nati)
At 22/10/2004 22/10/2004 -0400, you wrote: On Oct 22, 2004, at 8:13 AM, tonix (Antonio Nati) wrote: Any comment? Tonino Why is qMail calling _exit() and not exit()? Is there a reason it does not want its files closed, and other stuff properly cleaned up? Or is it because DJB is just not happy wit

Re: [vchkpw] MySql load causes bounced mail

2004-10-22 Thread X-Istence
On Oct 22, 2004, at 8:13 AM, tonix (Antonio Nati) wrote: Any comment? Tonino Why is qMail calling _exit() and not exit()? Is there a reason it does not want its files closed, and other stuff properly cleaned up? Or is it because DJB is just not happy with using calls that are in the libc library

Re: [vchkpw] MySql load causes bounced mail

2004-10-22 Thread tonix (Antonio Nati)
At 21/10/2004 21/10/2004 -0700, you wrote: vdelivermail calls _exit() when running a command in a .qmail file (exit codes 99, 100 and 111). It should really be calling vexit() to give the MySQL lib a chance to close its connections. We could also consider just using atexit() to register functio

Re: [vchkpw] MySql load causes bounced mail

2004-10-21 Thread tonix (Antonio Nati)
At 21/10/2004 21/10/2004 +0100, you wrote: But, as we are speaking of atexit(), I'll give the good example ( :-) ) and in next 2.0.7 version I'll use it to call vclose(). As another thread is saying, qmail-smtpd also is using _exit(), so atexit() is useless. I'll put another solution to work. P

Re: [vchkpw] MySql load causes bounced mail

2004-10-21 Thread X-Istence
On Oct 21, 2004, at 3:09 PM, Tom Collins wrote: vdelivermail calls _exit() when running a command in a .qmail file (exit codes 99, 100 and 111). It should really be calling vexit() to give the MySQL lib a chance to close its connections. According to my book here, calling _exit() does not run an

Re: [vchkpw] MySql load causes bounced mail

2004-10-21 Thread tonix (Antonio Nati)
At 21/10/2004 21/10/2004 -0700, you wrote: We could also consider just using atexit() to register functions that will be automatically called at exit, then we don't have to worry about calling vexit instead (which calls vclose). Wow! In another thread I just suggested to use atexit() in vpopmail.

Re: [vchkpw] MySql load causes bounced mail

2004-10-21 Thread Tom Collins
On Oct 21, 2004, at 11:17 AM, Jason Wilkinson wrote: We're hitting a wall with our MySql install and our traffic is filling up all available MySql connections. I think I see one possible problem. vdelivermail calls _exit() when running a command in a .qmail file (exit codes 99, 100 and 111). It

Re: [vchkpw] MySQL logging

2004-08-24 Thread Richard A . Secor
Have you thought of writing a script in perl and run it in the crontab? Richard A. Secor [EMAIL PROTECTED] Sequential Logic http://www.seqlogic.com/ +1.914.494.0751 On Aug 24, 2004, at 06:11, Maurice Snellen wrote: Listmembers: I've got sql logging enabled on my server and recently noticed that thi

Re: [vchkpw] mysql dir_control table

2004-07-20 Thread Dave Goodrich
On Fri, Jul 16, 2004 at 11:28:46PM -0500, Dave Goodrich wrote: > Hello the list. > > We ahve been using vpopmail for over a year with no problems. We recently > move to using mysql for auth and I am seeing a strange side effect. New > users are no longer being created in the directory split but ar

Re: [vchkpw] mysql help

2004-05-19 Thread Mark Matrafajlo
i reverted to the mysql 3.25 version and problem fixed, now onto courier thx, Mark On Wed, 2004-05-19 at 12:58, Jeremy Kitchen wrote: > On Wednesday 19 May 2004 08:39 am, Mark Matrafajlo wrote: > > > vmysql: sql error[c]: Can't create/write to file > > > './vpopmail/dir_control.frm' (Errcode: 13) v

Re: [vchkpw] mysql help

2004-05-19 Thread Jeremy Kitchen
On Wednesday 19 May 2004 08:39 am, Mark Matrafajlo wrote: > > vmysql: sql error[c]: Can't create/write to file > > './vpopmail/dir_control.frm' (Errcode: 13) vmysql: sql error[c]: Can't > > create/write to file './vpopmail/dir_control.frm' (Errcode: 13) vmysql: > > sql error[b]: Can't find file: '.

Re: [vchkpw] MySQL error messages & vpalias.c

2004-05-10 Thread Tom Collins
On May 6, 2004, at 7:11 PM, Rick Widmer wrote: At first glance, it appers that vpalias.c, vmysql.c and vpgsql.c share common functions. It seems to me that if the code is in vmysql.c and vpgsql.c it should also appear in vcdb.c and vpalias.c should not exist. It looks like there is some ifdef ma

RE: [vchkpw] MySQL error messages & vpalias.c

2004-05-07 Thread Edward Neville
Hey! I think you helped me out on another list, the qmail main one I think. Was using ed at ednevitible . Co . Uk as mail address. -Original Message- From: X-Istence [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 05:35 To: [EMAIL PROTECTED] Subject: Re: [vchkpw] MySQL error messages

Re: [vchkpw] MySQL error messages & vpalias.c

2004-05-06 Thread X-Istence
Rick Widmer wrote: My travels have finally brought me to the MySQL database module... I am working on improving the error messages returned by vconvert, as part of the process of testing the MySQL back end. The first thing I've noticed is that a number of errors call fprintf(stderr) directly from

Re: [vchkpw] MySQL / LDAP

2004-05-06 Thread Rainer Duffner
Edward Neville wrote: Can someone direct me to a descent site that compares or details how to install LDAP and/or MySQL with Qmail please? http://www.tnpi.biz/ No comparison though. Rainer

Re: [vchkpw] mysql-auth replicated databases

2004-04-24 Thread Jeff Koch
Hi Rick: Thanks for the help. We managed to get replication running and it seems to working. We stayed with MySQL 3.23.58 because we were unable to get the upgrade to MySQL version 4 to work. So now we have chkuser-mysql and virus scanning off-loaded to the front-end server. Next step is to off

Re: [vchkpw] mysql aliases

2004-04-24 Thread Werner Amon
Tom Collins schrieb: On Apr 23, 2004, at 2:01 PM, Werner Amon wrote: Is it possible to convert .qmail-name files automaticly in mysql tables? Take a look at the dotqmail2valias program included in vpopmail 5.4.1 and later. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.n

Re: [vchkpw] mysql aliases

2004-04-23 Thread Tom Collins
On Apr 23, 2004, at 2:01 PM, Werner Amon wrote: Is it possible to convert .qmail-name files automaticly in mysql tables? Take a look at the dotqmail2valias program included in vpopmail 5.4.1 and later. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://v

RE: [vchkpw] mysql vlog

2004-04-22 Thread Shane Chrisp
You will need to recomplile without mysql logging to turn it off. Shane >-Original Message- >From: Jeff Koch [mailto:[EMAIL PROTECTED] >Sent: Friday, 23 April 2004 10:10 AM >To: [EMAIL PROTECTED] >Subject: [vchkpw] mysql vlog > > >Our mysql vlog database seems to growing very large and

Re: [vchkpw] mysql-auth replicated databases

2004-04-21 Thread Nick Harring
On Wed, 2004-04-21 at 12:21, Rick Romero wrote: > On Wed, 2004-04-21 at 12:08, Jeff Koch wrote: The replication works like a charm. I have found the occasional problem if the vlog table is replicated, for some reason its very prone to duplicate records. I myself just stopped using this table and m

Re: [vchkpw] mysql-auth replicated databases

2004-04-21 Thread Rick Romero
On Wed, 2004-04-21 at 12:08, Jeff Koch wrote: > In order to relieve the load from our main mailserver we offloaded chkuser > and virus scanning to a frontend mailserver. However, the front-end server > is not getting a fast enough response on the chkuser query from the mysql > server on the main

RE: [vchkpw] MySQL questions, vchkpw & tcpserver

2004-04-05 Thread Joel Newkirk
On Tue, 2004-03-30 at 13:20, Shane Chrisp wrote: > PS: I just confirmed the format is as I said before. Add the IP address > like 192.168.0 with a NULL timestamp. > > Shane Well, I've tried this, but it always disappears from the DB eventually, I presume (unchecked) when clearopensmtp runs. I'v

Re: [vchkpw] MySQL questions, vchkpw & tcpserver

2004-04-01 Thread Joel Newkirk
On Tue, 2004-03-30 at 12:59, Jeremy Kitchen wrote: > this is better: http://untroubled.org/relay-ctrl > put /var/spool/relay-ctrl on an nfs share. Easy as pie. > then you can just use normal tcprules stuff if you want to do static relay > controls, etc. > > -Jeremy And Shane Chrisp wrote: > I

RE: [vchkpw] MySQL questions, vchkpw & tcpserver

2004-03-30 Thread Shane Chrisp
The mysql server patch for tcpserver works very well and its simple to use. That's aside from the fact that almost every qmail install out there is using tcpserver anyway. Makes sense to keep it simple. But each to their own, I personally would rather keep all the IP's that are allowed to relay in

Re: [vchkpw] MySQL questions, vchkpw & tcpserver

2004-03-30 Thread Jeremy Kitchen
On Tuesday 30 March 2004 03:40 pm, Joel Newkirk wrote: > I'm set up to use vpopmail:relay table to track pops, and I've applied > the tcpserver patch to also use vpopmail:relay to store info on > 'always-allowed' relaying from our own IPs. ugh. this is better: http://untroubled.org/relay-ctrl p

RE: [vchkpw] MySQL questions, vchkpw & tcpserver

2004-03-30 Thread Shane Chrisp
Im not certain, but I think you can add the IP like 192.168.0 with a NULL timestamp with version 2 of the tcpserver patch. Shane >-Original Message- >From: Joel Newkirk [mailto:[EMAIL PROTECTED] >Sent: Tuesday, 30 March 2004 11:41 PM >To: [EMAIL PROTECTED] >Subject: [vchkpw] MySQL quest

RE: [vchkpw] MySQL has gone away

2004-03-28 Thread Chris Miller
  From: Chris Miller [mailto:[EMAIL PROTECTED] Sent: Saturday, March 27, 2004 2:15 PM To: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away   I am using 5.4.0, which is the latest version. I was using an older version before, but I ditched it and am reinstalling it

RE: [vchkpw] MySQL has gone away

2004-03-27 Thread Chris Miller
Somehow, the subject of this conversation has gotten changed the original subject was "MySQL has gone away". Please make sure all future messages related to this problem have this subject, NOT SMTP AUTH as that is a different problem. Thanks, Chris Miller Compuville www.compuville.net

RE: [vchkpw] MySQL has gone away

2004-03-27 Thread Chris Miller
: [EMAIL PROTECTED] Subject: RE: [vchkpw] MySQL has gone away   The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I can’t remember which one so make sure either you are using the latest version or modify that file and then recompile

RE: [vchkpw] MySQL has gone away

2004-03-27 Thread Remo Mattei
The version of vpopmail you are using is not using the file for password you need to modify the vmysql.c or .h I can’t remember which one so make sure either you are using the latest version or modify that file and then recompile..       Remo Mattei Network Security Engineer cell 80

Re: [vchkpw] mysql-standard-4.0.18-unknown-openbsd3.4-i386 + vpopmail 5.4.0

2004-03-18 Thread Mikael
fredagen den 19 mars 2004 00.12 skrev Tom Collins: > On Mar 18, 2004, at 3:52 PM, Mikael wrote: > > have anyone successfully built vpopmail with the binaries that > > mysql provide? > > Try this patch and report back. If it solves your problem, then I'll > add it to the next release. (If you're n

Re: [vchkpw] mysql-standard-4.0.18-unknown-openbsd3.4-i386 + vpopmail 5.4.0

2004-03-18 Thread Tom Collins
On Mar 18, 2004, at 3:52 PM, Mikael wrote: have anyone successfully built vpopmail with the binaries that mysql provide? Try this patch and report back. If it solves your problem, then I'll add it to the next release. (If you're not comfortable using patch, it will be easy to modify those files

RE: [vchkpw] mysql-standard-4.0.18-unknown-openbsd3.4-i386 + vpopmail 5.4.0

2004-03-18 Thread Shouguan Lin
It happens on the FreeBSD too. The "floor" is in the libm. Edit the Makefile and change "-lz" to "-lz -lm" and it will compile fine. For vi, just do "1,$ s/-lz/-lz -lm/g". Save the Makefile and do a make. -Original Message- From: Mikael [mailto:[EMAIL PROTECTED] Sent: Thursday, March 1

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Nick Harring
On Mon, 2004-02-16 at 14:45, Tom Collins wrote: > On Feb 16, 2004, at 1:23 PM, Nick Harring wrote: > > In most setups, i.e. less than 1k users, I'd probably agree. For larger > > sites though I'd be interested in trying to benchmark, maybe with > > something like oProfile?, how much of a difference

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Tom Collins
On Feb 16, 2004, at 1:23 PM, Nick Harring wrote: In most setups, i.e. less than 1k users, I'd probably agree. For larger sites though I'd be interested in trying to benchmark, maybe with something like oProfile?, how much of a difference dynamic libraries could make for MySQL. I'm currently beginni

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Nick Harring
On Mon, 2004-02-16 at 14:13, Jeremy Kitchen wrote: > On Mon, 2004-02-16 at 14:07, Nick Harring wrote: > > > Well, I'll not flame, but I will correct. Stripping removes debugging > > symbols only which only get loaded, iirc, when you load the binary in a > > debugger like gdb. > > Thanks, I'll ha

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Jeremy Kitchen
On Mon, 2004-02-16 at 14:07, Nick Harring wrote: > Well, I'll not flame, but I will correct. Stripping removes debugging > symbols only which only get loaded, iirc, when you load the binary in a > debugger like gdb. Thanks, I'll have to look more into this as it's something that I'd like to unde

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Nick Harring
On Mon, 2004-02-16 at 13:25, Jeremy Kitchen wrote: > On Mon, 2004-02-16 at 13:01, Nick Harring wrote: > > > except for the segfaults adding domains and users when using mysql > > > replication along with it :) > > Which segfaults would those be? I use mysql replication and add users > > all the tim

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Jeremy Kitchen
On Mon, 2004-02-16 at 13:01, Nick Harring wrote: > > except for the segfaults adding domains and users when using mysql > > replication along with it :) > Which segfaults would those be? I use mysql replication and add users > all the time without any issues. I did this running both vpopmail 5.2.1

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Nick Harring
On Mon, 2004-02-16 at 12:55, Jeremy Kitchen wrote: > On Mon, 2004-02-16 at 13:47, Eduardo M. Bragatto wrote: > > Hi, > > > > I've been using vpopmail with cdb authentication system on many servers > > about 2 years and I don't have any complains about it. > > Looking the README.mysql from

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Ken Jones
On Monday 16 February 2004 1:47 pm, Eduardo M. Bragatto wrote: > Hi, > > I've been using vpopmail with cdb authentication system on many servers > about 2 years and I don't have any complains about it. > Looking the README.mysql from vpopmail 5.4.0 it says: > > "Using vpopmail wit

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Jeremy Kitchen
On Mon, 2004-02-16 at 13:47, Eduardo M. Bragatto wrote: > Hi, > > I've been using vpopmail with cdb authentication system on many servers > about 2 years and I don't have any complains about it. > Looking the README.mysql from vpopmail 5.4.0 it says: > > "Using vpopmail with My

Re: [vchkpw] MySQL vs CDB

2004-02-16 Thread Nick Harring
On Mon, 2004-02-16 at 13:47, Eduardo M. Bragatto wrote: > Hi, > > I've been using vpopmail with cdb authentication system on many servers > about 2 years and I don't have any complains about it. > Looking the README.mysql from vpopmail 5.4.0 it says: > > "Using vpopmail with My

Re: [vchkpw] Mysql + NFS + Quota Problem

2004-01-08 Thread Clayton Weise
Please paste the output of a vuserinfo on one of your email addresses. Phisher1 wrote: Here is my setup: I have qmail + vpopmail 5.3.30+ mysql setup. I have 5 servers for this mail cluster. 1. mx for internet ( no relay) 2. smtp for customers ( relay for customers) 3. pop3

Re: [vchkpw] Mysql Threads

2003-11-25 Thread Adam Hooper
X-Istence wrote: Adam Hooper wrote: Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. > Last i checked Slashdot was running PostGreSQL. http://www.mysql.com/press/user_stories/slashdot.html "Naturally, Slashdot has been run

Re: [vchkpw] Mysql Threads

2003-11-24 Thread X-Istence
Adam Hooper wrote: I've never had problems with InnoDB in the past 1-2 years. In one case it's being used for some fairly computationally intense PHP website calculations. Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance

Re: [vchkpw] Mysql Threads

2003-11-24 Thread Adam Hooper
I've never had problems with InnoDB in the past 1-2 years. In one case it's being used for some fairly computationally intense PHP website calculations. Many people have used it in more critical applications, and it's up to the task. Slashdot, for instance, or Yahoo! Finance. It's around the s

RE: [vchkpw] Mysql Threads

2003-11-24 Thread Ross Davis - DataAnywhere.net
x27;t you deserve a vacation! -Original Message- From: Erik Bourget [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 4:13 PM To: Adam Hooper Cc: Mandy; VCHKPW Mailinglist Subject: Re: [vchkpw] Mysql Threads Adam Hooper <[EMAIL PROTECTED]> writes: > I don't quite

  1   2   >