07664: Allow unix_socket on installation and connexion string - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

6

ID	Project	Category	View Status	Date Submitted	Last Update

07664	Feature requests	Installation	public	2013-03-15 09:02	2014-05-03 21:34

Reporter	DezB	Assigned To	DenisChenu
Priority	normal	Severity	feature
Status	closed	Resolution	fixed

Summary	07664: Allow unix_socket on installation and connexion string
Description	I recently had problems installing to a 1and1 managed server which turned out to be a problem with line 1106 on the starting config file. Once I had changed the configuration to: $dsn = "mysql:unix_socket={$sDatabaseLocation};port={$sDatabasePort};dbname={$sDatabaseName};"; And the install will run as normal but in the host box instead of localhost put /tmp/mysql5.sock As 1and1 are one of the largest host suppliers in the UK, Germany and across Europe perhaps a selection button could be put into the installation process to pre-select these details
Additional Information	Many thanks to Ben_V and DenisChenu for helping me to solve this problem The solution can be found in the forum here: http://www.limesurvey.org/en/forum/installation-a-update-issues/92001-limesurvey-2-and-1and1-hosting#92818
Tags	No tags attached.

Bug heat	6
Story point estimate
Users affected %

DenisChenu 2013-03-15 15:05 developer ~24700	Changed the title of the bug: Allow unix_socket on installation and connexion string And did you test with only: $dsn = "mysql:unix_socket={$sDatabaseLocation};dbname={$sDatabaseName};"; unix_socket don't need port, and surely can break some installation: http://php.net/manual/de/ref.pdo-mysql.connection.php

DezB 2013-03-15 18:24 reporter ~24703	HI Shnoulle Yes, I did try about every combination I could think of until Ben_V pointed me to the link above which worked first time. Hope this helps. DezB

c_schmitz 2013-03-16 13:15 administrator ~24704	it is relativel easy to code - if the the %DatabaseLocation starts with a slash '/' assume a unix socket and set the connection string accordingly during installation.

DenisChenu 2013-03-16 14:14 developer ~24706	<q>it is relativel easy to code</q>You know the reason i take it ;). Think it's best to have a select box 'connexion method' defal to host, no ?

LimeSurvey: 2.05 7f74b1b0 2013-03-26 10:35:31 DenisChenu Details Diff	New feature 07664: Allow unix_socket on installation and connexion string (use socket directly in DB location) Dev: maybe adding more protocol : http://dev.mysql.com/doc/refman/5.5/en//connecting.html#option_general_protocol Dev: but seem needed only for some ... hoster		Affected Issues 07664
	mod - application/controllers/InstallerController.php		Diff File
	mod - application/views/installer/dbconfig_view.php		Diff File

Date Modified	Username	Field	Change
2013-03-15 09:02	DezB	New Issue
2013-03-15 15:02	DenisChenu	Severity	@50@ => feature
2013-03-15 15:02	DenisChenu	Summary	Installation on 1and1 Servers => Allow unix_socket on installation and connexion string
2013-03-15 15:05	DenisChenu	Note Added: 24700
2013-03-15 18:24	DezB	Note Added: 24703
2013-03-16 00:22	DenisChenu	Assigned To	=> DenisChenu
2013-03-16 00:22	DenisChenu	Status	new => assigned
2013-03-16 13:15	c_schmitz	Note Added: 24704
2013-03-16 14:14	DenisChenu	Note Added: 24706
2013-03-26 11:39	DenisChenu	Changeset attached	=> LimeSurvey 2.05 7f74b1b0
2013-03-26 11:39	DenisChenu	Status	assigned => resolved
2013-03-26 11:39	DenisChenu	Fixed in Version	=> 2.05+
2013-03-26 11:39	DenisChenu	Resolution	open => fixed
2014-05-03 21:34	c_schmitz	Status	resolved => closed