[exim-dev] EXIM4-daemon-heavy with MySQL = error

Top Page
Delete this message
Reply to this message
Author: Andreas Sokov
Date:  
To: exim-dev
Subject: [exim-dev] EXIM4-daemon-heavy with MySQL = error
Hi, exim-dev.

i use LINUX DEBIAN

# exim4 -bV
Exim version 4.54 #1 built 02-Nov-2005 19:44:06
Copyright (c) University of Cambridge 2005
Berkeley DB: Sleepycat Software: Berkeley DB 4.2.52: (December 3, 2003)
Support for: crypteq iconv() IPv6 PAM Perl GnuTLS Content_Scanning Old_Demime
Lookups: lsearch wildlsearch nwildlsearch iplsearch cdb dbm dbmnz dnsdb dsearch ldap ldapdn ldapm mysql nis nis0 passwd pgsql
Authenticators: cram_md5 cyrus_sasl plaintext spa
Routers: accept dnslookup ipliteral iplookup manualroute queryprogram redirect
Transports: appendfile/maildir/mailstore/mbx autoreply lmtp pipe smtp
Fixed never_users: 0
Configuration file is /var/lib/exim4/config.autogenerated

# mysql -V
mysql Ver 14.12 Distrib 5.0.13-rc, for pc-linux-gnu (i486) using readline 5.0


i use Mysql DB for store users, emails, etc ...

and hav such error :

=============================
.....
--------> courier_user router <--------
local_part=andreas domain=j8.com.ru
R: courier_user for andreas@???
checking "condition"
search_open: mysql "NULL"
search_find: file="NULL"
key="SELECT id FROM COURIER_PWD WHERE id=CONCAT('andreas', '@', 'j8.com.ru')" partial=-1 affix=NULL starflags=0
LRU list:
:/etc/exim4/domains/local_domains
End



internal_search_find: file="NULL"
type=mysql key="SELECT id FROM COURIER_PWD WHERE id=CONCAT('andreas', '@', 'j8.com.ru')"
database lookup required for SELECT id FROM COURIER_PWD WHERE id=CONCAT('andreas', '@', 'j8.com.ru')
MYSQL query: SELECT id FROM COURIER_PWD WHERE id=CONCAT('andreas', '@', 'j8.com.ru')
MYSQL new connection: host=localhost port=0 socket=/var/run/mysqld/mysqld.sock database=RADIUS user=courier
MYSQL: query failed: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

lookup deferred: MYSQL: query failed: Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation '='

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

condition check lookup defer
andreas@??? cannot be resolved at this time:
condition check lookup defer
search_tidyup called
close MYSQL connection: localhost:(/var/run/mysqld/mysqld.sock)/RADIUS/courier
>>>>>>>>>>>>>>>> Exim pid=15236 terminating with rc=1 >>>>>>>>>>>>>>>>

.....
=============================

Who can explain to me what is this and in what is my problems ?



-- 
 Best Regards, Andreas                          
 Wednesday, December 28, 2005 4:42:23 AM


 "Do not hesitate to ask me"
 ICQ UIN 177624
 http://ServersLease.net - Offshore Dedicated Servers, Offshore Collocation
 http://HOST-LUX.RU      - Offshore Virtual Hosting, Web Hosting, as low as 5$ per 1Gb HDD/month
 http://Reg-Master.net   - Register`s Master of Domains
 http://Web-Media.Ru     - Web Design studio.