[vchkpw] [SPAM] vadduser does not check valias table nor .qmail file

2012-08-14 Thread xaf
hi all, if i've a .qmail-user file or a row in valias table with this user qmailadmin does not permit to create a pop account for this user but vadduser does (and therefore vqadmin) vadduser, vdeluser don't delete the row in valias table troubles are create user and delete it with fo

[vchkpw] [SPAM] Check data in dir_control table

2012-07-31 Thread Alessio Cecchi
Hi, after a migration, based on mysqldump and rsync, I think I've corrupted the dir_control table in vpopmail database (I'm using mysql). The row total in my dir_control are 1220 but the total number of domain hosted in the email server are about 1300. How can I rebuild or check

Re: [vchkpw] add AuthType to lastauth table

2010-11-09 Thread Rick Romero
field 'type' char(10), and puts the text AuthType in >> there.  I'm not sure if a table change is handled via README or automated.. >> - It also adjusts the vget_lastauth to grab the 'latest' record for that >> user from the lastauth table, no m

Re: [vchkpw] add AuthType to lastauth table

2010-11-09 Thread Matt Brookings
and how the system is utilized > overall. > > I attached a patch and honestly I haven't even tested yet - just thought > I'd throw it out there.. > > - It utilizes a new field 'type' char(10), and puts the text AuthType in > there. I'm not sure i

[vchkpw] add AuthType to lastauth table

2010-11-09 Thread Rick Romero
- just thought I'd throw it out there.. - It utilizes a new field 'type' char(10), and puts the text AuthType in there.  I'm not sure if a table change is handled via README or automated.. - It also adjusts the vget_lastauth to grab the 'latest' record for that use

Re: [vchkpw] Vpopmail-5.5.0 with MySQL and vpopmail.vlog table

2010-04-15 Thread Fabrice TERRANCLE
ot; wrote: Hello all, Sorry for my English. I have a problem with vpopmail-5.5.0 and mysql when I delete an user. #/home/vpopmail/bin/vdeluser te...@mydomain.tld auth_deluser: warning: mysql_query(DELETE FROM vlog WHERE domain = 'mydomain.tld' AND user = 'test1') failed: Table

Re: [vchkpw] Vpopmail-5.5.0 with MySQL and vpopmail.vlog table

2010-04-15 Thread Remo Mattei
ain.tld > auth_deluser: warning: mysql_query(DELETE FROM vlog WHERE domain = > 'mydomain.tld' AND user = 'test1') failed: Table 'vpopmail.vlog' doesn't > exist > Failed to delete user from auth backend > Error: Illegal username > > My compilat

[vchkpw] Vpopmail-5.5.0 with MySQL and vpopmail.vlog table

2010-04-15 Thread Fabrice TERRANCLE
Hello all, Sorry for my English. I have a problem with vpopmail-5.5.0 and mysql when I delete an user. #/home/vpopmail/bin/vdeluser te...@mydomain.tld auth_deluser: warning: mysql_query(DELETE FROM vlog WHERE domain = 'mydomain.tld' AND user = 'test1') failed: Table &#x

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

Re: [vchkpw] Seems to be a problem with dir_control table

2008-02-01 Thread aledr
Hmmm... Just removed --disable-users-big-dir from my config and I got what I need. =D Regards! -- [ ]'s Aledr - Alexandre "OpenSource Solutions for SmallBusiness Problems" !DSPAM:47a309e6310541020117296!

RE: [vchkpw] Seems to be a problem with dir_control table

