Koozali.org: home of the SME Server

Mariadb105 connecting through localhost:3313

Offline uli334

  • ***
  • 128
  • +0/-0
Mariadb105 connecting through localhost:3313
« on: April 23, 2022, 12:46:08 PM »
Hello,

im having trouble installing groupoffice 6.6 on my sme10.
Because the standard sme mariadb has too low version (5.5.68-MariaDB) and Groupoffice needs MariaDB10.5, i installed the contrib "Mariadb105". This version is ok and im using it also for Nextcloud 22- running perfectly on the socket connection.
Unfortunately Groupoffice fails to work with the socket- connection (as it also did on my sme9.2...), so i tried to open the tcp port 3313:

- config setprop mariadb105-mariadb port 3313 LocalNetworkingOnly no (after that: signal-event... and reboot)

Now:
- config show mariadb105-mariadb
gives me:

mariadb105-mariadb=service
    LocalNetworkingOnly=no
    port=3313
    status=enabled

Mariadb 105 seems to reachable an port 3313.

I tried:
- /opt/rh/rh-mariadb105/root/usr/bin/mariadb --protocol=TCP --port=3313
Answer:
- ERROR 2002 (HY000): Can't connect to MySQL server on 'localhost' (115)

Now i tried:
- /opt/rh/rh-mariadb105/root/usr/bin/mariadb --socket=/var/lib/mysql/mariadb105.sock
With this i suscseed entering the database.

So i think, the mariadb105 is still not reachable via localhost:3313  :sad:

Can anyone see where my failure is and what i have to do to open port 3313?

Thank you very much!
Uli


Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: Mariadb105 connecting through localhost:3313
« Reply #2 on: April 28, 2022, 11:36:20 PM »
I have 10.5 + opencart on a port.

Just localhost:3313

However socket is preferable if possible (I hadn't time to debug opencart!)

You can check for a port:

Code: [Select]
netstat -tulpn | grep 3313
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline uli334

  • ***
  • 128
  • +0/-0
Re: Mariadb105 connecting through localhost:3313
« Reply #3 on: April 30, 2022, 11:28:10 AM »
About: Groupoffice & socket:
Now i have set an enquiry at the groupoffice support about the socket connection. When i get the answer i'll post it here.

I know the list of options in go's config.php and there set:

//  'db_socket' => '/var/lib/mysql/mariadb105.sock',
  'db_port' => '3313',

The 'db_socket' option is commented out, because i tried it without success. But maybe it's a question of the syntax, i hope the go support tells me...

- The port check with "netstat -tulpn | grep 3313" gives no message. I write it, press 'enter' and the shell ist empty again.

- When i set 'db_port' => 'localhost:3313', the go- installation tells me again: "Your MariaDB version 5.5.68 is too old".

I also would prefer the socket connection, but if it is malfunctionig with go i would try to reach the database via port. Did i use the wrong command (config setprop mariadb105-mariadb port 3313 LocalNetworkingOnly no) to open it?

Offline Jean-Philippe Pialasse

  • *
  • 2,746
  • +11/-0
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Mariadb105 connecting through localhost:3313
« Reply #4 on: April 30, 2022, 03:08:16 PM »

'db_port' => 'localhost:3313' telling you are using 5.5, only 2 solutiins


first the obvious when you put an incorrect string value in a variable expecting a port number you have either the code returning an error or trying to make it easy for you and use the default 3306

or would you happen to add a custom template that set the port number to 3313 and fall in the mariadb section?


Offline uli334

  • ***
  • 128
  • +0/-0
Re: Mariadb105 connecting through localhost:3313
« Reply #5 on: May 03, 2022, 10:50:49 AM »
Now i've got an answer from go support:

" The db_socket option is old and is no longer used. If you set the hostname to 'localhost' it will use a socket on unix systems. "

I'll try and then report here...

Now:
- It's only accepting 'localhost' and then uses the socket of the old  (default) mariadb.
- I asked the GO support: Unfortunately GO does't support options like '/var/lib/mysql/mariadb105.sock'
« Last Edit: May 07, 2022, 06:27:57 AM by uli334 »