Dear all,
I am trying to install a toaster and got into an issue with vpopmail after
issuing make command
gcc -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -Xlinker -R
-Xlinker /var/lib/mysql -L/var/lib/mysql -lmysqlclient -lz -lm -lcrypt
/usr/bin/ld: cannot find -lmysqlclient
collect2
On 20/03/2013 10:30 AM, Nicholas C. wrote:
Dear all,
I am trying to install a toaster and got into an issue with vpopmail
after
issuing make command
gcc -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -Xlinker -R
-Xlinker /var/lib/mysql -L/var/lib/mysql -lmysqlclient -lz -lm
-lcrypt
snip
Can you send us rpm -qa |grep -i mysql
I guess mysql 5.5.30 is installed from an additional repo, since
RHEL/Centos6 come with 5.1.67?
In this case check for mysql-shared-compat rpm and install it.
Thanks Todor. Below is the result
[root@localhost vpopmail-5.4.33]# rpm -qa |grep -i
Il 20/03/2013 09:30, Nicholas C. ha scritto:
Dear all,
I am trying to install a toaster and got into an issue with vpopmail after
issuing make command
gcc -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -Xlinker -R
-Xlinker /var/lib/mysql -L/var/lib/mysql -lmysqlclient -lz -lm -lcrypt
snip
Have you install mysql-devel rpm?
Is your configure similar to
./configure --enable-mysql-limits --enable-auth-module=mysql
--enable-libdir=/usr/lib64/mysql/
Thanks Alessio for your reply.
Yes I do have devel package installed.
Package mysql-devel-5.5.30-1.el6.remi.x86_64 already
On 20/03/2013 11:57 AM, Nicholas C. wrote:
snip
Can you send us rpm -qa |grep -i mysql
I guess mysql 5.5.30 is installed from an additional repo, since
RHEL/Centos6 come with 5.1.67?
In this case check for mysql-shared-compat rpm and install it.
Thanks Todor. Below is the result
[root
snip
Can you send us rpm -qa |grep -i mysql I guess mysql 5.5.30 is
installed from an additional repo, since
RHEL/Centos6 come with 5.1.67?
In this case check for mysql-shared-compat rpm and install it.
Thanks Todor. Below is the result
[root@localhost vpopmail-5.4.33]# rpm -qa |grep -i
On Wed, Mar 20, 2013 at 3:30 AM, Nicholas C. nicholasc...@outlook.com wrote:
Dear all,
I am trying to install a toaster and got into an issue with vpopmail after
issuing make command
gcc -o vchkpw vchkpw.o md5.o hmac_md5.o libvpopmail.a -Xlinker -R
-Xlinker /var/lib/mysql -L/var/lib
I have install vpopmail without mysql. I want to install courier-imap. Can any
body please tell me that courier-imap will also be configured without mysql or
with mysql In the end I have to install roundcube.
Regards,
Salman...
Date: Sat, 21 May 2011 07:22:49 -0500
From: supp
On Sunday 22 May 2011, Salman Riaz wrote:
I have install courier imap without mysql but roundcube is not working
fine...
Do yourself a favour and install dovecot instead of courier-imap.
That will work with roundcube, squirrelmail etc.
Regards,
Salman...
From: salmanriaz
Subject: Re: [vchkpw] vpopmail without mysql
On Sunday 22 May 2011, Salman Riaz wrote:
I have install courier imap without mysql but roundcube is not working
fine...
Do yourself a favour and install dovecot instead of courier-imap.
That will work with roundcube, squirrelmail etc
] vpopmail without mysql
There was php-version issue Now successfully installed roundcube All
things are working fine
But qmailadmin is not working I am unable to login qmailadmin
Regards,
Salman...
From: hutchli...@midwales.com
To: vchkpw@inter7.com
Date: Sun, 22 May
That information is stored in a file named vpasswd which lives in the
root folder of the domain.
For example, ~/vpopmail/domains/yourdomain/vpasswd
It uses a similar format to /etc/passwd.
Trey Nolen
On 05/20/2011 11:26 PM, Salman Riaz wrote:
Dear Team,
I am installing Qmail without mysql
Dear Team,
I am installing Qmail without mysql. I want to know where user information will
be stored as well as passwords..
Regards,
Salman...
!DSPAM:4dd73ede32712903919615!
Dear All,*
*
i want to add few fields like pw_popenable , pw_imapenable
use of these fields will be
like for some user i want to disable pop3
and for few user disable imap
please suggest me how to start, i will have to modify
vusersinfo
adduser
cheking password
qmailadmin field etc
Regards
From a command line try :
mysql -hYOUR-REMOTE-HOST -uYOUR-MYSQL-LOGIN -p and please tell us if your
are able ton connect
- Original Message -
From: Bob Hutchinson hutchli...@midwales.com
To: vchkpw@inter7.com
Sent: Friday, June 18, 2010 9:21 AM
Subject: Re: [vchkpw] Vpopmail
Hi Thibault,
Yes i have tried this already. I can connect and login to remote DB
from command line.
I have found a solution on google. made a file in
/var/qmail/control/sql and place the name of mysql server hostname in
it. After this i can connect to remote DB. Do you think
On Friday 18 June 2010, ta...@nayatel.com wrote:
I had vpopmail database on the local server. Now i have taken backup
of mysql and restored to a remote database server. I am connecting
vpopmail to remote mysql server. The users are not authenticated. I
have taken following steps.
1
I had vpopmail database on the local server. Now i have taken backup
of mysql and restored to a remote database server. I am connecting
vpopmail to remote mysql server. The users are not authenticated. I
have taken following steps.
1 - Database migration and restoration to the remote
That fixed it. Thanks
_
From: Jianbin Xiao [mailto:xia...@gmail.com]
Sent: Sunday, May 16, 2010 8:38 AM
To: vchkpw@inter7.com
Subject: Re: [vchkpw] vmysql: sql error[3]: MySQL server has gone away
patch: http://www.xiaojb.com/archives/mailtech/patch_for_vpopmail.shtml
On Sat
patch: http://www.xiaojb.com/archives/mailtech/patch_for_vpopmail.shtml
On Sat, May 15, 2010 at 2:38 AM, Joe Littleton jlittle...@citnatbank.comwrote:
None of that helped…I have decided to go back to CentOS 4.8 and just use
MySQL 4.1 instead of the newer version
up with an unknown slow query .
when you have those errors if you log to the mysql server can you query
anything to the db? or the server is dead?
Also take a look at this link
http://www.unix.com/web-programming-web-2-0-mashups/75618-mysql-tuning-tools-mysqltuner-pl-tuning-primer-sh.html
Come
I have searched for two days trying to figure out why I keep getting this
error. I am using vpopmail 5.4.30 and mysql 5.0.77-4 on CentOS 5.4
I can reproduce the error by restarting the mysql server. The only way to
make it work after restarting mysql is to also restart authdaemond.
I did
Joe Littleton ha scritto:
I have searched for two days trying to figure out why I keep getting
this error. I am using vpopmail 5.4.30 and mysql 5.0.77-4 on CentOS 5.4
I can reproduce the error by restarting the mysql server. The only way
to make it work after restarting mysql is to also
I have recompiled authdaemon and using 0.63.0
Usually people pacthes and recompiles vpopmail, then forgets to
recompile authdaemond, which continues to use old libraries.
Hope it is your problem :-) .
Tonino
--
On 13/05/2010 15:37, Joe Littleton wrote:
I have searched for two days trying to figure out why I keep getting
this error. I am using vpopmail 5.4.30 and mysql 5.0.77-4 on CentOS 5.4
I can reproduce the error by restarting the mysql server. The only way
to make it work after restarting
I tried your config for my.cnf but I am still having the same issue.
It appears that if mysql is restarted whatever authdaemon is looking at is
gone. Its like there is a specific PID or something and once that PID is
gone authdaemon believes mysql has stopped.
Hi!
I had a similar problem
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 'vpopmail.vlog' doesn't
Did you modify the vpopmail.mysql with the right username and password?
On 4/15/10 14:05 , Fabrice TERRANCLE fabr...@terrancle.fr 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
...@terrancle.fr 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
I have recently upgraded vpopmail from vpopmail-5.4.18 to vpopmail-5.4.27 and
have configured it to use mysql. I am running a stock shupp toaster.
vconvert converted the popboxes just fine, but the .qmail-xxx aliases have
remained where they are and work OK. Qmailadmin was recompiled afterwards
Is it possible to convert from MySQL to LDAP authentication in any sort
of a sane manner?
I'm trying to couple two systems together, one of them being
closed-source. The only available way to couple qmail together with my
CS application without programming an intermediary black-box is to
convert
I have recently converted a mailserver running a shupp toaster to mysql from
cbd. I ran vconvert -c -m and all the popboxes were entered into the mysql
database, but none of the aliases (.qmail-xxx) were converted and none of
them show up in qmailadmin. They still accept and forward mail though
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
2nd graffitiist: Why?
Use bill shupp toaster you will have not problem with this.
Just my 2 cents.
Remo
From: Mohsen Pahlevanzadeh moh...@pahlevanzadeh.org
Reply-To: vchkpw@inter7.com
Date: Wed, 25 Feb 2009 20:14:27 +0330
To: vchkpw@inter7.com
Subject: [vchkpw] mysql auth
Dear all
Dear all,
I wanna know can i install ldap+mysql+qmail+vpopmail ? Or no , Or with
mysql or with ldap?
Yours,
Mohsen
!DSPAM:49a2a76e32681337035543!
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mohsen Pahlevanzadeh wrote:
Dear all,
I wanna know can i install ldap+mysql+qmail+vpopmail ? Or no , Or with
mysql or with ldap?
You can certainly install, and run, both of them. You can only use a single
authentication source with vpopmail
Hi,
On Tue, 11 Nov 2008 14:16:46 -0800
Tren Blackburn [EMAIL PROTECTED] wrote:
Domain quotas are broken, and have been for years now.
Regards,
Tren
Many-many thanks.
My problem was solved now. It relates to the existing mysql. Seems
in my case i have to put IP-address in the /home
Hi,
Is it possible to automatic create Domain's Directory (/home/vpopmail/do.ma.in)
based
on inserted data to vpopmail's table in MySQL ?
I know users home dir is possible if domain already created first
Best Regards
Geri Anggara
NOC IndoInternet Jakarta
http://www.indo.net.id
!DSPAM
Hola,
As documented in vpopmail.mysql:
#
# Note:
# The value of host may be either a hostname or an IP address.
# If host is 'localhost', then sockets (Unix) or named pipes (Windows)
# will be used instead of TCP/IP to connect to the server.
Thus, this is more related to your MySQL server
clear, how are you creating your domains at the moment?
cheers,
Antti Kanes
Quoting Geri Anggara [EMAIL PROTECTED]:
Hi,
Is it possible to automatic create Domain's Directory
(/home/vpopmail/do.ma.in) based
on inserted data to vpopmail's table in MySQL ?
I know users home dir is possible
through another host that have it's own program, relates
to the billing purpose.
That host will do insert to mysql of vpopmail and i was hoping magic to
happen :)
I think i'll give vqadmin a shot.
Many-many thanks.
Quoting Geri Anggara [EMAIL PROTECTED]:
Hi,
Is it possible
DomainDir based on inserted data to mysql
Hi,
On Thu, 13 Nov 2008 10:45:12 +0200
Antti Kanes [EMAIL PROTECTED] wrote:
Hi,
We're using the vqadmin -tool to create domains; it creates the
directory structure for the domain when adding the domain.
Afterwards, our users manage their domains
DomainDir based on inserted data to mysql
On Thursday 13 November 2008, Geri Anggara wrote:
Hi,
On Thu, 13 Nov 2008 10:45:12 +0200
Antti Kanes [EMAIL PROTECTED] wrote:
Hi,
We're using the vqadmin -tool to create domains; it creates the
directory structure for the domain when adding
vpopmail 5.4.7 + mysql
Hola,
As documented in vpopmail.mysql:
#
# Note:
# The value of host may be either a hostname or an IP address.
# If host is 'localhost', then sockets (Unix) or named pipes (Windows)
# will be used instead of TCP/IP to connect to the server.
Thus, this is more
DomainDir based on inserted data to mysql
Hi,
We're using the vqadmin -tool to create domains; it creates the directory
structure for the domain when adding the domain.
Afterwards, our users manage their domains and users using qmailadmin.
My question would be, why would you want to manually
+ mysql
Hi,
On Tue, 11 Nov 2008 14:16:46 -0800
Tren Blackburn [EMAIL PROTECTED] wrote:
Domain quotas are broken, and have been for years now.
Regards,
Tren
Many-many thanks.
My problem was solved now. It relates to the existing mysql. Seems
in my case i have to put IP-address
DomainDir based on inserted data to mysql
Hi,
Is it possible to automatic create Domain's Directory
(/home/vpopmail/do.ma.in) based
on inserted data to vpopmail's table in MySQL ?
I know users home dir is possible if domain already created first
Best Regards
Geri Anggara
NOC IndoInternet Jakarta
.
The reason is because we plan to proceed registration of domains
through another host that have it's own program, relates
to the billing purpose.
That host will do insert to mysql of vpopmail and i was hoping magic to
happen :)
It might be better to get the 'billing' host to add new domains
create DomainDir based on inserted data to mysql
Hi,
On Thu, 13 Nov 2008 10:45:12 +0200
Antti Kanes [EMAIL PROTECTED] wrote:
Hi,
We're using the vqadmin -tool to create domains; it creates the
directory structure for the domain when adding the domain.
Afterwards, our users
0.0.0.0 is typically is an alias for all interfaces :)
used by servers to bind to all interfaces. not valid from the client side
if you need to connect using socket - use localhost, using IP - ip addr
you can change this in /etc/my.cnf in [mysql] or something like [client]
section of the config
Hi,
I need to use vpopmail 5.4.7 along with domainquotas support together with
mysql.
I have a very strange problem, that qmail-send log keep saying
d z 1226437320.400681500 1226437320.400742500 1226437320.406664500 205
[EMAIL PROTECTED] 18797 502
d z 1226437320.400681500
Domain quotas are broken, and have been for years now.
Regards,
Tren
- Original Message -
From: Geri Anggara [EMAIL PROTECTED]
To: vchkpw@inter7.com vchkpw@inter7.com
Sent: Tue Nov 11 14:10:24 2008
Subject: [vchkpw] delivery problem vpopmail 5.4.7 + mysql
Hi,
I need to use vpopmail
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
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
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
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
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
could
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
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 a
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!
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
Hrmm didn't get D.Hilbig's reply..so mines included in this...
my problem is solved once after installation of devel package.
during next upgradation i'll switch to centos.
you'll still have the same problem, last time I loaded up a CentOS
image. This is why I am only useing slackware
Dear All,
i am trying to compile vpopmail (5.4.24) with mysql
I used
./configure --enable-logging=p --enable-auth-module=mysql
--disable-passwd --enable-clear-passwd --disable-many-domains
--enable-auth-logging --enable-sql-logging --enable-valias
--disable-mysql-limits --enable-incdir=/usr
Why you want to use fedora on a production server I'll never know,
but as usual with everything butchered to buggery by RH, you dont
have the headers files, so you need to install the -devel packages
of mysql (and anything you want to build against), if your not
commited try a decent
Dear Customer,
Thank you for contacting Wachovia.
This message is in response to your recent communication, which was
received on 04/22/2008 and assigned Case ID 27119495.
I regret the message we received was unclear. Please send us another
secure e-mail with additional information
Dhaval,
For now, you shouldn't specify the --enable-auth-logging option because
it's got bugs up through v5.4.26.
Like Quey said, you'll need the mysql-devel package.
And as for Fedora on a production server, you might want to consider an
alternative. I use CentOS (http://www.centos.org
v5.4.26.
Like Quey said, you'll need the mysql-devel package.
And as for Fedora on a production server, you might want to consider an
alternative. I use CentOS (http://www.centos.org) which is effectively a
RHEL production release.
-Original Message-
From: Quey [mailto:[EMAIL
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!
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
to MYSQL_UPDATE_SOCKET and
MYSQL_UPDATE_PORT?
You are correct, and that probably fixes an outstanding bug report on
SourceForge. Most people use the same info for read and update, so
no one has fixed the problem before.
In the current vpopmail version with mysql support tries to reconnect
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
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?
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
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
had to restart courier-imap
package
(wich I use for pop and imap services) and seems to be running ok... so
this is normal then? and I shouldn't change nothing then? or is it
advisable to increase mysql timeout?? or I could stay as I'm now?
I would suggest setting the mysql timeout to about
then? or is it
advisable to increase mysql timeout?? or I could stay as I'm now?
I would suggest setting the mysql timeout to about twice the longest
interval between pop/imap logins. 4 or 5 days is probably good. One
day wouldn't be bad if you don't mind seeing a few warnings on weekends
is different.
Each vpopmail/qmail program usually executes brieftly and opens and
closes MySQL, so there are no abnormal exits.
When courier plays (both imap and pop), it asks auth data to
courier's auth daemon.
When this daemon is started, it opens MySQL and never closes it, as
it supposes
brieftly and opens and
closes MySQL, so there are no abnormal exits.
When courier plays (both imap and pop), it asks auth data to
courier's auth daemon.
When this daemon is started, it opens MySQL and never closes it, as
it supposes to reuse continuosly the same opened connection
restarted authdaemon if this happens or upgrade vpopmail. This
should not break the database. It just affects your imap connections.
Or change your my.cnf for mysql to allow unlimited timeout's. That's
what I did (Well I actually set it to 4 days).
Rick
At 04.55 05/10/2007, you wrote:
tonix (Antonio Nati) wrote:
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with persistent attach to
vpopmail/MySQL, it could be that during the night there are no
requests, so MySQL connections are droppped (by MySQL).
I
At 04.55 05/10/2007, you wrote:
tonix (Antonio Nati) wrote:
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with persistent attach to
vpopmail/MySQL, it could be that during the night there are no
requests, so MySQL connections are droppped (by MySQL
thanks a lot mates for you're answers, and in where logs could you see
connections have been droped?? you doing an overview for all answers some
mysql versions have timeout for it's persistent connections (connections
as vpopmail connections) and this causes connection not to close properly
At 04.55 05/10/2007, you wrote:
tonix (Antonio Nati) wrote:
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with persistent attach to
vpopmail/MySQL, it could be that during the night there are no
requests, so MySQL connections are droppped
this...
sorry for insisting
The problem does not really lie with courier.
All qmail processes run under tcpserver and are only invoked when a
connection appears.
courier has this authdaemon that maintains persistent connections to
mysql via the vpopmail library and so its behaviour is different from
As told in other messages, the way of playing is different.
Each vpopmail/qmail program usually executes brieftly and opens and
closes MySQL, so there are no abnormal exits.
When courier plays (both imap and pop), it asks auth data to
courier's auth daemon.
When this daemon is started
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with
persistent attach to vpopmail/MySQL, it could be
that during the night there are no requests, so
MySQL connections are droppped (by MySQL).
Ciao,
Tonino
At 09.36 04/10/2007, you wrote:
Hi
cliets appear... in show
status
in mysql...
P.D. John (John Simpson) perhaps this could be a challenge for you :)
i don't know a whole lot about how vpopmail uses mysql, the only
thing i use mysql for is the back-end storage for my jabber server,
and a few clients who need it for their web
tonix (Antonio Nati) wrote:
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with persistent attach to
vpopmail/MySQL, it could be that during the night there are no requests,
so MySQL connections are droppped (by MySQL).
I thought
On 2007-10-04, at 2255, Christopher Chan wrote:
tonix (Antonio Nati) wrote:
MysSQL has now an hardcoded timeout of eight hours.
Courier uses it's authentication daemon with persistent attach to
vpopmail/MySQL, it could be that during the night there are no
requests, so MySQL connections
]# ./vadduser -q 10 -c Carlos Collart ccollart
'password'
Error: User's directory already exists?
i am googling for alternatives
./vadduser -ignoredirectory
or
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn'.vpopmail or crypt?
[EMAIL PROTECTED] bin
PROTECTED] bin]# ./vadduser -q 10 -c Carlos Collart ccollart
'password'
Error: User's directory already exists?
i am googling for alternatives
./vadduser -ignoredirectory
or
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
http://aduanett.hn
, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format
Just one domain, or many?
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
http://aduanett.hn'.vpopmail or crypt?
This may be the easiest
in the other domain login
username_at_fenaduanah_dot_hn
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
http://aduanett.hn'.vpopmail or crypt?
This may be the easiest method available. You will have to write a
Perl, php or whatever program
was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format
Just one domain, or many?
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx) into 'aduanett.hn
http://aduanett.hn'.vpopmail or crypt?
This may
then back up the mail store.
the system was a production one, under the domain xx_at_aduanett_dot_hn
I have a backup with the username, name, password in a CVS format
Just one domain, or many?
how could i re-poblate the mysql directly?
insert values(xxx,hash(xxx),xx,xx
to include the mysql root pass in it (assuming your roots mysql
pass is set)
It uses sys::syslog and mail::sendmail perl mods as well for notification
Cheers
On 10/1/07, *Quey* [EMAIL PROTECTED]
mailto:[EMAIL PROTECTED] wrote:
Rick Widmer wrote:
Carlos Collart wrote:
I am the dumbest
:)
Invest in a little time now running a mysqldump, attached is what I
run *hourly*
just replace the hostnames, database names and password and whatever
else thats mine with yours, and make sure the perms are 700 since you
need to include the mysql root pass in it (assuming your roots mysql
pass
i will swap directories 1at time with a bash scritp
#!/bin/bash
echo mv $1 $1temp # temporal rename of the folder
mv $1 $1temp
echo ../../bin/vadduser -c \ $2 \ $1 $3 # creation of the username inside
mysql
../../bin/vadduser -c \ $2 \ $1 $3
echo mv $1temp $1 # restoration of the mails
mv
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 and alias -- the names can
1 - 100 of 1536 matches
Mail list logo