2008-01-04 Thread shadowplay dot net
age- > From: DAve [mailto:[EMAIL PROTECTED] > Sent: January 4, 2008 15:22 > To: vchkpw@inter7.com > Subject: Re: [vchkpw] Seems to be a problem with dir_control table > > > aledr wrote: > > Hi! > > > > I was searching for domains information in my serv

Re: [vchkpw] Seems to be a problem with dir_control table

2008-01-04 Thread DAve
aledr wrote: > Hi! > > I was searching for domains information in my servers and I realized > that when I add a domain using vadddomain it doesn't insert a new row > into dir_control table with my domain name, but vpopmail insert the > rows after I execute vmoddomain (with

[vchkpw] Seems to be a problem with dir_control table

2008-01-04 Thread aledr
Hi! I was searching for domains information in my servers and I realized that when I add a domain using vadddomain it doesn't insert a new row into dir_control table with my domain name, but vpopmail insert the rows after I execute vmoddomain (with wrong cur_users number). Is this

Re: [vchkpw] mail forwarding with valias table...

2007-11-30 Thread Cagri Ersen
chkpw@inter7.com > Sent: Fri Nov 30 07:26:01 2007 > Subject: [vchkpw] mail forwarding with valias table... > > Hi, > > I have a vpopmail server with mysql intergation. > and i need to forward a copy of some mails to another e-mail addresses... > > i googled this case and

Re: [vchkpw] mail forwarding with valias table...

2007-11-30 Thread Remo Mattei
I just use the .qmail file for that. shupp has a patch I believe that allows you to do that. but I never used it. My 2 cents. Remo Cagri Ersen wrote: > Hi, > > I have a vpopmail server with mysql intergation. > and i need to forward a copy of some mails to another e-mail addresses... > > i go

Re: [vchkpw] mail forwarding with valias table...

2007-11-30 Thread Tren Blackburn
You forgot the trailing / on Maildir :) t - Original Message - From: Cagri Ersen <[EMAIL PROTECTED]> To: vchkpw@inter7.com Sent: Fri Nov 30 07:26:01 2007 Subject: [vchkpw] mail forwarding with valias table... Hi, I have a vpopmail server with mysql intergation. and i need to f

[vchkpw] mail forwarding with valias table...

