You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@guacamole.apache.org by ke...@gmail.com on 2020/04/26 02:10:28 UTC

Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on Debian 10

Hi All,

 

I have to assume I'm doing something wrong, but I have no idea what.  I'm
trying to get Guac DB auth to work on Raspbian Buster Lite.  I've gotten DB
auth to work on Debian 10 using MySQL, but even on basic Debian 10, I had to
use MySQL instead of MariaDB to get it to work.

 

I'm currently trying to get Guac to work on Raspbian Buster Lite (apt
upgraded all the way.)  Raspbian does not like MariaDB.  I could build MySQL
8 from source, but I'm specifically trying to avoid that.  I'd rather use
APT to install the preferred MariaDB server.

 

I can use something like "mysql -u guacamole_user -p" and do whatever in the
database, but Guac doesn't seem to want to play ball.

 

I have logging enabled at the "Debug" level, but all catalina.out tells me
is that 'Authentication attempt from _X.X.X.X_ for user "guacadmin" failed.'
It doesn't tell me any more than that.  Syslog says nothing.  I'm assuming
there is some sort of library/JDBC driver malfunction here, but I don't even
begin to have an idea of how to troubleshoot.

 

I would appreciate any guidance.

 

Thanks!

RE: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on Debian 10

Posted by ke...@gmail.com.

Thank you!!!

 

Using the MySQL Connector/J JDBC driver (mysql-connector-java-5.1.47.jar in
my case) did the trick!

 

I had definitely tried the MySQL Connector/J driver for 8.x, but it would
have taken me some time and frustration to think to try the 5.x version.
Invaluable information.  I will be looking forward to the MariaDB driver
code being included in future versions (I am using Guac 1.1.0sorry for not
mentioning.)

 

Thanks

 

From: ivanmarcus <iv...@yahoo.com> 
Sent: Sunday, April 26, 2020 1:12 AM
To: user@guacamole.apache.org; kendellwelch007@gmail.com
Subject: Re: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine
on Debian 10

 

Kendall,

I believe some people are using MariaDB, but from what I recollect/read it
needs a little special treatment.

From this thread:

http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/Assi
stance-with-Apache-Guacamole-1-0-0-Client-td5478.html#a5634

You may want to try using the 5.x version of MySQL Connector J (and add the
"default_time_zone" line to the my.conf file in the [mysqld] section). To be
clear - don't use the MariaDB Connector.

Also, you could be running into this?:

https://issues.apache.org/jira/browse/GUACAMOLE-852

Which Nick appears to have merged into the latest code, but is not part of
Guacamole 1.1.0 (although you've not said what version of Guacamole you're
using I guess it could be this?).

 

On 26/04/2020 2:16 p.m., kendellwelch007@gmail.com
<ma...@gmail.com>  wrote:

I would add, I did download the current MariaDB Connector/J library and use
that.

ï¿½

https://mariadb.com/downloads/#connectors

ï¿½

No luck.

ï¿½

From: kendellwelch007@gmail.com <ma...@gmail.com>
<ma...@gmail.com> <ke...@gmail.com> 
Sent: Saturday, April 25, 2020 9:10 PM
To: user@guacamole.apache.org <ma...@guacamole.apache.org> 
Subject: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on
Debian 10

ï¿½

Hi All,

ï¿½

I have to assume Iï¿½m doing something wrong, but I have no idea what.ï¿½
Iï¿½m trying to get Guac DB auth to work on Raspbian Buster Lite.ï¿½ Iï¿½ve
gotten DB auth to work on Debian 10 using MySQL, but even on basic Debian
10, I had to use MySQL instead of MariaDB to get it to work.

ï¿½

Iï¿½m currently trying to get Guac to work on Raspbian Buster Lite (apt
upgraded all the way.)ï¿½ Raspbian does not like MariaDB.ï¿½ I could build
MySQL 8 from source, but Iï¿½m specifically trying to avoid that.ï¿½ Iï¿½d
rather use APT to install the preferred MariaDB server.

ï¿½

I can use something like ï¿½mysql -u guacamole_user -pï¿½ and do whatever in
the database, but Guac doesnï¿½t seem to want to play ball.

ï¿½

I have logging enabled at the ï¿½Debugï¿½ level, but all catalina.out tells
me is that ï¿½Authentication attempt from _X.X.X.X_ for user "guacadmin"
failed.ï¿½ï¿½ It doesnï¿½t tell me any more than that.ï¿½ Syslog says
nothing.ï¿½ Iï¿½m assuming there is some sort of library/JDBC driver
malfunction here, but I donï¿½t even begin to have an idea of how to
troubleshoot.

