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
[SOLVED] OTRS DB
Moderator: crythias
-
- Znuny newbie
- Posts: 28
- Joined: 09 Mar 2015, 14:41
- Znuny Version: 4.0.5
- Real Name: Tiago Rocha
[SOLVED] OTRS DB
Last edited by jafumega27 on 13 Mar 2015, 17:11, edited 1 time in total.
Re: OTRS DB
Hi,
what do you want to achieve?
The appliance uses postgres (locally installed) preconfigured. Works fine.
Flo
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.
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.
-
- Znuny newbie
- Posts: 28
- Joined: 09 Mar 2015, 14:41
- Znuny Version: 4.0.5
- Real Name: Tiago Rocha
Re: OTRS DB
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?
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?
-
- Znuny newbie
- Posts: 28
- Joined: 09 Mar 2015, 14:41
- Znuny Version: 4.0.5
- Real Name: Tiago Rocha
Re: OTRS DB
in the promp i tried to do this,wurzel wrote:Hi,
what do you want to achieve?
The appliance uses postgres (locally installed) preconfigured. Works fine.
Flo
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....
-
- Znuny newbie
- Posts: 28
- Joined: 09 Mar 2015, 14:41
- Znuny Version: 4.0.5
- Real Name: Tiago Rocha
Re: OTRS DB
wrong command.
SOLVED.
thk for the help =)
SOLVED.
thk for the help =)
-
- 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
What was the correct command?jafumega27 wrote:wrong command.
SOLVED.
thk for the help =)
Thank you.
Powered by OTRS 6
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
Active Directory LDAP Integration.
Ubuntu 18 LTS, Apache2, PostgreSQL.
-
- Znuny newbie
- Posts: 28
- Joined: 09 Mar 2015, 14:41
- Znuny Version: 4.0.5
- Real Name: Tiago Rocha
Re: OTRS DB
Hello,netjess wrote:What was the correct command?jafumega27 wrote:wrong command.
SOLVED.
thk for the help =)
Thank you.
I have not used MySQL, I used PostgreSQL.
The commanding I used was, psql -h 127.0.0.1 -d otrs -U otrs