Koozali.org: home of the SME Server

Obsolete Releases => SME 9.x Contribs => Topic started by: uli334 on November 09, 2018, 10:19:34 AM

Title: Mysql55 and Port 3307
Post by: uli334 on November 09, 2018, 10:19:34 AM

Hello,
I want to use Groupoffice 6.3 on SME 9.2/64.

- For that purpose I installed from the Softare Collections PHP and this works well.
- For GO I also needed Mysql >= 5.3 and I installed Mysql55 (https://wiki.contribs.org/Software_Collections:MySQL55) in the RH Version.
- After installation and restart I could connect to the socket with
 " /opt/rh/mysql55/root/usr/bin/mysql  --socket=/var/lib/mysql/mysql55.sock "
but not through TCP port 3307 with:
- " /opt/rh/mysql55/root/usr/bin/mysql --protocol=TCP --port=3307 " - Here the answer is " Can't connect to MySQL server on 'localhost' (111) "

As shown in the contrib- section I made:
- " config setprop mysq55-mysql LocalNetworkingOnly no
signal-event post-upgrade;signal-event reboot "

But after this I get the same result- no connection on port 3307...

Unfortunately Groupoffice does't support connection via socket.
Can someone tell me how to enable the support for port 3307 on localhost?

Thanks for your help!
Uli

Title: Re: Mysql55 and Port 3307
Post by: sages on November 09, 2018, 12:23:09 PM

Quote from: uli334 on November 09, 2018, 10:19:34 AM

- For GO I also needed Mysql >= 5.3 and I installed Mysql55 (https://wiki.contribs.org/Software_Collections:MySQL55)

Read the entire wiki entry that you used to install Mysgl55 that you have quoted in your question  8-)
Specifically the section regarding USAGE  :-?

Title: Re: Mysql55 and Port 3307
Post by: mmccarn on November 09, 2018, 12:31:47 PM

There appears to be a typo in the wiki.

On my server with the smeserver-mysql55 contrib installed, I do not have any config db entry for "mysql55-mysql" as indicated in the wiki.

Instead, I have a section for "mysql55-mysqld":

Code: [Select]

# config show mysql55-mysqld
mysql55-mysqld=service
    LocalNetworkingOnly=no
    port=3306
    status=enabled

Also - it looks to me as though, on my system, if I enable LocalNetworkOnly I will get a port conflict on port 3306.  This could be something I did to myself, but you'd better check (or reset) before reconfiguring your system:

Code: [Select]

config setprop mysql55-mysqld port 3307 LocalNetworkOnly no
signal-event post-upgrade;signal-event reboot


[edit] I wrote "contrib" instead of "config db" in 2nd paragraph

[edit2] I had IP turned on (LocalNetworkOnly no) and assumed it was not.  Changed "yes" to "no"

Title: Re: Mysql55 and Port 3307
Post by: mmccarn on November 09, 2018, 01:10:06 PM

After verifying on my own system that the wiki syntax was indeed missing the "d" in mysql55-mysqld, I've updated the wiki with the correct instructions:

https://wiki.contribs.org/Software_Collections:MySQL55#Usage

Title: Re: Mysql55 and Port 3307
Post by: uli334 on November 10, 2018, 03:09:46 PM

Hello,

thank you for your answers!

I think there is another typo in the wiki:

- config setprop mysq55-mysqld port 3307 LocalNetworkingOnly no

must be (an "l" seems to be missing in "mysq55-mysqld" ?...):

- config setprop mysql55-mysqld port 3307 LocalNetworkingOnly no

In your post here it is right, in the wiki there is no "l"... :?

Title: Re: Mysql55 and Port 3307
Post by: mmccarn on November 10, 2018, 06:22:56 PM

Quote from: uli334 on November 10, 2018, 03:09:46 PM

...

- config setprop mysql55-mysqld port 3307 LocalNetworkingOnly no

In your post here it is right, in the wiki there is no "l"... :?

Grrr...

Wiki fixed.

Thanks.

https://wiki.contribs.org/Software_Collections:MySQL55#Usage

Title: Re: Mysql55 and Port 3307
Post by: TerryF on November 10, 2018, 07:53:02 PM

Thank you for the update...

Title: Re: Mysql55 and Port 3307
Post by: ReetP on November 11, 2018, 12:07:38 AM

:thumbsup:

Title: Re: Mysql55 and Port 3307
Post by: uli334 on November 12, 2018, 11:47:36 AM

Hi,

thank you all for your help. Now i can install Groupoffice on mysql55 using port 3307!

Very much Greetins,
Uli