Re: [otrs] PostgreSQL note

[Bryan Fullerton]

On Tuesday, October 29, 2002, at 06:05 PM, Martin Edenhofer wrote:

Ja, that looks ok. But check your Kernel/Config.pm (perl -cw Kernel/Config.pm).
There is an perl syntax error.

Hmm, so it says...

% perl -cw /usr/local/otrs/Kernel/Config.pm
syntax error at /usr/local/otrs/Kernel/Config.pm line 539, near "$_;"
/usr/local/otrs/Kernel/Config.pm had compilation errors.

But I haven't changed much! Here's a diff between my production file and a copy grabbed from cvs:

=====
--- /home/bryanf/src/otrs/Kernel/Config.pm Fri Oct 25 10:51:14 2002
+++ /usr/local/otrs/Kernel/Config.pm Tue Oct 29 08:46:32 2002
@@ -50,7 +50,7 @@

# FQDN
# (Full qualified domain name of your system.)
- $Self->{FQDN} = 'yourhost.example.com';
+ $Self->{FQDN} = 'home.samurai.com';

# ScriptAlias
# Prefix to index.pl used as ScriptAlias in web config
@@ -59,7 +59,7 @@

# AdminEmail
# (Email of the system admin.)
- $Self->{AdminEmail} = '[EMAIL PROTECTED]';
+ $Self->{AdminEmail} = '[EMAIL PROTECTED]';

# Sendmail
# (Where is sendmail located and some options.
@@ -74,7 +74,7 @@
# Organization
# (If this is anything other than '', then the email will have an
# Organization X-Header)
- $Self->{Organization} = 'Example Company';
+ $Self->{Organization} = 'Samurai Consulting Inc';
# $Self->{Organization} = '';

# CustomQueue
@@ -95,7 +95,7 @@
# ----------------------------------------------------#
# DatabaseHost
# (The database host.)
- $Self->{DatabaseHost} = 'localhost';
+ $Self->{DatabaseHost} = 'db';

# Database
# (The database name.)
@@ -107,14 +107,14 @@

# DatabasePw
# (The password of database user.)
- $Self->{DatabasePw} = 'some-pass';
+ $Self->{DatabasePw} = 'GaljAdwi';

# DatabaseDSN
# (The database DSN for MySQL ==> more: "man DBD::mysql")
- $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";
+# $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

# (The database DSN for PostgrSQL ==> more: "man DBD::Pg")
-# $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};";
+ $Self->{DatabaseDSN} = "DBI:Pg:dbname=$Self->{Database};host=$Self->{DatabaseHost};";

# UserTable
$Self->{DatabaseUserTable} = 'system_user';
=====

PS: What do you think about http://lists.otrs.org/pipermail/otrs/2002-October/000401.html?

Ah, I forgot to reply to that one! Sounds good! All the configurable stuff for the system is in Kernel/Config.pm or in the database, so preserving that one file with a defaults/override setup should work nicely.

Thanks,

Bryan

_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs