DBforBIX 0.5 has been released!
on this release :
- some minor improvement on documentation
- fixed an issue with “AddSpace” parameter set
- fixed other minor issue
this software lacks of:
- query for MSSQL Server
- query for DB2
THIS IS A PREVIEW RELEASE AND IS NOT FULLY TESTED AS A STABLE PRODUCTION RELEASE
You can download DBforBIX here
Tags: database, db2, dbforbix, linkedin, MySQL, oracle, postgresql, zabbix
I am happy to announce that we have a new wiki!
Currently only Orabbix‘s manual has been updated and is almost completed, the rest is still a work in progress but it is a good place where start.
On the wiki is also a first version of the manual and DBforBIX PostBIX
Stay tuned!
The wiki is available from menù on top
Tags: database, linkedin, orabbix, postgresql, zabbix
The following error:
java.sql.SQLException: ORA-24247: network access denied by access control list (ACL)
ORA-06512: at “SYS.UTL_INADDR”, line 4
ORA-06512: at “SYS.UTL_INADDR”, line 35
ORA-06512: at line 1
Cause:
A new security measure is introduced in Oracle 11g Release 1 (11.1) for the following network-related PL/SQL packages: UTL_TCP, UTL_HTTP, UTL_SMTP, UTL_MAIL, UTL_INADDR, DBMS_LDAP and the HttpUriType type.
The invoker of those packages needs additional privileges to connect to an external host or to resolve the name or the IP address of a host.
The packages check the invoker for the necessary privileges only when the calls are made at runtime and raises an exception if the invoker lacks the privileges. T
his new security measure is implemented by the XML DB access control list (ACL) mechanism and, therefore, requires XML DB to be installed and Configure network Access Control Lists (ACLs) in the database before these packages can work as they were working in prior releases.
Set the ACL for your 11g schema :
1. Connect to the database with SYS user as SYSDBA
2. Execute the following script after updating the email server name and port number :
SQL> exec dbms_network_acl_admin.create_acl(acl => ‘resolve.xml’,description => ‘resolve acl’, principal =>’ZABBIX’, is_grant => true, privilege => ‘resolve’);
SQL> exec dbms_network_acl_admin.assign_acl(acl => ‘resolve.xml’, host =>’*’);
SQL> COMMIT;
You can verify the above is correct by running:
select utl_inaddr.get_host_name(‘127.0.0.1’) from dual;
and everything should working fine;
Orabbix 1.2.3 has been released!
On this release:
- Fixed the issue with Alive
- Deeply improved the dynamic recognition of new databases
Now you can add and remove databases simply writing them on configuration file.
I’ve improved the scalability.
and…
I want to say THANK YOU Denis Loshakov for all your tests!!!
You can download it here
There is a bug on Oracle’s JDBC driver.
Oracle has been published a note about here there is an extract:
Applies to:
JDBC – Version: 11.2.0.1 and later [Release: 11.2 and later ]
Information in this document applies to any platform.
Symptoms
A standalone java application connects to a version 10.2.0.4 database via JDBC/Thin 11.2.0.1. The application runs on several machines. The machines have different Unix operating
systems.
Consistently, when trying to connect to the database, the application running on one specific machine fails with:java.sqI.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region not found
An errorstack trace for ORA-01882 identifies the failing statement.
ksedmp: internal or fatal error
ORA-01882: timezone region not found
Current SQL statement for this session:
ALTER SESSION SET TIME_ZONE=’Africa/Lome’ NLS LANGUAGE = ‘AMERICAN’
NLS TERRITORY=’AMERICA’David has kindly advice a workaround
add the following to run.sh:
“-Duser.timezone=GMT”
Of course you should use your own GMT region
