May 18, 2007 
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
May 18, 2007 [00:04:22] *** fujin has joined #postfix [00:08:47] *** magyar has joined #postfix [00:08:54] *** mwc has joined #postfix [00:11:21] *** Kurtism has quit IRC [00:12:57] *** Kurtism has joined #postfix [00:13:58] *** pickcoder has quit IRC [00:21:59] <mwc> I'm trying to get my relayhost to relay via smtp/ssl, that is, port 465. My isp blocks outgoing connects on 25 [00:22:21] <mwc> doesn't seem to work: [00:22:33] <mwc> May 17 18:15:53 iron postfix/smtp[7802]: BD72120A1526: to=<hguthrie at uwo dot ca>, relay=mattcox.ca[216.246.61.94]:465, delay=2587, delays=2287/0.04/300/0, dsn=4.4.2, status=deferred (conversation with mattcox.ca[216.246.61.94] timed out while receiving the initial server greeting) [00:22:52] <mwc> I've used openssl s_client to connect on that port and carry out an SMTP convo [00:22:56] <mwc> so I know that end is fine [00:27:39] *** Neoteric__ has joined #postfix [00:29:48] <rob0> Yes, Postfix does not have an smtps client. [00:34:09] *** Taube is now known as taube [00:37:25] *** Neoteric_ has quit IRC [00:38:19] *** war has joined #postfix [00:44:40] <mwc> hmmmm [00:47:03] <rob0> Maybe this is something stunnel could do, but I don't know. Can't you put your relayhost on some other port, like submission? [00:47:08] <rob0> (Do you run the relayhost?) [00:52:24] *** pirho has quit IRC [00:53:20] <mwc> no, I don't [00:53:33] <mwc> and the other relayhost I have access to requires starttls before mail from: [00:58:51] <rob0> TLS works. [00:59:34] <rob0> afk, bbl [01:00:15] <mwc> yeah, I turned on smtp_use_tls [01:00:23] <mwc> but now I have a new problem [01:01:26] <mwc> May 17 18:53:59 iron postfix/smtp[8162]: C0B4120A1526: to=<mcox22 at uwo dot ca>, relay=smtphm.sympatico.ca[65.54.191.190]:25, delay=24, delays=23/0.1/0.98/0.12, dsn=5.7.3, status=bounced (host smtphm.sympatico.ca[65.54.191.190] said: 550 5.7.3 Requested action aborted; user not authenticated (in reply to MAIL FROM command)) [01:01:35] <mwc> so now i'm working through my sasl config to make sure it's fine [01:02:32] *** Kurtism has quit IRC [01:03:43] *** Kurtism has joined #postfix [01:10:40] *** war has quit IRC [01:11:06] *** flami has quit IRC [01:32:21] *** daqqal has joined #postfix [01:32:22] *** daqqal has left #postfix [01:32:25] *** daqqal has joined #postfix [01:37:00] *** ek has joined #Postfix [01:47:14] *** j416 has left #postfix [02:01:29] *** Kurtism has quit IRC [02:02:09] *** Kurtism has joined #postfix [02:03:59] *** hparker has joined #postfix [02:04:36] *** cilly has quit IRC [02:22:05] *** cilly has joined #postfix [02:29:33] *** cilly has quit IRC [02:30:54] *** jonez734 has joined #postfix [02:33:21] *** fujin_ has joined #postfix [02:41:22] *** fujin has quit IRC [02:42:33] *** jonez has quit IRC [02:53:03] *** jonez734 is now known as jonez [02:57:25] *** Kurtism has quit IRC [02:57:52] *** Kurtism has joined #postfix [03:05:08] *** Tachy_ has joined #postfix [03:19:41] *** Tachy has quit IRC [03:31:50] *** Terminator has joined #postfix [04:02:38] *** cilly has joined #postfix [04:03:47] *** amrit|wrk is now known as amrit|afk [04:08:35] *** ZzimmyY has quit IRC [04:11:27] *** cilly has quit IRC [04:12:00] *** cilly has joined #postfix [04:21:11] *** doomas_ has joined #postfix [04:21:21] *** cilly has quit IRC [04:22:58] *** cilly has joined #postfix [04:25:11] *** cilly has quit IRC [04:25:41] *** cilly has joined #postfix [04:27:32] *** cilly has quit IRC [04:27:45] *** rmayorga has quit IRC [04:28:03] *** cilly has joined #postfix [04:33:23] *** cilly has quit IRC [04:34:46] *** doomas has quit IRC [04:35:44] *** roe_ has joined #postfix [04:36:11] <roe_> does anyone know if something special needs to be done to enable personal maildrop filters? [04:41:11] *** roe_ has quit IRC [04:44:17] *** Kurtism has quit IRC [04:45:43] *** Kurtism has joined #postfix [04:49:32] *** rmayorga has joined #postfix [05:03:42] *** UQlev has joined #postfix [05:11:25] *** Neoteric__ has quit IRC [05:12:48] *** el_cubano has joined #postfix [05:27:24] *** el_cubano has left #postfix [05:33:46] *** Kurtism has quit IRC [05:34:47] *** Kurtism has joined #postfix [05:49:44] *** Lap_64 has quit IRC [06:08:52] *** Tinozaure is now known as Tino [06:08:53] *** Tino is now known as Tinozaure [06:35:45] *** magyar has quit IRC [06:39:12] *** mwc has quit IRC [06:46:16] *** Motoko-chan has joined #postfix [07:06:50] *** birmaan has joined #postfix [07:06:56] *** birmaan has quit IRC [07:07:14] *** birmaan has joined #postfix [07:21:47] *** Fr0zen_ has joined #postfix [07:28:09] *** amrit|afk is now known as amrit [07:30:41] *** GMFlash has quit IRC [07:30:45] *** GMFlash has joined #postfix [07:38:08] *** stellina has quit IRC [07:50:24] *** Kurtism has quit IRC [07:59:46] *** UQlev has left #postfix [08:08:41] *** fujin_ has quit IRC [08:30:35] *** amrit is now known as amrit|zzz [08:31:12] *** Fr0zen_ has quit IRC [08:46:39] *** pmjdebruijn has joined #postfix [08:46:40] *** pmjdebruijn_ has joined #postfix [08:46:49] *** pmjdebruijn_ has quit IRC [08:51:14] *** UQlev has joined #postfix [09:16:36] *** rmayorga is now known as tampoco_yo [09:18:13] *** j416 has joined #postfix [09:23:35] *** tampoco_yo is now known as rmayorga [09:24:06] *** rmayorga has quit IRC [09:24:56] *** smesjz has joined #postfix [09:31:54] *** rajkosto has joined #postfix [09:32:00] <rajkosto> how do i configure uebimiau [09:32:19] <rajkosto> it says invalid username and password [09:32:45] *** cutmasta has joined #postfix [09:33:17] <smesjz> rajkosto: care to give some more info? now it doesn't make sense [09:33:44] <rajkosto> postfix works great and dovecot and everything is configured [09:33:51] <rajkosto> i can use like thunderbird to send and receive mail [09:33:55] <rajkosto> via pop3 and imap [09:34:07] <smesjz> but? [09:34:07] <rajkosto> i have to check auth on smtp but it works when i do that [09:34:20] <smesjz> are you using dovecot sasl? [09:34:31] <rajkosto> yes [09:34:42] <smesjz> like this? [09:34:42] <smesjz> smtpd_sasl_auth_enable = yes [09:34:43] <smesjz> smtpd_sasl_path = private/auth [09:34:43] <smesjz> smtpd_sasl_type = dovecot [09:34:51] <rajkosto> yes [09:34:58] <rajkosto> i followed the ispconfig guide on howtoforge [09:35:22] <rajkosto> You cannot login with the username and password entered. [09:35:22] <rajkosto> Please check your username and password and try again. [09:35:22] <rajkosto> Back [09:35:33] <rajkosto> i set the config thing to one for all [09:35:44] <rajkosto> and just changed smtp auth to yes [09:35:47] <smesjz> what's in the logs? [09:35:58] <rajkosto> whers the logs [09:36:41] <smesjz> *sigh* [09:36:48] <smesjz> read /var/log/mail.log [09:38:23] <rajkosto> not that [09:38:28] <rajkosto> u want me to read postfix logs or [09:38:51] <smesjz> normally both dovecot and postfix logs are there [09:39:34] <smesjz> you should see smthing like: client=jasper[a.b.c.d], sasl_method=PLAIN, sasl_username=foo at bar dot nl [09:39:53] <rajkosto> thers no mail.log anywhere on the system [09:39:57] *** mazon is now known as Mazon [09:39:59] *** frennkie has joined #postfix [09:44:14] <smesjz> check your syslog conf [09:44:21] *** Motoko-chan has quit IRC [09:58:41] <f3ew> learn hotmail as http://www.circleid.com/posts/hotmail_running_own_smtp/ [09:58:45] <f3ew> !learn hotmail as http://www.circleid.com/posts/hotmail_running_own_smtp/ [09:58:50] <f3ew> !!learn hotmail as http://www.circleid.com/posts/hotmail_running_own_smtp/ [09:58:51] <knoba> f3ew: Error: "!learn" is not a valid command. [09:58:56] *** war has joined #postfix [09:58:57] <f3ew> Hmmm [09:59:06] <f3ew> someone teach Knoba about that please [09:59:47] <Signum> hmmm [09:59:53] <Signum> !learn hotmail as http://www.circleid.com/posts/hotmail_running_own_smtp/ [10:00:00] <Signum> !hotmail [10:00:01] <knoba> Signum: 'hotmail' : (#1) http://www.circleid.com/posts/hotmail_running_own_smtp/, or (#2) http://www.circleid.com/posts/hotmail_running_own_smtp/ [10:00:04] <Signum> oops [10:00:07] <Signum> !forget hotmail [10:00:08] <knoba> Signum: Error: 2 factoids have that key. Please specify which one to remove, or use * to designate all of them. [10:00:09] <Signum> !hotmail [10:00:10] <knoba> Signum: 'hotmail' : (#1) http://www.circleid.com/posts/hotmail_running_own_smtp/, or (#2) http://www.circleid.com/posts/hotmail_running_own_smtp/ [10:00:20] <Signum> !forget hotmail #1 [10:00:21] <knoba> Signum: Error: There is no such factoid. [10:00:23] <Signum> !forget hotmail 1 [10:00:27] <Signum> !hotmail [10:00:27] <knoba> Signum: 'hotmail' : http://www.circleid.com/posts/hotmail_running_own_smtp/ [10:00:33] <Signum> f3ew: !learn did it already :) [10:00:56] <f3ew> t didn't ack? [10:01:04] <f3ew> unusual for a bot [10:01:07] <Signum> It's like in UNIX. No ack means it works. [10:01:13] <f3ew> yeah [10:01:57] <smesjz> moin Chris [10:04:13] <sysmonk> Signum: reallly ? [10:04:16] <rajkosto> yay its working [10:04:19] *** rajkosto has quit IRC [10:04:20] <sysmonk> !make_me_a_sandwitch [10:04:20] <knoba> sysmonk: Error: "make_me_a_sandwitch" is not a valid command. [10:04:25] <sysmonk> ah [10:04:29] <sysmonk> i thought it wouldn't ack :) [10:05:07] *** MezzotinT has joined #postfix [10:05:57] <smesjz> Signum: nice to see the progress on the tutorial :) [10:06:02] <MezzotinT> hi, is there a way to read deferred messages to get to know their origin ? [10:06:12] <Signum> Hotmail is pretty lippy :) [10:06:28] <f3ew> mailq [10:06:30] <f3ew> postcat [10:06:30] <Signum> smesjz: Yes, I was diligent yesterday. And I'm pretty happy the normalized database works well. [10:06:59] <MezzotinT> mailq doesn't give me the headers of the messages... postcat might.. :P [10:07:03] <f3ew> sysmonk, it only makes noise on failure [10:07:10] <f3ew> postcat will [10:07:19] <smesjz> I wonder if phpmyadmin is a good choice though. But it's maybe more convenient to use a 'setup.sql' that makes the tables etc; [10:08:09] <MezzotinT> f3ew: awesome... that was what i needed... thanks ^^ [10:08:29] <sysmonk> f3ew: so knoba doesn't have any bread? [10:08:30] <sysmonk> ;/ [10:08:39] *** prebur has quit IRC [10:08:46] <f3ew> !learn sandwich as http://www.xkcd.com/c149.html [10:09:10] *** JoKoT3 has joined #postfix [10:09:13] <sysmonk> ;) [10:19:37] *** prebur has joined #postfix [10:20:56] *** newbie_chris has joined #postfix [10:22:30] <newbie_chris> Does anyone know if there's a way to use ESMTP authentication when relaying messages vis the "relayhost" setting? Or any other way to get message relaying to work on Virgin Media (UK)? [10:23:04] <newbie_chris> I've got relayhost setup great, but mail.virgin.net requires me to authenticate before it'll allow me to relay :( [10:26:14] <sep> http://ben.franske.com/blogs/bensbits.php/2005/09/06/postfix_smtp_auth_support_for_relayhost [10:26:53] *** Lap_64 has joined #postfix [10:28:28] *** stellina_ has quit IRC [10:31:51] <newbie_chris> In an hour of Googling how did I manage not to find that?! Thanks very much. [10:35:27] <sysmonk> hm [10:35:29] *** stellina has joined #postfix [10:35:32] <sysmonk> one problem with that setup... [10:37:00] <sysmonk> the guy says to chmod the file, cause it has his passsword [10:37:23] <sysmonk> (the chmod 600 /etc/postfix/sasl_passwd) [10:37:44] <sysmonk> but ... then again, he makes the hash file world readable ( by chmodding the SAME file with 644 ) [10:37:55] <sysmonk> first of all, it should be sasl_passwd.db [10:38:02] *** UQlev has quit IRC [10:38:29] <sysmonk> and, secondly, even if he chmod'ed 644 the sasl_passwd.db and not sasl_passwd, i woul still be able to see his password [10:38:34] <sysmonk> the .db file is not encrypted [10:38:48] <sysmonk> so, he has some security problems with his setup [10:39:27] *** tartar420 has joined #postfix [10:39:28] <ek> You can read the database? [10:39:53] <sysmonk> just by looking at it ? [10:40:12] <ek> No. By having access. [10:40:27] <sysmonk> ek: in his method - yes [10:40:40] <ek> sasl_passwd shouldn't be limited. But, the database should be. [10:40:45] <ek> Ah. [10:40:54] <sysmonk> he creates a sasl_passwd file [10:40:59] <sysmonk> writes his username and pass there [10:41:02] <sysmonk> and postmap's it [10:41:11] <ek> Encrypted I assume? [10:41:14] <sysmonk> nope [10:41:19] <ek> Ah. Cute. [10:41:26] <ek> That couldn't be any more wrong. [10:41:27] <sysmonk> ek: look at the link [10:41:28] <newbie_chris> can the .db not be owned postfix:postfix and chmod 600 ? [10:41:41] <ek> Unless you limit the file to system only. [10:41:47] <sysmonk> newbie_chris: you meen can it be owned by postfix:postfix and chmod'ed to 600 ? :) [10:41:55] <ek> newbie_chris: Sure. [10:41:58] <sysmonk> ek: yes, but HE chmod's the file to 644 [10:42:01] <sysmonk> so, readable for all [10:42:08] <ek> sysmonk: Not good. [10:42:13] <sysmonk> ek: look at here: http://ben.franske.com/blogs/bensbits.php/2005/09/06/postfix_smtp_auth_support_for_relayhost [10:42:15] *** nfi|ermes has joined #postfix [10:42:25] <sysmonk> so you could understand what i'm talking about [10:42:53] <newbie_chris> cool [10:43:23] <ek> Hrm. [10:43:26] <ek> That's an oopsie. [10:43:46] *** taube is now known as Taube [10:43:49] <ek> That should not be world-readable. You're 100% world readable. [10:44:15] <ek> Why would you chmod it to 600, postmap, then chmod 644? [10:44:20] <ek> He's made a mistake. [10:45:02] <newbie_chris> of course this relies on me *finding* my virgin mail server password, I didn't use it for two years... [10:45:03] <ek> Someone needs to mail him to let him know. Especially if that's a popular how-to/guide. [10:45:25] <ek> newbie_chris: Anyone with access to the system would have access to any mail account on the machine. [10:45:31] <sysmonk> ek: i just wrote a comment [10:45:38] <sysmonk> but it awaits moderation [10:45:43] <stellina> hi ppl [10:45:44] <ek> sysmonk: W-P? [10:45:49] <ek> Hello, stellina. [10:46:00] <sysmonk> ek: b2evolution [10:46:06] <ek> sysmonk: Ah. [10:46:14] <stellina> does postfix support server side delivery notification? [10:46:17] <newbie_chris> ek: how so? [10:46:32] <stellina> I mean to send mail to the sender when the mail is sent to the remote mail server [10:46:40] <sysmonk> newbie_chris: because in his manual he chmods the db file to 644 [10:46:51] <sysmonk> that means, that the db file will be readable by everybody [10:46:56] <sysmonk> and the db file isn't encrypted [10:47:03] <sysmonk> so your password will be there, inside [10:47:22] <sysmonk> and you could see it by just viewing the file with any editor, i.e. vi [10:48:21] <ek> stellina: I'm not quite sure I understand the question. [10:48:29] <sysmonk> here's the proof of concept [10:48:39] <ek> stellina: You want to email the sender when the mail is delivered? [10:48:46] <newbie_chris> sysmonk: aah, yes, I chowned it to postfix:postfix and chmoded it 600 [10:48:53] <newbie_chris> does that fix the problem? [10:48:55] <f3ew> stellina yes [10:48:55] <ek> newbie_chris: That's fine. [10:49:23] <ek> newbie_chris: Well, as long as the user and group "postfix" exists. [10:49:35] <stellina> ek: not when the mail is read by a mail client... I need the sender to get a mail when the mail leaves my mail server and goes to the remote [10:49:52] <ek> stellina: Ah. Then yes. [10:50:13] <ek> Postfix supports just about anything. [10:50:26] <ek> Especially mundane things like sender notification. [10:50:40] <newbie_chris> ek: yeah, that's what postfix runs as, thanks very much :) [10:50:49] <ek> newbie_chris: Sure thing. [10:51:12] <stellina> ek: is this active by default or do I have to add something to main.cf? [10:51:15] <sysmonk> http://p.data.lt/67 [10:51:44] <ek> stellina: It is not active by default. You have to configure Postfix to do such. [10:51:57] <ek> stellina: Start with "man postfix". [10:52:04] <stellina> ek: ok [10:52:31] <ek> Anyhow, I'm off to home. [as] airs the fun stuff tonight. G'night, all. [10:55:18] <stellina> ek: I cannot find such a configuration in man bounce [11:05:49] *** Mez has joined #postfix [11:07:46] *** frennkie has quit IRC [11:10:37] *** Zeit|awy has joined #postfix [11:11:25] *** MezzotinT has quit IRC [11:13:01] *** koollman has joined #postfix [11:17:42] *** Zeit|idle has quit IRC [11:21:23] *** Jax has joined #postfix [11:41:36] *** UQlev has joined #postfix [11:53:48] *** Mavvie2 has joined #postfix [11:59:49] *** nareshov has joined #postfix [12:00:04] <newbie_chris> quit Thanks guys! [12:00:11] *** newbie_chris has quit IRC [12:03:01] <nareshov> Hi, I'm on a fresh freebsd 6.2 with postfix from ports and rc.conf fixed. /usr/local/etc/rc.d/postfix start doesn't start postfix :(. /var/log/maillog says "May 18 08:33:44 students postfix/postqueue[1181]: warning: Mail system is down -- accessing queue directly [12:03:01] <nareshov> " [12:07:28] *** Mavvie has quit IRC [12:13:40] *** Terminator has quit IRC [12:17:06] *** xpoint has joined #postfix [12:20:44] *** Paul23 has joined #postfix [12:24:51] *** cpm has joined #postfix [12:26:25] <Paul23> hi all, sry for the stupid question, but can somebody tell me which main.cf file should i use (the one in my install_root dir or in /etc/postfix). This is the first time i'm dealing with postfix so i'll really appriciate your help [12:27:36] <Roobarb> Paul23: /etc/postfix/main.cf usually [12:28:04] <Paul23> 10x [12:30:01] <many> warning: dict_nis_init: NIS domain name not set - NIS lookups disable [12:30:06] <many> how do i get rid of that? [12:30:33] <Roobarb> Paul23: actually, postfix uses its config as defined in config_directory [12:36:25] <Paul23> Roobarb config_directory? is this the tempdir? [12:36:40] <Roobarb> postconf -d config_directory [12:40:59] <Roobarb> /usr/sbin/postconf [12:43:02] <Paul23> yes it's /etc/postfix ;) [12:45:33] *** belleke has joined #postfix [12:46:09] <belleke> is there a tool for using proxy's with postfix? [12:48:54] *** TheOutlander has joined #postfix [12:50:13] <Roobarb> belleke: what kind of proxy? [12:50:31] <belleke> sow that ip don't show [12:51:18] <Roobarb> that would be very difficult considering IP Address information is stored in the SMTP headers of every email you send [12:51:27] <Roobarb> you'd have to explicitly filter those out [12:52:51] <belleke> thx [12:52:54] *** belleke has quit IRC [12:53:07] <stellina> hi again [12:53:27] <stellina> I have a major problem... for some users I get a session timeout while sending mail [12:53:44] <stellina> after the data command [12:53:50] <stellina> how can I debug this? [12:57:12] *** UQlev has quit IRC [13:02:06] <stellina> any idea? I need your help [13:08:01] *** Mavvie2 is now known as Mavvie [13:11:32] <Roobarb> stellina: use tcpdump to verify whether data is actually being transmitted after the DATA command [13:12:25] <stellina> ok I'll use tcpdump as recommended in the DEBUG_README [13:35:08] <stellina> well I understand nothing from tcpdump's output [13:36:50] *** j416 has quit IRC [13:56:34] *** master_of_master has joined #postfix [13:56:56] *** TheOutlander has quit IRC [14:02:57] *** Taube is now known as taube [14:03:39] *** taube is now known as Taube [14:05:00] *** Taube is now known as taube [14:05:37] *** taube is now known as Taube [14:06:19] *** fatman has joined #postfix [14:06:23] <fatman> hello, i am fat-man and i weigh 400 pounds. you can see video of my supreme fatness at www.fat-man.org [14:07:19] *** j416 has joined #postfix [14:07:34] *** j416 has quit IRC [14:07:35] *** master_o1_master has quit IRC [14:07:36] *** fatman has left #postfix [14:07:39] *** fatman has joined #postfix [14:07:40] <fatman> hello, i am fat-man and i weigh 400 pounds. you can see video of my supreme fatness at www.fat-man.org [14:07:43] *** fatman has left #postfix [14:08:04] *** j416 has joined #postfix [14:08:09] *** frennkie has joined #postfix [14:13:13] <Signum> Yeah, right... [14:14:28] <smesjz> I actually clicked that URL...he is fat :( [14:16:03] *** riz_ has left #postfix [14:17:31] <sep> smesjz, evil you.! [14:18:49] <smesjz> somehow I didn't expect to find a hot chick there though... [14:21:33] <Roobarb> clicking on random URL's is how browsers are exploited... [14:22:20] <smesjz> Roobarb: i'm a dare-devil ;) [14:22:22] <sep> it's also the reason why spam is so rampant. if people just quit clicking everything spam would not "work" anylonger. [14:23:18] <sep> people that click on spam links should have their mouse wielding licence removed ! [14:24:50] *** hoodow has left #postfix [14:26:56] <Signum> sep: Don't be angry. Look at my new rolex! [14:27:40] *** hoodow has joined #postfix [14:28:27] <sep> haha [14:33:24] *** j416 has quit IRC [14:36:58] *** Lap_64 has quit IRC [14:41:10] *** Neoteric_ has joined #postfix [14:51:55] *** j416 has joined #postfix [14:53:51] *** Danielss89 has joined #postfix [14:53:54] <Danielss89> Hi.-. [14:54:20] <Danielss89> ive installed postfix and dovecot, with mysql support, and ive installed postfixadmin [14:54:31] <Danielss89> and when i create a user it creates the folders for the user.. [14:54:58] <Danielss89> but when im sending an email to the user ive created from my gmail i get this error: http://pastebin.ca/494774 [14:55:03] <Danielss89> what is wrong? [14:56:02] <Dominian> 127.0.0.1:60000 [14:56:07] <Danielss89> ? [14:56:09] <Dominian> what's supposed to be listening on port 60000? [14:56:14] <Dominian> that's what the problem is [14:56:30] <Danielss89> hehe i dont know :P ive just followed a guide.. [14:56:45] <Dominian> well look in your postfix main.cf file and find the line with 127.0.0.1:60000 in it [14:56:50] <Dominian> and show me what it is [14:57:23] <Danielss89> http://johnny.chadda.se/2007/04/15/mail-server-howto-postfix-and-dovecot-with-mysql-and-tlsssl-postgrey-and-dspam/ [14:58:13] <Dominian> Did you install postgrey? [14:58:28] <Danielss89> uhm [14:58:45] <Danielss89> no :P [15:01:07] *** mordaunt has left #postfix [15:01:09] <Dominian> Then that's your problem :) [15:01:29] <Dominian> If you just want to test your configuration.. you can remove that line for the check_policy_service and restart postfix [15:01:35] <Dominian> but I suggest that you do use postgrey or sqlgrey [15:01:42] <Dominian> they help a lot [15:02:11] <Danielss89> okey.. [15:03:38] *** pmjdebruijn has quit IRC [15:05:34] <Danielss89> Dominian [15:05:51] <Danielss89> if i add a user via the postfixadmin, will it have IMAP access also? [15:15:56] <Dominian> should [15:18:19] <lkthomas> postgrey is not as good as sqlgrey [15:18:28] <lkthomas> I am using sqlgrey 1days ago [15:18:37] <lkthomas> works pretty good [15:19:52] <Dominian> yeah [15:19:55] <Dominian> same here [15:19:58] <Dominian> sqlgrey is based on postgrey [15:21:40] <lkthomas> I don't feel postgrey is good tho [15:22:40] <lkthomas> if we don't use RBL but greylist only, how effective is it ? [15:23:54] <Danielss89> hmm.. im connected now but it doest fetch the new mail... [15:24:13] <Danielss89> im just using the mail program in windows vista.. [15:24:27] <Danielss89> it creates some directories [15:24:33] <Danielss89> on the server so it is connected.. [15:24:35] <Dominian> well check your maillog [15:24:48] <Dominian> Don't assume its working.. you need to check for errors in the maillog [15:24:49] <Danielss89> but it doesnt get the mails from the new filder [15:25:12] <Dominian> You need to troubleshoot the issue.. I"m not saying its completely fixed.. you could have other issues.. permissions.. ownership.. etc [15:25:35] *** tartar420 has quit IRC [15:25:36] <Danielss89> May 18 15:23:11 danielss89 dovecot: imap-login: Login: user=<danielss89 at potterskolen dot dk>, method=PLAIN, rip=80.62.61.221, lip=89.186.169.112 [15:25:36] <Danielss89> May 18 15:23:11 danielss89 dovecot: IMAP(danielss89 at potterskolen dot dk): Disconnected in IDLE [15:25:36] <Danielss89> May 18 15:25:18 danielss89 dovecot: Killed with signal 15 [15:25:36] <Danielss89> May 18 15:25:19 danielss89 dovecot: Dovecot v1.0.rc15 starting up [15:25:36] <Danielss89> May 18 15:25:20 danielss89 dovecot: auth-worker(default): mysql: Connected to localhost (mail) [15:26:13] <Dominian> Try POP3 [15:26:29] <Dominian> Don't always fully rely on a tutorial [15:26:37] <Dominian> your situation may vary.. and you may hae to do some extra digging to solve issues [15:28:09] <Danielss89> yeah :D [15:28:14] <Danielss89> ive digged a lot :D [15:28:23] <Danielss89> hehe okey with pop3 it gets the new mail [15:29:15] <Danielss89> hmm Dominian when sending a mail from the mail program i get this: [15:29:15] <Danielss89> May 18 15:28:37 danielss89 postfix/smtpd[23254]: warning: dict_nis_init: NIS domain name not set - NIS lookups disabled [15:29:15] <Danielss89> May 18 15:28:37 danielss89 postfix/smtpd[23254]: connect from 0x503e3ddd.hknxx1.adsl-dhcp.tele.dk[80.62.61.221] [15:29:15] <Danielss89> May 18 15:28:37 danielss89 postfix/smtpd[23254]: NOQUEUE: reject: RCPT from 0x503e3ddd.hknxx1.adsl-dhcp.tele.dk[80.62.61.221]: 504 5.5.2 <Daniellappy>: Helo command rejected: need fully-qualified hostname; from=<danielss89 at potterskolen dot dk> to=<danielss89 at gmail dot com> proto=SMTP helo=<Daniellappy> [15:29:17] <Danielss89> May 18 15:28:37 danielss89 postfix/smtpd[23254]: disconnect from 0x503e3ddd.hknxx1.adsl-dhcp.tele.dk[80.62.61.221] [15:29:32] *** Neoteric_ has quit IRC [15:30:13] <Dominian> What client are you using to send email? [15:30:42] *** Lo-lan-do has joined #postfix [15:30:47] <Danielss89> imap [15:30:52] <Dominian> no.. email client [15:30:53] <Danielss89> oh.. [15:31:02] <Danielss89> the one that comes with windows vista [15:31:09] [15:31:09] <Danielss89> Den afviste e-mail-adresse var danielss89 at gmail dot com. Emne 'Re: adsf', Konto: 'potterskolen.dk (1)', Server: 'potterskolen.dk', Protokol: SMTP, Svar fra server: '504 5.5.2 <Daniellappy>: Helo command rejected: need fully-qualified hostname', Port: 25, Sikker (SSL): Nej, Serverfejl: 504, Fejlnummer: 0x800CCC79 [15:31:15] <Danielss89> some of it is in danish [15:31:19] <Dominian> I have no idea what that says [15:31:20] <Danielss89> but the errors is danish [15:31:47] <Danielss89> sorry.. [15:31:53] <Danielss89> i mean the errors is english' [15:32:06] <Danielss89> <Daniellappy>: Helo command rejected: need fully-qualified hostname' [15:32:09] <Dominian> What email clinet are you using? [15:32:29] <lkthomas> LOL Dominian [15:32:55] <lkthomas> are you using SASL ? [15:33:10] <Dominian> Its not SASKL [15:33:14] <Dominian> er.. SASL causing the issue [15:33:22] <lkthomas> hmm [15:33:27] <Dominian> his email client is pushing the name of his laptop as its HELO statement [15:33:39] <Dominian> and postfix is going "uhh.. i want a FQDN.." [15:33:44] <Dominian> and kills the connection [15:33:49] <lkthomas> you have to select SASL enable on your email client [15:34:30] <Dominian> yes and no [15:34:36] <Dominian> <Daniellappy> [15:34:42] <Dominian> as long as THAT is his FQDN ... [15:34:42] <lkthomas> very obvious the problem is caused by that [15:34:51] <Dominian> ohh yeah ok [15:34:56] <Dominian> I see what you're saying [15:34:57] <Dominian> ignore me [15:35:00] <lkthomas> heh [15:35:01] <lkthomas> :) [15:36:17] <lkthomas> a fucking small pizza cost 14USD [15:36:21] <lkthomas> damn expensive [15:38:14] *** j416 has quit IRC [15:42:43] *** j416 has joined #postfix [15:44:17] <xpoint> lkthomas, would you rather die ? :-) [15:44:28] <lkthomas> LOL [15:44:41] <lkthomas> I got 6bucks per hour to work here [15:44:41] *** Jax has quit IRC [15:44:55] <lkthomas> almost two hours of effort [15:45:00] <lkthomas> to buy a pizza [15:45:01] <lkthomas> damn [15:46:49] *** Mazon is now known as mazon [15:54:40] *** UQlev has joined #postfix [15:57:09] <Dominian> heh [15:57:11] <Dominian> then.. [15:57:24] <Dominian> I can buy a pizza within 15 mins of walking in the door... [15:57:53] <Signum> I make pizza myself! [15:58:11] <Signum> Although that usually makes my wife show up yelling "stop that, let me do that... after all I want to eat it, too" [16:01:23] <rob0> Clever! [16:04:37] *** cutmasta has quit IRC [16:04:47] <lkthomas> LOL [16:04:50] <lkthomas> what a smart way [16:04:59] *** Lap_64 has joined #postfix [16:05:22] *** rmayorga has joined #postfix [16:08:00] *** iratik has left #postfix [16:10:13] *** stellina has quit IRC [16:12:44] <lkthomas> damn [16:12:52] <lkthomas> our network engineer is finished with BGP [16:12:55] <lkthomas> I am going to leave soon [16:17:07] *** Paul23 has quit IRC [16:17:15] *** Paul23 has joined #postfix [16:29:22] <xpoint> lkthomas, ? [16:34:02] *** jordi_ has quit IRC [16:37:53] *** mazon is now known as Mazon [16:39:54] <Lo-lan-do> Is there a way to use pipe-delivery with virtual_alias_maps, like it can be done with alias_maps? [16:40:50] <Lo-lan-do> Alternately, is there a way to limit an alias map to one particular domain? [16:41:07] *** j416 has quit IRC [16:43:02] *** j416 has joined #postfix [16:49:08] *** cpm has quit IRC [16:49:51] *** cpm has joined #postfix [16:50:52] *** nemo_work has quit IRC [16:50:57] *** csm-laptop has joined #postfix [16:54:37] *** nemo_work has joined #postfix [16:59:35] *** rmayorga has quit IRC [17:01:25] *** jonez has quit IRC [17:02:31] *** Neoteric_ has joined #postfix [17:05:23] *** Lap_64 has quit IRC [17:06:12] *** Lap_64 has joined #postfix [17:10:26] <Lo-lan-do> Also, is there a way to debug address rewriting without actually sending email to see where it ends up? [17:11:46] *** Mazon is now known as mazon [17:19:26] *** j416 has quit IRC [17:20:11] *** Lap_64 has quit IRC [17:21:28] *** j416 has joined #postfix [17:24:20] *** j416 has quit IRC [17:24:29] *** j416 has joined #postfix [17:26:01] *** rmayorga has joined #postfix [17:27:11] <smesjz> Lo-lan-do: sendmail -bv toaddress at domain dot org [17:28:13] <smesjz> see also: http://www.postfix.org/DEBUG_README.html [17:28:36] <Lo-lan-do> I've tried that, but apparently the results are sent by email. [17:29:53] <Lo-lan-do> And, well, I'd have liked to get the results right now rather than wait for the mail to go through. [17:32:20] <Danielss89> hmm im trying to set up my mail server with postfix, dovecot and reads the users with mysql. It seems to work, i can create users with the postfixadmin, and the directories is created in /var/vmail/domain/user [17:32:46] <Danielss89> and when i send a mail from my gmail, it delivers it to the user, and put the mail in the directory... [17:33:03] *** UQlev has quit IRC [17:33:08] *** nareshov has quit IRC [17:33:09] <Danielss89> im trying with PHP to connect via IMAP but i get these errors: http://mcmoney.dk/test.php [17:33:56] <Danielss89> is IMAP not working or what is wrong [17:40:51] *** nemo_wor1 has joined #postfix [17:40:54] <rob0> That looks like a php coding problem to me. To troubleshoot your imapd, look at its logs. [17:41:02] *** b52laptop has joined #postfix [17:41:07] <b52laptop> hello [17:41:21] <b52laptop> i got a small problem in my postfix setup [17:41:32] <b52laptop> after restarting postfix and in the logs [17:41:42] <b52laptop> fatal: open database /etc/aliases.db: No such file or directory [17:41:51] <b52laptop> i remove the aliases and create them again [17:41:55] <b52laptop> buut i got [17:42:05] <b52laptop> newaliases [17:42:05] <b52laptop> postalias: fatal: open /etc/aliases: No such file or directory [17:43:18] *** lunaphyte has quit IRC [17:43:24] *** lunaphyte has joined #postfix [17:43:27] *** j416 has quit IRC [17:43:54] *** j416 has joined #postfix [17:46:06] *** j416 has quit IRC [17:46:11] *** j416 has joined #postfix [17:47:17] *** nemo_work has quit IRC [17:49:31] *** b52laptop has left #postfix [18:02:32] *** af_ has joined #postfix [18:05:45] *** Neoteric_ has quit IRC [18:07:28] *** af_ has quit IRC [18:20:11] *** Arsenick-TC2L has quit IRC [18:22:32] *** nfi|ermes has quit IRC [18:23:13] *** Arsenick-TC2L has joined #postfix [18:26:57] *** harux has joined #postfix [18:39:46] *** jonez has joined #postfix [18:41:00] *** j416 has quit IRC [18:41:42] *** nemo_wor1 is now known as nemo_work [18:47:14] *** hoodow has left #postfix [18:54:29] *** JoKoT3 has quit IRC [19:23:17] *** SiliconG_ has joined #postfix [19:23:55] <SiliconG_> I want to add port 587 to my master.cf [19:24:15] *** RexMundi has quit IRC [19:24:23] <many> grep subm master.cf [19:24:28] <SiliconG_> but I have a few questions - I want to -o and add a few things so is this a valid command? [19:24:29] <SiliconG_> 127.0.0.1:10587 inet n - - - - smtpd [19:24:50] *** SiliconG_ has left #postfix [19:25:01] <Dominian> http://pastebin.slackadelic.com/137 [19:25:06] <Dominian> That's what mine looks like [19:27:44] *** Paul23 has quit IRC [19:28:47] *** Mez has quit IRC [19:29:25] *** sepski has joined #postfix [19:30:44] *** GMFlash has quit IRC [19:30:48] *** GMFlash has joined #postfix [19:31:22] *** amrit|zzz is now known as amrit|wrk [19:43:52] *** Paul23 has joined #postfix [19:53:17] *** SiliconG has joined #postfix [19:55:40] *** Godsey has joined #postfix [19:56:18] <Godsey> I'm trying to get postfixadmin working, I have php 5.2.1 and mysql_real_escape_string wants the mysql connection handle [19:56:25] <Godsey> might anyone know of a patch that fixes this? [20:02:27] <frennkie> hi guys.. my Server is running in Germany, I do "check_client_access" and in that file I have: [20:02:38] <frennkie> "/(dsl|dynamic|ppp|dhcp|broadband|cable|dialin|dialup).*..*$/ REJECT" [20:03:33] <frennkie> could i have your advise if this is too strict and if I maybe could add some strings that identify dynamic ranges..? thx a lot [20:07:00] *** adf323 has quit IRC [20:07:01] *** SiliconG has quit IRC [20:07:04] *** adf323 has joined #postfix [20:08:06] <Signum> frennkie: wouldn't it be easier to use RBLs that explicitly block dialup IPs? [20:08:23] <Signum> frennkie: besides... ".*..*$" is pretty redundant and can be optimized to "" :) [20:08:40] *** hooch has quit IRC [20:09:29] <frennkie> i'm trying to use a mix.. if i definetly know that "p1234.dialin.t-online.de" is dynamic.. then i can block it before i need to do an external dns lookup [20:09:49] <frennkie> i also have a few RBL lists [20:10:04] <frennkie> thx for that hint.. i'll check that expression [20:11:15] *** SiliconG_ has joined #postfix [20:12:08] <SiliconG_> hello postfix guru's - I have a question - I am trying to add 587 to my master.cf [20:12:37] <Signum> frennkie: I block certain dialups, too. But I would trust your client_access rule. [20:13:34] <SiliconG_> can I add it in this way 127.0.0.1:10587 inet n - - - - smtpd [20:13:45] <SiliconG_> I really dont know what to do here [20:13:57] <frennkie> any hints what strings i could add? maybe there is something that identifys does spammers from china (at least a few ;-)) [20:14:54] <Signum> frennkie: you would need to create a list of asian IP networks. too much work really. [20:15:10] <SiliconG_> can some one explain me this line "127.0.0.1:10025 inet n - - - - smtpd [20:15:23] <Signum> frennkie: I block: adsl.hansenet.de, dip.t-dialin.net, dip0.t-dialin.net, dip0.t-ipconnect.de, dyndsl.versatel.nl, serverkompetenz.net [20:15:30] <Signum> frennkie: that covers most german spam sources [20:16:02] <Signum> frennkie: And my lines are per ISP so I can give the user helpful information. e.g.: dip.t-dialin.net REJECT Bitte senden Sie Mails nicht direkt an uns, sondern nutzen Sie den Mail-Relay-Server von T-Online. Danke. [20:16:16] <Signum> frennkie: or: adsl.hansenet.de REJECT Bitte senden Sie Mails nicht direkt an uns, sondern nutzen Sie den Mail-Relay-Server von Hansenet. Danke. [20:16:46] <Signum> frennkie: some people are unaware of RBLs or even spam. so they need a hint what to do right. I also name our abuse address in case something goes really wrong. [20:16:53] <frennkie> that helps a lot. thankx [20:17:03] <SiliconG_> Signum: I am trying to add port 587 - I have found this -> 587 inet n - - - - smtpd [20:17:40] <Signum> SiliconG_: what is 587? [20:18:08] <SiliconG_> port - 587 - but my question is do I need to proceed that with 127.0.0.1:10587 inet n - - - - smtpd [20:18:42] <SiliconG_> I am trying to make postfix listen on multiple ports [20:19:26] <Signum> SiliconG_: looks reasonable [20:19:39] <SiliconG_> which? the second or the first? [20:20:59] <Signum> SiliconG_: depends on the interfaces you want the port to bound to [20:21:12] <Signum> SiliconG_: if you just need it locally (localhost) then 127.0.0.1 makes sense [20:21:31] <Signum> SiliconG_: But 10587 means TCP port 10587. You may mean 127.0.0.1:587 [20:21:46] <SiliconG_> ok [20:21:47] <frennkie> Signum: I see quite a few ".pool."s in my logs .. would you say it is save to block these? [20:22:25] <SiliconG_> so then where in the file do I add "587 inet n - - - - smtpd" [20:22:28] *** hooch has joined #postfix [20:22:37] <SiliconG_> Signum: can I just add that anywhere? [20:22:50] <Signum> frennkie: might be. I don't know all the DNS entries in the world. :) But it's at "dsl" is a dangerous choice because many leased line companies have that in their DNS names. [20:22:53] <Signum> SiliconG_: yes [20:23:12] <Dominian> YOu don't add.. [20:23:15] <Dominian> http://pastebin.slackadelic.com/137 [20:23:16] <Dominian> read that [20:23:27] <Dominian> You don't specify 587 anywhere.. you specify submission [20:24:22] <Signum> that's just an alias stored in /etc/services... [20:39:10] <Dominian> true [20:43:43] *** Chico-SP has joined #postfix [20:47:47] <madclicker> hi, need to convert mbox email to maildir email that already exists [20:47:57] <madclicker> append [20:49:51] *** Motoko-chan has joined #postfix [20:51:37] <rob0> "Append" in maildir terms is a meaningless concept. But anyway, there are some perl (and probably other) scripts available which do convert to maildir from mbox. [20:51:54] <rob0> You can also do it with a MUA like mutt or kmail. [20:52:45] <madclicker> rob0, the users currently have a maildir, i would like to add the old emails from mbox style system [20:59:44] *** drraid has left #postfix [20:59:57] *** rikstah has quit IRC [21:02:33] *** bertrand^ has joined #postfix [21:04:36] <bertrand^> helo [21:04:48] <bertrand^> is there something wrong having relay_domains = $mydestination ? [21:11:31] <rob0> Although that's the default setting for relay_domains, yes, it is wrong. It's the default for compatibility with ancient Postfix, where relay_domains had a different meaning. [21:13:16] <bertrand^> in fact, i've a domain listed in transport_maps [21:13:34] <bertrand^> whose entry is stmp:some.host:25 [21:13:55] <bertrand^> and i'd like postfix not to check local_recipient_map on it, but forward to the remote host [21:14:03] <bertrand^> (that's temporary) [21:14:42] <rob0> The new (not so new, dating back to at least 2.0) meaning is that. A relay_domains listing is where you're the MX but not the final destination, and you'd have a transport_maps listing to get it to the final destination. [21:14:45] <bertrand^> postfix 2.1.5 [21:15:24] <rob0> local_recipient_maps is for mydestination, whereas relay_recipient_maps does the same thing for relay_domains. [21:16:17] <rob0> The format differs slightly, however. local_recipient_maps lists only the username. relay_recipient_maps list username@domain (the full email address.) [21:16:34] <bertrand^> relay_domains = $mydestination [21:16:40] <bertrand^> mydestination = $myhostname, localhost.$mydomain, $transport_maps [21:16:47] <rob0> ouch [21:17:15] <rob0> So if you needed a special transport to hotmail.com, you'd treat that as a local destination? [21:17:39] <bertrand^> well, that's not my config :) [21:18:02] <bertrand^> hmm, _now_ it's mine, but didn't did it, the guy's gone [21:18:30] <bertrand^> i guess i can safely remove $transport_maps from mydestination [21:19:00] <bertrand^> trying, i'll be saved by soft bounce [21:20:36] * rob0 <3 soft_bounce :) [21:22:07] <bertrand^> in fact, i'm not sure about these local/virtual stuff [21:23:09] <rob0> ADDRESS_CLASS_README might help to explain it. [21:23:40] <bertrand^> reading, thanx [21:23:52] <bertrand^> removed relay_domains = $mydestination [21:24:28] <rob0> relay_domains = domain.you.want.to.relay [21:24:59] <rob0> relay_recipient_maps = hash:/path/to/list/of/addresses [21:27:20] <bertrand^> so: [21:27:22] <bertrand^> mydestination = $myhostname, localhost.$mydomain [21:27:58] <rob0> relay_recipient_maps is technically optional, but if you're going to do it long-term you should have it. [21:28:05] <bertrand^> transport_maps = mysql:/etc/postfix/mysql-transport.cf [21:28:13] <rob0> otherwise you will become a backscatter spammer. [21:28:50] <bertrand^> in this table i have lmtp:127.0.0.1:24 for most domains, smtp:relay.host:25 for the domain i want to relay [21:29:16] <bertrand^> local_recipient_maps = mysql:/etc/postfix/mysql-rcpt-maps.cf [21:29:31] <rob0> transport_maps can indeed be stored in mysql, but it's not considered the best design, because you depend on that always being available. [21:29:52] <rob0> Unusual to have local_recipient_maps in mysql. [21:30:05] <bertrand^> yeah, local_recipient_maps don't work anymoer [21:30:09] <bertrand^> anymore [21:30:26] <bertrand^> it accepts any user [21:31:05] *** eject_ck has joined #postfix [21:31:10] <bertrand^> select count(*) from transport; [21:31:16] <bertrand^> 7369 [21:31:24] <bertrand^> that's why we're using MySQL :) [21:32:35] <rob0> Hmmm, when you get up to more than a handful of local domains, it might be time to consider virtual_mailbox_domains . [21:32:59] <rob0> (I don't say that lightly. I'm a diehard local(8) user.) [21:33:19] <bertrand^> i guess since i removed $transport_maps from mydestination, local_recipient_maps is not used anymore [21:35:57] <bertrand^> i don't use local system account for mails at all [21:36:08] *** jonez734 has joined #postfix [21:36:27] <Dominian> using virtual mailboxes is easier imo [21:36:39] <Dominian> Don't need local usernames on the box. [21:36:49] <Dominian> but then again.. I do hosting only for email/websites so... makes sense for my setup [21:38:29] <bertrand^> got it [21:38:52] <bertrand^> i'll keep all my domains in local for now, i'll tidy it up later [21:39:16] * cpm agrees with Dominian, no reason to have local users on a server, , , at all. [21:39:26] * Dominian nods [21:39:29] <cpm> This is the 21st century, you have a *nix desktop simply [21:39:40] <Dominian> yah [21:39:47] <bertrand^> the domain i want to temporary forward to another host will be in $relay_domains and $relay_transport [21:40:28] *** jonez has quit IRC [21:44:32] *** cilly has joined #postfix [21:46:01] *** Terminator has joined #postfix [21:52:42] *** cpm has quit IRC [21:53:57] *** jonez734 is now known as jonez [21:58:12] <bertrand^> seems to work perfectly, thanx :) [21:59:14] <bertrand^> off course, i had to remove my realy_domains from $transport_maps [22:00:14] *** raw_ has left #postfix [22:05:20] *** birmaan has quit IRC [22:10:29] *** eject_ck has quit IRC [22:18:27] <bertrand^> have to go [22:18:28] <bertrand^> thanx [22:18:29] *** bertrand^ has quit IRC [22:18:52] *** rootsvr has joined #postfix [22:20:17] *** smesjz has quit IRC [22:20:54] *** war has quit IRC [22:26:12] *** eject_ck has joined #postfix [22:33:42] *** csm-laptop has quit IRC [22:34:13] <Danielss89> hmm where is a attached file placed on my server when i recieve a mail with an attachment?? im using postfix and dovecot... and the PEAR NET_POP3 class [22:34:45] *** Lo-lan-do has left #postfix [22:41:07] <eject_ck> Hi all, I'm using postfix with mysql - now need sent copies of incoming letters for some users to their mailboxes at freemails (such yahoo and gmail) [22:41:25] <eject_ck> how I can do this? [22:42:20] <Signum> eject_ck: use virtual_alias_maps. use an alias like "original original,copy". [22:42:31] <eject_ck> Oh [22:44:17] <eject_ck> insert into alias(address,forward) values('originalmail at mail dot com','originalmail@mail.com,backup@gmail.com'); [22:44:21] <eject_ck> ? [22:45:06] <Signum> looks good [22:45:36] <Signum> you can as well insert two rows. values('originalmail at mail dot com','originalmail@mail.com') , ('originalmail at mail dot com','backup@gmail.com') [22:45:50] <Signum> It's the same for postfix but easier for the database. [22:46:29] <eject_ck> I can't make two records with same address [22:46:42] <Signum> why not? wrong indices? [22:47:07] <eject_ck> mysql> describe alias; [22:47:08] <eject_ck> +----------+--------------+------+-----+---------------------+-------+ [22:47:08] <eject_ck> | Field | Type | Null | Key | Default | Extra | [22:47:08] <eject_ck> +----------+--------------+------+-----+---------------------+-------+ [22:47:08] <eject_ck> | address | varchar(255) | NO | PRI | | | [22:47:08] <eject_ck> | goto | text | NO | | | | [22:47:09] <eject_ck> | domain | varchar(255) | NO | | | | [22:47:10] <eject_ck> | created | datetime | NO | | 0000-00-00 00:00:00 | | [22:47:13] <eject_ck> | modified | datetime | NO | | 0000-00-00 00:00:00 | | [22:47:15] <eject_ck> | active | tinyint(1) | NO | | 1 | | [22:47:17] <eject_ck> +----------+--------------+------+-----+---------------------+-------+ [22:47:19] <eject_ck> 6 rows in set (0.02 sec) [22:47:20] <eject_ck> I have PRI key on it [22:47:42] <Signum> suggestion: use a numberical index as primary key but no unique index on the address [22:48:08] <eject_ck> so I must add new field [22:48:10] <Signum> but if you like you can of course stay with your layout :) [22:48:18] <Signum> primary keys on strings are generally a bad idea. [22:48:22] <eject_ck> Signum [22:48:23] <eject_ck> ok [22:48:27] <eject_ck> I'll try [22:48:30] <eject_ck> tnx [22:48:34] <Signum> You're welcome. :) [22:56:31] <eject_ck> mysql> describe alias; [22:56:32] <eject_ck> +----------+------------------+------+-----+---------------------+----------------+ [22:56:32] <eject_ck> | Field | Type | Null | Key | Default | Extra | [22:56:32] <eject_ck> +----------+------------------+------+-----+---------------------+----------------+ [22:56:32] <eject_ck> | id | int(10) unsigned | NO | PRI | NULL | auto_increment | [22:56:32] <eject_ck> | address | varchar(255) | NO | | | | [22:56:34] <eject_ck> | goto | text | NO | | | | [22:56:36] <eject_ck> | domain | varchar(255) | NO | | | | [22:56:39] <eject_ck> | created | datetime | NO | | 0000-00-00 00:00:00 | | [22:56:41] <eject_ck> | modified | datetime | NO | | 0000-00-00 00:00:00 | | [22:56:42] <eject_ck> | active | tinyint(1) | NO | | 1 | | [22:56:44] <eject_ck> +----------+------------------+------+-----+---------------------+----------------+ [22:56:45] <eject_ck> 7 rows in set (0.00 sec) [22:56:48] <eject_ck> Is this good ? [22:58:38] * Signum nods [23:04:49] *** pickcoder has joined #postfix [23:05:37] <eject_ck> Signum, what I must have in config to allow forward messages to another domains (which I use in alias) [23:05:38] <eject_ck> Signum, what I must have in config to allow forward messages to another domains (which I use in alias)? [23:05:43] *** sepski has quit IRC [23:06:08] <Signum> eject_ck: define virtual_alias_maps as a mysql:... mapping and create a 'cf' file that defines your mysql query [23:06:32] <Signum> eject_ck: the query is likely: SELECT goto FROM alias WHERE address='%s'; [23:06:59] <eject_ck> I have this [23:07:11] <eject_ck> I mean main.cf config for resending [23:09:07] *** frennkie has quit IRC [23:24:04] *** eject_ck has quit IRC [23:25:02] *** Taube has left #postfix [23:30:42] *** jonez has quit IRC [23:36:02] *** rootsvr has quit IRC [23:40:47] *** mazon is now known as Mazon [23:45:12] *** lunaphyte has quit IRC [23:46:48] *** Motoko-chan has quit IRC [23:50:32] *** jonez has joined #postfix [23:51:18] *** cilly has quit IRC [23:51:44] *** meandtheshell has quit IRC [23:54:56] <Signum> Phew... Signum needs a tutorial writing break.