ï¿½

I would appreciate any guidance.

ï¿½

Thanks!

Re: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on Debian 10

Posted by ivanmarcus <iv...@yahoo.com.INVALID>.

Kendall,

I believe some people are using MariaDB, but from what I recollect/read 
it needs a little special treatment.

 From this thread:

http://apache-guacamole-general-user-mailing-list.2363388.n4.nabble.com/Assistance-with-Apache-Guacamole-1-0-0-Client-td5478.html#a5634

You may want to try using the 5.x version of MySQL Connector J (and add 
the "default_time_zone" line to the my.conf file in the [mysqld] 
section). To be clear - don't use the MariaDB Connector.

Also, you could be running into this?:

https://issues.apache.org/jira/browse/GUACAMOLE-852

Which Nick appears to have merged into the latest code, but is not part 
of Guacamole 1.1.0 (although you've not said what version of Guacamole 
you're using I guess it could be this?).


On 26/04/2020 2:16 p.m., kendellwelch007@gmail.com wrote:
>
> I would add, I did download the current MariaDB Connector/J library 
> and use that.
>
> https://mariadb.com/downloads/#connectors
>
> No luck.
>
> *From:* kendellwelch007@gmail.com <ke...@gmail.com>
> *Sent:* Saturday, April 25, 2020 9:10 PM
> *To:* user@guacamole.apache.org
> *Subject:* Raspian Buster Lite - MariaDB does not work, MySQL 8 works 
> fine on Debian 10
>
> Hi All,
>
> I have to assume Iï¿½m doing something wrong, but I have no idea what.  
> Iï¿½m trying to get Guac DB auth to work on Raspbian Buster Lite.  Iï¿½ve 
> gotten DB auth to work on Debian 10 using MySQL, but even on basic 
> Debian 10, I had to use MySQL instead of MariaDB to get it to work.
>
> Iï¿½m currently trying to get Guac to work on Raspbian Buster Lite (apt 
> upgraded all the way.)  Raspbian does not like MariaDB.  I could build 
> MySQL 8 from source, but Iï¿½m specifically trying to avoid that.  Iï¿½d 
> rather use APT to install the preferred MariaDB server.
>
> I can use something like ï¿½mysql -u guacamole_user -pï¿½ and do whatever 
> in the database, but Guac doesnï¿½t seem to want to play ball.
>
> I have logging enabled at the ï¿½Debugï¿½ level, but all catalina.out 
> tells me is that ï¿½Authentication attempt from _X.X.X.X_ for user 
> "guacadmin" failed.ï¿½  It doesnï¿½t tell me any more than that.  Syslog 
> says nothing.  Iï¿½m assuming there is some sort of library/JDBC driver 
> malfunction here, but I donï¿½t even begin to have an idea of how to 
> troubleshoot.
>
> I would appreciate any guidance.
>
> Thanks!
>

RE: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on Debian 10

Posted by ke...@gmail.com.

I would add, I did download the current MariaDB Connector/J library and use
that.

 

https://mariadb.com/downloads/#connectors

 

No luck.

 

From: kendellwelch007@gmail.com <ke...@gmail.com> 
Sent: Saturday, April 25, 2020 9:10 PM
To: user@guacamole.apache.org
Subject: Raspian Buster Lite - MariaDB does not work, MySQL 8 works fine on
Debian 10

 

Hi All,

 

I have to assume I'm doing something wrong, but I have no idea what.  I'm
trying to get Guac DB auth to work on Raspbian Buster Lite.  I've gotten DB
auth to work on Debian 10 using MySQL, but even on basic Debian 10, I had to
use MySQL instead of MariaDB to get it to work.

 

I'm currently trying to get Guac to work on Raspbian Buster Lite (apt
upgraded all the way.)  Raspbian does not like MariaDB.  I could build MySQL
8 from source, but I'm specifically trying to avoid that.  I'd rather use
APT to install the preferred MariaDB server.

 

I can use something like "mysql -u guacamole_user -p" and do whatever in the
database, but Guac doesn't seem to want to play ball.

 

I have logging enabled at the "Debug" level, but all catalina.out tells me
is that 'Authentication attempt from _X.X.X.X_ for user "guacadmin" failed.'
It doesn't tell me any more than that.  Syslog says nothing.  I'm assuming
there is some sort of library/JDBC driver malfunction here, but I don't even
begin to have an idea of how to troubleshoot.

 

I would appreciate any guidance.

 

Thanks!