[SOLVED] OTRS DB

Moderator: crythias

Post Reply
jafumega27
Znuny newbie
Posts: 28
Joined: 09 Mar 2015, 14:41
Znuny Version: 4.0.5
Real Name: Tiago Rocha

[SOLVED] OTRS DB

Post by jafumega27 »

I installed OTRS appliance in a virtual machine, and windows installed mySQL. In mySQL I insert the IP of the virtual machine is unable to access the OTRS database, give me the error "Can not connect to MySQL server on 'XXX.XXX.XXX.XXX'".
Someone explain to me how I have to do? and if it is possible the way I'm doing.
I need to install the OTRS mySQL server?

Cumps
Last edited by jafumega27 on 13 Mar 2015, 17:11, edited 1 time in total.
wurzel
Znuny guru
Posts: 3234
Joined: 08 Jul 2010, 22:25
Znuny Version: x.x.x
Real Name: Florian

Re: OTRS DB

Post by wurzel »

Hi,

what do you want to achieve?

The appliance uses postgres (locally installed) preconfigured. Works fine.

Flo
OTRS 8 SILVER (Prod)
OTRS 8 auf Debian 11 (Test)
Znuny 7.x latest version testing auf Debian 11

-- Ich beantworte keine Forums-Fragen PN - No PN please

I won't answer to unfriendly users any more. A greeting and regards are just polite.
jafumega27
Znuny newbie
Posts: 28
Joined: 09 Mar 2015, 14:41
Znuny Version: 4.0.5
Real Name: Tiago Rocha

Re: OTRS DB

Post by jafumega27 »

hi,
i want to make some custom configuration, so i need to acess to the DB.
Postgre? hum... i can acess in my windows or only by ssh?
BTW you know the default user ? its root right?
jafumega27
Znuny newbie
Posts: 28
Joined: 09 Mar 2015, 14:41
Znuny Version: 4.0.5
Real Name: Tiago Rocha

Re: OTRS DB

Post by jafumega27 »

wurzel wrote:Hi,

what do you want to achieve?

The appliance uses postgres (locally installed) preconfigured. Works fine.

Flo
in the promp i tried to do this,

the password, login and the database nabe is in Config.pm right?

because i try to enter, but i cant, give me this error:

root@otrs:/opt/otrs/Kernel# psql -s otrs -U otrs -W
Password for user otrs:
psql: FATAL: Ident-Authentifizierung f?r Benutzer >>otrs<< fehlgeschlagen


if i try
root@otrs:/opt/otrs/Kernel# psql -s otrs -U otrs -w

give me the same error....
jafumega27
Znuny newbie
Posts: 28
Joined: 09 Mar 2015, 14:41
Znuny Version: 4.0.5
Real Name: Tiago Rocha

Re: OTRS DB

Post by jafumega27 »

wrong command.

SOLVED.

thk for the help =)
netjess
Znuny expert
Posts: 172
Joined: 16 Nov 2011, 23:35
Znuny Version: 6.0.16
Real Name: Jesse
Company: Mercer Valve Company
Location: Oklahoma USA
Contact:

Re: OTRS DB

Post by netjess »

jafumega27 wrote:wrong command.

SOLVED.

thk for the help =)
What was the correct command?

Thank you.
Powered by OTRS 6
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
jafumega27
Znuny newbie
Posts: 28
Joined: 09 Mar 2015, 14:41
Znuny Version: 4.0.5
Real Name: Tiago Rocha

Re: OTRS DB

Post by jafumega27 »

netjess wrote:
jafumega27 wrote:wrong command.

SOLVED.

thk for the help =)
What was the correct command?

Thank you.
Hello,
I have not used MySQL, I used PostgreSQL.
The commanding I used was, psql -h 127.0.0.1 -d otrs -U otrs
Post Reply