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)
Can't connect to database in Web-Installer for Mysql server
Moderator: crythias
-
- 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
OTRS V 2.4.7 (french version & Windows installation)
OS : XP Pro + Win Server 2003
OS : XP Pro + Win Server 2003
Re: Can't connect to database in Web-Installer for Mysql ser
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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
OS : XP Pro + Win Server 2003
Re: Can't connect to database in Web-Installer for Mysql ser
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
"Testing": ((OTRS Community Edition)) and git Master
Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
-
- 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
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.
Thank you.
OTRS V 2.4.7 (french version & Windows installation)
OS : XP Pro + Win Server 2003
OS : XP Pro + Win Server 2003
Re: Can't connect to database in Web-Installer for Mysql ser
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.
Re: Can't connect to database in Web-Installer for Mysql ser
Yeah.. agree with you dude.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.