Re: [vchkpw] delivery problem vpopmail 5.4.7 + 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 in the /home/vpopmail/etc/vpopmail.mysql Somehow 'localhost' not work, 127.0.0.1 not work, 0.0.0.0 not work, but public IP, it worked. Don't really know why. Domain quota seem's like working, but breakable by small-size email. - 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 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 1226437415.351574500 1226437415.381846500 205 [EMAIL PROTECTED] 18797 502 d z 1226438455.466867500 1226438455.466901500 1226438455.471854500 206 [EMAIL PROTECTED] 29832 502 d z 1226438455.466867500 1226438556.377593500 1226438556.382903500 206 [EMAIL PROTECTED] 29832 502 Mail never gets delivered. With latest vpopmail, i see error vdelivermail: deferred database_down Mail never gets delivered. I cannot see any other relevant error in /var/log/messages or /var/log/maillog. The database is not down since authenticating to vchkpw through port 110 is always successful. I use mysql 4.0.16 compiled. It didn't happen if i use CDB. Best Regards Geri Anggara !DSPAM:491be2d032312057418355!
[vchkpw] force create 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 http://www.indo.net.id !DSPAM:491be50632312957579589!
Re: [vchkpw] delivery problem 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 related to your MySQL server configuration; If you've set up your mysql server to listen to sockets, then localhost will work as a parameter. And if you've bind your mysql to listen to localhost (127.0.0.1) (and on linux servers, enabled your lo interface), that will work. 0.0.0.0 should never work (or at least I can't see why it should work, not being a valid address at all). In your case, I'd guess you've set your MySQL server to only listen to connections on your servers public ip address Cheers, Antti Kanes Quoting Geri Anggara [EMAIL PROTECTED]: 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/vpopmail/etc/vpopmail.mysql Somehow 'localhost' not work, 127.0.0.1 not work, 0.0.0.0 not work, but public IP, it worked. Don't really know why. Domain quota seem's like working, but breakable by small-size email. - 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 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 1226437415.351574500 1226437415.381846500 205 [EMAIL PROTECTED] 18797 502 d z 1226438455.466867500 1226438455.466901500 1226438455.471854500 206 [EMAIL PROTECTED] 29832 502 d z 1226438455.466867500 1226438556.377593500 1226438556.382903500 206 [EMAIL PROTECTED] 29832 502 Mail never gets delivered. With latest vpopmail, i see error vdelivermail: deferred database_down Mail never gets delivered. I cannot see any other relevant error in /var/log/messages or /var/log/maillog. The database is not down since authenticating to vchkpw through port 110 is always successful. I use mysql 4.0.16 compiled. It didn't happen if i use CDB. Best Regards Geri Anggara !DSPAM:491be6f932314948813182!
Re: [vchkpw] force create 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 insert the data instead? Or to be more 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id !DSPAM:491be91b32313484885224!
Re: [vchkpw] force 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 manage their domains and users using qmailadmin. My question would be, why would you want to manually insert the data instead? Or to be more clear, how are you creating your domains at the moment? cheers, Antti Kanes I use /home/vpopmail/bin/vaddomain installed on the host offcourse. 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 :) I think i'll give vqadmin a shot. Many-many thanks. 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id !DSPAM:491bf94132311911320462!
Re: [vchkpw] force create DomainDir based on inserted data to mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Geri Anggara [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 4:53 AM Subject: Re: [vchkpw] force 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 manage their domains and users using qmailadmin. My question would be, why would you want to manually insert the data instead? Or to be more clear, how are you creating your domains at the moment? cheers, Antti Kanes I use /home/vpopmail/bin/vaddomain installed on the host offcourse. 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 :) I think i'll give vqadmin a shot. Many-many thanks. 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id !DSPAM:491c0ac232319633323063!
Re: [vchkpw] force create DomainDir based on inserted data to mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Bob Hutchinson [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 5:22 AM Subject: Re: [vchkpw] force create 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 the domain. Afterwards, our users manage their domains and users using qmailadmin. My question would be, why would you want to manually insert the data instead? Or to be more clear, how are you creating your domains at the moment? cheers, Antti Kanes I use /home/vpopmail/bin/vaddomain installed on the host offcourse. 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 to a TODO list and set up a cron job on the 'mailing' host that works its way through that list and let vpopmail do it's own database management. I haven't tried this, but you could get the billing host to send an email and use maildrop to filter the email, collect the domain and password and run vadddomain. That would be more immediate than a cronjob. my 2c worth I think i'll give vqadmin a shot. Many-many thanks. 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id -- - Bob Hutchinson Midwales dot com - !DSPAM:491c0ae632311612918095!
Fw: [vchkpw] delivery problem vpopmail 5.4.7 + mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Antti Kanes [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 3:36 AM Subject: Re: [vchkpw] delivery problem 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 related to your MySQL server configuration; If you've set up your mysql server to listen to sockets, then localhost will work as a parameter. And if you've bind your mysql to listen to localhost (127.0.0.1) (and on linux servers, enabled your lo interface), that will work. 0.0.0.0 should never work (or at least I can't see why it should work, not being a valid address at all). In your case, I'd guess you've set your MySQL server to only listen to connections on your servers public ip address Cheers, Antti Kanes Quoting Geri Anggara [EMAIL PROTECTED]: 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/vpopmail/etc/vpopmail.mysql Somehow 'localhost' not work, 127.0.0.1 not work, 0.0.0.0 not work, but public IP, it worked. Don't really know why. Domain quota seem's like working, but breakable by small-size email. - 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 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 1226437415.351574500 1226437415.381846500 205 [EMAIL PROTECTED] 18797 502 d z 1226438455.466867500 1226438455.466901500 1226438455.471854500 206 [EMAIL PROTECTED] 29832 502 d z 1226438455.466867500 1226438556.377593500 1226438556.382903500 206 [EMAIL PROTECTED] 29832 502 Mail never gets delivered. With latest vpopmail, i see error vdelivermail: deferred database_down Mail never gets delivered. I cannot see any other relevant error in /var/log/messages or /var/log/maillog. The database is not down since authenticating to vchkpw through port 110 is always successful. I use mysql 4.0.16 compiled. It didn't happen if i use CDB. Best Regards Geri Anggara !DSPAM:491c0af232311696621260!
Re: [vchkpw] force create DomainDir based on inserted data to mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Antti Kanes [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 3:45 AM Subject: Re: [vchkpw] force create 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 insert the data instead? Or to be more 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id !DSPAM:491c0afe3234916713!
Fw: [vchkpw] delivery problem vpopmail 5.4.7 + mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Geri Anggara [EMAIL PROTECTED] To: Sent: Thursday, November 13, 2008 3:18 AM Subject: Re: [vchkpw] delivery problem vpopmail 5.4.7 + 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 in the /home/vpopmail/etc/vpopmail.mysql Somehow 'localhost' not work, 127.0.0.1 not work, 0.0.0.0 not work, but public IP, it worked. Don't really know why. Domain quota seem's like working, but breakable by small-size email. - 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 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 1226437415.351574500 1226437415.381846500 205 [EMAIL PROTECTED] 18797 502 d z 1226438455.466867500 1226438455.466901500 1226438455.471854500 206 [EMAIL PROTECTED] 29832 502 d z 1226438455.466867500 1226438556.377593500 1226438556.382903500 206 [EMAIL PROTECTED] 29832 502 Mail never gets delivered. With latest vpopmail, i see error vdelivermail: deferred database_down Mail never gets delivered. I cannot see any other relevant error in /var/log/messages or /var/log/maillog. The database is not down since authenticating to vchkpw through port 110 is always successful. I use mysql 4.0.16 compiled. It didn't happen if i use CDB. Best Regards Geri Anggara !DSPAM:491c0a9a32311263880303!
Re: [vchkpw] force create DomainDir based on inserted data to mysql
I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Geri Anggara [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 3:27 AM Subject: [vchkpw] force create 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 http://www.indo.net.id !DSPAM:491c0b0932311587855513!
Re: [vchkpw] force create 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 the domain. Afterwards, our users manage their domains and users using qmailadmin. My question would be, why would you want to manually insert the data instead? Or to be more clear, how are you creating your domains at the moment? cheers, Antti Kanes I use /home/vpopmail/bin/vaddomain installed on the host offcourse. 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 to a TODO list and set up a cron job on the 'mailing' host that works its way through that list and let vpopmail do it's own database management. I haven't tried this, but you could get the billing host to send an email and use maildrop to filter the email, collect the domain and password and run vadddomain. That would be more immediate than a cronjob. my 2c worth I think i'll give vqadmin a shot. Many-many thanks. 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id -- - Bob Hutchinson Midwales dot com - !DSPAM:491c000232311250361390!
Re: [vchkpw] force create DomainDir based on inserted data to mysql
Hi Matthew, and All, I really apologize for this. I myself receive 4 times of Your complain about receiving it multiple times. We currently are testing an antispam tech which require our outgoing mail be directed to them first. I think it does involve. I will conctact them immediately. For safety, i made inter7.com: in smtproutes. So it will be delivered directly without those. So this posting, and next will go direclty to inter7. Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id On Thu, 13 Nov 2008 06:08:46 -0500 real estate agent [EMAIL PROTECTED] wrote: I keep getting a copy of your emails. I will forward them to you so you can see and fix your problem. Kind regards, Matthew - Original Message - From: Geri Anggara [EMAIL PROTECTED] To: vchkpw@inter7.com Sent: Thursday, November 13, 2008 4:53 AM Subject: Re: [vchkpw] force 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 manage their domains and users using qmailadmin. My question would be, why would you want to manually insert the data instead? Or to be more clear, how are you creating your domains at the moment? cheers, Antti Kanes I use /home/vpopmail/bin/vaddomain installed on the host offcourse. 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 :) I think i'll give vqadmin a shot. Many-many thanks. 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 if domain already created first Best Regards Geri Anggara NOC IndoInternet Jakarta http://www.indo.net.id !DSPAM:491c1b7e32319562657338!
Re: [vchkpw] delivery problem vpopmail 5.4.7 + mysql
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. Tren Blackburn пишет: 0.0.0.0 is typically an alias for localhost. It's not used very often anymore, but it still works in many cases. Try pinging 0.0.0.0 and see what happens. t. - Original Message - From: Antti Kanes [EMAIL PROTECTED] To: vchkpw@inter7.com vchkpw@inter7.com Sent: Thu Nov 13 00:36:04 2008 Subject: Re: [vchkpw] delivery problem 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 related to your MySQL server configuration; If you've set up your mysql server to listen to sockets, then localhost will work as a parameter. And if you've bind your mysql to listen to localhost (127.0.0.1) (and on linux servers, enabled your lo interface), that will work. 0.0.0.0 should never work (or at least I can't see why it should work, not being a valid address at all). In your case, I'd guess you've set your MySQL server to only listen to connections on your servers public ip address Cheers, Antti Kanes Quoting Geri Anggara [EMAIL PROTECTED]: 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/vpopmail/etc/vpopmail.mysql Somehow 'localhost' not work, 127.0.0.1 not work, 0.0.0.0 not work, but public IP, it worked. Don't really know why. Domain quota seem's like working, but breakable by small-size email. - 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 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 1226437415.351574500 1226437415.381846500 205 [EMAIL PROTECTED] 18797 502 d z 1226438455.466867500 1226438455.466901500 1226438455.471854500 206 [EMAIL PROTECTED] 29832 502 d z 1226438455.466867500 1226438556.377593500 1226438556.382903500 206 [EMAIL PROTECTED] 29832 502 Mail never gets delivered. With latest vpopmail, i see error vdelivermail: deferred database_down Mail never gets delivered. I cannot see any other relevant error in /var/log/messages or /var/log/maillog. The database is not down since authenticating to vchkpw through port 110 is always successful. I use mysql 4.0.16 compiled. It didn't happen if i use CDB. Best Regards Geri Anggara !DSPAM:491c547332311264916807! begin:vcard fn:Dmitry Dvorkin n:Dvorkin;Dmitry org:Take Over The World Inc;Evil Solutions adr:;;;Tver;;170001;Russia email;internet:[EMAIL PROTECTED] title:Dr Evil x-mozilla-html:FALSE url:http://dvorkin.tvernet.ru version:2.1 end:vcard