mysql auth configuration problem

[Piviul <pi...@riminilug.it>]

Hi all, I have installed guacamole and I would like to install mysql as 
auth; I have followed the guacamole manual: created the guacamole_db, 
the guacamole_user and installed the schemas. Then I have load the mysql 
extension and the mysql driver:
> $ ls -l /etc/guacamole/{extensions,lib}
> /etc/guacamole/extensions:
> total 4916
> -rw-r--r-- 1 root root 5030106 Apr  8 12:55 
> guacamole-auth-jdbc-mysql-1.1.0.jar
>
> /etc/guacamole/lib:
> total 2304
> -rw-r--r-- 1 root root 2356711 Apr  8 12:59 
> mysql-connector-java-8.0.19.jar

Then if I enable mysql auth in guacamole.properties on the web page I 
get the error:
> An error has occurred and this action cannot be completed. If the 
> problem persists, please notify your system administrator or check 
> your system logs.

If I check the mysql error.log I find this error:
> 2020-04-08 14:53:27 46 [Warning] Aborted connection 46 to db: 
> 'guacamole_db' user: 'guacamole_user' host: 'localhost' (Got an error 
> reading communication packets)
> 2020-04-08 14:53:27 47 [Warning] Aborted connection 47 to db: 
> 'guacamole_db' user: 'guacamole_user' host: 'localhost' (Got an error 
> reading communication packets)

Someone can help me to solve this problem?

Piviul

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org

Re: mysql auth configuration problem

[Piviul <pi...@riminilug.it>]

Il 08/04/20 16:29, Tushar Jain ha scritto:
> [...]
> You could try with mysql-connector-java-5.1.47-bin.jar instead of
> mysql-connector-java-8.0.19.jar in 'lib' directory. I am not sure if it
> would work for you, but that is what is working for me. Sometimes version
> compatibility between MySQL and its driver can cause issues listed by you.
Bingo!

Thank you very much!!!

Piviul

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org

RE: mysql auth configuration problem

[Tushar Jain <tu...@hitachi.mgrmnet.com>]

Hi Piviul,

You could try with mysql-connector-java-5.1.47-bin.jar instead of
mysql-connector-java-8.0.19.jar in 'lib' directory. I am not sure if it
would work for you, but that is what is working for me. Sometimes version
compatibility between MySQL and its driver can cause issues listed by you.

Also assuming that you have installed mysql on the same server as guacamole
and have configured its port correctly in guacamole.properties


-----Original Message-----
From: Piviul [mailto:piviul@riminilug.it] 
Sent: 08 April 2020 06:42 PM
To: user@guacamole.apache.org
Subject: mysql auth configuration problem

Hi all, I have installed guacamole and I would like to install mysql as
auth; I have followed the guacamole manual: created the guacamole_db, the
guacamole_user and installed the schemas. Then I have load the mysql
extension and the mysql driver:
> $ ls -l /etc/guacamole/{extensions,lib}
> /etc/guacamole/extensions:
> total 4916
> -rw-r--r-- 1 root root 5030106 Apr  8 12:55 
> guacamole-auth-jdbc-mysql-1.1.0.jar
>
> /etc/guacamole/lib:
> total 2304
> -rw-r--r-- 1 root root 2356711 Apr  8 12:59 
> mysql-connector-java-8.0.19.jar

Then if I enable mysql auth in guacamole.properties on the web page I get
the error:
> An error has occurred and this action cannot be completed. If the 
> problem persists, please notify your system administrator or check 
> your system logs.

If I check the mysql error.log I find this error:
> 2020-04-08 14:53:27 46 [Warning] Aborted connection 46 to db: 
> 'guacamole_db' user: 'guacamole_user' host: 'localhost' (Got an error 
> reading communication packets)
> 2020-04-08 14:53:27 47 [Warning] Aborted connection 47 to db: 
> 'guacamole_db' user: 'guacamole_user' host: 'localhost' (Got an error 
> reading communication packets)

Someone can help me to solve this problem?

Piviul

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org



-- 
**Disclaimer:* This message and any attachment may contain confidential, 
proprietary information and is intended only for the individual named. If 
you are not the original intended recipient and have erroneously received 
this message, you should not disseminate, distribute or copy this e-mail. 
Please notify the sender immediately by e-mail if you have received this 
e-mail by mistake and delete this e-mail from your system. Hitachi MGRM Net 
E-mail transmission cannot be guaranteed to be secure or error-free as 
information could be intercepted, corrupted, lost, destroyed, arrive late 
or incomplete, or contain viruses. Hitachi MGRM Net therefore does not 
accept liability for any errors or omissions in the contents of this 
message, which arise as a result of e-mail transmission. If verification is 
required, please request a hard-copy version. Hitachi MGRM Net Ltd, C - 
6/5, Safdarjung Development Area, New Delhi - 110016, India*
*
*
*'Please 
consider the environment before printing this e-mail'.*

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@guacamole.apache.org
For additional commands, e-mail: user-help@guacamole.apache.org