Log file - how build a trigger

[ufocek]

Hi,

I monitoring some file, when apllication can't connect to database put some information to my log e.g:

onnectionFactory.openConnection(ConnectionFactory.java:66)
        at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:124)
        at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:30)
        at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:29)
        at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
        at org.postgresql.Driver.makeConnection(Driver.java:386)
        at org.postgresql.Driver.connect(Driver.java:260)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:154)
        at org.hibernate.connection.DriverManagerConnectionProvider.getConnection(DriverManagerConnectionProvider.java:110)
        at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:84)
        at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
        at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1292)
        at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:859)
        at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
        at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:83)
        at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:60)
        at pl.ibs.ekod.database.DatabaseAware.<clinit>(DatabaseAware.java:17)
        at pl.ibs.ekod.Ekod.main(Ekod.java:29)
Caused by: java.net.NoRouteToHostException: No route to host
        at java.net.PlainSocketImpl.socketConnect(Native Method)
        at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
        at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
        at java.net.Socket.connect(Socket.java:525)
        at java.net.Socket.connect(Socket.java:475)
        at java.net.Socket.<init>(Socket.java:372)
        at java.net.Socket.<init>(Socket.java:186)
        at org.postgresql.core.PGStream.<init>(PGStream.java:62)
        at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:77)
        ... 20 more
2010-08-24 11:04:06,504 [main] WARN Could not obtain connection metadata
org.postgresql.util.PSQLException: The connection attempt failed.

My items look like:
log[/home/javappl/logs/test.log,"org.postgresql.util.PSQLException: The connection attempt failed"], in the latest data I see and it's ok:

[2010.Aug.25 12:41:08]	 -	 -	Unknown	 -	org.postgresql.util.PSQLException: The connection attempt failed.
[2010.Aug.25 12:41:08]	 -	 -	Unknown	 -	org.postgresql.util.PSQLException: The connection attempt failed.
[2010.Aug.25 12:41:08]	 -	 -	Unknown	 -	org.postgresql.util.PSQLException: The connection attempt failed.
[2010.Aug.25 12:41:08]	 -	 -	Unknown	 -	org.postgresql.util.PSQLException: The connection attempt failed.
[2010.Aug.25 12:41:08]	 -	 -	Unknown	 -	org.postgresql.util.PSQLException: The connection attempt failed.

Now How I can build a trigger for this item? I create a trigger
{devappl:log[/home/javappl/logs/test.log,"org.postgresql.util.PSQLException: The connection attempt failed"].str(30)}=1 or
{devappl:log[/home/javappl/logs/test.log,"org.postgresql.util.PSQLException: The connection attempt failed"].last(0)}=1, but none no working.

[chriso]

Try this instead. The str() method needs a string.
{devappl:log[/home/javappl/logs/test.log,"org.postgresql.util.PSQLException: The connection attempt failed"].str("org.postgresql.util.PSQLException")}>0

last(0) will return an actual value...so it would return something like "org.postgresql.util.PSQLException.xxx.xx.x". So..this will not work:
{devappl:log[/home/javappl/logs/test.log,"org.postgresql.util.PSQLException: The connection attempt failed"].last(0)}=1