Can't connect to database in Web-Installer for Mysql server

Moderator: crythias

Post Reply
scorpioncf
Znuny newbie
Posts: 37
Joined: 16 Apr 2010, 11:04
Znuny Version: 2.4.7

Can't connect to database in Web-Installer for Mysql server

Post by scorpioncf »

Hello,
On the page of Web-Installer, I inform the IP address of the server in fields Host and the name of computer of the server in fields host's name for the creation of the database and I obtain this error message:

Erreur: Can't connect to database, read comment!
Commentaire: Host 'faf-test.faf-securite-sociale.lan' is not allowed to connect to this MySQL server
Rapport d'anomalie:
Trace du retour d'erreur: ERROR: OTRS-Installer-10 Perl: 5.10.0 OS: MSWin32 Time: Wed May 19 09:17:25 2010

Message: Can't connect to database, read comment!

Traceback (2508):
Module: Kernel::Output::HTML::Layout::Error (v1.176.2.17) Line: 1416
Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.176.2.17) Line: 1395
Module: Kernel::Modules::Installer::Run (v1.58) Line: 221
Module: main::GenericModules (v1.31) Line: 130
Module: C:/Program Files/OTRS/OTRS/bin/cgi-bin/installer.pl (v1.31) Line: 91

I tempted some combination but unsuccessfully, only the localhost works but I don't want to inform it there localhost, seen that will be for a network use.

I'm on Dell Server (1,10 GHz Celeron processor and 256 Mo RAM with Windows Server 2003 SP2, this server is only used for the tests)
OTRS V 2.4.7 (french version & Windows installation)
OS : XP Pro + Win Server 2003
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Can't connect to database in Web-Installer for Mysql ser

Post by jojo »

If you wan't to access an external mysql Server you have to allow external access for the database user. Please refer to the mysql admin manual.
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
scorpioncf
Znuny newbie
Posts: 37
Joined: 16 Apr 2010, 11:04
Znuny Version: 2.4.7

Re: Can't connect to database in Web-Installer for Mysql ser

Post by scorpioncf »

The installation of OTRS for Windows includes the automatic installation of MySQL, Apache, CRONw and StrawberryPerl of OTRS. There isn't coding to be made. Mysql seems to be internal with OTRS. During the creation it localhost, the database created correctly but not when I replace localhost in hosts' fields by the name and the IP of the server DELL.
OTRS V 2.4.7 (french version & Windows installation)
OS : XP Pro + Win Server 2003
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Can't connect to database in Web-Installer for Mysql ser

Post by jojo »

If you are using the local database don't change the connection settings for the database in the installer!
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
scorpioncf
Znuny newbie
Posts: 37
Joined: 16 Apr 2010, 11:04
Znuny Version: 2.4.7

Re: Can't connect to database in Web-Installer for Mysql ser

Post by scorpioncf »

OK, I do not know how we are going to use it in the future but in every case, a saving and an export of data will protect us from any later problem.

Thank you.
OTRS V 2.4.7 (french version & Windows installation)
OS : XP Pro + Win Server 2003
meronbar
Znuny newbie
Posts: 13
Joined: 18 May 2010, 08:56
Znuny Version: 2.4.7

Re: Can't connect to database in Web-Installer for Mysql ser

Post by meronbar »

In case of general windows installation package, all services installed on same server, so from OTRS(Perl) point of view database located on localhost (same computer). This is not related to address your used to access web interface.
Remixen
Znuny newbie
Posts: 1
Joined: 18 Aug 2010, 09:37
Znuny Version: lastest

Re: Can't connect to database in Web-Installer for Mysql ser

Post by Remixen »

meronbar wrote:In case of general windows installation package, all services installed on same server, so from OTRS(Perl) point of view database located on localhost (same computer). This is not related to address your used to access web interface.
Yeah.. agree with you dude.
Post Reply