Re: [otrs] Postgres setup newbie

On Wednesday, November 12, 2003 2:25 PM Ted Kaczmarek wrote:

I am looking into test driving otrs, I already have opennms running on a box and it uses postgres. I grabbed source rpms and started poking around, but could not figure out how to set up otrs for postgres instead of mysql. The spec file doesn't even have postgres listed, yet the perl scripts reference postgres.

It should be no more than setting this in /opt/otrs/Kernel/Config.pm: # (The database DSN for PostgrSQL ==> more: "man DBD::Pg") # $Self->{DatabaseDSN} = "DBI:Pg:dbname=;host=;"; Watch out - the last line of the above wraps! Find the 'original' entry buried in /opt/otrs/Kernel/Config/Defaults.pm, somwhere around line 155. See http://doc.otrs.org/1.1/html/install-cli.html and esp. http://doc.otrs.org/1.1/html/install-cli.html#INSTALL-CLI-DATABASE for a quite comprehensive set of instructions to manually setup OTRS.

Ultimately I would like to get to the point where opennms events can automatically generate tickets in otrs.

Is opennms capable of sending an email? That's it.

Think like netcool/remedy integrated. Have no clue what, where and how, but that has never stopped me before from trying :-)

If anyone has a spec file that build otrs for postgres a pint of any bier you like on me if you come to Linux show in NY :-) a liter even, hehe

You got good beer over there? Hm... Regards, Robert Kehl -- ((otrs.de)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Tel. +49 (0)6172 4832388