Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to Set MySQL Port Options? #364

Open
elrok123 opened this Issue Sep 14, 2018 · 2 comments

Comments

Projects
None yet
3 participants
@elrok123
Copy link

elrok123 commented Sep 14, 2018

I don't know if I'm being stupid. But I swear there doesn't seem to be any way of setting the port for MySQL on Open Web Analytics (at least not without having a proper inspection under the hood, but even then it still looked like it was just assuming the default port).

This could be problematic for some people using MySQL on non-default ports. Apologies if I've totally missed the options, but I've had a look through the MySQL options in the installation guide and looked around in the code base where it sets up the MySQL connection.

@padams padams added the enhancement label Sep 28, 2018

@padams

This comment has been minimized.

Copy link
Owner

padams commented Sep 28, 2018

very true. happy to look at a patch/PR if you have one.

@gili77

This comment has been minimized.

Copy link

gili77 commented Oct 10, 2018

I run into the same problem, I had to replace the port to able to use database cluster...
Anyway, my solution was following the error and edit the connect function "mysqli_connect".
Edit the file "plugins/db/owa_db_mysql.php" at line 107
change this:
$this->connection = mysqli_connect(
$host,
$this->getConnectionParam('user'),
$this->getConnectionParam('password'),
$this->getConnectionParam('name')
);

into this:
$this->connection = mysqli_connect(
$host,
$this->getConnectionParam('user'),
$this->getConnectionParam('password'),
$this->getConnectionParam('name'),
'3307'
);
Note that if you use "mysql_connect" function the solution will be to edit the function
at the file "includes/pqp/classes/MySqlDatabase.php".

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.