[SOLVED] Connect to PSQL in OTRS 4 Appliance

netjess · Post by **netjess** » 20 May 2015, 00:01

Hello,
I have an OTRS 4 Appliance VM.
I have a need to connect a FileMaker database via ODBC to the Postgresql database on the appliance.

I cat /SOURCE/SHARE/var/otrs/Kernel/Config.pm and grab the database password.
I use the following:
psql -d otrs -U otrs -W
I give it the password found in Config.pm and I get the following:
psql: FATAL: Ident-Authentifizierung f?r Benutzer >>otrs<< fehlgeschlagen

So, not sure why it wont recognize the username and password found in Config.pm.

Any ideas?
Thank you.

netjess · Post by **netjess** » 21 May 2015, 15:17

Bump.
Anybody?

Post by **crythias** » 21 May 2015, 15:34

On the surface, I don't understand why this is an OTRS issue.
As well, the pgsql connection to a non-pg database should certainly fail.

Post by **crythias** » 21 May 2015, 15:36

or ... Maybe I'm missing that you're having problems getting the *correct* pg password and why it's not in /opt/otrs/Kernel/Config.pm

netjess · Post by **netjess** » 21 May 2015, 15:56

crythias wrote:On the surface, I don't understand why this is an OTRS issue.
As well, the pgsql connection to a non-pg database should certainly fail.

It would be an OTRS issue because I am using a SSH shell on the OTRS appliance and trying the command using the information contained in the OTRS Config.pm file and it isn't working.

I want to create a new psql user to access the database to do some datamaping to another database via ODBC.

netjess · Post by **netjess** » 21 May 2015, 16:01

crythias wrote:or ... Maybe I'm missing that you're having problems getting the *correct* pg password and why it's not in /opt/otrs/Kernel/Config.pm

if the correct user name and password are not in the Config.pm then how would the OTRS scripts know how to connect to the database?

Post by **crythias** » 21 May 2015, 16:09

/SOURCE/SHARE/var/otrs/Kernel/Config.pm
/opt/otrs/Kernel/Config.pm

is production otrs running from /SOURCE/SHARE?

netjess · Post by **netjess** » 21 May 2015, 16:25

I have compared the two files and they both have the same information, at least as far as database connection.

Code: Select all

    # ---------------------------------------------------- #
    # database settings                                    #
    # ---------------------------------------------------- #

    # The database host
    $Self->{DatabaseHost} = '127.0.0.1';

    # The database name
    $Self->{Database} = 'otrs';

    # The database user
    $Self->{DatabaseUser} = 'otrs';

    # The password of database user. You also can use bin/otrs.CryptPassword.pl
    # for crypted passwords
    $Self->{DatabasePw} = 'jD93Odmj7IjSM@n';
        $Self->{SecureMode}=1;
        $Self->{"Package::Timeout"}=120;
        $Self->{'SystemID'}=96;
        $Self->{'SessionName'}='OTRSAgentInterface';
### MARKER ###

If it is encrypted will the CryptPassword.pl decrypt it or is it one way?

Thank you.

Post by **crythias** » 21 May 2015, 16:42

I think it's one way, but crypted passwords will be enclosed in {}.

Post by **crythias** » 21 May 2015, 16:50

viewtopic.php?t=28487 unfortunately I can't verify the rest of this.

http://www.cyberciti.biz/faq/psql-fatal ... -for-user/
search results

netjess · Post by **netjess** » 21 May 2015, 17:24

OK, so it appears that you have to specify the host.
psql -h 127.0.0.1 -d otrs -U otrs

I now have a psql prompt.

Thank you for your time.

netjess · Post by **netjess** » 21 May 2015, 17:32

Bummer,
Now when I enter the command:
CREATE USER fmuser WITH PASSWORD 'superSecret1';

I get the error:
FEHLER: keine Berechtigung, um Rolle zu erzeugen (ERROR : No authorization to create role).

Ugh. I guess I will have to give the otrs username to the other application admin, or move my OTRS to an installed application rather than using the appliance.

Thanks.

Znuny Open Source Ticketsystem