06586: mySql port - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

06586	Bug reports	Installation	public	2012-09-24 18:48	2012-09-30 15:22

Reporter	robk84625	Assigned To	c_schmitz
Priority	high	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	2.00+
Fixed in Version	2.00+

Summary	06586: mySql port
Description	In the installation process you can't allocate a port number for mySql. Alternatives like "localhost:PORT_ID" are not working.
Steps To Reproduce	(german installation) 1) Fresh Installation 2) {DOMAIN_NAME}/index.php/installer/database 3) Second Text field: "Database Location"
Additional Information	I tried: a) 127.0.0.1 b) localhost c) 127.0.0.1:PORT_ID d) localhost:PORT_ID Picture: http://i.imgur.com/SsOEA.png
Tags	No tags attached.
Attached Files	limesurvey.png (48,459 bytes) limesurvey.png (48,459 bytes)

Bug heat	4
Complete LimeSurvey version number (& build)	2.00
I will donate to the project if issue is resolved	Yes
Browser	Firefox 15.0.1.
Database type & version	MySQL Servers 5.1.61
Server OS (if known)	Debian
Webserver software & version (if known)	Apache2 20051115
PHP Version	5.3.16

User List	There are no users monitoring this issue.

c_schmitz 2012-09-25 16:38 administrator ~20799	How do you know it is a port issue? 3306 is assumed by default if you just use localhost.

robk84625 2012-09-25 16:45 reporter ~20800	a) In version RC9 limesurvey Installation with port assignment works perfect b) The textfield "database location" is red while all four possibilites 127.0.0.1, localhost, 127.0.0.1:PORT_ID, localhost:PORT_ID was tried c) No other errors occur during the installation while all requirements fit

robk84625 2012-09-25 23:44 reporter ~20808	Now it works... i think there is no port problem but a problem with the right error display.

c_schmitz 2012-09-26 09:02 administrator ~20815	Can you explain?

robk84625 2012-09-26 18:35 reporter ~20831	Yes, i think the error message is too common.... The user does not know why the database connection failed. Perhaps it's better to differ with mysql_connect and mysql_select_db.

c_schmitz 2012-09-27 08:49 administrator ~20834	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=9562

c_schmitz 2012-09-27 08:49 administrator ~20835	Thank you for the feedback.

c_schmitz 2012-09-30 15:22 administrator ~20909	New Version 2.00+ Build 120930 released. If you are using 120926 you should be able to update by ComfortUpdate. All earlier versions need to update manually.

Date Modified	Username	Field	Change
2012-09-24 18:48	robk84625	New Issue
2012-09-24 18:48	robk84625	File Added: limesurvey.png
2012-09-24 19:23	Mazi	Assigned To	=> c_schmitz
2012-09-24 19:23	Mazi	Status	new => assigned
2012-09-25 16:38	c_schmitz	Note Added: 20799
2012-09-25 16:38	c_schmitz	Status	assigned => feedback
2012-09-25 16:45	robk84625	Note Added: 20800
2012-09-25 16:45	robk84625	Status	feedback => assigned
2012-09-25 23:44	robk84625	Note Added: 20808
2012-09-26 09:02	c_schmitz	Note Added: 20815
2012-09-26 09:02	c_schmitz	Status	assigned => feedback
2012-09-26 18:35	robk84625	Note Added: 20831
2012-09-26 18:35	robk84625	Status	feedback => assigned
2012-09-27 08:49	c_schmitz	Changeset attached	=> LimeSurvey master 2be65c64
2012-09-27 08:49	c_schmitz	Note Added: 20834
2012-09-27 08:49	c_schmitz	Resolution	open => fixed
2012-09-27 08:49	c_schmitz	Status	assigned => resolved
2012-09-27 08:49	c_schmitz	Fixed in Version	=> 2.00+
2012-09-27 08:49	c_schmitz	Note Added: 20835
2012-09-30 15:22	c_schmitz	Note Added: 20909
2012-09-30 15:22	c_schmitz	Status	resolved => closed

LimeSurvey: master 2be65c64 2012-09-27 01:48 c_schmitz Details Diff	Fixed issue 06586: Misleading error message when configuring database access	Affected Issues 06586
	mod - application/controllers/InstallerController.php	Diff File
	mod - application/views/installer/dbconfig_view.php	Diff File