RE: [vchkpw] Re: un-subscribe
Jeremy: Here is the header I have unscribed it. Few suggestion for the future: (1) Update the we site: http://www.inter7.com/?page=vpopmail and just below where it says subscribe add a line which says un-subscribe. Most web sites do that! (2) Mention to look into the message header somewhere so subscribers can see it and try to figure it out. (3) Do what other mailing lists do; automatically add a section on each posting which directs nailing list user how to do certain thing. Here is an example from another list: ___ Shorewall-users mailing list Post: [EMAIL PROTECTED] Subscribe/Unsubscribe: https://lists.shorewall.net/mailman/listinfo/shorewall-users Support: http://www.shorewall.net/support.htm FAQ: http://www.shorewall.net/FAQ.htm This makes it easy for user to navigate various options. (4) Whenever someone does not follow or know the directions, do not get upset or make fun of users but simply ask Why someone did such a thing?, you may have an anser. Thanks. Kirti Received: from tib.com (TESUQUE [12.21.237.250]) by tesuque.JASPER with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id S3NYHWW8; Wed, 8 Sep 2004 18:55:17 -0400 Received: from mail.inter7.com (68.78.194.73) by ZZYNET04 (MailMax 4. 8. 3. 0) with ESMTP id 40281704 for [EMAIL PROTECTED]; Wed, 08 Sep 2004 18:53:48 -0400 EDT Received: (qmail 13860 invoked by uid 511); 8 Sep 2004 22:51:13 - Mailing-List: contact [EMAIL PROTECTED]; run by ezmlm Precedence: bulk List-Post: mailto:[EMAIL PROTECTED] List-Help: mailto:[EMAIL PROTECTED] List-Unsubscribe: mailto:[EMAIL PROTECTED] List-Subscribe: mailto:[EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Delivered-To: mailing list [EMAIL PROTECTED] Received: (qmail 13852 invoked by uid 0); 8 Sep 2004 22:51:13 - From: Jeremy Kitchen [EMAIL PROTECTED] Organization: Inter7 Internet Technologies, Inc. To: [EMAIL PROTECTED] Date: Wed, 8 Sep 2004 17:50:47 -0500 User-Agent: KMail/1.6.2 References: [EMAIL PROTECTED] In-Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Message-Id: [EMAIL PROTECTED] Subject: Re: [vchkpw] Re: un-subscribe -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 08, 2004 6:51 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Re: un-subscribe On Wednesday 08 September 2004 04:44 pm, Kirti S. Bajwa wrote: [EMAIL PROTECTED] please stop this madness. read the headers of every message sent to you by the mailing list to figure out how to unsubscribe. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 815.776.9465 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
[vchkpw] RE:un-subscribe
Un-subscribe
RE: [vchkpw] Re: un-subscribe
[EMAIL PROTECTED]
RE: [vchkpw] Vpopmail MySQL
Jeremy: Your answers are always very helpful. I had almost given up using mysql backend on a master server. Now I am going to try again. I will keep posted. Thanks again. Kirti -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Sunday, June 06, 2004 11:36 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] Vpopmail MySQL On Sunday 06 June 2004 08:37 pm, Kirti S. Bajwa wrote: Hello: I had posted a similar question couple of days ago. I have done quite a bit research actual installation and would like to post the following question for somebody's help and/or recommendation: I have setup a MAIL server with RH9, qmail, mysql, vpopmail, etc. I have tested vpopmail by adding a domain it works. I also have setup a DATA server with RH9 Master MySQL. My goal is to keep all MySQL data on the DATA server. MAIL server RADIUS servers go to the DATA server for MySQL records. Latency is not a problem because all these servers are connected on a private (192.168.237.X) network. right, a relatively common configuration. I've done multiple mysql-replicated setups (this isn't replication, but vpopmail is configured very similarly. After I tested the MAIL server, I tried for it to create a domain on DATA server vpopmail database. On the MAIL server I changed the /home/vpopmail/etc/vpopmail.mysql from: localhost|0|vpopmailuser|vpoppasswd|vpopmail -to- 192.167.237.16|0|vpopmailuser|vpoppasswd|vpopmail ok. make sure your mysql server is listening on TCP port 3306 (which is the default) and that you can connect to it from the 'MAIL' server. Telnet should suffice. Once you've determined you can connect to it, make sure you are able to perform operations on the database using the 'mysql' command line interface (from the MAIL server). where 192.167.237.16 is the IP address of the DATA server. I also have tried various other techniques but nothing seem to work. When I try adding a domain, I get error message: various other techniques of doing what? I don't see how this is difficult, to be honest. vmysql: sql error[c]: MYSQL server has gone away (and slew of other similar error messages) and those other error messages are? Usually 'mysql server has gone away' means that the password didn't work. Therefore, my question is: (1) Has anybody tried setting up vpopmail with MySQL backend data being on server (but on the same LAN/network)? yes. (2) Is it even possible? yes. (3) If not possible, how can I move the user data to the backend MySQL DATA server so other servers (such as RADIUS for authentication) can use it? well, if it wasn't possible (which it is) you're asking how to do the impossible I don't see how you could expect a solution to an impossible question :) I have spent about two weeks on this project. Your help is highly appreciated. setting up vpopmail with mysql backend shouldn't take more than about 3 minutes. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Hello: Yesterday, I posted this message many people responded. I was following document http://www.pipeline.com.au/staff/isp/webmail-server.htm;. When I tried to add a domain I will get an error: /home/vpopmail/bin/vadddomain: error while loading shared libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory Several people on this list responded. That made me thinking. Finally, I figured it out: During the build of vpopmail, include full path to the directory, as follows: ./configure \ (several options) --enable-incdir=/usr/local/mysql/include/mysql --enable-libdir=/usr/local/mysql/lib/mysql This did the trick. This post is for future information. Kirti
[vchkpw] Vpopmail MySQL
Hello: I had posted a similar question couple of days ago. I have done quite a bit research actual installation and would like to post the following question for somebody's help and/or recommendation: I have setup a MAIL server with RH9, qmail, mysql, vpopmail, etc. I have tested vpopmail by adding a domain it works. I also have setup a DATA server with RH9 Master MySQL. My goal is to keep all MySQL data on the DATA server. MAIL server RADIUS servers go to the DATA server for MySQL records. Latency is not a problem because all these servers are connected on a private (192.168.237.X) network. After I tested the MAIL server, I tried for it to create a domain on DATA server vpopmail database. On the MAIL server I changed the /home/vpopmail/etc/vpopmail.mysql from: localhost|0|vpopmailuser|vpoppasswd|vpopmail -to- 192.167.237.16|0|vpopmailuser|vpoppasswd|vpopmail where 192.167.237.16 is the IP address of the DATA server. I also have tried various other techniques but nothing seem to work. When I try adding a domain, I get error message: vmysql: sql error[c]: MYSQL server has gone away (and slew of other similar error messages) Therefore, my question is: (1) Has anybody tried setting up vpopmail with MySQL backend data being on server (but on the same LAN/network)? (2) Is it even possible? (3) If not possible, how can I move the user data to the backend MySQL DATA server so other servers (such as RADIUS for authentication) can use it? I have spent about two weeks on this project. Your help is highly appreciated. Thanks in advance. Kirti
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Rick: I like your idea of installing complete MySQL package and then use the data from the master server. I will try it. Thanks. Kirt -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:01 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Kirti S. Bajwa wrote: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? The mysql-client and/or mysql-devel packages (what ever RedHat calls them) are not installed, or for some reason vpopmail can not find them. If you already have a file libmysqlclient.so.12 on the slave server, let us know and we'll look at something different, but I bet you don't... Make sure the client library and include files are installed on the slave machine. I don't do Red Hat, so I can't help with specifics. or Just install all of the mysql packages on the slave and don't sweat the extra couple of MB disk space they require. You don't have to actually start MySQL on the slave server. or If you have one box it works on, and another it does not and both are on the same version of RH, just find the files vpopmail complains about on the machine that has them, and copy them to the same directory on the other machine. There may be several files and vpopmail only reports one at a time, so you may have to run - copy - run - copy several times. Rick
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Eduardo: /usr/local/mysql/lib/mysql does have libmysqlclient.so.12. I followed your advice. Added path to the library in etc/ld.so.conf and created the PATH to /usr/local/mysql/lib/mysql. Still the same error. I am going to take advice of Rick install MySQL full package. Kirti -Original Message- From: Eduardo M. Bragatto [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:11 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Kirti S. Bajwa wrote: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory I've never used vpopmail with Mysql, but I've been following the thread and I think that I know what's going on. Your vpopmail is trying to use shared libraries that can't be found on the system. Search for the path of the files libmysqlclient.* (find / | grep libmysqlclient) and check if it's listed at /etc/ld.so.conf. It must be listed at your $PATH environment variable as well. You must find the file libmysqlclient.so.12. If you don't find it, you may try to create a symbolic link to other libmysqlclient.so.XX. Best regards, Eduardo M. Bragatto.
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Rick: I do have the file libmysqlclient.so.12 in /usr/local/mysql/lib/mysql /usr/local/mysql-4.0.20/libmysql/.lib. I have installed the mysql-client package. I am going to install full mysql package see if the problem goes away. Kirti -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:01 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Kirti S. Bajwa wrote: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? The mysql-client and/or mysql-devel packages (what ever RedHat calls them) are not installed, or for some reason vpopmail can not find them. If you already have a file libmysqlclient.so.12 on the slave server, let us know and we'll look at something different, but I bet you don't... Make sure the client library and include files are installed on the slave machine. I don't do Red Hat, so I can't help with specifics. or Just install all of the mysql packages on the slave and don't sweat the extra couple of MB disk space they require. You don't have to actually start MySQL on the slave server. or If you have one box it works on, and another it does not and both are on the same version of RH, just find the files vpopmail complains about on the machine that has them, and copy them to the same directory on the other machine. There may be several files and vpopmail only reports one at a time, so you may have to run - copy - run - copy several times. Rick
[vchkpw] User ID Password
Hello: I am posting this message on freeRADIUS, vpopmail mysql lists. This may get few people upset but please read I am trying to install (on RH9), qmail, vpopmail, mysql, Courier-IMAP, squirrelmail, etc., with backend data on MySQL. On another computer I have installed RH9 freeRADIUS server. vpopmail is used to add UID PW and the data is stored in vpopmail DB in MySQL. Now freeRADIUS also uses UID PW to authenticate and has its own data structure. I like to know if there is a way so that user data is stored in one table in MySQL so vpopmail and freeRADIUS can access the same information?? Thanks in advance. Kirti
RE: [vchkpw] vpopmail installation on a Client MySQL Server
JB: I think you performed the magic. After I run ldconfig, the old library error is gone. Now the error is MYSQL server has gone away. I can connect to the mysql server data. So why is this error? Is it possible that I may have done some mistake in installing mysql? Thanks. Kirti -Original Message- From: JB [mailto:[EMAIL PROTECTED] Sent: Saturday, June 05, 2004 11:00 AM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Make sure the directory where libmysqlclient.so.12 is located in listed in ld.so.conf. Don't forget to run ldconfig if you add a new path to ld.so.conf Kirti S. Bajwa wrote: Rick: I do have the file libmysqlclient.so.12 in /usr/local/mysql/lib/mysql /usr/local/mysql-4.0.20/libmysql/.lib. I have installed the mysql-client package. I am going to install full mysql package see if the problem goes away. Kirti -Original Message- From: Rick Widmer [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 8:01 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Kirti S. Bajwa wrote: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? The mysql-client and/or mysql-devel packages (what ever RedHat calls them) are not installed, or for some reason vpopmail can not find them. If you already have a file libmysqlclient.so.12 on the slave server, let us know and we'll look at something different, but I bet you don't... Make sure the client library and include files are installed on the slave machine. I don't do Red Hat, so I can't help with specifics. or Just install all of the mysql packages on the slave and don't sweat the extra couple of MB disk space they require. You don't have to actually start MySQL on the slave server. or If you have one box it works on, and another it does not and both are on the same version of RH, just find the files vpopmail complains about on the machine that has them, and copy them to the same directory on the other machine. There may be several files and vpopmail only reports one at a time, so you may have to run - copy - run - copy several times. Rick
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Jeremy: I knew someone has done it. I did follow your instructions; I updated /home/vpopmail/etc/vpopmail.mysql with the ip address now the file vpopmail.mysql has the following entry: 192.168.237.11|0|vpopmailuser|vpopmailpw|vpopmal NOTE: Each server has 2 NICs. One NIC uses public IP addresses (12.21.237.x) to access the Internet. The second NIC uses 192.168.237.X. All networking is over 192.168.237.0/255.255.255.0. MySQL server can only be accesses over the internal network. Then I tried to add a domain: %/home/vpopmail/bin/vadddomain tibinternet.com vpopmailpw I get the following (the same) error: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? Thats in advance. You are saving my life. You are a swell of a person. Kirti -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:20 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server On Friday 04 June 2004 12:57 pm, Kirti S. Bajwa wrote: The problem is that all the instruction to install vpopmail is for a MySQL to be installed on the localhost. Therefore, my question is: Has anyone installed vpopmail client mysql where all the data resides on a master mysql server? Is it even possible? If it is not possible, then what are the alternatives? yes, you put the ip address of the mysql server into the ~vpopmail/etc/vpopmail.mysql file in place of localhost. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Rainer: Thank for your response. Our design is such (see my post in response to Jeremy) that we use an internal network to access the data server. At this point, I have no idea if latency is going to be a problem. I may get back to you later on. Thanks again. Kirti -Original Message- From: Rainer Duffner [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:09 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server Am Fr, 2004-06-04 um 19.57 schrieb Kirti S. Bajwa: Hello List: This is my first message on this list. Please consider me a newbie in the area of LINUX, vpopmail, etc. I have setup two servers as follows: [snip] I haven't done this either, but I think I've heard that one uses a master-slave model because the lookups in the mysql-tables need to be as fast as possible. And a connection to a local mysql-db is much faster than making a remote tcp/ip-connection - the latency envolved may be just too much. Rainer
RE: [vchkpw] vpopmail installation on a Client MySQL Server
Jeremy: One other thought came to my mind when you respond, you can include this information also (unless someone else also responds); In /home/vpopmail/etc/vpopmail.mysql, the follwoing information is contained: 192.168.237.11|0|vpopmailuser|vpopmailpw|vpopmal It is my understanding that |0| is the port number for the mysql server. Is it possible that this port number is different in this/my design? Kirti - Jeremy: I knew someone has done it. I did follow your instructions; I updated /home/vpopmail/etc/vpopmail.mysql with the ip address now the file vpopmail.mysql has the following entry: 192.168.237.11|0|vpopmailuser|vpopmailpw|vpopmal NOTE: Each server has 2 NICs. One NIC uses public IP addresses (12.21.237.x) to access the Internet. The second NIC uses 192.168.237.X. All networking is over 192.168.237.0/255.255.255.0. MySQL server can only be accesses over the internal network. Then I tried to add a domain: %/home/vpopmail/bin/vadddomain tibinternet.com vpopmailpw I get the following (the same) error: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? Thats in advance. You are saving my life. You are a swell of a person. Kirti -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:20 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server On Friday 04 June 2004 12:57 pm, Kirti S. Bajwa wrote: The problem is that all the instruction to install vpopmail is for a MySQL to be installed on the localhost. Therefore, my question is: Has anyone installed vpopmail client mysql where all the data resides on a master mysql server? Is it even possible? If it is not possible, then what are the alternatives? yes, you put the ip address of the mysql server into the ~vpopmail/etc/vpopmail.mysql file in place of localhost. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
RE: [vchkpw] vpopmail installation on a Client MySQL Server
For those who are following this thread: I changed the port in /home/vpopmail/etc/vpopmail.mysql to 3306. Same error. I went ahead and deleted all the vpopmail related folder re-installed vpopmail-5.4.4. Same place same error (the error is listed below). Back to square ONE. OK folks, give some suggestions. I am sure that someone out these has installed vpopmail on a mysql client server!! Kirti -Original Message- From: Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 4:50 PM To: '[EMAIL PROTECTED]' Subject: RE: [vchkpw] vpopmail installation on a Client MySQL Server Jeremy: One other thought came to my mind when you respond, you can include this information also (unless someone else also responds); In /home/vpopmail/etc/vpopmail.mysql, the follwoing information is contained: 192.168.237.11|0|vpopmailuser|vpopmailpw|vpopmal It is my understanding that |0| is the port number for the mysql server. Is it possible that this port number is different in this/my design? Kirti - Jeremy: I knew someone has done it. I did follow your instructions; I updated /home/vpopmail/etc/vpopmail.mysql with the ip address now the file vpopmail.mysql has the following entry: 192.168.237.11|0|vpopmailuser|vpopmailpw|vpopmal NOTE: Each server has 2 NICs. One NIC uses public IP addresses (12.21.237.x) to access the Internet. The second NIC uses 192.168.237.X. All networking is over 192.168.237.0/255.255.255.0. MySQL server can only be accesses over the internal network. Then I tried to add a domain: %/home/vpopmail/bin/vadddomain tibinternet.com vpopmailpw I get the following (the same) error: /home/vpopmail/bin/vadddomain: error while loading sharred libraries: libmysqlclient.so.12: cannot open shared object file: no such file or directory What is this error how to fix it? Thats in advance. You are saving my life. You are a swell of a person. Kirti -Original Message- From: Jeremy Kitchen [mailto:[EMAIL PROTECTED] Sent: Friday, June 04, 2004 3:20 PM To: [EMAIL PROTECTED] Subject: Re: [vchkpw] vpopmail installation on a Client MySQL Server On Friday 04 June 2004 12:57 pm, Kirti S. Bajwa wrote: The problem is that all the instruction to install vpopmail is for a MySQL to be installed on the localhost. Therefore, my question is: Has anyone installed vpopmail client mysql where all the data resides on a master mysql server? Is it even possible? If it is not possible, then what are the alternatives? yes, you put the ip address of the mysql server into the ~vpopmail/etc/vpopmail.mysql file in place of localhost. -Jeremy -- Jeremy Kitchen ++ Systems Administrator ++ Inter7 Internet Technologies, Inc. [EMAIL PROTECTED] ++ www.inter7.com ++ 866.528.3530 ++ 847.492.0470 int'l kitchen @ #qmail #gentoo on EFnet ++ scriptkitchen.com/qmail
