View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
08738Bug reportsAuthenticationpublic2016-02-15 16:49
Reportergkuchyt Assigned Tomdekker  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Summary08738: Upgrading with webserver auth from 2.00+ to 2.05+ does not work.
Description

The introduction of plugins in 2.05 (good idea by the way) does not play well with an upgrade from 2.00 when webserver authentication is being utilized. This config directive is apparently not being regarded in the config file to see if the needed database entries enabling the 'Authwebserver' plugin are needed.

Steps To Reproduce

Upgrade from 2.00 to 2.05 ensuring the 2.00 install utilizes webserver authentication

Attempt to login to the limesurvey admin interface, and you'll be presented with the login form instead of being passed through on the Authwebserver plugin.

Additional Information

This can be mitigated by adding the following to the lime_plugins table (changing strip_domain and serverkey as needed)

insert into lime_plugins values(NULL, 'Authwebserver', 1);
insert into lime_plugin_settings values(NULL, 2, NULL, NULL, 'strip_domain', 'null');
insert into lime_plugin_settings values(NULL, 2, NULL, NULL, 'serverkey', '"REMOTE_USER"');

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)e141305286b4c102738d99528902
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPercona MySQL 5.5.35-33.0
Server OS (if known)RHEL 6
Webserver software & version (if known)Apache 2.2.15-29
PHP Version5.3.3-27

Users monitoring this issue

There are no users monitoring this issue.

Activities

gkuchyt

gkuchyt

2014-02-18 19:32

reporter   ~28812

I should add that the title is not accurate. The upgrade does work properly and the schema is upgraded, it's just that the user will be unable to login to LimeSurvey using webserver authentication as they had previously before the upgrade.

mdekker

mdekker

2014-02-19 14:23

reporter   ~28821

Maybe this can be a check in the upgrade script? If webserver auth is active perform these actions?

c_schmitz

c_schmitz

2014-02-19 15:04

administrator   ~28824

mdekker, should be possible. Can you implement it into an existing dbversion step (as it makes no sense to create a new one)?

mdekker

mdekker

2014-03-06 11:55

reporter   ~29111

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13978

mdekker

mdekker

2014-03-06 11:58

reporter   ~29112

@gkuchyt I gues since you already upgraded it is not possible to test but if you can, please give it a try and let us know if the fix works.

c_schmitz

c_schmitz

2014-03-17 13:14

administrator   ~29272

2.05+ Build 140317 released

gkuchyt

gkuchyt

2014-03-21 14:57

reporter   ~29492

First I really apologize for taking so long to follow up on this. I know it bothers me when customers do this on tickets I have open with them.

I was doing this in our test instance so I can attempt to repeat at will.

So when I attempted to go from 2.00+ to the latest build (2.05 build 130320) I got a stack trace during the database schema upgrade. Screenshot here http://www.uvm.edu/~gkuchyt/saa/tmp/08738_stacktrace.png

Though, attempting to re-run the upgrade process after the stack trace seems to yield a successful update.

mdekker

mdekker

2014-07-03 12:38

reporter   ~30259

Dont see a lot of comments on this and it would be hard to fix it the right way. Leaving the ticket for reference. Problem will die out when 2.05 is around for a longer time and there are no more 2.00 installations trying to upgrade.

Related Changesets

LimeSurvey: master cd7d3871

2014-03-06 10:55:28

mdekker

Details Diff
Fixed 08738: Upgrading with webserver auth from 2.00+ to 2.05+ does not enable authwebserver plugin Affected Issues
08738
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2014-02-18 19:31 gkuchyt New Issue
2014-02-18 19:31 gkuchyt Status new => assigned
2014-02-18 19:31 gkuchyt Assigned To => c_schmitz
2014-02-18 19:32 gkuchyt Note Added: 28812
2014-02-19 14:23 mdekker Note Added: 28821
2014-02-19 15:03 c_schmitz Assigned To c_schmitz => mdekker
2014-02-19 15:04 c_schmitz Note Added: 28824
2014-02-19 15:05 c_schmitz Category ComfortUpdate => Authentication
2014-03-06 11:55 mdekker Changeset attached => LimeSurvey master cd7d3871
2014-03-06 11:55 mdekker Note Added: 29111
2014-03-06 11:55 mdekker Resolution open => fixed
2014-03-06 11:58 mdekker Note Added: 29112
2014-03-12 14:18 mdekker Status assigned => resolved
2014-03-17 13:14 c_schmitz Note Added: 29272
2014-03-17 13:14 c_schmitz Status resolved => closed
2014-03-21 14:57 gkuchyt Note Added: 29492
2014-03-21 14:57 gkuchyt Status closed => feedback
2014-03-21 14:57 gkuchyt Resolution fixed => reopened
2014-07-03 12:38 mdekker Note Added: 30259
2014-07-03 12:38 mdekker Status feedback => acknowledged
2016-02-15 16:49 c_schmitz Status acknowledged => closed
2016-02-15 16:49 c_schmitz Resolution reopened => fixed