On Thu, Dec 10, 2020 at 3:48 AM Martin Gerlach91 <[email protected]> wrote:
> Hello Guys! > > I looked for hours. > After building Guacamole 1.2.0 from Scratch under CENTOS 8 and testing > succesfully with a local MySQL DB, I am now trying to connect it to our > MySQL cluster in the Network. > > catalina.out tells me: > 14:32:55.319 [main] INFO o.a.g.environment.LocalEnvironment - > GUACAMOLE_HOME is "/usr/share/tomcat/.guacamole". > 14:32:55.487 [main] ERROR o.a.g.extension.ProviderFactory - authentication > provider extension failed to start: Property "mysql-port" must be an > integer. > 14:32:55.489 [main] ERROR o.a.g.extension.ProviderFactory - authentication > provider extension failed to start: Property "mysql-port" must be an > integer. > 14:32:55.535 [main] INFO o.a.g.extension.ExtensionModule - Extension > "MySQL > Authentication" loaded. > > The only Topic i've found to this Problem is: > "https://jira.glyptodon.com/browse/GUAC-1348"; -> reported from here: > https://sourceforge.net/p/guacamole/discussion/1110834/thread/8b46c96b/ > > But there is NO Solution how to solve this...or i just don't get it. Not > even working with DB root. > > A direct access to the DB using custom Port works fine. > > My guacamole.properties looks like: > > # MySQL properties > mysql-hostname: 10.0.4.67 > mysql-port: 12134 > mysql-database: guacamole_db > mysql-username: guacamole > mysql-password: XXXXXXXXXXXx > > I can't figure out what to do. May you have me an Idea? > > The only thing that I can think of is that the guacamole.properties file was created or edited in a way that resulted in it having CRLF terminators (DOS/Windows-style file) and that those characters are being read in by Guacamole in some way that makes it think there are non-integer characters. You can try installing the "dos2unix" command, running it on that file, and then restart Tomcat to see if that clears up the issue. -Nick
