[00:00:25] *** Mavvie has joined #postfix
[00:08:49] <pdbogen> A regexp sender canonical map did it.
[00:13:52] *** hparker has quit IRC
[00:16:25] *** FastJack has joined #postfix
[00:24:47] *** sepski has quit IRC
[00:27:47] *** hparker has joined #postfix
[00:30:06] <rob0> pdbogen: I'm going to suffer that pain in the near future. "+" is the more "correct" recipient_delimiter, but too many clueless coders out there have made Web-based forms which reject "+". So I'm going to give up and switch to "-".
[00:30:37] <rob0> Phooey on coders who don't know the standards they should be coding to!
[00:31:17] *** knoba has quit IRC
[00:31:26] *** knoba has joined #postfix
[00:31:37] <pickcoder> what if a recpient has - in the address?
[00:31:59] <rob0> yeah ... on the lhs that could cause a mess.
[00:32:31] <rob0> In general it should work though.
[00:32:56] <pickcoder> I don't see what's wrong with whitespace
[00:38:10] *** tris- has joined #postfix
[00:38:33] *** _StyleWarz has joined #Postfix
[00:39:46] *** StyleWarz has quit IRC
[00:39:59] *** vr has quit IRC
[00:40:10] *** vr has joined #postfix
[00:42:53] *** tris has quit IRC
[00:42:54] *** tris- is now known as tris
[00:43:32] *** rob0 has quit IRC
[01:07:46] *** vn has left #postfix
[01:09:37] *** pickcoder has quit IRC
[01:21:24] *** Spec is now known as Spec[x]
[01:29:25] *** variable_office has joined #postfix
[01:30:03] <variable_office> if a user tries to send a large file, they will get back error 552, message too large ; where can i correct this?
[01:30:38] *** Mazon is now known as mazon
[02:02:52] *** jingo has quit IRC
[02:09:35] *** variable_office has left #postfix
[02:16:51] *** nipuL has joined #Postfix
[02:17:04] <nipuL> does virtual accept wildcard domains?
[02:17:23] <nipuL> eg: postmaster@* postmaster
[02:17:49] <nipuL> or do i need to define it for each virtual domain?
[02:18:32] *** war has quit IRC
[02:20:54] *** lx^ has joined #postfix
[02:31:33] <nipuL> ok figured it out, need a regexp: map
[02:48:24] *** Terminator has joined #postfix
[02:55:42] *** AJ_Z0 has quit IRC
[02:56:00] *** AJ_Z0 has joined #postfix
[03:00:18] *** rmayorga has quit IRC
[03:02:21] *** sc00p has joined #postfix
[03:10:20] *** Tachy_ has joined #postfix
[03:17:05] *** fujin has joined #postfix
[03:18:44] *** ronartos has joined #postfix
[03:19:02] <ronartos> anybody online and available to chat?
[03:24:38] *** Tachy has quit IRC
[03:25:42] *** fujin has quit IRC
[03:46:56] *** pickcoder has joined #postfix
[03:49:33] *** ronartos has quit IRC
[03:52:12] *** rmayorga has joined #postfix
[03:53:04] *** higuita has quit IRC
[04:02:05] *** Terminator has quit IRC
[04:03:57] *** amrit|wrk is now known as amrit|bbl
[04:06:38] *** TheOutlander has joined #postfix
[04:15:54] *** ronartos has joined #postfix
[04:16:01] <ronartos> can anybody help?
[04:16:39] <ronartos> we got this local postfix server and hosted non-local mail server which with same domain name
[04:17:36] <ronartos> I just want to send e-mail to a non-local user which he supposed to recieve mail from our main online server, but as of now he always recieved mail locally
[04:20:41] *** doomas has joined #postfix
[04:28:08] *** lx^ has quit IRC
[04:30:01] *** ronartos has left #postfix
[04:33:28] *** doomas_ has quit IRC
[04:46:24] *** fholmes_laptop has joined #postfix
[04:53:26] <fholmes_laptop> Can someone tell me how to convert to a pem file?  I am trying to use new certificates and for some reason Postfix will not read my private key file.
[04:57:01] <sn00p-> Can anybody help me with this error for dovecot and postfix ? Password query failed: Table 'postfix.user' doesn't exist
[04:59:30] <fholmes_laptop> Looks like somewhere something is not looking in the right user table.
[05:00:06] <sn00p-> the user talbe I have is in database called mysql
[05:00:43] <fholmes_laptop> so then either you username and password is wrong or the query is wrong.
[05:00:51] <fholmes_laptop> you/your
[05:01:40] <fholmes_laptop> IE your database username and password.
[05:01:48] <fholmes_laptop> Did you try the query manually yet?
[05:01:59] <sn00p-> oI dont know how to
[05:02:15] <sn00p-> I just try logging from outlook and I get that error
[05:02:18] <fholmes_laptop> You on Linux?  Do you have command line access?
[05:02:38] <sn00p-> freebsd
[05:02:41] <sn00p-> yea I have cli
[05:02:54] <fholmes_laptop> So do you know what your username and password are for the database?
[05:03:05] <sn00p-> yes
[05:03:10] <fholmes_laptop> mysql -u root -p postfixdatabasename
[05:03:16] <fholmes_laptop> it will ask you for your password
[05:03:21] <sn00p-> yea I know
[05:03:58] <fholmes_laptop> then do show tables; and look and see if your table is in there.  If so, then look in the postfix file where you have your query and basically type it in there and see if they query works.
[05:04:31] <fholmes_laptop> You can do a SELECT * FROM TABLE; and find out a username to match, or just match it based on the username you are using now.
[05:04:33] <sn00p-> I only see the user in the table
[05:04:36] <sn00p-> not opassword
[05:04:53] <fholmes_laptop> Is the name of the table postfix.user?
[05:05:02] <sn00p-> nope
[05:05:08] <fholmes_laptop> What is the name of the table?
[05:05:13] <sn00p-> postfix
[05:05:29] <fholmes_laptop> So somewhere you have a mistypeing of the table name it appears.
[05:06:03] <sn00p-> how do I show what data is in user?
[05:06:21] <fholmes_laptop> SELECT user FROM postfix;
[05:06:40] <fholmes_laptop> the user field right?
[05:07:06] <sn00p-> this is weird
[05:07:17] <sn00p-> it says it doesn't exit
[05:07:24] <fholmes_laptop> so are you in mysql right now?
[05:07:28] <sn00p-> yep
[05:07:34] <sn00p-> the user is in the table mysql;
[05:07:41] <fholmes_laptop> so type in show tables;
[05:07:48] <sn00p-> thats how DATABASE_MYSQL.TXT told me to set it up
[05:07:59] <sn00p-> yea
[05:08:00] <sn00p-> user is there
[05:08:09] <sn00p-> under the database mysql
[05:08:14] <fholmes_laptop> Humm, that is weird.  They might have been telling you to set up a database user for Postfix.
[05:08:20] <fholmes_laptop> so do show databases;
[05:08:36] <sn00p-> mysql and postfix
[05:08:42] <fholmes_laptop> Do you have a postfix database?  If so type in use postfix;
[05:08:50] <fholmes_laptop> Then type in show tables;
[05:08:57] <sn00p-> yep
[05:09:22] <sn00p-> all the tables I have in there is admin alias domain doman_admins log mailbox vacation
[05:09:55] <fholmes_laptop> So do you know what file has your users in there?
[05:10:00] <sn00p-> no
[05:10:03] <fholmes_laptop> So do you know what file has your users "QUERY" in there?
[05:10:10] <sn00p-> no
[05:10:13] <fholmes_laptop> in /etc/postfix?
[05:10:30] <sn00p-> no
[05:10:51] <sn00p-> here is what the txt told me to do
[05:11:02] <sn00p-> # You can create the database from the shell with:
[05:11:03] <sn00p-> #
[05:11:03] <sn00p-> # mysql -u root [-p] < DATABASE_MYSQL.TXT
[05:11:03] <sn00p-> #
[05:11:03] <sn00p-> # Postfix / MySQL
[05:11:03] <fholmes_laptop> Is it in your main.cf file?
[05:11:03] <sn00p-> #
[05:11:06] <sn00p-> USE mysql;
[05:11:07] <sn00p-> # Postfix user & password
[05:11:27] <sn00p-> i'm using dovecot
[05:11:30] <sn00p-> also
[05:14:25] <sn00p-> I dont know why it has me using mysql
[05:14:29] <sn00p-> and its under root
[05:14:38] <sn00p-> how do I add another mysql user?
[05:14:50] <fholmes_laptop> You probably don't want to be using mysql unless you have a good reason.
[05:14:58] <fholmes_laptop> it will actually make you loose performance.
[05:15:11] <sn00p-> i need it for authentication
[05:15:42] <sn00p-> postfixadmin
[05:15:42] <fholmes_laptop> Well, there are many other types of files you can use for keeping track of your settings.
[05:16:12] <sn00p-> I use postfixadmin + dovecot + mysql + postfix
[05:16:14] <fholmes_laptop> is that some type of web based postfix gui?
[05:16:27] <sn00p-> yea
[05:16:42] <sn00p-> can I use ldap?
[05:16:53] <fholmes_laptop> Do you know how to setup LDAP?
[05:16:58] <sn00p-> no
[05:17:23] <fholmes_laptop> Then you definately can't use ldap.
[05:17:39] <sn00p-> I think it will mess up my mail system because I have the virtual mailboxes set up to work
[05:18:00] <fholmes_laptop> Humm.  It sounds like either your database import was bad.
[05:18:22] <sn00p-> postfix.users
[05:18:27] <sn00p-> says it should be a table
[05:18:55] <sn00p-> This is frustrating
[05:19:03] <sn00p-> I almost have it setup
[05:19:28] <fholmes_laptop> Well, that might be postfix database and users table.  You should look in the DATABASE_MYSQL.TXT file and see how it created the table.
[05:19:42] <sn00p-> I did
[05:19:50] <sn00p-> I read it and did exactly what it said to do
[05:20:19] <sn00p-> it says to put it under the login root and under mydql; to me that is very unsecure
[05:20:54] <sn00p-> how do I create the user postfix?
[05:22:30] <sn00p-> Someone told me it might be postmap
[05:22:31] <fholmes_laptop> useradd
[05:22:38] <sn00p-> but this isn't a postfix issue
[05:22:45] <fholmes_laptop> I don't know how to run postmap on a mysql database.
[05:25:58] <sn00p-> uhh this is pissing me off
[05:30:29] *** rmayorga has quit IRC
[05:33:44] <sn00p-> fholmes_laptop you mean from the shell not the mydql?
[05:36:35] *** hparker has quit IRC
[05:42:45] <fholmes_laptop> useradd from the shell.
[05:44:03] *** rmayorga has joined #postfix
[05:53:54] *** ziro has quit IRC
[06:05:55] *** Tinozaure is now known as Tino
[06:05:55] *** Tino is now known as Tinozaure
[06:10:14] *** cilly has quit IRC
[06:10:43] *** cilly has joined #postfix
[06:14:18] *** GMFlash has quit IRC
[06:14:25] *** GMFlash has joined #postfix
[06:15:36] *** fholmes_laptop has quit IRC
[06:28:42] *** Motoko-chan has joined #postfix
[07:14:07] *** rmayorga has quit IRC
[07:17:26] *** pickcoder has quit IRC
[08:13:23] *** birmaan has joined #postfix
[08:31:58] *** mazon is now known as Mazon
[08:35:29] *** Fr0zen_ has joined #postfix
[08:49:01] *** fujin has joined #postfix
[08:56:37] *** Arsenick-TC2L has quit IRC
[09:14:07] *** smesjz has joined #postfix
[09:17:21] <smesjz> hi, can I redirect mail in Postfix to two addresses, based on sender address? the sender_bcc_maps only allow one address
[09:19:45] <smesjz> the header_checks and REDIRECT combo also allow only one target
[09:21:12] <smesjz> so I assume the only option here is to make a new alias that expands to joe at domain dot org and sarah at domain dot org ?
[09:22:46] *** livadic`cvetko has joined #postfix
[09:23:30] <livadic`cvetko> guys help me, I'm having problem with 10k mails in queue active and I cant trace from where they come. Any ideas ?
[09:24:38] <smesjz> install pfqueue , it's a nice tool to inspect the queue. Or use postcat
[09:26:32] <livadic`cvetko> any help, I'm not very good with it :(
[09:26:53] <Dominian> I knew there was a reason I hung out in this channel
[09:27:14] *** nightfreak has joined #postfix
[09:27:20] <Dominian> livadic`cvetko: where does your maillog say its all coming from?
[09:27:23] <sn00p-> Hey Dominian can you helpme with postfix
[09:27:28] <Dominian> sn00p-: ?
[09:27:47] <livadic`cvetko> Dominian: cant even catch it in mail log cause it keeps inserting new lines
[09:28:18] <livadic`cvetko> Like crazy, in 1 minute queue active goes to 10+k and it stops around 18k and then starts to grow again
[09:28:35] <smesjz> postfix stop
[09:28:56] <smesjz> stop postfix first before you'll be a spamzombie :)
[09:29:52] <livadic`cvetko> Got few abuse mails, mail headers show that all mails were sent trough squirrell mail webmail system
[09:30:23] <Dominian> livadic`cvetko: disable squirrelmail
[09:30:24] <Dominian> now
[09:30:29] <Dominian> I'm dead serious
[09:30:37] * smesjz looks sternly at Dominian
[09:30:44] <Dominian> trust me on this...
[09:30:52] <Dominian> You have a few webmail users accounts that have been hijacked
[09:31:11] <smesjz> well, headers can be forged too. Can you pastebin one of the headers. Maybe there is more
[09:31:31] <sn00p-> Dominian, why do I get this Password query failed: Table 'postfix.user' doesn't exist
[09:31:39] <sn00p-> Dominian i'm using dovecot and postfix
[09:31:46] <Dominian> smesjz: possbily, but I'm telling you.. shut down webmail
[09:32:05] <Dominian> sn00p-: does the table "user" exist in the database "postfix" ?
[09:32:11] <sn00p-> yep
[09:32:23] <Dominian> Whre's that error comng from?
[09:32:40] <sn00p-> when I try and login with outlook to my imap server
[09:32:47] <smesjz> sn00p-: Password query is a Dovecot thingie..not a Postfix one ;)
[09:33:12] <sn00p-> shit
[09:33:13] <sn00p-> brb
[09:33:14] *** sn00p- has quit IRC
[09:33:34] <livadic`cvetko> http://pastebin.ca/484499
[09:34:25] <Dominian> hmm
[09:34:28] <Dominian> which one of those is your server?
[09:34:39] *** UQlev has joined #postfix
[09:34:44] <Dominian> ahh .. look at that
[09:34:45] <Dominian> they are proxying
[09:34:56] <livadic`cvetko> Yes that's what I'v also noticed
[09:35:21] <Dominian> are they all coming from the same ip?
[09:36:12] <livadic`cvetko> grep -H "10.250.50.104" * -R | wc - l says 46
[09:36:50] <Dominian> 81.199.179.5
[09:36:53] <Dominian> look for that IP
[09:37:18] <livadic`cvetko> 556 mails
[09:37:24] <Dominian> I'd firewall that IP
[09:37:27] <Dominian> then clean out your queue
[09:37:37] <Dominian> and bitch slap whoever orion is
[09:37:40] <Dominian> :)
[09:37:45] <Dominian> its orion's account they are using
[09:37:59] <Dominian> livadic`cvetko: you may want to look in to installing a captcha on squirrelmail
[09:38:17] <Dominian> livadic`cvetko: first thing I'd do.. shut down postfix...
[09:38:22] <Dominian> livadic`cvetko: second.. firewall the IP
[09:38:25] <Dominian> third.. clean out the queue
[09:38:33] <Dominian> fourth .. change orion's password
[09:38:43] <Dominian> fifth.. restart postfix and monitor the queue for a whiel
[09:39:10] <livadic`cvetko> orion has been locked ;) ip firewalled lets just emtpy queue now
[09:39:17] * Dominian nods
[09:39:33] <Dominian> the only reason I know what to somewhat do here...
[09:39:39] *** sn00p- has joined #postfix
[09:39:42] <Dominian> we had the same thing happen to us.. but it was more than one user
[09:39:45] <sn00p-> Dominian, hey you there?
[09:40:02] <Dominian> had three with easily guessed passwords.. and about 20,000 mails in less than 4 hours
[09:40:17] <Dominian> So everything kind of came to a halt all at once
[09:40:18] <Dominian> sn00p-: sup
[09:40:28] <sn00p-> Dominian ok, do you know whats wrong with my dovecot?
[09:40:51] <Dominian> livadic`cvetko: stupid question.. how did you get that header information like that?.. I know how to do it in an email client.. maybe I'm missing something.
[09:41:02] <livadic`cvetko> postcat
[09:41:06] <livadic`cvetko> on one mail :)
[09:41:07] <Dominian> sn00p-: well.. it has to do with something in your dovecot.conf file my guess
[09:41:10] <Dominian> or dovecot-mysql.conf
[09:41:15] <Dominian> livadic`cvetko: oh duh..
[09:42:05] <livadic`cvetko> ok, cleaned queue and fired it up
[09:42:20] *** timotiCK has joined #POSTFIX
[09:42:58] <livadic`cvetko> ok, it contunes to grow
[09:43:05] <livadic`cvetko> from 12 to 25 to 100
[09:43:08] <livadic`cvetko> 340 now
[09:43:23] <livadic`cvetko> prob multiple accounts hijacked
[09:44:28] <Dominian> yeah
[09:44:33] <Dominian> You'll have to take the time to read through and find them all
[09:44:41] <Dominian> make sure it isn't the same proxy IP hitting
[09:45:59] <livadic`cvetko> nah this time different one, blocked it again. Let me clear queue once again
[09:46:14] <livadic`cvetko> is there any way I can got the ip in the log ?
[09:46:25] <livadic`cvetko> maybe to tail log and grep for something ?
[09:46:47] <Dominian> hmmm
[09:46:47] <sn00p-> Dominian I cant find any thing in t he dovecot.conf
[09:47:06] <Dominian> sn00p-: well it has to be getting it from somewhere..
[09:49:27] <sn00p-> I cant find where
[09:49:48] <Dominian> well.. without seeing the config....
[09:49:52] <Dominian> nor can I ;)
[09:50:05] <sn00p-> DO you want to see it?
[09:50:11] <Dominian> sure
[09:54:46] *** amrit|bbl is now known as amrit|zzz
[09:56:23] <livadic`cvetko> hmm, either I'm still sleepy or something is not good. Added that ip to iptables but it still send mails o.O
[09:56:40] <livadic`cvetko> ursus:~# iptables -nvL
[09:56:41] <livadic`cvetko> Chain INPUT (policy ACCEPT 655M packets, 331G bytes)
[09:56:41] <livadic`cvetko>  pkts bytes target     prot opt in     out     source               destination
[09:56:41] <livadic`cvetko>   131 12120 DROP       all  --  *      *       80.255.59.242        0.0.0.0/0
[09:56:58] <xpoint> thats my ip :-)
[09:56:59] <Dominian> what was your iptables line?
[09:57:28] <livadic`cvetko> iptables -I INPUT 1 -s ip -j DROP
[09:58:18] <Dominian> stop postfix
[09:58:19] *** frennkie has joined #postfix
[09:58:22] <Dominian> then restart it
[09:58:31] <Dominian> did you stop webmail?
[09:58:38] <livadic`cvetko> yes
[09:58:49] *** Mez has quit IRC
[10:00:39] <livadic`cvetko> 2k now
[10:00:43] <livadic`cvetko> after restart
[10:00:49] <Dominian> 2000??
[10:00:50] <Dominian> jesus
[10:01:06] <Dominian> Either I'm not thinking straight or I'm getting really freakin' tired.
[10:02:07] *** war has joined #postfix
[10:02:08] <livadic`cvetko> and once again the ip 80.255.59.242 shows up in all mails. And I'v cleaned deferred queue also
[10:03:39] *** timotiCK has quit IRC
[10:05:19] <Dominian> hmmm
[10:05:30] <Dominian> do you have netwatch on that box by chance?
[10:07:43] <livadic`cvetko> no, I dont have it installed
[10:07:56] <Dominian> argh
[10:08:52] <Dominian> Do see this IP 85.222.160.153 in the logs all over the palce?
[10:09:15] <livadic`cvetko> 85.222.160.153 <- webmail IP :)
[10:09:47] <Dominian> and that's your IP?
[10:10:06] <livadic`cvetko> yes
[10:10:31] <Dominian> So even when you have webmail disabled.... email sare still going through
[10:11:05] <livadic`cvetko> yes. webmail disabled emails still going with that header
[10:11:21] <Dominian> that's just fucked up
[10:11:48] *** xpoint has quit IRC
[10:12:00] <livadic`cvetko> makes no logic at all
[10:12:20] <Dominian> yeah no kidding
[10:12:24] <Dominian> and I'm not sure where else to look..
[10:12:27] <livadic`cvetko> umh and incoming queue has 33k mails inside
[10:12:31] <Dominian> if I were on the box.. I could probably figure it out
[10:14:50] <livadic`cvetko> well point in logic is IP blocked but mails still show up
[10:15:00] <livadic`cvetko> is it possbile that they are going from incoming to active queue ?
[10:15:59] <Dominian> could be
[10:16:02] <Dominian> did you clean all the queues out? lol
[10:25:43] <livadic`cvetko> doing it now
[10:26:35] *** Motoko-chan has quit IRC
[10:30:42] <livadic`cvetko> think we got them
[10:30:43] <livadic`cvetko> down :)
[10:30:44] *** unknown has quit IRC
[10:30:54] <livadic`cvetko> 1k mails now
[10:30:59] <livadic`cvetko> which is as ussual
[10:31:14] *** unknown has joined #postfix
[10:31:31] <livadic`cvetko> but def squirell mail
[10:31:36] <livadic`cvetko> has unpatched bug
[10:32:13] * Dominian nods
[10:33:00] <livadic`cvetko> umh what is required to install captcha into squirell mail ?
[10:33:05] <livadic`cvetko> I would like to do it now
[10:33:36] <livadic`cvetko> cause I dont want to sit next to pc whole day looking at which possible proxy or zombie is using that bug now :)
[10:34:39] <sysmonk> hm, squirrel bug?
[10:34:44] <livadic`cvetko> oh yea :)
[10:34:52] <sysmonk> what bug it is ?
[10:35:04] <livadic`cvetko> dunno, I'v could look at webserver logs
[10:35:20] * Dominian uses roundcube webmail
[10:35:30] <sysmonk> you could report it to squirrel, so they could fix the bug
[10:36:08] <livadic`cvetko> there was something on sec mailing lists
[10:36:18] <livadic`cvetko> about squirell mail xss and CRLF attacks I think
[10:36:32] <livadic`cvetko> it's date is 09-05-07
[10:38:36] *** MrRagga has joined #postfix
[10:41:14] <livadic`cvetko> ok guys it was fun morning, I'm going back to sleep
[10:41:16] <livadic`cvetko> have a nice day
[10:41:27] <livadic`cvetko> and tnx for tips :)
[10:41:28] <Dominian> I'm going to head to bed soon myself
[10:41:31] <Dominian> I'm about to pass out
[10:41:35] *** livadic`cvetko has quit IRC
[11:09:07] *** Zeit|awy has joined #postfix
[11:14:49] *** Zeit|idle has quit IRC
[11:18:58] *** cilly has quit IRC
[11:29:53] <sn00p-> ok, i'm having a new problem now, anybody know why I get this? postfix/smtpd[62227]: warning: problem talking to service rewrite: Unknown error: 0
[11:32:42] *** rob0 has joined #postfix
[11:38:06] *** MrRagga has quit IRC
[11:38:33] *** MrRagga has joined #postfix
[11:39:35] *** nightfreak_ has joined #postfix
[11:47:23] *** taube is now known as Taube
[11:50:57] *** nightfreak has quit IRC
[11:57:47] *** UQlev has left #postfix
[12:05:32] *** war has quit IRC
[12:21:23] *** SID_seba has joined #postfix
[12:23:46] <SID_seba> hi, i have postfix working on virtual users, i have an acount, and i want to send a copy (leaving a copy on inbox) to another email. how can ai?
[12:33:22] *** unknown has quit IRC
[12:33:40] <smesjz> make an alias: you at email dot com -> you at email dot com,otherdude@email.com
[12:33:46] *** unknown has joined #postfix
[12:36:20] <SID_seba> thats means
[12:36:51] <SID_seba> user@local   user@local, another@domain
[12:37:39] <Signum> correct
[12:37:50] <SID_seba> with out ->
[12:41:16] <sn00p-> anybody know whats wrong ??warning: connect to mysql server localhost: Access denied for user 'postfix'@'localhost' (using pass$ fatal: mysql:/usr/local/etc/postfix/mysql_virtual_alias_maps.cf(0,lock|fold_fix): table lookup probl$
[12:43:29] <Signum> sn00p-: you have a permissions problem. the user "postfix" from "localhost" is not granted access to the mysql table
[12:43:49] <sn00p-> Do you know how i can fix it?
[12:45:52] <sn00p-> nm
[12:45:53] <sn00p-> I got it
[13:11:32] *** sn00p- has quit IRC
[13:14:12] *** fujin has quit IRC
[13:15:05] *** roe has quit IRC
[13:18:26] *** RT^ has quit IRC
[13:18:31] *** roe has joined #postfix
[13:23:52] *** RT^ has joined #postfix
[13:32:16] *** _RT^ has joined #postfix
[13:32:41] *** _RT^ has quit IRC
[13:34:51] *** _RT^ has joined #postfix
[13:35:38] *** unknown has quit IRC
[13:36:10] *** unknown has joined #postfix
[13:46:15] *** RT^ has quit IRC
[13:48:54] *** Tinozaure is now known as Tino
[13:56:05] *** master_of_master has joined #postfix
[14:08:21] *** master_o1_master has quit IRC
[14:21:19] *** ayeuu has joined #postfix
[14:23:22] *** birmaan has quit IRC
[14:31:44] *** _Tino has joined #postfix
[14:32:18] *** Beket has joined #postfix
[14:37:24] *** frennkie has quit IRC
[14:42:54] *** Tino has quit IRC
[14:47:40] <Beket> Hello everyone. I've skimmed through various tutorials, and I am kind of lost. I want to setup postfix to be able to send email to a SMTP server with TLS. Any hints on what to read ? Thanx
[15:05:18] *** hemry has quit IRC
[15:08:43] *** hemry has joined #postfix
[15:13:46] *** war has joined #postfix
[15:19:43] *** newzen has joined #postfix
[15:20:59] <newzen> hi i have ~11000 on my root mbox, how i can the sen mailer-DAEMON messages not to be sended??
[15:33:50] *** newzen has quit IRC
[15:36:01] *** Beket has left #postfix
[15:36:32] *** Zelest has quit IRC
[15:36:37] *** Zelest has joined #postfix
[15:37:25] *** ceL_ has quit IRC
[15:42:01] *** rootsvr has joined #postfix
[15:46:31] <MidBSD> Is it possible to have Postfix use non-Unix accounts AND Unix accounts at the same time? E.g. in the virtual_alias_maps file "me at test dot com me@localhost    them at there dot com there.com/them"?
[16:04:09] *** hemry has quit IRC
[16:13:55] *** Zelest has quit IRC
[16:16:32] *** sc00p has quit IRC
[16:22:41] *** _StyleWarz is now known as StyleWarz
[16:28:58] *** Zelest has joined #postfix
[16:41:23] *** pickcoder has joined #postfix
[16:43:17] *** rootsvr has quit IRC
[16:43:52] *** Zelest has quit IRC
[16:55:23] <rob0> MidBSD: of course. You can have any combination of address classes. You just can't have the same domain in different classes. But, as you point out, virtual(5) aliasing can redirect individual addresses.
[16:55:26] *** prebur has quit IRC
[16:56:03] *** prebur has joined #postfix
[17:48:29] *** rmayorga has joined #postfix
[17:51:16] *** frennkie has joined #postfix
[18:01:13] *** unknown has quit IRC
[18:02:08] *** unknown has joined #postfix
[18:04:54] *** cilly has joined #postfix
[18:05:12] *** Kurtism has joined #postfix
[18:05:52] *** Taube is now known as taube
[18:14:19] *** GMFlash has quit IRC
[18:14:28] *** GMFlash has joined #postfix
[18:20:56] *** amrit|zzz is now known as amrit
[18:28:26] *** frennkie has quit IRC
[18:38:30] *** rmayorga has quit IRC
[18:56:08] *** xinming_ has joined #postfix
[19:08:38] *** xinming has quit IRC
[19:17:46] *** rmayorga has joined #postfix
[19:20:07] *** war has quit IRC
[19:20:43] *** war has joined #postfix
[19:40:04] <war> If I want postfix to answer on two domains, one IP = 1.2.3.4 and the second IP = 1.2.3.5 can I just add another entry in master.cf?
[19:41:30] <Signum> war: either that or change inet_interfaces
[19:41:42] <war> k nice
[19:42:25] *** VolVE has quit IRC
[19:44:03] *** yassin1 has joined #postfix
[19:44:08] <yassin1> hi everyone
[19:45:15] <yassin1> any idea why i get an error message each time i send a mail to mytest@myhost telling me that there is no such user "mytest" while i can get the mail via smtp ??
[19:45:57] <Signum> you can "get the mail via smtp"? what do you mean? logs?
[19:46:33] *** amrit has quit IRC
[19:48:03] *** amrit has joined #postfix
[19:52:36] *** ek has quit IRC
[19:54:12] <war> question though Signum
[19:54:17] <war> Signum: looks like it will work just fine receiving mail
[19:54:26] <war> however, if domain one = IP 1.1.1.1 and domain two = 2.2.2.2
[19:54:38] <war> how do I send e-mail from the second domain (and also the second IP)?
[19:55:01] <war> because if I send e-mail outbound using the second domain which uses the second IP, then it will be the same tihng as a spoofed e-mail
[19:55:07] <war> which uses* the first IP rather
[20:01:33] <Signum> war: you mean you want to choose the outbound IP address depending on the senders address?
[20:01:48] <Signum> war: It has been discussed here before and let's say it didn't appear to be trivial.
[20:02:23] <Signum> war: Large ISPs that send email for a million domains don't use a million IP addresses either. Reconsider if that's really important.
[20:03:01] <smesjz> yea, they rather have a loadbalancer and a cluster to take care of that
[20:03:44] <Signum> Or perhaps that have just one IP and a short-TTLd entry on the IP of the outbound MX address and before they send out an email they quickly change the PTR record. :)
[20:04:18] <smesjz> the bastards :)
[20:04:31] <smesjz> i bet f3ew uses that
[20:05:06] <Signum> Does India have more than IP address? I thought they NAT everything. Or was it Pakistan? :)
[20:05:35] <smesjz> :)
[20:05:52] * Signum 's keyboard ate the "one"
[20:06:09] <smesjz> you type too fast for the keyboard ;)
[20:06:53] <MidBSD> Can someone help me clarify my terminology for me please?
[20:07:30] <MidBSD> Are virtual_alias_domains and virtual_mailbox_domains different things?
[20:07:53] <Signum> MidBSD: yes.
[20:08:04] <Signum> MidBSD: the difference is: virtual_alias_domains just allow you to forward mail somewhere else
[20:08:17] <Signum> MidBSD: virtual_mailbox_domains allow you to receive and store mails for virtual users on your harddisk
[20:08:24] <MidBSD> Ah, right.
[20:08:33] <MidBSD> So I'll be needing virtual_mailbox_domains
[20:08:35] <MidBSD> thanks signum
[20:08:37] <Signum> likely
[20:09:13] <MidBSD> I'm just changing my configuration to completely virtual domain and user
[20:09:24] <smesjz> but you can alias domains too.. like domain.org to domain.eu if a company has more than one domain
[20:09:44] <MidBSD> I'm just worried that my current unix-account settings are going to interfere as a lot of the tutorials on the Internet assume you're starting from a clean install
[20:10:25] <MidBSD> smesjz: Could they also be aliasing test.com = testing.com?
[20:11:11] <MidBSD> Hmmm... I'm too confused
[20:11:12] <Signum> MidBSD: you can use virtual_alias_maps which works for all kinds of domains, both local, virtual alias and virtual mailbox
[20:11:35] <Signum> MidBSD: local domains are defined in $mydestination. virtual domains are defined in $virtual_alias_domains or $virtual_mailbox_domains
[20:11:54] <Signum> MidBSD: one domain must only belong to one of those three categories. that's all.
[20:12:21] <Signum> MidBSD: if you want to be able to receive mail to local system users you can still use "mydestination=localhost" and reach the users at root@localhost and midbsd@localhost.
[20:12:23] <MidBSD> signum, I could define all my domains in virtual domains though couldn't I? The reason why I'd want to do that is that a tutorial I'm reading suggests that it's easier just to have them all as virtual domains
[20:12:40] <MidBSD> http://www.howtoforge.com/linux_postfix_virtual_hosting
[20:12:41] <Signum> MidBSD: I wouldn't say it's generally easier. The easiest way are local domains. :)
[20:13:28] <Signum> MidBSD: virtual mailbox domains come into play when you have different domains and don't want to create user accounts for all the users on your system
[20:13:45] <MidBSD> Yeah, I don't want to create user accounts on my FreeBSD box
[20:14:08] <Signum> MidBSD: then set "mydestination=" and feel free to use ten million virtual domains :)
[20:14:12] *** devdas has joined #postfix
[20:14:16] <MidBSD> I was going to see if I could set up a system that would allow me to have a system account and everyone else to have a virtual account but I don't think Dovecot would allow it (even if Postfix would)
[20:14:34] <Signum> why should dovecot not allow that?
[20:14:52] <MidBSD> signum: Would it be 'cleaner' to keep all the domains in a separate file like virtual_alias_domains?
[20:15:01] <Signum> you may want to keep one of the domains/hostnames or at least "localhost" as mydestination so you can receive local mail.
[20:15:14] <MidBSD> In reading the Dovecot documentation it seems to only allow for using one type of account or the other
[20:15:35] <MidBSD> Ah, yes, I've got localhost in mydestination
[20:15:38] <Signum> MidBSD: dovecot works well for virtual domains. yes.
[20:15:57] <Signum> MidBSD: I have one local domain here, too, because I want to use procmail (which doesn't work on virtual accounts).
[20:16:29] <MidBSD> It's not that I'm lazy but I just wanted unix-accounts to have the same password as my mail account instead of one password per system (I'm not yet ready to go LDAP)
[20:16:35] <Signum> MidBSD: And although I have just 20 domains I maintain them in a MySQL database instead of text files. That way I can write a web interface and let users change their password for example.
[20:16:54] <MidBSD> Signum: That sounds pretty neat
[20:16:55] <Signum> heh, ldap kept me busy for a week and still doesn't work well :)
[20:17:06] <Signum> MidBSD: what operating system t
[20:17:09] <Signum> MidBSD: do you use?
[20:17:10] *** rmayorga has quit IRC
[20:17:18] <MidBSD> I'm using FreeBSD, Postfix and Dovecot
[20:17:36] <Signum> I see. Just curious because I wrote a tutorial for Debian that would do what you want.
[20:17:37] <MidBSD> I've got postgresql too but I wanted to learn to walk before I start to run
[20:17:48] <Signum> Using text files first is a good idea.
[20:18:03] <MidBSD> I think I'm half way through my config
[20:18:09] <Signum> Most people blindly follow some tutorial and don't understand a word. That bites them sooner or later when they need to debug things.
[20:18:11] <MidBSD> I'm just too scared to restart the server now
[20:18:12] <MidBSD> hehe
[20:18:18] <MidBSD> Yeah, I like to understand
[20:19:01] <Signum> MidBSD: you'll be pleased with virtual mailbox domains. don't worry about restarting postfix. just use a test hostname/domain for the virtual_mailbox_domains. like virtualtest.mydomain.com.
[20:19:39] <MidBSD> I have all weekend to break things :)
[20:20:14] <MidBSD> If I wanted to alias several domains do I do that in virtual_alias_domains?
[20:20:23] <MidBSD> E.g. example.com, example.co.uk
[20:20:32] <Signum> no. just use a virtual_alias_maps entry.
[20:20:37] *** knoba has quit IRC
[20:20:38] <Signum> see "man 5 virtual" for the syntax
[20:20:48] *** knoba has joined #postfix
[20:21:07] <Signum> knoba: hickup?
[20:21:51] <MidBSD> signum: I thought virtual_alias_maps was to map accounts?
[20:22:10] <Signum> MidBSD: you can map whole domains, too
[20:22:31] <Signum> MidBSD: see the man page and look for "@domain"
[20:22:36] <MidBSD> There's also a rather ominous warning in the documentation about NEVER having a catchall in the virtual_alias_map files
[20:23:01] *** nightfreak_ has quit IRC
[20:23:11] <MidBSD> I'll go read up a bit more - then I'll try my new settings out :)
[20:23:19] <MidBSD> Thanks Signum!
[20:25:09] <Signum> catchalls work well. but you also catch an awful lot of spam because every address in the domain works.
[20:25:25] <Signum> customers always want catchall domains but don't want the spam.
[20:25:37] * Signum gets his customer cluebat
[20:25:39] <MidBSD> I figured the warning was to do with a recursive lookup or something
[20:25:57] <Signum> not much to fear IMHO
[20:26:01] <MidBSD> I going to avoid the catchalls from now on. I get 400 spam a day from a catchall account
[20:26:35] * Signum considers using catchalls and forwarding all mails to his spam learn script
[20:26:40] *** taube is now known as Taube
[20:27:38] <MidBSD> I don't have customers. I have fiends who expect me to provide them email
[20:27:39] * devdas suggests Signum forward the spam to a local spamikaze installation
[20:28:03] <devdas> MidBSD: then you need to walk the way of the operator
[20:28:33] <MidBSD> It's only 4 people but then setting up email for one person is as good as setting it up for a thousand
[20:30:31] *** caravena has joined #postfix
[20:31:46] <MidBSD> I have to say, Postfix is much easier to learn
[20:35:50] *** Fr0zen_ has quit IRC
[20:36:42] *** knoba has quit IRC
[20:36:53] *** knoba has joined #postfix
[20:45:30] *** sepski has joined #postfix
[20:47:49] *** mrivera has joined #postfix
[20:51:21] *** mrivera has quit IRC
[20:51:59] *** mrivera has joined #postfix
[20:58:28] <MidBSD> Is virtual_alias_maps the same as virtual_alias_domains?
[20:59:28] <MidBSD> Sorry, scrub that questino
[21:06:20] *** sn00p- has joined #postfix
[21:07:57] *** devdas has left #postfix
[21:09:05] *** rootsvr has joined #postfix
[21:14:56] *** UQlev has joined #postfix
[21:17:36] <Signum> f3ew: If you know the person in charge of spamikaze.org: my german browser settings direct me to /StartSeite which is not the english home page. The wiki admin may want to change that.
[21:18:17] *** sc00p has joined #postfix
[21:20:43] *** Kurtism has quit IRC
[21:20:48] *** Kurtism has joined #postfix
[21:22:47] *** Leonidas has joined #postfix
[21:25:10] <Leonidas> Hi. I messed up my postfix configuratioN: my server does not accept mails from another servers. I get a recipient address rejected. I suspect that my smtpd_recipient_restrictions are too strinct. Can someone help me out with the proper way to configure this?
[21:25:58] <Signum> what does the log say? can you paste the output of "postconf -n"?
[21:26:23] <UQlev> seems relay forbidden
[21:28:43] <Leonidas> Signum: the logs say: http://dpaste.com/10167/
[21:29:28] *** hparker has joined #postfix
[21:30:20] <Leonidas> Signum: and postconf -n: http://dpaste.com/10168/
[21:30:42] <Leonidas> UQlev: error code 554, so it really seems to be releay forbidden.
[21:32:28] <Leonidas> I could of course drop reject_unauth_destination, but that would leave me with an open releay if I understand it correctly.
[21:36:44] <Signum> At a glance I don't see anything wrong.
[21:38:24] <Leonidas> Signum: is the reject at the end of smtpd_recipient_restrictions fine?
[21:39:57] *** tl2 has joined #postfix
[21:40:27] <tl2> hi, postfix is sending my mail as originating from foo@relay_host; meaning it's not using my hostname as the source, but my relay host. Why?
[21:41:13] <Signum> Leonidas: looks like you should leave it off
[21:41:43] <Signum> tl2: whoever/whatever is sending the email should use a proper sender's address.
[21:42:31] *** rootsvr has quit IRC
[21:44:01] <tl2> how?
[21:44:08] <tl2> I'm just using mail/pine to test it
[21:44:59] <Signum> tl2: $mydomain and $append_dot_mydomain is set?
[21:45:43] <tl2> mydomain is set, but not append_dot
[21:46:03] <tl2> you know, it worked briefly yesterday, but reverted back
[21:46:19] <blinx> hi
[21:46:43] <blinx> Signum:
[21:46:46] <blinx> <benny at builtin dot de>: unknown user: "benny"
[21:48:19] <blinx> if I sent a mail from gmail to my server
[21:48:21] <Leonidas> Signum: seems to have worked.
[21:48:28] <blinx> Leonidas: here?
[21:48:29] <Leonidas> Signum: thanks.
[21:48:45] <Leonidas> blinx: you're postifx user? :)
[21:48:51] <tl2> oh great, fixed it
[21:48:54] <blinx> yeah
[21:48:59] <tl2> but don't know how i fixed it
[21:50:01] <blinx> Signum: all mails from outside are rejected or not accepted
[21:50:09] <blinx> Signum: that is my problem
[21:50:27] <blinx> where I have to search?
[21:50:56] <Signum> blinx: start by looking at your logs
[21:52:20] *** tl2 has quit IRC
[21:52:38] *** amrit has quit IRC
[21:52:44] *** mrivera has quit IRC
[21:52:45] *** amrit has joined #postfix
[21:53:22] <blinx> http://paste.debian.net/27821
[21:53:58] <Signum> blinx: you read the warning?
[21:54:05] <blinx> http://paste.debian.net/27822
[21:54:23] <Leonidas> Is there a way to reduce log output? Because postfix is putting really a lot into mail.log, several lines per mail.
[21:54:31] <blinx> ah Signum mom
[21:55:07] <Leonidas> blinx: it is written in the documentation as well.
[21:56:12] *** zUriel has joined #postfix
[21:56:13] *** zUriel has left #postfix
[21:57:09] <blinx> it works now
[21:58:21] *** amrit has quit IRC
[21:58:24] *** KenSentMe has joined #postfix
[21:58:30] *** amrit has joined #postfix
[21:59:13] <blinx> thx
[22:00:25] <KenSentMe> Hi, i run postfix and try to use sasl to authenticate clients for sending mail through postfix. But i get the error that relay access is denied when i try to send mail. I use a correct username and password. This is my main.cf file. Anyone have a clue what goes wrong?
[22:00:29] <KenSentMe> http://paste.ubuntu-nl.org/20536/
[22:00:39] <KenSentMe> ^^ that is the main.cf file
[22:15:25] <Leonidas> I'm calling spamassassin from master.cf with -u ${recipient} which is expanded with username@domain. How to get rid of the whole domain part?
[22:17:09] <Leonidas> Because spamassassin keeps on complaining that no such user exists. Of course it does not exist, because I'm using virtual_alias_maps.
[22:27:38] <Leonidas> Is there a way to pipe the value of recipient in master.cf through sed?
[22:31:21] *** Taube is now known as taube
[22:31:54] *** memic has quit IRC
[22:32:55] *** memic has joined #postfix
[22:33:37] <smesjz> Leonidas: normally you would use amavis for per-user stuff. spamc -u requires a system user, not a virtual one
[22:35:43] <Leonidas> smesjz: I have system users. The problem is: i have the virtaul user marek@mydomain which gets mapped to marek@localhost. There is a system user marek. Unfortunately, $recipient in master.cf is marek@localhost so I would like to get rid of the @localhost part.
[22:38:14] <smesjz> ic, you might need to use a SA wrapper that cuts of the @localhost part
[22:38:28] <smesjz> cant you map marek@mydomain straight to marek ?
[22:40:26] *** AJ_Z0 has quit IRC
[22:40:57] *** AJ_Z0 has joined #postfix
[22:43:06] <Leonidas> smesjz: I tried, but postfix then set recipient to marek@mydomain
[22:49:39] <smesjz> there is a setting for that. append_dot_mydomain = no
[22:51:58] *** smesjz has quit IRC
[22:53:25] <Leonidas> hmm, append_dot_domain is set to no. Strange thing. Anyway, I wrote a script for that
[22:53:32] *** yassin1 has quit IRC
[22:54:13] <Leonidas> http://dpaste.com/10183/
[22:56:11] *** Kurtism has quit IRC
[22:56:21] *** Kurtism has joined #postfix
[23:00:15] <MidBSD> Ok, I think the mist is clearling. Do virtual_alias_domains and virtual_mailbox_domains do the same thing but for different types of user (Unix accounts and non-unix accounts)?
[23:00:44] <MidBSD> Also, can the information in both files actually be stored in the same file?
[23:13:08] *** rmayorga has joined #postfix
[23:16:38] *** caravena_ has joined #postfix
[23:17:22] <Leonidas> If I don't use anvil, can I disable it safely?
[23:18:14] *** war has quit IRC
[23:20:00] *** meandtheshell has quit IRC
[23:23:10] *** megaTherion is now known as Therion
[23:23:25] *** Therion is now known as megaTherion
[23:23:34] *** meandtheshell has joined #postfix
[23:32:45] <Signum> MidBSD: I'd agree to your first sentence.
[23:33:15] <Signum> MidBSD: since a domain is either in mydestination or virtual_alias_domains or virtual_mailbox_domains I'd say no to your second sentence.
[23:33:28] *** caravena has quit IRC
[23:34:52] <MidBSD> signum: You're watching the Eurovision Song Contest, aren't you? :p
[23:35:27] <Signum> MidBSD: my wife is.
[23:35:38] <MidBSD> I took a break to watch some of it too
[23:35:43] <Signum> MidBSD: I'm running kaffeine as a sender because the DVB-S card is in my linux pc. and I'm streaming it to her. :)
[23:35:58] <MidBSD> You're into some technical stuff
[23:35:59] <Signum> MidBSD: Germany and Switzerland are far off anyway. :)
[23:36:02] <Signum> MidBSD: I am.
[23:36:13] <MidBSD> No wonder mail servers are so easy for you ;)
[23:36:40] <MidBSD> Good news - I've got it half working now :)
[23:36:45] <Signum> MidBSD: They weren't easy until - some years ago - I started writing tutorials on the complex setup of ISP-style postfix setups (http://workaround.org)
[23:36:55] *** tuxick has joined #postfix
[23:36:57] <tuxick> lo
[23:37:08] <MidBSD> It's your years of experience that count ;)
[23:37:49] <Signum> MidBSD: Then why am I working in a company where I'm not in charge of the mail servers but have to suffer from M$ Exchange and Outlook... where IMAP and SMTP are disabled for security reasons? (boohoo)
[23:38:23] <tuxick> i'm wondering if postfix milter is ready for production?
[23:38:24] <MidBSD> I feel your pain.
[23:38:41] <MidBSD> I've worked for a lot of people who insist on using MS for everything
[23:38:46] <Signum> MidBSD: That's why I stay around here torturing other users. :)
[23:38:52] <MidBSD> lol
[23:39:03] <jduggan__> hrm
[23:39:04] <MidBSD> Mind you, Signum, there's no substitute for Exchange yet
[23:39:18] <Signum> Only regarding the calendar functions perhaps
[23:39:19] <jduggan__> is it common practise to virus scan outbound email?
[23:39:37] <Signum> jduggan__: for companies probably yes.
[23:39:54] <jduggan__> what about ISP's
[23:39:57] <jduggan__> are they doing such
[23:41:22] <jduggan__> typically, i mean
[23:41:23] <jduggan__> :)
[23:41:29] <tuxick> jduggan__: only if the users use outlook :)
[23:41:45] <jduggan__> heh
[23:43:54] <tuxick> i don't think you'd find many ISPs scanning outgoing
[23:43:58] <tuxick> sadly
[23:44:17] <tuxick> i worry more about spam than viruses of course
[23:44:21] <Signum> idd
[23:45:02] <tuxick> anyway, about this milter, is it relatively stable?
[23:45:28] <tuxick> or can postfix do something similar with clamav already?
[23:45:58] <tuxick> i want to get rid of this amavis beast
[23:52:11] *** sepski has quit IRC
[23:53:15] <Leonidas> meandtheshell: oh, debianforum users in here :)
[23:53:44] <meandtheshell> Leonidas: hi there :)
[23:56:22] <MidBSD> I've missunderstood something. I've entered "test.com midbsd@localhost/" in my virtual_alias_maps. I added the slash because I wanted to use maildir but the logs suggest it doesn't work like that. what am I doing wrong?
[23:57:07] <Signum> MidBSD: the virtual_alias_maps is an ALIASING table. the syntax you are using would fit for virtual_MAILBOX_maps.
[23:57:28] <Signum> MidBSD: the latter specifies where the mailboxes for the virtual users are located on your disk
[23:57:44] <MidBSD> Ah, yes - ALIASING
[23:57:49] <MidBSD> My head is spinning
[23:57:54] <MidBSD> Thanks again signum
[23:58:10] <Signum> Pretty normal. All that directives in the config file. Takes a while to get them.
[23:59:43] *** Leonidas has quit IRC





top