ODBC monitoring - the connection was reset

[konstaner]

I have an incomprehensible problem with odbc monitoring!

I installed and configured unixODBC correctly, it's working from shell fine.
When I'm trying to add item, my browser gives me an error page:

The connection was reset
The connection to the server was reset while the page was loading.

I thought that it is beacause my php was configured without unixODBC support. I reconfigured it, but no result!

Type of item: Database monitor
Key: db.odbc.select[testq]
Additional parameters:
DSN=pmon
user=zabbix
password=zabbix
sql=SELECT '1' from dual;

Also I noticed, that when I add quotes to sql="select..." the item creates with no problem! but it's in 'No supported' status with error:

Failed selection [[Oracle][ODBC][Ora]ORA-00900: invalid SQL statement ] (900)

also if I change sql to any other WRONG query the item creates, but dont works. if I set COREECT sql statment - it fails with 'The connection was reset' error.

[konstaner]

I've just tryed to add an item with wrong sql query and then changed it in database, and item works good! =)

But problem with "connection reset" remains...

[konstaner]

Can anybody help? =)

I've tryed to find a problem via firebug (network tab):

on the first step it says:

sql=select count(*) from hosts;

POST items.php aborted

If I change my query for example to:

sql=select_ count(*) from hosts;
or
sql=_select count(*) from hosts;
or
sql="select count(*) from hosts;"

Item creates with no problem.. But it is wrong query and I must update it in database manually..


I thing that problem in php or apache settings..

I use Apache/2.2.17 and PHP Version 5.3.4


maybe downgrade to php 5.3.0 can help?