Koozali.org: home of the SME Server
Contribs.org Forums => Koozali SME Server 10.x Contribs => Topic started by: uli334 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
-
socket should be the way
https://www.group-office.com/forum/viewtopic.php?t=6942
https://www.group-office.com/wiki/Configuration_file#Database_settings_list
-
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:
netstat -tulpn | grep 3313
-
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?
-
'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?
-
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'