Topic: Mysql55 and Port 3307

[uli334]

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

[sages]

- 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 
Specifically the section regarding USAGE 

[mmccarn]

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"

[mmccarn]

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

[uli334]

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"...

[mmccarn]

...

- 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

[TerryF]

Thank you for the update...

[ReetP]

:thumbsup:

[uli334]

Hi,

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

Very much Greetins,
Uli