ich think the problem will generated in exim-group-router.conf.inc.

if i try to do the query manually with phpmyadmin i get allways

syntax errors at the line "from domains d, groups g, group_contents c, users u"

from the virtual_dom_groups: query

but im not an mysql guru , to trace the problem down.

Holger

# exim-group-router.conf.inc
#
# A group is a list of users
#
# if a group is flaged public
# then anyone on the internet can write to it
# else only members can write to it
#
# If not public non member sender will re,ceive a "550 Unknown user" message
virtual_dom_groups:
�� driver = redirect
�� allow_fail
�� senders = ${if eq{Y}{${lookup mysql{select g.is_public \
�� from groups g, domains d \
�� where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and \
�� d.domain_id = g.domain_id and g.enabled = '1' and \
�� g.name = '${quote_mysql:$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 = '${quote_mysql:$domain}' and \
�� d.domain_id = g.domain_id and g.name = '${quote_mysql:$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' \
�� and u.username = '${quote_mysql:$sender_address}' }}}}
�� data = ${lookup mysql{ \
�� select u.username \
�� from domains d, groups g, group_contents c, users u \
�� where d.enabled�� = '1'�� and \
�� d.domain�� = '${quote_mysql:$domain}'�� and \
�� d.domain_id�� = g.domain_id�� and \
�� g.enabled�� = '1'�� and \
�� g.id�� = c.group_id�� and \
�� c.member_id�� = u.user_id�� and \
�� d.domain_id�� = u.domain_id�� and \
�� u.enabled�� = '1'�� and \
�� g.name�� = '${quote_mysql:$local_part}'} }

#�� local_part_suffix = -*
#�� local_part_suffix_optional

�� retry_use_local_part
�� reply_transport = address_reply
�� pipe_transport = address_pipe

On 14.04.23 00:29, Gordon Dickens wrote:

Hi Holger,

Sorry but I have not yet upgraded to Exim 4.95 or MySql 8.�� Nevertheless, I am sure that I will be upgrading within a few months. Please let us know what you finally determine is the problem and how that you fix it so that the rest of us can benefit from your experience.

Thanks!

Gordon Dickens

On 4/13/23 00:46, Holger Glaess wrote:

hi

i get the error bellow since the update to exim 4.95 and mysql8.

i remove just the orginal names and ips from log.

everthing was fine befor the update ( i had to move to mysql 8 due the old mysql version was outdated. )

any hint for me to fix this ?

Holger

2023-04-13 05:17:16 failed to expand "${if eq{Y}{${lookup mysql{select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = '${quote_mysql:$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 = '${quote_mysql:$domain}' and d.domain_id = g.domain_id and g.name = '${quote_mysql:$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' and u.username = '${quote_mysql:$sender_address}' }}}}" while checking a list: lookup of "select g.is_public from groups g, domains d where d.enabled = '1' and d.domain = 'oneworlddapp.de' and d.domain_id = g.domain_id and g.enabled = '1' and g.name = 'r.maehnhoefer'" gave DEFER: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g, domains d where d.enabled = '1' and d.domain = 'xxxxxx.de' and d' at line 1

2023-04-13 05:17:16 H=xx-xx.xx.de [xx.xx.xx.xx] X=TLS1.3:TLS_AES_256_GCM_SHA384:256 CV=no F=<> temporarily rejected RCPT <yyyyy@xxxxxxx.de>: MYSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'groups g, domains d where d.enabled = '1' and d.domain = 'xxxxxxxxx.de' and d' at line 1

_______________________________________________
users mailing list -- users@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org
_______________________________________________
users mailing list -- users@exim4u.org
To unsubscribe send an email to users-leave@exim4u.org