2007-11-30 Thread Cagri Ersen
Hi, I have a vpopmail server with mysql intergation. and i need to forward a copy of some mails to another e-mail addresses... i googled this case and found a solution like below. INSERT INTO valis VALUES('user','domain.com','/dir/to/Maildir'); INSERT INTO valis VALUES('user','domain.com','[EMAI

Re: [vchkpw] Re: Mysql table

2007-09-23 Thread Rick Widmer
Tom Collins wrote: I think we'll get better domain alias support if you pull column > `domain` out of table `Domains` and add it to the table `domain_alias`. I agree. This makes it easy to make sure domain names are unique. > I'm not sure we need to have a "master"

Re: [vchkpw] Re: Mysql table

2007-09-22 Thread Rick Macdougall
Rick Widmer wrote: I wasn't quite ready for this, but it has been on my list for a long time... since it has come up, let me throw up this database structure for comment. I have reduced the number of tables (in a full installation) and made it relational.- CREATE TABLE relay( ip

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Tom Collins
On Sep 21, 2007, at 4:32 PM, Rick Widmer wrote: Comments? I think we'll get better domain alias support if you pull column `domain` out of table `Domains` and add it to the table `domain_alias`. "Domain name" to "domain on the system" is a many to one relationsh

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Widmer
I wasn't quite ready for this, but it has been on my list for a long time... since it has come up, let me throw up this database structure for comment. I have reduced the number of tables (in a full installation) and made it relational.- CREATE TABLE Domains( doma

[vchkpw] Re: Mysql table

2007-09-21 Thread Robin Bowes
on the servers I manage for > clients (around 20 or so). > > The biggest installation I manage is around 18k users and I could export > that with munged domain names / passwords if you wanted something that big. It's hardly worth bothering with for ~2000 users. The difference in memory/disk use would be minimal. An 18k user table would be interesting. R.

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Macdougall
Robin Bowes wrote: Rick Macdougall wrote: Robin Bowes wrote: Tom Collins wrote: I understand what you're proposing, but I would suggest that it would add complexity for little gain. Of course, that would need benchmarking to establish which is the faster method. If someone can give me a large

[vchkpw] Re: Mysql table

2007-09-21 Thread Robin Bowes
Rick Macdougall wrote: > Robin Bowes wrote: >> Tom Collins wrote: >> >> I understand what you're proposing, but I would suggest that it would >> add complexity for little gain. Of course, that would need benchmarking >> to establish which is the faster method. >> >> If someone can give me a large d

Re: [vchkpw] Re: Mysql table

2007-09-21 Thread Rick Macdougall
Robin Bowes wrote: Tom Collins wrote: I understand what you're proposing, but I would suggest that it would add complexity for little gain. Of course, that would need benchmarking to establish which is the faster method. If someone can give me a large dataset, I'm happy to crunch some numbers.

[vchkpw] Re: Mysql table

2007-09-21 Thread Robin Bowes
Tom Collins wrote: > 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,

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

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.

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.

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 desi

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

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
:~ # vadddomain a.com Please enter password for postmaster: enter password again: qmail-newu: fatal: bad format in users/assign vmysql: error creating table 'a

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
:~ # vadddomain a.com Please enter password for postmaster: enter password again: qmail-newu: fatal: bad format in users/assign vmysql: error creating table 'aaaaa_co

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

[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

Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist

2006-10-18 Thread Bert JW Regeer
On Oct 18, 2006, at 03:24:42 MST, Jarkko Ranta wrote: Bert JW Regeer kirjoitti: On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, w

Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist

2006-10-18 Thread Jarkko Ranta
Bert JW Regeer kirjoitti: On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes t

Re: [vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist

2006-10-18 Thread Bert JW Regeer
On Oct 18, 2006, at 02:45:12 MST, Jarkko Ranta wrote: Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the

[vchkpw] authdaemond: vmysql: sql error[3]: Table 'vpopmail.testi_com' doesn't exist

2006-10-18 Thread Jarkko Ranta
Hello, I'm in need of a bit of advice: I first installed vpopmail-5.4.13 with the many domains option (own table for each virtual domain). Now, when I installed vpopmail-5.4.17 so that each domain goes to the table vpopmail.vpopmail, thinks get wrong. (I even removed whole /home/vpo

RE: [vchkpw] Vpopmail with existing user table

2006-06-28 Thread Tren Blackburn
Should be fairly easy to do. You'll need to extend your table with the necessary fields that vpopmail uses. Assuming you're using MySQL, here is the default schema that vpopmail uses: +-+---+--+-+-+---+ | Field | Type |

[vchkpw] Vpopmail with existing user table

2006-06-28 Thread Luciano Bolonheis
Hi, i'm installing qmail+vpopmail+etc. and I want to know if can I use an existing users table (the used to authenticate in my Intranet) with vpopmail... So, vpopmail should check user and password from this other table instead of a new one. Is it possible... Thanks. Luciano Bolonheis

Re: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Tom Collins
On Nov 4, 2005, at 7:10 AM, Ken Jones wrote: I would try putting /var/qmail/queue on the ramdisk since you have the RAM already. Does the OS back up the ramdisk to a physical disk on shutdown? If not, and you have to reboot your server (or if it goes down for maintenance), you'll lose any qu

RE: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Nicholas Harring
> > What if I put qmails queue to ramdisk (or tmpfs ramdisk) ? (memory cards > ? > > are good enough ?) > > I would try putting /var/qmail/queue on the ramdisk since you have the > RAM already. > > I would also comment out the fsync() calls in the qmail source code. > If you're going to do this,

Re: [vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-04 Thread Ken Jones
Szeki - Inc wrote: Hi, It is a good idea to use heap tables for vpopmail query-s ? MyISAM tables for UPDATES, and HEAP for selects (they will be created from MyISAM)? I wanna to minimalize the disk subsystem impact. System is always waiting for disks(big load, can even reach 20-25). What is th

[vchkpw] ramdisk with ext2 or tmpfs, vpopmail mysql - heap table : performance - too big disk load

2005-11-03 Thread Szeki - Inc
Hi,   It is a good idea to use heap tables for vpopmail query-s ? MyISAM tables for UPDATES, and HEAP for selects (they will be created from MyISAM)? I wanna to minimalize the disk subsystem impact. System is always waiting for disks(big load, can even reach 20-25). What is the ideal maximum

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-16 Thread mark
Thanks for the note. I was able to change vpopmail.php in passwd module to allow passwords change in the "one table per domain configuration". I will continue using it. Quoting Tom Collins <[EMAIL PROTECTED]>: > On May 12, 2005, at 12:13 PM, [EMAIL PROTECTED] wrote: > &

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-15 Thread Tom Collins
On May 12, 2005, at 12:13 PM, [EMAIL PROTECTED] wrote: Thanks for confirming that. I was able to create a single vpopmail table running "make distclean" first. (Thanks to Tom Collins response). After that my qmailadmin stopped authenticating as well as imp, even the user was there an

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-12 Thread Chris Godwin
5.5.3 does - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, May 12, 2005 2:13 PM Subject: Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table > Thanks for confirming that. > I was able to create a single vpopmail ta

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-12 Thread mark
Thanks for confirming that. I was able to create a single vpopmail table running "make distclean" first. (Thanks to Tom Collins response). After that my qmailadmin stopped authenticating as well as imp, even the user was there and password was correct and all services were up. I rolled b

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-12 Thread Chris Godwin
of course

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-11 Thread mark
ED] wrote: > > I'm trying to configure vpopmail to create a single vpopmail table in > > mysql. > > I installed 5.4.10 version and whatever I'm trying to do, it is still > > creates a > > individual table per domain. > > config.h has MANY_DOMAINS 1 setup

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-11 Thread mark
Thanks, I will try. Quoting Tom Collins <[EMAIL PROTECTED]>: > On May 11, 2005, at 8:18 AM, [EMAIL PROTECTED] wrote: > > I'm trying to configure vpopmail to create a single vpopmail table in > > mysql. > > I installed 5.4.10 version and whatever I'm tr

Re: [vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-11 Thread Tom Collins
On May 11, 2005, at 8:18 AM, [EMAIL PROTECTED] wrote: I'm trying to configure vpopmail to create a single vpopmail table in mysql. I installed 5.4.10 version and whatever I'm trying to do, it is still creates a individual table per domain. config.h has MANY_DOMAINS 1 setup. Do a `make

Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-11 Thread Chris Godwin
Wierd. - Original Message - From: "Dirk Tanneberger" <[EMAIL PROTECTED]> To: Sent: Wednesday, May 11, 2005 3:19 AM Subject: Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias' > when i do "SELECT * FROM valias;" on v

[vchkpw] VPOPMAIL 5.4.10 configuration doesn't create a single vpopmail table

2005-05-11 Thread mark
I'm trying to configure vpopmail to create a single vpopmail table in mysql. I installed 5.4.10 version and whatever I'm trying to do, it is still creates a individual table per domain. config.h has MANY_DOMAINS 1 setup.

Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-11 Thread Dirk Tanneberger
PROTECTED] | There is no problem. I can get data from valias-table. When i do "valias -s [EMAIL PROTECTED]", i see the following: [EMAIL PROTECTED] -> [EMAIL PROTECTED] This looks also ok. regards Dirk Am 10.05.2005 18:51 schrieb Chris Godwin: My first action would be to login to th

Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-10 Thread Chris Godwin
berger" <[EMAIL PROTECTED]> To: Sent: Tuesday, May 10, 2005 10:05 AM Subject: Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias' > > Well it is clear what the problem is. Have you granted privilages to the > > user vpopmail in your mysql d

Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-10 Thread Dirk Tanneberger
o do this. He has only the rights for read and write in the table. This should be enough for an incoming only server, or? I'm wondering what is the reason that vmysql will create this table? The only tool that works during the smtp-session is chkuser, or? regards Dirk Tanneberger Am 10.05.2005

Re: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-10 Thread Chris Godwin
Subject: [vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias' > hello, > > i'm using a server for incoming mail only, with the following software: > - netqmail-1.05 > - vpopmail-5.4.10 with mysql-server on other host > - chkuser-2.0.8b-rele

[vchkpw] undefined entry in smtpd-log - vmysql: error creating table 'valias'

2005-05-10 Thread Dirk Tanneberger
ias=y --enable-auth-logging=y --disable-passwd --disable-md5-passwords in my smtpd-log i see sometimes a entry like this: + @400042804ea611514bd4 vmysql: error creating table 'valias': create command denied to user: '[EMAIL PROTECTED]' for table 'valias&#x

[vchkpw] empty mysql tables / update vpopmail table directly?

2005-03-28 Thread ax
rrently running v5.5.0). 1. Is it ok to update the vpopmail table directly, such as to set a quota for an entire domain by e.g. "update vpopmail set pw_shell='NOQUOTA' where pw_domain='foo.com'", or are there side-effects of the vsetuserquota command that ma

[vchkpw] Vlog Table

2005-02-02 Thread Tom
Hi! Does anyone have a nice routine to truncate the vlog table in MySQL they can share? Mine is rather larg. Not sure if vpopnail maintains this table or not.TIA!!-- Regards,Tom

Re: [vchkpw] vlog Table

2004-10-19 Thread Jeremy Kitchen
On Tuesday 19 October 2004 08:28 am, Lucas G. Obredor wrote: > Hi everyone, > I have qmail + vpopmail + mysql on a red hat 8.0, > the thing is that i don't want to save all the logs in vlog table in mysql, > is this possible ?. vlog is not enabled by de

[vchkpw] vlog Table

2004-10-19 Thread Lucas G. Obredor
Hi everyone,     I have qmail + vpopmail + mysql on a red hat 8.0, the thing is that i don't want to save all the logs in vlog table in mysql, is this possible ?.                           Thank you a lot.     Lucas G. ObredorSistemas División Banda AnchaTel. 4469

[vchkpw] relay table issue

2004-09-21 Thread kengheng
Hi All, I've a qmail+vpopmail+mysql+roaming installation on a A server. I've up another B server (qmail smtp only) that wish to connect to A server to check for the relay table for validating users who send emails to B servers. What options I need to set at the B server? Thanks

Re: [vchkpw] mysql dir_control table

2004-07-20 Thread Dave Goodrich
ctory split but are all going > to the domain root. We have one domain with 4557 users and since > converting to mysql the last 177 users have been created in the domain > root. > > I first thought I had compiled somthing incorrectly but reviewing it > doesn't seem so. I not

[vchkpw] mysql dir_control table

2004-07-16 Thread Dave Goodrich
since converting to mysql the last 177 users have been created in the domain root. I first thought I had compiled somthing incorrectly but reviewing it doesn't seem so. I notice that the dir-control table was not updating when new users were added. In fact the largest domain (4558 users) sho

[vchkpw] -Table 'vpopmail.relay' doesn't exist-db_close() called!

2004-02-29 Thread Radu Bighiu
I have this error in /var/loq/qmail/smtp: -Table 'vpopmail.relay' doesn't exist-db_close() called! How can i create 'vpopmail.relay' table? or what is that error? Thanks!

[vchkpw] where can I find qmail mysql database table structure?

2004-02-26 Thread Raymond
HI Could anyone send me the qmail Mysql database tables structure? I am a realy new user to learn qmail. Thanks, Raymond

RE: [vchkpw] where can I find qmail mysql database table structure?

2004-02-26 Thread Shane Chrisp
nt of Qmail. For more information on Qmail with Sql, see the qmail home page http://www.qmail.org Shane >-Original Message- >From: Raymond [mailto:[EMAIL PROTECTED] >Sent: Friday, 27 February 2004 11:53 AM >To: [EMAIL PROTECTED] >Subject: [vchkpw] where can I find qmail

答复: [vchkpw] where can I find qmail mysql database table structure?

2004-02-26 Thread Raymond
HI Shan, Thank for you reply. Where can I find Vpopmail database schema. If you have, would you like to send it to me? Regards, Raymond Shane Chrisp [mailto:[EMAIL PROTECTED] RE: [vchkpw] where can I find qmail mysql database table structure? Qmail itself doesn't use mysql. There i

[vchkpw] Re: Vpopmail MySQL Table Layouts

2004-01-19 Thread Thomas Smith
Jeff Koch writes: Are the MySQL table layouts documented anywhere? I went all through the doc's and source but maybe someone could give me a pointer please. Thanks Have you looked in the source directory? There's a file called README.mysql. It refers to another file called vmys

[vchkpw] Vpopmail MySQL Table Layouts

2004-01-17 Thread Jeff Koch
Are the MySQL table layouts documented anywhere? I went all through the doc's and source but maybe someone could give me a pointer please. Thanks Best Regards, Jeff Koch

Re: [vchkpw] customizing mysql table

2003-11-12 Thread jean
t want to do it at first because its a complex system with over 20mb of php files (not only for webmail). Anyway, i'd like to make a suggestion for the vpopmail developers: to user some kind of mysql.conf table where the user can customize the layout. I've seen this in some other

Re: [vchkpw] customizing mysql table

2003-11-12 Thread Hugo Cisneiros
grate the old database to the "new" server (using vpopmail), and my question is: Is it possible to easily customize (change table name,user column name, etc) the mysql table which vpopmail will use to authenticate? Do I have to change anything else besides vmysql.h? I already did this, on

Re: [vchkpw] customizing mysql table

2003-11-12 Thread X-Istence
e the old database to the "new" server (using vpopmail), and my question is: Is it possible to easily customize (change table name,user column name, etc) the mysql table which vpopmail will use to authenticate? Do I have to change anything else besides vmysql.h? thanks in advance, Jw

[vchkpw] customizing mysql table

2003-11-12 Thread jean wainer
o the "new" server (using vpopmail), and my question is: Is it possible to easily customize (change table name,user column name, etc) the mysql table which vpopmail will use to authenticate? Do I have to change anything else besides vmysql.h? thanks in advance, Jw

Re: [vchkpw] password generation - vpopmail table - pw_passwd

2003-10-26 Thread Michael Bowe
> I want to generate just the > password so that I can insert it > solely into the vpopmail mysl-database. > > I other words I don´t want to make ./vadduser ... first, I just want > generate thi user in my database. If you are doing it via PHP you can follow these notes : http://bluedot.net/mail/

[vchkpw] Re: password generation - vpopmail table - pw_passwd

2003-10-24 Thread Paul L. Allen
t that user's password. Copy the crypted password in /etc/shadow into your MySQL table. It's relatively painless to do and guarantees good entropy on the salt if you happen to need it. You could even automate it with a little perl if you're feeling lazy. Which reminds me. I hav

Re: [vchkpw] password generation - vpopmail table - pw_passwd

2003-10-24 Thread Justin Heesemann
On Friday 24 October 2003 10:57, Oliver Etzel - GoodnGo.COM (R) wrote: > Hello Remo, hello all, > > I know that vadduser will do that, but I want to generate just the > password so that I can insert it > solely into the vpopmail mysl-database. > > I other words I don´t want to make ./vadduser ...

Re: [vchkpw] password generation - vpopmail table - pw_passwd

2003-10-24 Thread Oliver Etzel - GoodnGo.COM \(R\)
, Oliver > Vadduser -r > With the new version that will generate the passwd for the user. > > Remo > Hello list, > > I have vpopmail -with-mysql installation. > > In which way passwords are storedin the vpopmail table under > pw_passwd? > > How can I gene

[vchkpw] Re: [toaster] password generation - vpopmail table - pw_passwd

2003-10-23 Thread Tom Collins
On Thursday, October 23, 2003, at 03:47 PM, GoodnGo.de ((R)) Zentrale wrote: How can I generate such passwords from commandline? Use the vpasswd program (installed to ~vpopmail/bin/). -- Tom Collins - [EMAIL PROTECTED] Note: The Tom Logic offices will be closed October 23 to November 18. Qmail

[vchkpw] password generation - vpopmail table - pw_passwd

2003-10-23 Thread Oliver Etzel - GoodnGo.COM \(R\)
Hello list, I have vpopmail -with-mysql installation. In which way passwords are storedin the vpopmail table under pw_passwd? How can I generate such passwords from commandline? Regs, Oliver Etzel

Re: [vchkpw] mysql relay table frustrations

2003-09-26 Thread Joseph Kacmarcik
> apply this patch to your courier-imap source tree and add > "-DHAVE_OPEN_SMTP_RELAY -DHAVE_VLOGAUTH" to your CFLAGS when you compile > it. > let me know how it goes.. most excellent! this works great! thanks! (: i've read about this patch, but hadn't found it anywhere. now it's on the list fo

Re: [vchkpw] mysql relay table frustrations

2003-09-26 Thread Brah Mon
/ipv6 enabled imap server then the mysql enabled tcpserver is a pain in the rectum) plain vpopmail-5.3.X series is ready to go in this department, however a patch needs to be applied to courier-imap. you can verify this by looking for the existence of a vpopmail.relay table.. if you have the

Re: [vchkpw] mysql relay table frustrations

2003-09-25 Thread Flavio Curti
Hello On Thu, Sep 25, 2003 at 03:55:45PM +1000, Michael Bowe wrote: > If you are using Matt Simerson's tcpserver patch, then I would imagine that > you wouldn't use the "-x /path/tcp.smtp.cdb" switch in the tcpserver run > script (because this information is stored in MySQL by the -S switch) You c

Re: [vchkpw] mysql relay table frustrations

2003-09-24 Thread Michael Bowe
t;[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 1:14 PM Subject: [vchkpw] mysql relay table frustrations > hi list! > > so... i've read a number of posts, looked in a number of places, compiled > and recompiled numerous times, but i can't get qmail/vpopmail/couri

Re: [vchkpw] mysql relay table frustrations

2003-09-24 Thread Joseph Kacmarcik
> I cant help you on the problem about it not adding entries, but have you > considered using a qMail auth patch for outgoing, so clients can AUTH to > send mail. This would do the same thing, and would work as you intended, > to let someone relay. haven't really considered it. the more i think a

Re: [vchkpw] mysql relay table frustrations

2003-09-24 Thread X-Istence
Joseph Kacmarcik wrote: hi list! so... i've read a number of posts, looked in a number of places, compiled and recompiled numerous times, but i can't get qmail/vpopmail/courier on linux to write to an sql relay table. everything works except this part. i can authenticate and receive

[vchkpw] mysql relay table frustrations

2003-09-24 Thread Joseph Kacmarcik
hi list! so... i've read a number of posts, looked in a number of places, compiled and recompiled numerous times, but i can't get qmail/vpopmail/courier on linux to write to an sql relay table. everything works except this part. i can authenticate and receive via pop or imap, and eithe

[vchkpw] Limits Table

2003-07-22 Thread Widmer Hannes
HI List I have a question about the limits witch can be set up in a mysql table. So, i did the installation with the limits in a mysql Table called limits. Now, I'm hosting also other domains for my friends and I d'like to give them the administrativ account to set the quotas o

[vchkpw] error on table relay suggestions

2003-07-12 Thread Remo Mattei
@40003f10e2a524d5a63c -Table 'vpopmail.relay' doesn't exist-db_close() called! @40003f10e2a524d5cd4c db_ping() is re-calling open_db! Anyone has any suggestions why this relay did not get created? What's the options I need to create this relay table on vpopmail. Th

Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

2003-06-12 Thread Jeff Hill
/2003 +1000, Michael Bowe wrote: - Original Message - From: "Jeff Hill" <[EMAIL PROTECTED]> To: "vpopmail list" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 11:12 AM Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions? > I'm work

Re: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

2003-06-12 Thread Michael Bowe
- Original Message - From: "Jeff Hill" <[EMAIL PROTECTED]> To: "vpopmail list" <[EMAIL PROTECTED]> Sent: Friday, June 13, 2003 11:12 AM Subject: [vchkpw] Adding Users Directly to the MySQL Table: Suggestions? > I'm working on adding users direc

[vchkpw] Adding Users Directly to the MySQL Table: Suggestions?

2003-06-12 Thread Jeff Hill
I'm working on adding users directly to the mysql tables. It appears from the list archive that this is reasonable, but I'm not certain if there's any catch? I've played around with it a bit, and I can't see any particular problems with my few tests. Has anyone actually done this? Is it better

[vchkpw] dir-control table does not exist

2003-06-11 Thread Jonas Thomsen
Hi! I've just migrated from vpopmail 5.2.1 using CDB til vpopmail 5.3.21 using MySql. On my testserver this went just fine, but when I did the same on the production server, dir-control is somehow lost. There is no 'dir-control' table in the database. Everything works fine (as f

SV: [vchkpw] dir-control table does not exist

2003-06-11 Thread Jonas Thomsen
> I've just migrated from vpopmail 5.2.1 using CDB til vpopmail > 5.3.21 using MySql. On my testserver this went just fine, but > when I did the same on the production server, dir-control is > somehow lost. There is no 'dir-control' table in the database. > Ever

  1   2   >