Microsoft MySQL Connection Problem

[BenjaminCz0101]

Have you read the documentation?

• [ X] Yes, but it does not include related information regarding my question.
• [ X] Yes, but the steps described in the documentation do not work on my machine.
• [X ] Yes, but I am having difficulty understanding it and wants clarification.

You are setting up gotify in

• Docker
• [ X] Linux native platform
• Windows native platform

Describe your problem
Hi there,

i have a Problem to Connect Microsoft MySQL Server. When i Starting with this Config my Gotify Server i have a Error in Logfile:

root@Gotify:/opt/gotify# sudo ./gotify-linux-amd64
Starting Gotify version 2.3.0@2023-07-20-18:03:23
panic: unknown time zone 192.168.178.140

goroutine 1 [running]:
main.main()
/proj/app.go:47 +0x36d
root@Gotify:/opt/gotify#

my config is ...

server:
  keepaliveperiodseconds: 0 # 0 = use Go default (15s); -1 = disable keepalive; set the interval in which keepalive packets will be sent. Only change this value if you know what you are doing.
  listenaddr: "" # the address to bind on, leave empty to bind on all addresses
  port: 80 # the port for the http server
  ssl:
    enabled: false # if https should be enabled
    redirecttohttps: true # redirect to https if site is accessed by http
    listenaddr: "" # the address to bind on, leave empty to bind on all addresses
    port: 443 # the https port
    certfile: # the cert file (leave empty when using letsencrypt)
    certkey: # the cert key (leave empty when using letsencrypt)
    letsencrypt:
      enabled: false # if the certificate should be requested from letsencrypt
      accepttos: false # if you accept the tos from letsencrypt
      cache: data/certs # the directory of the cache from letsencrypt
      hosts: # the hosts for which letsencrypt should request certificates
  #     - mydomain.tld
  #     - myotherdomain.tld
  responseheaders: # response headers are added to every response (default: none)
  # X-Custom-Header: "custom value"

  cors: # Sets cors headers only when needed and provides support for multiple allowed origins. Overrides Access-Control-* Headers in response headers.
    alloworigins:
    # - ".+.example.com"
    # - "otherdomain.com"
    allowmethods:
    # - "GET"
    # - "POST"
    allowheaders:
  #   - "Authorization"
  #   - "content-type"

  stream:
    pingperiodseconds: 45 # the interval in which websocket pings will be sent. Only change this value if you know what you are doing.
    allowedorigins: # allowed origins for websocket connections (same origin is always allowed, default only same origin)
#     - ".+.example.com"
#     - "otherdomain.com"
database: # see below
  **dialect: mysql
  connection: gotify:password@/gotify?charset=utf8&parseTime=true&loc=192.168.XXX.XXX**
defaultuser: # on database creation, gotify creates an admin user (these values will only be used for the first start, if you want to edit the user after the first start use the WebUI)
  name: admin # the username of the default user
  pass: admin # the password of the default user
passstrength: 10 # the bcrypt password strength (higher = better but also slower)
uploadedimagesdir: data/images # the directory for storing uploaded images
pluginsdir: data/plugins # the directory where plugin resides (leave empty to disable plugins)
registration: false # enable registrations

Any errors, logs, or other information that might help us identify your problem

Ex: docker-compose.yml, nginx.conf, android logcat, browser requests, etc.

Name of the information here

contents here

[jmattheis]

The loc params in the mysql connection string describes the timezone and not the host. Define the host like this:

gotify:secret@tcp(localhost:3306)/gotifydb?charset=utf8&parseTime=True&loc=Local

Replace localhost with your IP / host.

I've updated the gotify.net docs accordingly.

[BenjaminCz0101]

Hi thank you for Support me! I try this Here gotify:Homepage007!@tcp(192.168.178.140:1433)/gotify?charset=utf8&parseTime=True&loc=Local and the Error Code is: root@Gotify:/opt/gotify# sudo ./gotify-linux-amd64 Starting Gotify version 2.3.0@2023-07-20-18:03:23 [mysql] 2023/08/27 13:20:39 packets.go:36: unexpected EOF [mysql] 2023/08/27 13:22:39 packets.go:36: unexpected EOF [mysql] 2023/08/27 13:24:39 packets.go:36: unexpected EOF panic: driver: bad connection Where ist he Problem ? Best Regards! Von: Jannis Mattheis ***@***.***> Gesendet: Sonntag, 27. August 2023 09:58 An: gotify/server ***@***.***> Cc: BenjaminCz0101 ***@***.***>; Author ***@***.***> Betreff: Re: [gotify/server] Microsoft MySQL Connection Problem (Issue #588) The loc params in the mysql connection string describes the timezone and not the host. Define the host like this: ***@***.***(localhost:3306)/gotifydb?charset=utf8&parseTime=True&loc=L ocal Replace localhost with your IP / host. I've updated the gotify.net docs accordingly. - Reply to this email directly, view it on GitHub <#588 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/A5JEKVWBUAN5AEG6RJJISF3XX L4YHANCNFSM6AAAAAA373Z7GE> . You are receiving this because you authored the thread. <https://github.com/notifications/beacon/A5JEKVQQF24X2SBDEFJLZPTXXL4YHA5CNFS M6AAAAAA373Z7GGWGG33NNVSW45C7OR4XAZNMJFZXG5LFINXW23LFNZ2KUY3PNVWWK3TUL5UWJTT FAGD7I.gif> Message ID: ***@***.*** ***@***.***> >

[jmattheis]

Given the port you've specified (1433), I expect you to use Microsoft SQL (MSSQL) not some kind of MySQL. MSSQL isn't supported by gotify.

[BenjaminCz0101]

ok thank you.