API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 4th, 2016
165
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 21.51 KB | None | 0 0
raw download clone embed print report
  1. make makefiles shared=yes shlib_directory=/usr/local/lib/postfix/3.1.1 dynamicmaps=yes 'CCARGS=-DHAS_MYSQL -I/usr/include/mysql -DUSE_SASL_AUTH -DDEF_SERVER_SASL_TYPE="dovecot" ' 'AUXLIBS_MYSQL=-L/usr/lib64/mysql -lmysqlclient -lz -lm'
  2.  
  3. ./configure --enable-maintainer-mode --with-mysql
  4. make
  5. make install
  6.  
  7. 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 123-123-123-123
  8. ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 123-123-123-123
  9.  
  10. groupadd -g 5000 vmail
  11.  
  12. useradd -g vmail -u 5000 -s /sbin/nologin vmail
  13.  
  14. compatibility_level = 2
  15. queue_directory = /var/spool/postfix
  16. command_directory = /usr/sbin
  17. daemon_directory = /usr/libexec/postfix
  18. data_directory = /var/lib/postfix
  19. mail_owner = postfix
  20. myhostname = mail.mydomain123.com
  21. mydomain = mydomain123.com
  22. myorigin = $mydomain
  23. inet_interfaces = all
  24. mydestination = $myhostname, localhost.$mydomain, localhost
  25. local_recipient_maps =
  26. unknown_local_recipient_reject_code = 550
  27. alias_maps = hash:/etc/aliases
  28. alias_database = hash:/etc/aliases
  29. smtpd_banner = $myhostname ESMTP unknow
  30. debug_peer_level = 2
  31. debugger_command =
  32. PATH=/bin:/usr/bin:/usr/local/bin:/usr/X11R6/bin
  33. ddd $daemon_directory/$process_name $process_id & sleep 5
  34. sendmail_path = /usr/sbin/sendmail
  35. newaliases_path = /usr/bin/newaliases
  36. mailq_path = /usr/bin/mailq
  37. setgid_group = postdrop
  38. html_directory = no
  39. manpage_directory = /usr/local/man
  40. sample_directory = /etc/postfix
  41. readme_directory = no
  42. smtputf8_enable = no
  43. smtpd_sasl_type = dovecot
  44. smtpd_sasl_path = /var/spool/postfix/private/auth
  45. smtpd_sasl_application_name = smtpd
  46. smtpd_sasl_auth_enable = yes
  47. smtpd_sasl_local_domain = $myhostname
  48. broken_sasl_auth_clients = yes
  49. smtpd_recipient_restrictions = permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination,reject_unknown_sender_domain
  50. smtpd_sasl_security_restrictions = permit_mynetworks,permit_sasl_authenticated,reject_unauth_destination
  51. smtpd_client_restrictions = permit_sasl_authenticated
  52. smtpd_sasl_security_options = noanonymous
  53. proxy_read_maps = $local_recipient_maps $mydestination $virtual_alias_maps $virtual_alias_domains $virtual_mailbox_maps $virtual_mailbox_domains $relay_recipient_maps $relay_domains $canonical_maps $sender_canonical_maps $recipient_canonical_maps $relocated_maps $transport_maps $mynetworks $virtual_mailbox_limit_maps
  54. virtual_mailbox_base = /home/vmail/
  55. virtual_mailbox_domains = proxy:mysql:/etc/postfix/sql/mysql_virtual_domains_maps.cf
  56. virtual_alias_maps =
  57. proxy:mysql:/etc/postfix/sql/mysql_virtual_alias_maps.cf,
  58. proxy:mysql:/etc/postfix/sql/mysql_virtual_alias_domain_maps.cf,
  59. proxy:mysql:/etc/postfix/sql/mysql_virtual_alias_domain_catchall_maps.cf
  60. virtual_mailbox_maps =
  61. proxy:mysql:/etc/postfix/sql/mysql_virtual_mailbox_maps.cf,
  62. proxy:mysql:/etc/postfix/sql/mysql_virtual_alias_domain_mailbox_maps.cf
  63. virtual_uid_maps = static:5000
  64. virtual_gid_maps = static:5000
  65. virtual_transport = dovecot
  66. dovecot_destination_recipient_limit = 1
  67. meta_directory = /etc/postfix
  68. shlib_directory = /usr/local/lib/postfix/${mail_version}
  69.  
  70. smtp inet n - n - - smtpd
  71. pickup unix n - n 60 1 pickup
  72. cleanup unix n - n - 0 cleanup
  73. qmgr unix n - n 300 1 qmgr
  74. tlsmgr unix - - n 1000? 1 tlsmgr
  75. rewrite unix - - n - - trivial-rewrite
  76. bounce unix - - n - 0 bounce
  77. defer unix - - n - 0 bounce
  78. trace unix - - n - 0 bounce
  79. verify unix - - n - 1 verify
  80. flush unix n - n 1000? 0 flush
  81. proxymap unix - - n - - proxymap
  82. proxywrite unix - - n - 1 proxymap
  83. smtp unix - - n - - smtp
  84. relay unix - - n - - smtp
  85. showq unix n - n - - showq
  86. error unix - - n - - error
  87. retry unix - - n - - error
  88. discard unix - - n - - discard
  89. local unix - n n - - local
  90. virtual unix - n n - - virtual
  91. lmtp unix - - n - - lmtp
  92. anvil unix - - n - 1 anvil
  93. scache unix - - n - 1 scache
  94. dovecot unix - n n - - pipe
  95. flags=DRhu user=vmail:vmail argv=/usr/libexec/dovecot/dovecot-lda -f ${sender} -d ${recipient}
  96.  
  97. user = mymaildb
  98. password = mypassword
  99. hosts = localhost
  100. dbname = mymaildb
  101. query = SELECT goto FROM alias WHERE address='%s' AND active = '1'
  102.  
  103. user = mymaildb
  104. password = mypassword
  105. hosts = localhost
  106. dbname = mymaildb
  107. query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('%u', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
  108.  
  109. user = mymaildb
  110. password = mypassword
  111. hosts = localhost
  112. dbname = mymaildb
  113. query = SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = '%d' and alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
  114.  
  115. user = mymaildb
  116. password = mypassword
  117. hosts = localhost
  118. dbname = mymaildb
  119. query = SELECT domain FROM domain WHERE domain='%s' AND active = '1'
  120.  
  121. user = mymaildb
  122. password = mypassword
  123. hosts = localhost
  124. dbname = mymaildb
  125. query = SELECT maildir FROM mailbox WHERE username='%s' AND active = '1'
  126.  
  127. user = mymaildb
  128. password = mypassword
  129. hosts = localhost
  130. dbname = mymaildb
  131. query = SELECT maildir FROM mailbox,alias_domain WHERE alias_domain.alias_domain = '%d' and mailbox.username = CONCAT('%u','@',alias_domain.target_domain) AND mailbox.active = 1 AND alias_domain.active='1'
  132.  
  133. user = mymaildb
  134. password = mypassword
  135. hosts = localhost
  136. dbname = mymaildb
  137. query = SELECT quota FROM mailbox WHERE username='%s' AND active = '1'
  138.  
  139. # 2.2.10: /usr/local/etc/dovecot/dovecot.conf
  140. # OS: Linux 3.10.0-327.22.2.el7.x86_64 x86_64 CentOS Linux release 7.2.1511 (Core)
  141. #log_path = /var/log/dovecot.log
  142. #info_log_path = /var/log/dovecot-info.log
  143. protocols = imap pop3
  144.  
  145. listen = *
  146.  
  147. !include conf.d/*.conf
  148.  
  149. passdb {
  150.  
  151. driver = sql
  152.  
  153. args = /usr/local/etc/dovecot/dovecot-sql.conf.ext
  154.  
  155. }
  156.  
  157. userdb {
  158.  
  159. driver = static
  160.  
  161. args = uid=5000 gid=5000 home=/home/vmail/%d/%n
  162.  
  163. }
  164.  
  165. #debug log
  166.  
  167. auth_debug_passwords=yes
  168.  
  169. mail_debug=yes
  170.  
  171. auth_verbose=yes
  172.  
  173. auth_verbose_passwords=plain
  174.  
  175. disable_plaintext_auth = no
  176. auth_mechanisms = plain login cram-md5
  177. !include auth-system.conf.ext
  178.  
  179. ssl = no
  180.  
  181. mail_location = maildir:/home/vmail/%d/%n/Maildir
  182. namespace inbox {
  183. inbox = yes
  184. }
  185. mbox_write_locks = fcntl
  186.  
  187. log_path = /var/log/dovecot.log
  188. info_log_path = /var/log/dovecot-info.log
  189. debug_log_path = /var/log/dovecot-debug.log
  190. plugin {
  191. }
  192.  
  193. service imap-login {
  194. inet_listener imap {
  195. port = 143
  196. }
  197. inet_listener imaps {
  198. }
  199. }
  200. service pop3-login {
  201. inet_listener pop3 {
  202. port = 110
  203. }
  204. inet_listener pop3s {
  205. }
  206. }
  207. service lmtp {
  208. unix_listener lmtp {
  209. }
  210. }
  211. service imap {
  212. }
  213. service pop3 {
  214. }
  215. service auth {
  216. unix_listener auth-userdb {
  217. mode = 0600
  218. user = vmail
  219. group = vmail
  220. }
  221. unix_listener /var/spool/postfix/private/auth {
  222. mode = 0666
  223. user = postfix
  224. }
  225. }
  226. service auth-worker {
  227. }
  228. service dict {
  229. unix_listener dict {
  230. }
  231. }
  232.  
  233. postmaster_address = postmaster@mydomain123.com
  234. protocol lda {
  235. }
  236.  
  237. driver = mysql
  238. connect = host=localhost dbname=mymaildb user=mymaildb password=mypassword
  239. userdb_warning_disable=yes
  240. #postfixadmin
  241. default_pass_scheme = MD5-CRYPT
  242. password_query = SELECT username AS user,password FROM mailbox WHERE username = '%u' AND active='1'
  243. user_query = SELECT CONCAT('/home/vmail/', maildir) AS home, 5000 AS uid, 5000 AS gid, CONCAT('*:bytes=', quota) as quota_rule FROM mailbox WHERE username = '%u' AND active='1'
  244.  
  245. <?php
  246.  
  247. $CONF['configured'] = true;
  248. $CONF['setup_password'] = 'mypasswordhash';
  249. $CONF['default_language'] = 'en';
  250. $CONF['language_hook'] = '';
  251.  
  252. $CONF['database_type'] = 'mysqli';
  253. $CONF['database_host'] = 'localhost';
  254. $CONF['database_user'] = 'mymaildb';
  255. $CONF['database_password'] = 'mypassword';
  256. $CONF['database_name'] = 'mymaildb';
  257. $CONF['database_prefix'] = '';
  258. $CONF['database_tables'] = array (
  259. 'admin' => 'admin',
  260. 'alias' => 'alias',
  261. 'alias_domain' => 'alias_domain',
  262. 'config' => 'config',
  263. 'domain' => 'domain',
  264. 'domain_admins' => 'domain_admins',
  265. 'fetchmail' => 'fetchmail',
  266. 'log' => 'log',
  267. 'mailbox' => 'mailbox',
  268. 'vacation' => 'vacation',
  269. 'vacation_notification' => 'vacation_notification',
  270. 'quota' => 'quota',
  271. 'quota2' => 'quota2',
  272. );
  273. $CONF['admin_email'] = '';
  274. $CONF['smtp_server'] = 'localhost';
  275. $CONF['smtp_port'] = '25';
  276. $CONF['encrypt'] = 'dovecot:CRAM-MD5';
  277. $CONF['authlib_default_flavor'] = 'md5raw';
  278. $CONF['dovecotpw'] = "/usr/bin/doveadm pw";
  279. $CONF['password_validation'] = array(
  280. # '/regular expression/' => '$PALANG key (optional: + parameter)',
  281. '/.{5}/' => 'password_too_short 5', # minimum length 5 characters
  282. '/([a-zA-Z].*){3}/' => 'password_no_characters 3', # must contain at least 3 characters
  283. '/([0-9].*){2}/' => 'password_no_digits 2', # must contain at least 2 digits
  284. );
  285. $CONF['generate_password'] = 'NO';
  286. $CONF['show_password'] = 'NO';
  287. $CONF['page_size'] = '10';
  288. $CONF['default_aliases'] = array (
  289. 'abuse' => 'abuse@mydomain123.com',
  290. 'hostmaster' => 'hostmaster@mydomain123.com',
  291. 'postmaster' => 'postmaster@mydomain123.com',
  292. 'webmaster' => 'webmaster@mydomain123.com'
  293. );
  294. $CONF['domain_path'] = 'YES';
  295. $CONF['domain_in_mailbox'] = 'NO';
  296. $CONF['maildir_name_hook'] = 'NO';
  297.  
  298. $CONF['admin_struct_hook'] = '';
  299. $CONF['domain_struct_hook'] = '';
  300. $CONF['alias_struct_hook'] = '';
  301. $CONF['mailbox_struct_hook'] = '';
  302. $CONF['alias_domain_struct_hook'] = '';
  303. $CONF['fetchmail_struct_hook'] = '';
  304. $CONF['aliases'] = '1000';
  305. $CONF['mailboxes'] = '1000';
  306. $CONF['maxquota'] = '1000';
  307. $CONF['domain_quota_default'] = '2048';
  308. $CONF['quota'] = 'YES';
  309. $CONF['domain_quota'] = 'YES';
  310. $CONF['quota_multiplier'] = '1024000';
  311. $CONF['transport'] = 'NO';
  312. $CONF['transport_options'] = array (
  313. 'virtual', // for virtual accounts
  314. 'local', // for system accounts
  315. 'relay' // for backup mx
  316. );
  317. $CONF['transport_default'] = 'virtual';
  318. $CONF['vacation'] = 'NO';
  319. $CONF['vacation_domain'] = 'autoreply.mydomain123.com';
  320. $CONF['vacation_control'] ='YES';
  321. $CONF['vacation_control_admin'] = 'YES';
  322. $CONF['vacation_choice_of_reply'] = array (
  323. 0 => 'reply_once', // Sends only Once the message during Out of Office
  324. # considered annoying - only send a reply on every mail if you really need it
  325. # 1 => 'reply_every_mail', // Reply on every email
  326. 60*60 *24*7 => 'reply_once_per_week' // Reply if last autoreply was at least a week ago
  327. );
  328. $CONF['alias_control'] = 'YES';
  329. $CONF['alias_control_admin'] = 'YES';
  330. $CONF['special_alias_control'] = 'NO';
  331. $CONF['alias_goto_limit'] = '0';
  332. $CONF['alias_domain'] = 'YES';
  333. $CONF['backup'] = 'NO';
  334. $CONF['sendmail'] = 'YES';
  335. $CONF['logging'] = 'YES';
  336. $CONF['fetchmail'] = 'NO';
  337. $CONF['fetchmail_extra_options'] = 'NO';
  338. $CONF['show_header_text'] = 'NO';
  339. $CONF['header_text'] = ':: Postfix Admin ::';
  340. $CONF['show_footer_text'] = 'YES';
  341. $CONF['footer_text'] = 'Return to mydomain123.com';
  342. $CONF['footer_link'] = 'mydomain123.com';
  343. $CONF['motd_user'] = '';
  344. $CONF['motd_admin'] = '';
  345. $CONF['motd_superadmin'] = '';
  346. $CONF['welcome_text'] = <<<EOM
  347. Hi,
  348. Welcome to your new account.
  349. EOM;
  350. $CONF['emailcheck_resolve_domain']='YES';
  351. $CONF['show_status']='YES';
  352. $CONF['show_status_key']='YES';
  353. $CONF['show_status_text']='&nbsp;&nbsp;';
  354. $CONF['show_undeliverable']='YES';
  355. $CONF['show_undeliverable_color']='tomato';
  356. $CONF['show_undeliverable_exceptions']=array("unixmail.domain.ext","exchangeserver.domain.ext");
  357. $CONF['show_popimap']='YES';
  358. $CONF['show_popimap_color']='darkgrey';
  359. $CONF['show_custom_domains']=array("subdomain.domain.ext","domain2.ext");
  360. $CONF['show_custom_colors']=array("lightgreen","lightblue");
  361. $CONF['recipient_delimiter'] = "";
  362. $CONF['mailbox_postcreation_script'] = '';
  363. $CONF['mailbox_postedit_script'] = '';
  364. $CONF['mailbox_postdeletion_script'] = '';
  365. $CONF['domain_postcreation_script'] = '';
  366. $CONF['domain_postdeletion_script'] = '';
  367. $CONF['create_mailbox_subdirs'] = array();
  368. $CONF['create_mailbox_subdirs_host']='localhost';
  369. $CONF['create_mailbox_subdirs_prefix']='INBOX.';
  370. $CONF['used_quotas'] = 'YES';
  371. $CONF['new_quota_table'] = 'YES';
  372. $CONF['create_mailbox_subdirs_hostoptions'] = array('');
  373. $CONF['theme_logo'] = 'images/logo-default.png';
  374. $CONF['theme_css'] = 'css/default.css';
  375. $CONF['theme_custom_css'] = '';
  376. $CONF['xmlrpc_enabled'] = false;
  377. if (file_exists(dirname(__FILE__) . '/config.local.php')) {
  378. include(dirname(__FILE__) . '/config.local.php');
  379. }
  380. /* vim: set expandtab softtabstop=4 tabstop=4 shiftwidth=4: */
  381.  
  382. localhost postfix/smtpd[1430]: connect from unknown[myip]
  383. localhost postfix/smtpd[1430]: 8E390DEAD: client=unknown[myip], sasl_method=CRAM-MD5, sasl_username=test1@mydomain123.com
  384. localhost postfix/smtpd[1430]: disconnect from unknown[myip] ehlo=1 auth=1 mail=1 rcpt=1 quit=1 unknown=0/1 commands=5/6
  385.  
  386. auth-worker(1425): Error: pam(test1@mydomain123.com,myip): pam_authenticate() failed: Authentication failure (/etc/pam.d/dovecot missing?)
  387.  
  388. auth-worker(1179): Info: pam(test1@mydomain123.com,myip,<mysession>): unknown user - trying the next passdb
  389. imap-login: Info: Login: user=<test1@mydomain123.com>, method=CRAM-MD5, rip=myip, lip=123.123.123.123, mpid=1200, session=<mysession>
  390.  
  391. auth: Debug: Loading modules from directory: /usr/local/lib/dovecot/auth
  392. auth: Debug: Read auth token secret from /usr/local/var/run/dovecot/auth-token-secret.dat
  393. auth: Debug: auth client connected (pid=0)
  394. auth: Debug: client in: AUTH 1 CRAM-MD5 service=smtp nologin lip=123.123.123.123 rip=myip
  395. auth: Debug: client passdb out: CONT 1 <8291903702710139.1470320898@123-123-123-123>
  396. auth: Debug: client in: CONT 1 test1@mydomain123.com <somehash> (previous base64 data may contain sensitive data)
  397. auth: Debug: pam(test1@mydomain123.com,myip): passdb doesn't support credential lookups
  398. auth-worker(1434): Debug: Loading modules from directory: /usr/local/lib/dovecot/auth
  399. auth-worker(1434): Debug: sql(test1@mydomain123.com,myip): query: SELECT username AS user,password FROM mailbox WHERE username = 'test1@mydomain123.com' AND active='1'
  400. auth: Debug: sql(test1@mydomain123.com,myip): Credentials: <somehash>
  401. auth: Debug: client passdb out: OK 1 user=test1@mydomain123.com
  402.  
  403. Connect mymaildb@localhost as anonymous on mymaildb
  404. 512 Query SELECT username AS user,password FROM mailbox WHERE username = 'test1@mydomain123.com' AND active='1'
  405.  
  406. 513 Connect mymaildb@localhost as anonymous on mymaildb
  407. 513 Query SELECT goto FROM alias WHERE address='mydomain123.com' AND active = '1'
  408. 514 Connect mymaildb@localhost as anonymous on mymaildb
  409. 514 Query SELECT domain FROM domain WHERE domain='mydomain123.com' AND active = '1'
  410. 513 Query SELECT goto FROM alias WHERE address='test1@mydomain123.com' AND active = '1'
  411. 513 Query SELECT goto FROM alias WHERE address='test1@mydomain123.com' AND active = '1'
  412.  
  413. 512 Quit
  414. 514 Quit
  415. 513 Quit
  416.  
  417. localhost postfix/smtpd[1512]: connect from unknown[myip]
  418. localhost postfix/smtpd[1512]: 95C52DEAD: client=unknown[myip], sasl_method=CRAM-MD5, sasl_username=test1@mydomain123.com
  419. localhost postfix/cleanup[1522]: 95C52DEAD: message-id=<d2d0c364-0763-4b04-812f-e1d4862c8745@mydomain123.com>
  420. localhost postfix/qmgr[25451]: 95C52DEAD: from=<test1@mydomain123.com>, size=561, nrcpt=1 (queue active)
  421. localhost postfix/pipe[1523]: 95C52DEAD: to=<test2@mydomain123.com>, relay=dovecot, delay=1.6, delays=1.5/0.01/0/0.02, dsn=2.0.0, status=sent (delivered via dovecot service)
  422. localhost postfix/qmgr[25451]: 95C52DEAD: removed
  423. localhost postfix/smtpd[1512]: disconnect from unknown[myip] ehlo=1 auth=1 mail=1 rcpt=1 data=1 quit=1 commands=6
  424.  
  425. auth-worker(1517): Info: pam(test2@mydomain123.com): unknown user - trying the next passdb
  426. lda(test2@mydomain123.com): Info: msgid=<d2d0c364-0763-4b04-812f-e1d4862c8745@mydomain123.com>: saved mail to INBOX
  427.  
  428. auth: Debug: Loading modules from directory: /usr/local/lib/dovecot/auth
  429. auth: Debug: Read auth token secret from /usr/local/var/run/dovecot/auth-token-secret.dat
  430. auth: Debug: auth client connected (pid=0)
  431. auth: Debug: client in: AUTH 1 CRAM-MD5 service=smtp nologin lip=123.123.123.123 rip=myip
  432. auth: Debug: client passdb out: CONT 1 <8451358779272317.1470321603@123-123-123-123>
  433. auth: Debug: client in: CONT 1 test1@mydomain123.com <somehash> (previous base64 data may contain sensitive data)
  434. auth: Debug: pam(test1@mydomain123.com,myip): passdb doesn't support credential lookups
  435. auth-worker(1517): Debug: Loading modules from directory: /usr/local/lib/dovecot/auth
  436. auth-worker(1517): Debug: sql(test1@mydomain123.com,myip): query: SELECT username AS user,password FROM mailbox WHERE username = 'test1@mydomain123.com' AND active='1'
  437. auth: Debug: sql(test1@mydomain123.com,myip): Credentials: <somehash>
  438. auth: Debug: client passdb out: OK 1 user=test1@mydomain123.com
  439. auth: Debug: master in: USER 1 test2@mydomain123.com service=lda
  440. auth-worker(1517): Debug: pam(test2@mydomain123.com): lookup
  441. auth: Debug: pam(test2@mydomain123.com): passdb doesn't support credential lookups
  442. auth-worker(1517): Debug: sql(test2@mydomain123.com): query: SELECT username AS user,password FROM mailbox WHERE username = 'test2@mydomain123.com' AND active='1'
  443. lda(test2@mydomain123.com): Debug: auth input: test2@mydomain123.com uid=5000 gid=5000 home=/home/vmail/mydomain123.com/test2
  444. lda(test2@mydomain123.com): Debug: Effective uid=5000, gid=5000, home=/home/vmail/mydomain123.com/test2
  445. lda(test2@mydomain123.com): Debug: Namespace inbox: type=private, prefix=, sep=, inbox=yes, hidden=no, list=yes, subscriptions=yes location=maildir:/home/vmail/mydomain123.com/test2/Maildir
  446. lda(test2@mydomain123.com): Debug: maildir++: root=/home/vmail/mydomain123.com/test2/Maildir, index=, indexpvt=, control=, inbox=/home/vmail/mydomain123.com/test2/Maildir, alt=
  447. lda(test2@mydomain123.com): Debug: none: root=, index=, indexpvt=, control=, inbox=, alt=
  448. lda(test2@mydomain123.com): Debug: Destination address: test2@mydomain123.com (source: user@hostname)
  449. auth: Debug: sql(test2@mydomain123.com): Credentials: <somehash>
  450. auth: Debug: userdb out: USER 1 test2@mydomain123.com uid=5000 gid=5000 home=/home/vmail/mydomain123.com/test2
  451.  
  452. 515 Connect mymaildb@localhost as anonymous on mymaildb
  453. 515 Query SELECT username AS user,password FROM mailbox WHERE username = 'test1@mydomain123.com' AND active='1'
  454. 516 Connect mymaildb@localhost as anonymous on mymaildb
  455. 516 Query SELECT goto FROM alias WHERE address='mydomain123.com' AND active = '1'
  456. 517 Connect mymaildb@localhost as anonymous on mymaildb
  457. 517 Query SELECT domain FROM domain WHERE domain='mydomain123.com' AND active = '1'
  458. 516 Query SELECT goto FROM alias WHERE address='mydomain123.com' AND active = '1'
  459. 517 Query SELECT domain FROM domain WHERE domain='mydomain123.com' AND active = '1'
  460. 516 Query SELECT goto FROM alias WHERE address='test2@mydomain123.com' AND active = '1'
  461. 516 Query SELECT goto FROM alias WHERE address='test2@mydomain123.com' AND active = '1'
  462. 516 Query SELECT goto FROM alias WHERE address='mydomain123.com' AND active = '1'
  463. 517 Query SELECT domain FROM domain WHERE domain='mydomain123.com' AND active = '1'
  464. 515 Query SELECT username AS user,password FROM mailbox WHERE username = 'test2@mydomain123.com' AND active='1'
  465. 516 Quit
  466. 517 Quit
  467. 515 Quit
  468.  
  469. 5 Connect mymaildb@localhost as anonymous on mymaildb
  470. 5 Query SELECT goto FROM alias WHERE address='mydomain123.com' AND active = '1'
  471. 6 Connect mymaildb@localhost as anonymous on mymaildb
  472. 6 Query SELECT domain FROM domain WHERE domain='mydomain123.com' AND active = '1'
  473. 7 Connect mymaildb@localhost as anonymous on mymaildb
  474. 7 Query SELECT username AS user,password FROM mailbox WHERE username = 'test1@mydomain123.com' AND active='1'
  475. 7 Quit
  476.  
  477. 5 Query SELECT goto FROM alias WHERE address='root@localhost' AND active = '1'
  478. 8 Connect mymaildb@localhost as anonymous on mymaildb
  479. 8 Query SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = 'localhost' and alias.address = CONCAT('root', '@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
  480. 9 Connect mymaildb@localhost as anonymous on mymaildb
  481. 9 Query SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = 'localhost' and alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
  482. 5 Query SELECT goto FROM alias WHERE address='root' AND active = '1'
  483. 5 Query SELECT goto FROM alias WHERE address='@localhost' AND active = '1'
  484. 9 Query SELECT goto FROM alias,alias_domain WHERE alias_domain.alias_domain = 'localhost' and alias.address = CONCAT('@', alias_domain.target_domain) AND alias.active = 1 AND alias_domain.active='1'
  485. 5 Query SELECT goto FROM alias WHERE address='localhost' AND active = '1'
  486. 6 Query SELECT domain FROM domain WHERE domain='localhost' AND active = '1'
  487.  
  488. 8 Quit
  489. 6 Quit
  490. 9 Quit
  491. 5 Quit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!