Configure database connection on specific port

259 views
Skip to first unread message

Rob Aval

unread,
Feb 26, 2015, 10:28:27 AM2/26/15
to resour...@googlegroups.com
Hi, i'd like to install ResourceSpace on my server, but my hosting provider is using to connection with mySQL database PORT 3307 (not the standard one 3307).
Is it possible to put this port number somewhere into the config file? And how can I do this?

PS. I find interesting, that when I 'm typing my SQL server information on setup.php and putting port number in the sql server field (sql.my_sql_server_domain.pl:3307) the configuration gets green boxes (like it means it's valid), but in the next step, on login.php, I get an error:

/include/db.php line 84: mysqli_connect() [<a href='function.mysqli-connect'>function.mysqli-connect</a>]: (HY000/2005): Unknown MySQL server host 'sql.my_sql_server_domain.pl:3307' (25)

Can you help me with it?

Allison Stec

unread,
Feb 26, 2015, 12:00:35 PM2/26/15
to ResourceSpace
Your php config will need to know the proper mysql port, but I don't think you need to do anything in RS.

Have you tried leaving the port off?

Allison Stec
Asset Management Specialist
Colorhythm
http://www.colorhythm.com

Main Office: +1 415-399-9921
Fax: +1 415-399-9928

as...@colorhythm.com

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.org
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Rob Aval

unread,
Feb 27, 2015, 2:56:22 AM2/27/15
to resour...@googlegroups.com
Thanks for response, i've tried it.

But I got an answer! I needed to change my default mysql and mysqli port to 3307, I made it with .htaccess file:

php_value mysql.default_port 3307
php_value mysqli.default_port 3307

Thanks!
Reply all
Reply to author
Forward
0 new messages