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 

21 hours ago, alturismo said:

enable RDP, use RDP in guacamole, install an VNC Server in the VM, use VNC in guacamole

Vnc server? I will try that one also, rdp started to work at this point

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 January 16, 20233 yr by Nickjones818

Since January 1st has come and gone I just wanted to post an update saying that the Apache Guacamole team has not yet made any 1.5.0 releases. As soon as they release something I will start working on an update.

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

@Shamalamadindong Do you have the variable OPT_MYSQL set to “Y”?

@Taddeusz

Hello,can you please help me to make wake on lan working for my apache instance?

2 hours ago, J05u said:

@Taddeusz

Hello,can you please help me to make wake on lan working for my apache instance?

I don’t use WOL so I’m not sure how I could help. There may be someone else here that can.

On 2/4/2023 at 5:58 PM, Taddeusz said:

@Shamalamadindong Do you have the variable OPT_MYSQL set to “Y”?

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

 

sql.txt

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.

1 hour 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 also need to add the container port and map that to a local port if you haven't done that already.

I don’t use WOL so I’m not sure how I could help. There may be someone else here that can.

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

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 ...

 

 

working oob here

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 ...

 

 

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

We're getting closer to Guacamole 1.5.0. They've released RC1.

So my server restarted for some unknown reason yestrday and now I get the error page instead of a login for Guacamole.  if I had to guess (and I do ) I would think it's a mysql error?

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.

2 hours ago, Electrohacker said:

So my server restarted for some unknown reason yestrday and now I get the error page instead of a login for Guacamole.  if I had to guess (and I do ) I would think it's a mysql error?

Logs would help.

22 hours ago, Taddeusz said:

Logs would help.

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

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.

catalina.out

 

I dont know where the other log is

3 minutes ago, Electrohacker said:

catalina.out 2.85 MB · 0 downloads

 

I dont know where the other log is

Are you running this on Unraid?

@Electrohacker Might as well send the mysql_safe.log file that's in the database folder.

yes it is unraid

mysql_safe.log

@Electrohacker If you go to the Unraid interface and go to the Docker page. Click on the ApacheGuacamole icon and click Logs on the menu.