Re: [vchkpw] vpopmail + dovecot

[Sergio Rosa]

Matt,

i've some posts you made regarding using the vpopmail driver, however i 
found nothing explaining how to do it. I did a lot of googling but 
whitout success (or right search words).


Can you detail/explain how to use/configure it?

Thank you

On 17/02/2011 00:12, Matt Brookings wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 2/16/2011 6:09 PM, Sergio Rosa wrote:

and awd-conf.ext
driver=mysql

Use the vpopmail driver.
- -- 
/*

 Matt BrookingsGnuPG Key FAE0672C
 Software developer Systems technician
 Inter7 Internet Technologies, Inc. (815)776-9465
*/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk1cZ9MACgkQIwet2/rgZyx5eQCfUGWBxX+1Tt39q1hT4QJEU88H
wZgAnRD6ctpblpHTrEr6JHwcS1iwM62D
=AwAG
-END PGP SIGNATURE-




--
*AWD
*arquitectura web e design, lda
rua do moinho velho, 19 2ºdto
2655-242 ericeira

tlm +351 913 489 195
mail sergior...@awd.pt <mailto:sergior...@awd.pt>
url http://www.awd.pt <http://www.awd.pt/>


!DSPAM:4d5c6fdd32711918854278!

[vchkpw] vpopmail + dovecot

[Sergio Rosa]

Hi all,

i'm near insanity trying to config dovecot as imap server.

I'm running vpopmail 5.4.26 with mysql backend. It seems impossible to 
get dovecot 2.0.9 to work.


My dovecot.conf contains just this:
protocols = imap
!include conf.d/00-awd.conf

and 00-awd.conf contains:
auth_mechanisms = plain
log_path = syslog
syslog_facility = mail
auth_verbose = yes
auth_debug = yes
mmap_disable = yes
mail_fsync = always
mail_nfs_storage = yes
mail_nfs_index = yes
default_login_user = dovenull
default_internal_user = dovecot

service imap-login {
  inet_listener imap {
port = 143
  }
}
ssl = no
!include awd-conf.ext

and awd-conf.ext
driver=mysql

connect = host=localhost dbname=vpopmail user=vuser password=vpass

default_pass_scheme = PLAIN

password_query = SELECT CONCAT(pw_name, '@', pw_domain) AS user, \
  pw_clear_passwd AS password \
  FROM vpopmail \
  WHERE pw_name = '%n' AND pw_domain = '%d'

user_query = SELECT pw_dir as home, \
  89 AS uid, 89 AS gid \
  FROM vpopmail \
  WHERE pw_name = '%n' AND pw_domain = '%d'

but dovecot complains that driver= mysql is Unknow.

Dovecot was compiled with --mysql --vpopmail

Please help.

Thanks,
sergio rosa


!DSPAM:4d5c672832711248615606!

Re: [vchkpw] incoming mails from vpopmail to exchange

[Sergio Rosa]

Hi Valt,

you should use de IP address of the exchange server.

If the exchange server is behind a pix, than the pix must accept 
incoming connections to the ip address that is used to nat the server or 
if it's doing pat than it should accept the traffic on his own address.


Hope this helped.

Regards,
Sérgio Rosa

[EMAIL PROTECTED] wrote:

I was change smtproutes file with :

domain1.com:10.10.10.10

where ip 10.10.10.10  is cisco pix ip adress

but i'ts not working !! :(


valts


Citējot: Rick Macdougall <[EMAIL PROTECTED]>:

  

[EMAIL PROTECTED] wrote:


Hi

I have external mailserver ( free bsd ) with qmail + vpopmail software and
  

i


need configure external mail server to forward all incoming mail messages
  

to


the internal ms exchange server. between servers i have cisco pix firewall
  

with


open incoming smtp port from external mail server !!
both mailservers have the same domain name.



  
Use smtproutes to forward (lok on www.lifewithqmail.org for more 
information).



domain1.com:exchange.domain1.com

Where domain1.com is your incoming domain and exchange.domain1.com 
resolves to the IP address of your internal smtp port.


Regards,

Rick











-
TVNET - Zinu adresse :: http://www.tvnet.lv






  


--
*AWD
*arquitectura web e design, lda
rua do moinho velho, 19 2^(o)dto
2655-242 ericeira

tlm +351 913 489 195
mail [EMAIL PROTECTED] 
url http://www.awd.pt



!DSPAM:48e3830c3231699680!

[vchkpw] vpopmail 5.4.25 + mysql + dovecot

[Sergio Rosa]

Hi all,

I'm stucked with this setup. I'm unable to authenticate through 
imap/imaps on my mysql backend.


I'm using dovecot 1.1.2.

Can anyone post a dovecot.conf /dovecot-mysql.conf that works with this 
type of setup.


