DM using different database

[frankcheong]

I have just finished a distributed setup where masternode is using Postgres SQL but all other server is using MYSQL. While from my masternode zabbix_server.log, I found the following error message prompt quite frequently:-


12824:20091013:143958 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR: inval
id byte sequence for encoding "UTF8": 0xc227
HINT: This error can also happen if the byte sequence does not match the encodi
ng expected by the server, which is controlled by "client_encoding".
[insert into items (itemid,type,snmp_community,snmp_oid,snmp_port,hos tid,descri
ption,key_,delay,history,trends,status,value_type, trapper_hosts,units,multiplier
,delta,snmpv3_securityname,snmpv3_securitylevel,sn mpv3_authpassphrase,snmpv3_pri
vpassphrase,formula,error,logtimefmt,templateid,va luemapid,delay_flex,params,ipm
i_sensor) values (4504500000021811,12,'','',161,4504500000010042,'D rive backplan
e temperature','drive_backplane.temperature',30,7,36 5,0,0,'','ÂÂ',0,0,'',0,'',''

I have double checked the encoding in the masternode postgre database as below:-

postgres=# \l+
List of databases
Name | Owner | Encoding | Description
-----------+----------+----------+---------------------------
postgres | postgres | UTF8 |
template0 | postgres | UTF8 |
template1 | postgres | UTF8 | Default template database
zabbix | zabbix | UTF8 |


My question is:-
1. Can I use different database on different node(based on physcial consideration which I can make use of existing DB on some child node without having to running one more DB process).
2. What is the meaning of the error message? What casued it and how to solve it?

Thx very much in advance.

Rgds,
Frank

[NOB]

Hi

what is the encoding on the MySQL side - iso-latin1 or something "swedish" ?

I guess the encodings should be the same.

HTH,

Norbert.

[frankcheong]

Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1

that would cause trouble with zabbix DM?

[frankcheong]

OK, finally I have changed all mysql character to utf8. Will double check if this message gone after this setting changed.