[Support] jasonbean - Apache Guacamole


Message added by Taddeusz,

Before upgrading to 1.5.0 you need to have first upgraded to 1.4.0-3 of the container. I discovered that prior to 1.4.0-3 it was not shutting down MariaDB correctly and causing the database to be left in a dirty state.

 

If after upgrading to 1.5.0 you discover that MariaDB is stopping and the log mentions something about needing to open the database in an older version of MariaDB you should downgrade specifically to 1.4.0-3, start the container and make sure it's running correctly. Then you may upgrade to 1.5.0.

Recommended Posts

15 hours ago, Taddeusz said:

Do you use a Microsoft account or a local account to log in? If you’re using a Microsoft account it cannot be passwordless. If you use Windows Hello to login you must use the password at least once otherwise RDP will not let you login.

Yeah seems it solved itself ) now I need somehow to solve issue with wake on lan and I am set 

Link to comment
On 11/11/2022 at 3:46 PM, Alex.vision said:

 

I was able to pull the following information.

221107 13:44:41 mysqld_safe Starting mysqld daemon with databases from /config/databases
221109 14:34:01 mysqld_safe Logging to '/config/databases/mysql_safe.log'.
221109 14:34:01 mysqld_safe Starting mysqld daemon with databases from /config/databases
221111 14:01:59 mysqld_safe Logging to '/config/databases/189c729a4305.err'.
221111 14:01:59 mysqld_safe Starting mysqld daemon with databases from /config/databases
221111 14:12:19 mysqld_safe Logging to '/config/databases/189c729a4305.err'.
221111 14:12:19 mysqld_safe Starting mysqld daemon with databases from /config/databases
221111 14:14:13 mysqld_safe Logging to '/config/databases/189c729a4305.err'.
221111 14:14:13 mysqld_safe Starting mysqld daemon with databases from /config/databases
221111 15:01:04 mysqld_safe Logging to '/config/databases/c721f46dfcab.err'.
221111 15:01:04 mysqld_safe Starting mysqld daemon with databases from /config/databases
221111 15:31:31 mysqld_safe Logging to '/config/databases/c721f46dfcab.err'.
221111 15:31:31 mysqld_safe Starting mysqld daemon with databases from /config/databases

 

When I looked at 189c729a4305.err I found:

221111 14:12:21 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
221111 14:14:13 mysqld_safe Starting mysqld daemon with databases from /config/databases
2022-11-11 14:14:13 0 [Note] /usr/sbin/mysqld (mysqld 10.3.37-MariaDB-1:10.3.37+maria~deb10-log) starting as process 297 ...
/usr/sbin/mysqld: One can only use the --user switch if running as root
2022-11-11 14:14:13 0 [Note] InnoDB: Using Linux native AIO
2022-11-11 14:14:13 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-11-11 14:14:13 0 [Note] InnoDB: Uses event mutexes
2022-11-11 14:14:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-11-11 14:14:13 0 [Note] InnoDB: Number of pools: 1
2022-11-11 14:14:13 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-11-11 14:14:13 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2022-11-11 14:14:13 0 [Note] InnoDB: Completed initialization of buffer pool
2022-11-11 14:14:13 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-11-11 14:14:13 0 [Note] InnoDB: Transaction 6976 was in the XA prepared state.
2022-11-11 14:14:13 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2022-11-11 14:14:13 0 [Note] InnoDB: Trx id counter is 6977
2022-11-11 14:14:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-11-11 14:14:13 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2022-11-11 14:14:13 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2022-11-11 14:14:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-11-11 14:14:13 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-11-11 14:14:13 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-11-11 14:14:13 0 [Note] InnoDB: 10.3.37 started; log sequence number 4990257; transaction id 6978
2022-11-11 14:14:13 0 [Note] InnoDB: Loading buffer pool(s) from /config/databases/ib_buffer_pool
2022-11-11 14:14:13 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-11-11 14:14:13 0 [Note] InnoDB: Starting recovery for XA transactions...
2022-11-11 14:14:13 0 [Note] InnoDB: Transaction 6976 in prepared state after recovery
2022-11-11 14:14:13 0 [Note] InnoDB: Transaction contains changes to 1 rows
2022-11-11 14:14:13 0 [Note] InnoDB: 1 transactions in prepared state after recovery
2022-11-11 14:14:13 0 [Note] Found 1 prepared transaction(s) in InnoDB
2022-11-11 14:14:13 0 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2022-11-11 14:14:13 0 [ERROR] Aborting

221111 14:14:15 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

 

I do have another location running this docker, it updated with no issues.  So I don't know that its the update that caused the issue. 

 

I did try to run jasonbean/guacamole:1.4.0 already but it still had the same error, so perhaps what ever is borked mysql stayed with it. 

 

I didn't want to have to set up all my RDP sessions and 2FA, so I tried it on a backup config folder.  I can restore from my last docker backup, or if it doesn't work I can just delete the container and reinstall. I just wanted to skip the hassle. 

 

 

When updating to the latest version last week I ended up having this issue (stumbled around for about a week until I came across this exact log with the Prepared transactions error). I can't confirm if it was the update that caused it, or if it was circumstantial. long story short I had to open up the shell for the Guacamole Docker and run this command: mysqld --tc-heuristic-recover=COMMIT. things started working again after that. hope this helps someone in the future. 

Edited by Nickjones818
  • Like 1
Link to comment
  • 2 weeks later...

Bit of an out of the ordinary one. I'm trying to run it in Azure App Service.

 

- I can pull the container

- It starts fine

- I can browse to the guacamole UI just fine

- jasonbean/guacamole:latest

 

When I try to login using guacadmin/guacadmin I get Invalid login. I can login using USERNAME/PASSWORD (as defined in user-mapping.xml) but that doesn't get me admin rights.

 

Anyone have any ideas?

catalina.out

Link to comment
59 minutes ago, Shamalamadindong said:

So that did make some difference, the UI doesn't load at all now haha.

 

sql.txt 1.49 kB · 0 downloads

You probably need to figure out what the proper PUID and PGID values should be for Azure App Service and add also add those as variables as the defaults are specifically for Unraid. Make sure the container path "/config" points to a good local path.

Link to comment
4 hours ago, J05u said:

Maybe anyone who is using wake on lan can help me? I want to make one VM for my mom to use :(

just enable it and enter the values, for a VM you need to enable WOL for VM's (plugin), address is then unraid, boot wait time depends on if hw passthrough etc ... or VM sleep ...

 

image.png.8a26c057a8b164b839bcbb839731d12c.png

 

working oob here

Link to comment
9 hours ago, alturismo said:

just enable it and enter the values, for a VM you need to enable WOL for VM's (plugin), address is then unraid, boot wait time depends on if hw passthrough etc ... or VM sleep ...

 

image.png.8a26c057a8b164b839bcbb839731d12c.png

 

working oob here

Thanks, that worked. I don't know why i put 255 255 255 255 for broadcast address :( When changed to ip everything started to work, this is pefrect

Link to comment
  • 2 weeks later...
On 2/6/2023 at 12:02 AM, Taddeusz said:

You probably need to figure out what the proper PUID and PGID values should be for Azure App Service and add also add those as variables as the defaults are specifically for Unraid. Make sure the container path "/config" points to a good local path.

 

Thanks I had the same issue as @Shamalamadindong  (not with Azure though) but it did fix it for me.

Link to comment
36 minutes ago, Electrohacker said:

yes, and if I knew where the log were that would also help.  every how to I look at says they're in /var/log... but I dont see them there

The catalina.out file would be a good place to start. It's in the config folder in log/tomcat. The Docker log output itself would also be useful.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.