Thanks,
Sérgio Rosa




!DSPAM:48b8826f32316647012158!

[vchkpw] Alias problem

[Sergio Rosa]

Hi All,

I need help on this matter it's turning into a big problem.

I'm running Bill Shupp toaster (thanks Bill).

I'm able o deliver mail do the account but not the de alias.

If I run ~vpopmail/bin/valias -i [EMAIL PROTECTED] [EMAIL PROTECTED] it inserts the 
alias into the VPOPMAIL.VALIAS table, If I delete it is removed.


When I try to send an e-mail to [EMAIL PROTECTED] I get the chkuser 550, 550 
5.1.1 sorry, no mailbox here by that name (chkuser).


This is new to me ans over the entire time I runned qmail+vpopmail+mysql 
and stuff I never had this problem.


What might be causing this?

Thanks,
Sergio Rosa




!DSPAM:487b838a32356967356571!

[vchkpw] What are you using to plot graphs

[Sergio Rosa]

Hi all,

I need to plot graphs on the occupation of our systems.

I've read about qmrtg (http://dev.publicshout.org/qmrtg/)  and they 
announce that qmailmrtg is not state full and qmrtg is.


It seems that qmrtg development is stopped.

So, what are you guys using for data collection of smtp, pop, clam, 
spam, total messages, etc, etc on your systems?


Thanks for your time.

Sergio


!DSPAM:481f9510120503040020764!

Re: [vchkpw] Delete all incoming mail for a user or domain

[Sergio Rosa]

Shane, thanks.

the .qmail should be placed in the user Maildir? or where?

thakns,
srosa

Shane Chrisp wrote:

  On Sat, 2005-11-19 at 16:09 +, Sergio Rosa wrote:
  
  
Hi,

I need to delete all incoming mail that arrives to a particular [EMAIL PROTECTED]

How can I do that? Should I alias all mail to that user to another 
domain and the create  a bounce-all-delete or there is a much cleaner 
and faster way to do that?

I'm running vpopmail 5.4.10 + qmail-scanner+clamd+spamassasin+qmailadmin 
1.2.9

Thanks,
srosa

  
  

Simply create a .qmail file with a "#" in it.

Shane

  



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

[vchkpw] Delete all incoming mail for a user or domain

[Sergio Rosa]

Hi,

I need to delete all incoming mail that arrives to a particular [EMAIL 
PROTECTED]

How can I do that? Should I alias all mail to that user to another 
domain and the create  a bounce-all-delete or there is a much cleaner 
and faster way to do that?


I'm running vpopmail 5.4.10 + qmail-scanner+clamd+spamassasin+qmailadmin 
1.2.9


Thanks,
srosa

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

Re: [vchkpw] vpopmail and mysql problem

[Sergio Rosa]

Hi,

increase the max_connections = 250 variable in my.cnf.

I had the same problem and this worked for me.

regards,
srosa


Wes Hegge wrote:


Hello everyone,

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

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

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

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

Qmail, daemontools, and tcuspi is installed.

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

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

I cannot figure out what the problem is.

Any help would be greatly appreciated.
 

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

Re: [vchkpw] vpasswd deleted

[Sergio Rosa]

Hi,
to recover I don't know. Bu I would try do create a new vpasswd file 
without any password. And if you have vpopmail with the 
--auto-learn-passwords option built into than you probably  be ok.


Regards
srosa

WAEL ELLOUZE wrote:


Greetings,
I  had vpopmail running with cdb, and i have accidently deleted a file
/home/vpopmail/domains/domain.com/vpasswd (not vpasswd.cdb).
Can anyone help me how to recover this file.

Thanks in advance





 

[vchkpw] Vpopmail + MySQL, Advise needed.

[Sergio Rosa]

Hi all,



I  had vpopmail running with cdb, upgraded to vpopmail with MySQL but
did a bad choice! I configure it without (the default) support for many
domains.

How can I convert my configuration, from one table per domain to a new
configuration of one column by domain?

I need to change things on my server because I now have a lot more
domains that I had a few weeks before.

BTW I'm running vpopmail 5.4.10 with the followinf config:
./configure \
--enable-clear-passwd \
--enable-learn-passwords \
--enable-domainquotas \
--disable-password \
--enable-logging=y \
--enable-valias \
--enable-mysql-limits \
--disable-many-domains \
--enable-auth-module=mysql \
--enable-sql-logging

on a Fedora Core 1 and a rpm build of MySQL 4.0.20, plus a lot of other
things like clamd, spamassassin, apache, and so on...

I only have this server and a down time is not welcome by the Clients.

Recently my sql server "Gone away!" for a while and it cause a big
trouble on mail delivery.

Thanks
SRosa