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

[vchkpw] mysql auth

2009-02-25 Thread Mohsen Pahlevanzadeh
Dear all, At first i installed qmail from LWQ on Debian.Then i installed courier-imap & courier-pop & their core. Then i installed vpopmail with mysql auth module.Even i tested it & it read & write to mysql. Now, When i use following command,i give error: --

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)

[vchkpw] MySQL server has gone away

2008-09-25 Thread Jordi Prats
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) it works OK. I'm us

[vchkpw] MySQL Domains

2008-06-30 Thread Quey
Hey all, OK, we all know we can add users directly into MySQL. But... can we do the same with Domains? I'm thinking this is not possible since typically no-one emails postmaster so vpopmail wouldn't know when to creat the domain root directory, just curious if anyone has attempted this and f

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!

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

2008-02-25 Thread Steve
Anyone know why no vlog entries, or even table when using MySQL5 and vpopmail? Using vpopmail 5.4.25, courier-authlib 0.60.2, vpopmail configured with --enable-sql-logging and --enable-logging=p and --enable-auth-logging vpopmail works, tables are created, lastauth is there, etc. But no vlog

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?

[vchkpw] mysql sourcing read/update server config file

2007-12-05 Thread Hartmut Wernisch
Hello, I have a question regarding sourcing the vpopmail.mysql config file. The first line reflect the reading mysql db server. If there is no second line the same values are taken for the update mysql db server. I am talking about vpopmail-5.4.25. Here is parsing the first line of vpopmail.my

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

[vchkpw] Mysql table

2007-09-18 Thread mlist
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 previous post tha

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

[vchkpw] MySQL going down results in 5xx error

2006-01-24 Thread Jennifer Abel
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.php?func=detail

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

[vchkpw] MySQL 4.0.x frequent database corruption?

2005-11-07 Thread Jack Kerouac
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 have run Vpopmail and MySQL f

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

[vchkpw] mysql - valias sequence?

2005-07-19 Thread John Simpson
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 alias. in many cases

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

[vchkpw] Mysql replica

2005-03-16 Thread Riccardo Bini
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 null pointer. Whit only one line in vpopmail.sql (

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

[vchkpw] mysql int and C's int limit

2005-03-11 Thread ceg ryan
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 ?

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

[vchkpw] mysql and valias_insert()

2005-02-12 Thread James Whitt
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 settings in ports for those FreeBSD people out there)

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

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

2005-01-27 Thread David Diaz
Hi everybody: 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 display the follow error message:

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

[vchkpw] MySQL problems in 5.4.7

2004-10-26 Thread Toshihiko Kyoda
Hello, all. I've got a mysql problems, after upgrading vpopmail from 5.2.1 to 5.4.7. I'm using vpopmail with MySQL 3.23.53 on Redhat Linux. ++ +--+ | MySQL | mysql | vpopmail |+ <-- POP3 | server |<--| server || <-- SMTP ++ +--+|

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

[vchkpw] MySql load causes bounced mail

2004-10-21 Thread Jason Wilkinson
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 MySql connections. We are currently workin

[vchkpw] mysql and valias

2004-09-16 Thread Dave Goodrich
Good morning, I am happy to say that I think I understand how dir_control works in mysql. I do not understand the use of every field but the fields that have an effect I di understand. I will try to get something together in the next for anyone interested. My question, valias, anyone using 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

[vchkpw] MySQL logging

2004-08-24 Thread Maurice Snellen
Listmembers: I've got sql logging enabled on my server and recently noticed that this leads to a rather large table and there doesn't seem to be a utility or command to clear the logging table given a timeframe of log that should be kept, like with logrotate. Have I overlooked something? What are

Re: [vchkpw] dumb question - courier/vchkpw/mysql

2004-08-11 Thread Jeremy Kitchen
On Wednesday 11 August 2004 03:20 pm, Paul Theodoropoulos wrote: > okay, hopefully this isn't too stupid a question. > > i'm needing to upgrade courier-imap. my vpopmail has been running off mysql > backend forever. when i configure courier, should i still use > --with-authvchkpw, or does my use of

[vchkpw] dumb question - courier/vchkpw/mysql

2004-08-11 Thread Paul Theodoropoulos
okay, hopefully this isn't too stupid a question. i'm needing to upgrade courier-imap. my vpopmail has been running off mysql backend forever. when i configure courier, should i still use --with-authvchkpw, or does my use of mysql mean it would be more direct to just use --with-authmysql? (i'm a

[vchkpw] MySQL v4.1.x support?

2004-07-22 Thread Oden Eriksson
Hi. I was wondering if latest vpopmail devel version works with MySQL 4.1.3? Anyone tried it? -- Regards // Oden Eriksson

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

[vchkpw] mysql dir_control table

2004-07-16 Thread Dave Goodrich
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 are all going to the domain root. We have one domain with 4557 users and si

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: '.

[vchkpw] mysql help

2004-05-19 Thread Mark Matrafajlo
> 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: './vpopmail/dir_control.frm' (errno: 13) > Error. Failed while

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

[vchkpw] MySQL error messages & vpalias.c

2004-05-06 Thread Rick Widmer
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 the extension. I w

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

[vchkpw] MySQL / LDAP

2004-05-06 Thread Edward Neville
Can someone direct me to a descent site that compares or details how to install LDAP and/or MySQL with Qmail please?

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

[vchkpw] mysql aliases

2004-04-23 Thread Werner Amon
Hi, Is it possible to convert .qmail-name files automaticly in mysql tables? Werner

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 t

[vchkpw] mysql vlog

2004-04-22 Thread Jeff Koch
Our mysql vlog database seems to growing very large and now I'm not sure we even need it. Is there any way of stopping the vlogging without re-compiling vpopmail? I know we can go into mysql and delete records but since we are going to start replication we don't want the vlog transactions in th

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

[vchkpw] mysql-auth replicated databases

2004-04-21 Thread Jeff Koch
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 mailserver and, at peaks loads, has started bouncing

  1   2   3   >