uldise

Members
 View Profile  See their activity

  • Posts

    962

  • Joined

  • Last visited

  • Days Won

    3

 Content Type 

Posts posted by uldise

    [Support] jasonbean - Apache Guacamole

    in Docker Containers

    Posted · Edited by uldise
    typos

    OK, looks like i somehow fixed it myself. what i did (just for reference) :

     

    1. there was a problem with my reverse proxy config, looks like it changed with this version. 

    old version that works till version 1.4: 

    ProxyPass / http://<LAN IP>:8088/guacamole/ flushpackets=on

    new version, works with version 1.5: 

    ProxyPass / http://<LAN IP>:8088/ flushpackets=on

     

    2. after upgrading to 1.5 this time mysql started just fine, but there was an errors in mysql.log: 

    2023-05-05 20:45:18 0 [ERROR] Incorrect definition of table mysql.event: expected column 'definer' at position 3 to have type varchar(, found type char(141).
2023-05-05 20:45:18 0 [ERROR] Incorrect definition of table mysql.event: expected column 'sql_mode' at position 14 to have type set('REAL_AS_FLOAT','PIPES_AS_CONCAT','ANSI_QUOTES','IGNORE_SPACE','IGNORE_BAD
2023-05-05 20:45:18 0 [ERROR] mysqld: Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.

    after quick googling i found that it should be fixed with this command inside docker container: 

    mariadb-upgrade -u root -p

    BUT, this command was not found in docker image used, so i installed it myself with command (again, inside docker container) : 

    apk add mariadb-server-utils

    and executed mariadb-upgrade command above and it fixed my mysql installation.

     

    looks like all is working just fine now, quick docker restart shows no more errors in mysql.log. 

    [Support] jasonbean - Apache Guacamole

    in Docker Containers

    Posted · Edited by uldise
    Added mariadb.log info

    22 minutes ago, Taddeusz said:

    Yes, that’s correct.

    just did that - 1.4.0-3 is working just fine. then i upgraded to latest - and it's not working - looks like mariadb is not running at all.

    catalina log snippet below. if i open docker log, it's full of mariadb restarting every one second... 

    19:11:38.010 [http-nio-8080-exec-5] WARN  o.a.g.e.AuthenticationProviderFacade - The "mysql" authentication provider has encountered an internal error which will halt the authentication process. If this is u
19:11:38.014 [http-nio-8080-exec-5] ERROR o.a.g.rest.RESTExceptionMapper - Unexpected internal error:.
### Error querying database.  Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
### The error may exist in org/apache/guacamole/auth/jdbc/user/UserMapper.xml
### The error may involve org.apache.guacamole.auth.jdbc.user.UserMapper.selectOne
### The error occurred while executing a query
### Cause: com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

     

    and mariadb.log is full of this: 

    /usr/bin/mysqld: One can only use the --user switch if running as root

     

    Hard Drivers Passthrough -> Proxmox -> UNRAID VM -- Not Spinning down

    in Virtualizing Unraid

    Posted

    On 10/30/2022 at 10:55 AM, chris_netsmart said:

    is that Unraid see them as Vm Hard disks and not a physical hard drive.

    that's true - if you have such config, forget about SMART monitoring, disk spindown..

    you must pass-through whole disk controller to get these features working.

     

    On 10/30/2022 at 10:55 AM, chris_netsmart said:

    I did try and pass through a PCI controller but this just course unraid and proxmox to crash

    look at IOMMU group of you controller - if there are many devices in same group, you are in trouble. as per your pic, i see group "11" more than once.

    if you pass this one device, then all others in this group will be inaccessible to Host.

     

    there are some options to split PCIe devices to each own group, but it depends on you motherboard used. 

    unraid server upgrade help

    in Virtualizing Unraid

    Posted

    7 hours ago, crash987_9 said:

    Are there any nay benefits to having proxmox running on the metal with everything in a VM, or is it better to just run unraid on the metal and setup VM computers inside unraid

    it depends..

    if you have to restart unraid, then all your VMs/containers will do the same..

    i'm running unraid on top of Proxmox, and it runs just fine - for me Proxmox is with more options cos it's pure debian. so on Proxmox VMs/LXC, while on unraid storage and Docker.

    if you run unraid as VM it's recoomended that you pass-through all needed devices to VM.. look at your hardware for this option..

    [REQUEST] Meshcentral

    in Docker Engine

    Posted

    On 6/6/2021 at 4:19 AM, tjustice86 said:

    I don't see any files under my meshcentral-data folder unless I check from within the container itself.

    then it's something wrong with volume mapping. all config files should be accessible by host in mapped folder.