piranha
Junior Member | Редактировать | Профиль | Сообщение | Цитировать | Сообщить модератору
Код:
15:03:02 12439 --------> virtual_dom_groups router <--------
15:03:02 12439 local_part=test domain=doma.in
15:03:02 12439 checking senders
15:03:02 12439 expanding: Y
15:03:02 12439 result: Y
15:03:02 12439 expanding: select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${local_part}'
15:03:02 12439 result: select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'test'
15:03:02 12439 search_open: mysql "NULL"
15:03:02 12439 cached open
15:03:02 12439 search_find: file="NULL"
15:03:02 12439 key="select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'test'" partial=-1 affix=NULL starflags=0
15:03:02 12439 LRU list:
15:03:02 12439 internal_search_find: file="NULL"
15:03:02 12439 type=mysql key="select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'test'"
15:03:02 12439 database lookup required for select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'test'
15:03:02 12439 MYSQL query: select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'test'
15:03:02 12439 MYSQL using cached connection for localhost:(/var/run/mysqld/mysqld.sock)/vexim/vexim
15:03:02 12439 lookup yielded: Y
15:03:02 12439 expanding: ${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${local_part}'} }
15:03:02 12439 result: Y
15:03:02 12439 condition: eq{Y}{${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${local_part}'} } }
15:03:02 12439 result: false
15:03:02 12439 expanding: $sender_address
15:03:02 12439 result:
15:03:02 12439 skipping: result is not used
15:03:02 12439 expanding: select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.name = '${local_part}' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1'
15:03:02 12439 result: select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.name = 'test' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1'
15:03:02 12439 search_open: mysql "NULL"
15:03:02 12439 cached open
15:03:02 12439 search_find: file="NULL"
15:03:02 12439 key="select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.name = 'test' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' " partial=-1 affix=NULL starflags=0
15:03:02 12439 LRU list:
15:03:02 12439 internal_search_find: file="NULL"
15:03:02 12439 type=mysql key="select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.name = 'test' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' "
15:03:02 12439 database lookup required for select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.name = 'test' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1'
15:03:02 12439 MYSQL query: select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = 'doma.in' and d.domain_id = g.domain_id and g.name = 'test' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1'
15:03:02 12439 MYSQL using cached connection for localhost:(/var/run/mysqld/mysqld.sock)/vexim/vexim
15:03:02 12439 MYSQL: no data found
15:03:02 12439 lookup failed
15:03:02 12439 expanding: ${lookup mysql{select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.name = '${local_part}' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' } }
15:03:02 12439 result:
15:03:02 12439 expanding: ${if eq{Y}{${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${local_part}'} } } {$sender_address} {${lookup mysql{select u.username from domains d, groups g, group_contents c, users u where d.enabled = '1' and d.domain = '${domain}' and d.domain_id = g.domain_id and g.name = '${local_part}' and g.enabled = '1' and g.is_public = 'N' and c.member_id = u.user_id and d.domain_id = u.domain_id and u.enabled = '1' } } } }
15:03:02 12439 result:
15:03:02 12439 root@doma.in in " "? no (end of list)
15:03:02 12439 virtual_dom_groups router skipped: senders mismatch
|
|
Всего записей: 91 | Зарегистр. 06-03-2002 | Отправлено: 16:08 30-10-2006 | Исправлено: piranha, 16:13 30-10-2006 |
|
