On 14/09/2016 14:17, Viktor Dukhovni wrote:
On Wed, Sep 14, 2016 at 10:27:32AM +0200, Antoine Nguyen wrote:
Do make sure that your tests with the sql CLI really make the same
query against the same database:
SELECT name FROM admin_domain WHERE name='<utf-8-domain>' AND
type='domain' AND enabled=1
I've enabled queries logging. Here is the result :
160914 8:24:14 57 Query SELECT name FROM admin_domain WHERE
name='gaël.com' AND type='domain' AND enabled=1
160914 8:24:31 60 Connect modoboa@localhost as anonymous on modoboa
60 Query SELECT name FROM admin_domain WHERE
name='gaël.com' AND type='domain' AND enabled=1
60 Quit
The first query was executed using mysql shell and it returns 1 row. The
second query was executed by postmap and returns nothing whereas we can see
they are the same...
Do post the "Connect" string for *both* queries.
Here is the missing line :
160914 8:23:57 57 Connect root@localhost as anonymous on modoboa
I indeed tried with root but result is the same if I use modoboa user
with mysql shell: it works.
Antoine
