Menu
▾
▴
phpesp-devel — Discussion of the development of phpESP
You can subscribe to this list here.
| 2002 |
Jan
|
Feb
|
Mar
(103) |
Apr
(37) |
May
(45) |
Jun
(49) |
Jul
(55) |
Aug
(11) |
Sep
(47) |
Oct
(55) |
Nov
(47) |
Dec
(8) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2003 |
Jan
(43) |
Feb
(85) |
Mar
(121) |
Apr
(37) |
May
(33) |
Jun
(33) |
Jul
(14) |
Aug
(34) |
Sep
(58) |
Oct
(68) |
Nov
(31) |
Dec
(9) |
| 2004 |
Jan
(13) |
Feb
(57) |
Mar
(37) |
Apr
(26) |
May
(57) |
Jun
(14) |
Jul
(8) |
Aug
(12) |
Sep
(32) |
Oct
(10) |
Nov
(7) |
Dec
(12) |
| 2005 |
Jan
(8) |
Feb
(25) |
Mar
(50) |
Apr
(20) |
May
(32) |
Jun
(20) |
Jul
(83) |
Aug
(25) |
Sep
(17) |
Oct
(14) |
Nov
(32) |
Dec
(27) |
| 2006 |
Jan
(24) |
Feb
(15) |
Mar
(46) |
Apr
(5) |
May
(6) |
Jun
(9) |
Jul
(12) |
Aug
(5) |
Sep
(7) |
Oct
(7) |
Nov
(4) |
Dec
(5) |
| 2007 |
Jan
(4) |
Feb
(1) |
Mar
(7) |
Apr
(3) |
May
(4) |
Jun
|
Jul
|
Aug
(2) |
Sep
(2) |
Oct
|
Nov
(22) |
Dec
(19) |
| 2008 |
Jan
(94) |
Feb
(19) |
Mar
(32) |
Apr
(46) |
May
(20) |
Jun
(10) |
Jul
(11) |
Aug
(20) |
Sep
(16) |
Oct
(12) |
Nov
(13) |
Dec
|
| 2009 |
Jan
|
Feb
(9) |
Mar
(37) |
Apr
(65) |
May
(15) |
Jun
|
Jul
(24) |
Aug
(1) |
Sep
(8) |
Oct
(4) |
Nov
(21) |
Dec
(5) |
| 2010 |
Jan
(35) |
Feb
(6) |
Mar
(8) |
Apr
|
May
(4) |
Jun
(3) |
Jul
(4) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2011 |
Jan
|
Feb
(4) |
Mar
|
Apr
|
May
(1) |
Jun
(1) |
Jul
(1) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
|
From: James E. F. <jf...@uv...> - 2004-02-21 04:44:51
|
It might be nice to also include a (CLI) php script that will generate/edit the 'populate' sql scripts with different table names. Or is that overkill since it's not a big file to hand edit? -James Matthew Gregg wrote: > Available here[1] is the patch provided by Mike Churchward, that was > mentioned on phpESP-general the other day. I've cleaned it up to apply > to CVS. Adoption of this patch will allow easier integration with ESP > and Moodle[2]. It might even help some folks that have to run ESP on an > ISP that limits database configurations. > Please try and break it, comment, etc... > > [1] http://bfs.itlab.musc.edu/~greggmc/stuff/moodle.patch > [2] http://moodle.org/ |
|
From: James E. F. <jf...@uv...> - 2004-02-21 04:40:21
|
No objections. Note that changing the _('...') text will mean that the
gettext tables will need regeneration. I normally just do that before
releases, but perhaps it should be done sometime soon, since releases
are not to frequent. I should probably also check in the script I use
to generate & merge the tables ... or at least put them somewhere so
other developers can use them.
-James
Matthew Gregg wrote:
> I'm ready to apply this to CVS. Any objections?
>
> On Fri, 2004-02-13 at 17:13, Matthew Gregg wrote:
>
>>Please give the patch located here[1] a try. It also contains a fix for
>>bug #: 890830(the mysql_populate.sql problem on mySQL version 4.x), the
>>patch should apply cleanly to current CVS.
>>
>>[1] http://bfs.itlab.musc.edu/~greggmc/stuff/permission_mysql4.patch
|
|
From: Matthew G. <gr...@mu...> - 2004-02-20 22:31:40
|
Best I think you can do it add some "Section Text" as the first "question" after each page break. On Fri, 2004-02-20 at 16:57, Charlie Smith wrote: > Is it possible to display different page header information (like that entered > into the info field) at the top of each page (where page breaks are specified)? > > Charlie :)) > > > > ------------------------------------------------------- > SF.Net is sponsored by: Speed Start Your Linux Apps Now. > Build and deploy apps & Web services for Linux with > a free DVD software kit from IBM. Click Now! > http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Charlie S. <Sm...@ld...> - 2004-02-20 22:04:40
|
Is it possible to display different page header information (like that entered into the info field) at the top of each page (where page breaks are specified)? Charlie :)) |
|
From: Charlie S. <Sm...@ld...> - 2004-02-20 20:06:35
|
I've got an Oracle version of phpESP ready for review. Would I be able to check in the source code somewhere? Hopefully, this will lead into further work on porting phpESP to PEARDB. I noticed following obstacles in porting to Oracle: Some of the SQL didn't translate directly from MySQL to Oracle due to: - No corresponding functions like PASSWORD() and NOW() in Oracle, so I just removed the functions from the Oracle version. NOW() was replaced with 'sysdate'. - The MySQL bit manipulation did'nt transfer directly to Oracle so I translated to use the Oracle bitand() function. Where the Oracle calls have been abstracted out to the oracleInc.php routine - it may be easier to use this to abstract to PEAR DB. My sites use TWiki as the front end CGI script to present the web site. As such, I had to write what's termed an Application Framework which is a PERL routine that calls programs written in other languages - currently php, java or PERL. For the programs, they need to function with the argv argument. I had to therefore modify the phpESP to use command-line arguments. Though, I did maintain the original phpESP call interface using HTTP_POST_VARS and HTTP_GET_VARS - There's a flag in the phpESP.ini.php routine that can be used to switch the Application Framework wrapper interface on and off. When off, phpESP should work as a stand-alone application as originally designed, albeit now with Oracle rather than MySQL. I've included an /admin/docs/Oracle_install.txt file to show you how to move from MySQL to Oracle. And in the /script/db/process_phpesp_tables.pl, there the stuff to actually take a MySQL dump file and translate it to Oracle. This PERL script translates the MySQL dump file into a bunch of .sql files that can be used to create and populate the Oracle tables for this version of phpESP. Couple of questions now. Hopefully, this work I've done won't become obsolete. I've tried to make is a simple process, by following the instructions in the Oracle_install.txt file on how to move from MySQL to Oracle. Is anyone still interested in porting this to PEAR DB? Last time I tried to access the CVS repository, I got some access denied errors. How would you suggest that I submit this Oracle version of phpESP? I've a newbie to source-forge, so please have patience with me on this one. Charlie :) |
|
From: Charlie S. <Sm...@ld...> - 2004-02-20 20:05:29
|
I've got an Oracle version of phpESP ready for review. Would I be able to check in the source code somewhere? Hopefully, this will lead into further work on porting phpESP to PEARDB. I noticed following obstacles in porting to Oracle: Some of the SQL didn't translate directly from MySQL to Oracle due to: - No corresponding functions like PASSWORD() and NOW() in Oracle, so I just removed the functions from the Oracle version. NOW() was replaced with 'sysdate'. - The MySQL bit manipulation did'nt transfer directly to Oracle so I translated to use the Oracle bitand() function. Where the Oracle calls have been abstracted out to the oracleInc.php routine - it may be easier to use this to abstract to PEAR DB. My sites use TWiki as the front end CGI script to present the web site. As such, I had to write what's termed an Application Framework which is a PERL routine that calls programs written in other languages - currently php, java or PERL. For the programs, they need to function with the argv argument. I had to therefore modify the phpESP to use command-line arguments. Though, I did maintain the original phpESP call interface using HTTP_POST_VARS and HTTP_GET_VARS - There's a flag in the phpESP.ini.php routine that can be used to switch the Application Framework wrapper interface on and off. When off, phpESP should work as a stand-alone application as originally designed, albeit now with Oracle rather than MySQL. I've included an /admin/docs/Oracle_install.txt file to show you how to move from MySQL to Oracle. And in the /script/db/process_phpesp_tables.pl, there the stuff to actually take a MySQL dump file and translate it to Oracle. This PERL script translates the MySQL dump file into a bunch of .sql files that can be used to create and populate the Oracle tables for this version of phpESP. Couple of questions now. Hopefully, this work I've done won't become obsolete. I've tried to make is a simple process, by following the instructions in the Oracle_install.txt file on how to move from MySQL to Oracle. Is anyone still interested in porting this to PEAR DB? Last time I tried to access the CVS repository, I got some access denied errors. How would you suggest that I submit this Oracle version of phpESP? I've a newbie to source-forge, so please have patience with me on this one. Charlie :) |
|
From: Percy M. <bj...@ya...> - 2004-02-20 16:29:06
|
GET YOUR UNIVERSITY DIPLOMA There are no required tests, classes, books, or interviews! Get a Bachelors, Masters, MBA, and Doctorate (PhD) diploma! Receive the benefits and admiration that comes with a diploma! No one is turned down! Call Today 1-248-927-0446 (7 days a week) Confidentiality assured! out http://buynow.meds34r.com/host/emailremove.asp permissive gambit lounsbury inferred retaliatory junketeer baseman ainu eq= uivalent clogging demolish eosine appeal cloudy belfast partition loathsom= e=20 dichotomous monmouth km nus sheepskinsadden actinium acs timeout diamagnetic marquette bingham anderso= n bernhard biscuit born counterpoint praseodymium coo mutagen seville pavl= ov plowshare=20=20 |
|
From: Matthew G. <gr...@mu...> - 2004-02-20 02:58:06
|
Available here[1] is the patch provided by Mike Churchward, that was mentioned on phpESP-general the other day. I've cleaned it up to apply to CVS. Adoption of this patch will allow easier integration with ESP and Moodle[2]. It might even help some folks that have to run ESP on an ISP that limits database configurations. Please try and break it, comment, etc... [1] http://bfs.itlab.musc.edu/~greggmc/stuff/moodle.patch [2] http://moodle.org/ -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Matthew G. <gr...@mu...> - 2004-02-20 02:49:14
|
I'm ready to apply this to CVS. Any objections? On Fri, 2004-02-13 at 17:13, Matthew Gregg wrote: > Please give the patch located here[1] a try. It also contains a fix for > bug #: 890830(the mysql_populate.sql problem on mySQL version 4.x), the > patch should apply cleanly to current CVS. > > [1] http://bfs.itlab.musc.edu/~greggmc/stuff/permission_mysql4.patch > > > On Tue, 2004-02-10 at 17:40, James E. Flemer wrote: > > Matthew Gregg wrote: > > > On Sun, 2004-02-08 at 22:19, James E. Flemer wrote: > > > > > >>Matthew Gregg wrote: > > >> > > >>>I'm want to fix this bug, but need some clarification on permissions. > > >>>What designer permission level should grant access to the admrespondent > > >>>and admdesigner pages? > > >>>pgroup, puser or must the designer have both? The manage.php page allows > > >>>access to menu items to the "superuser" or a designer with "puser" or > > >>>"pgroup" permissions. > > >>> > > >>>http://sourceforge.net/tracker/index.php?func=detail&aid=754420&group_id=8956&atid=108956 > > >> > > >>I think my intent was that superuser could add designers and > > >>respondents, and designers could add respondents. However, if there is > > >>another preference I'll defer to someone who actually uses phpESP > > >>regularly. :-) > > > > > > How about this: > > > Designers with "puser" see the "Manage Respondent Accounts" menu and > > > have access to the related pages, since "puser" permission corresponds > > > to the "Administer Group Respondents" setting in the account setup. > > > > > > Designers cannot see nor access the "Manage Designer Accounts" > > > menu/pages. > > > > > > SuperUser does everything. > > > > +1 > > > > > > -- > > The SF.Net email is sponsored by EclipseCon 2004 > > Premiere Conference on Open Tools Development and Integration > > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > > http://www.eclipsecon.org/osdn > > _______________________________________________ > > phpESP-devel mailing list > > php...@li... > > https://lists.sourceforge.net/lists/listinfo/phpesp-devel -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: SourceForge.net <no...@so...> - 2004-02-18 14:59:04
|
Feature Requests item #899620, was opened at 2004-02-18 15:52 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=899620&group_id=8956 Category: data analysis Group: None Status: Open Priority: 5 Submitted By: Sereinigg (pser2000) Assigned to: Nobody/Anonymous (nobody) Summary: csv, excel and german languages Initial Comment: when exporting results csv or excel and there are german letters (ä,ü,...) in the questions, this letters are substituted by "_" and it is very hard to read this ... Isa it powssible to change this chars: ä = ae ö =oe ü =ue ß =ss ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=358956&aid=899620&group_id=8956 |
|
From: SourceForge.net <no...@so...> - 2004-02-17 13:36:51
|
Bugs item #748223, was opened at 2003-06-03 14:53 Message generated for change (Comment added) made by mcwsf You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=748223&group_id=8956 Category: Admin Group: None Status: Open Resolution: None Priority: 5 Submitted By: Matthew Gregg (greggmc) Assigned to: Nobody/Anonymous (nobody) Summary: CSV Export field name clash Initial Comment: CVS exporter doesn't distinguish between fields that are named the same. ---------------------------------------------------------------------- Comment By: Martijn Willemsen (mcwsf) Date: 2004-02-17 13:31 Message: Logged In: YES user_id=977615 I would certainly value a patch that can resolve problems with already existing surveys. We ran a questionnaire using phpesp 1.6.1 that has this problem, and it is difficult to retrieve the data otherwise. ---------------------------------------------------------------------- Comment By: Matthew Gregg (greggmc) Date: 2003-10-01 13:23 Message: Logged In: YES user_id=14116 If the patch works for existing surveys it should go into the tree. Why would we want this optional? Don't want to have to ask people to apply a patch and we don't want to continually keep the patch in sync with the tree. ---------------------------------------------------------------------- Comment By: Kon Angelopoulos (angek) Date: 2003-10-01 11:50 Message: Logged In: YES user_id=198398 I've tested it an it doesn't break existing surveys it only applies to any new questions being added to the survey. However how about distributing a patch that can be used by those who find themselves in this situation where the question id is joined to the question name thus making it unique. They can then simply download the results again and hopefully the problem no longer exists. ---------------------------------------------------------------------- Comment By: Matthew Gregg (greggmc) Date: 2003-09-29 15:20 Message: Logged In: YES user_id=14116 I think disallowing duplicate question names is the way to go, but could break existing surveys. How should we handle that? ---------------------------------------------------------------------- Comment By: Kon Angelopoulos (angek) Date: 2003-09-28 01:25 Message: Logged In: YES user_id=198398 I've added code to survey_update to prevent duplicate question names from being used in a given survey which will prevent this type of bug from reoccuring. If you think that this is satisfactory then close this request. If however you feel strongly about allowing duplicate names and that the fix should be in the cvs export function then please let me know and I'll look into it while I have a bit of time on my hands. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=748223&group_id=8956 |
|
From: Matthew G. <gr...@mu...> - 2004-02-13 22:15:59
|
Please give the patch located here[1] a try. It also contains a fix for bug #: 890830(the mysql_populate.sql problem on mySQL version 4.x), the patch should apply cleanly to current CVS. [1] http://bfs.itlab.musc.edu/~greggmc/stuff/permission_mysql4.patch On Tue, 2004-02-10 at 17:40, James E. Flemer wrote: > Matthew Gregg wrote: > > On Sun, 2004-02-08 at 22:19, James E. Flemer wrote: > > > >>Matthew Gregg wrote: > >> > >>>I'm want to fix this bug, but need some clarification on permissions. > >>>What designer permission level should grant access to the admrespondent > >>>and admdesigner pages? > >>>pgroup, puser or must the designer have both? The manage.php page allows > >>>access to menu items to the "superuser" or a designer with "puser" or > >>>"pgroup" permissions. > >>> > >>>http://sourceforge.net/tracker/index.php?func=detail&aid=754420&group_id=8956&atid=108956 > >> > >>I think my intent was that superuser could add designers and > >>respondents, and designers could add respondents. However, if there is > >>another preference I'll defer to someone who actually uses phpESP > >>regularly. :-) > > > > How about this: > > Designers with "puser" see the "Manage Respondent Accounts" menu and > > have access to the related pages, since "puser" permission corresponds > > to the "Administer Group Respondents" setting in the account setup. > > > > Designers cannot see nor access the "Manage Designer Accounts" > > menu/pages. > > > > SuperUser does everything. > > +1 > > > -- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel -- mcg -- The IT Lab (http://www.itlab.musc.edu) |
|
From: SourceForge.net <no...@so...> - 2004-02-11 23:10:20
|
Bugs item #895275, was opened at 2004-02-11 15:08 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=895275&group_id=8956 Category: User Group: v1.6.1 Status: Open Resolution: None Priority: 5 Submitted By: C. B. Mathess (bmathess) Assigned to: Nobody/Anonymous (nobody) Summary: Required setting Initial Comment: Some survey compoments (Section text for example) can be marked "required". During data collection, survey will then "hang" on a page that displays this compoment. A message is displayed stating that required data is missing. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=108956&aid=895275&group_id=8956 |
|
From: James E. F. <jf...@uv...> - 2004-02-11 22:49:13
|
dega wrote: > I'm trying to complete the italian localization for phpESP. > For special character should I use the character itself or the xml > entities?? > ( ex. ' instead of ' ) > > Thanks. > > Giancarlo You should use XML/HTML entities. The strings are sent directly to the client (browser) so use whatever the browser expects. -James |
|
From: dega <de...@li...> - 2004-02-11 14:12:03
|
I'm trying to complete the italian localization for phpESP. For special character should I use the character itself or the xml entities?? ( ex. ' instead of ' ) Thanks. Giancarlo |
|
From: Stefan C. <sch...@ea...> - 2004-02-11 13:59:55
|
I've followed the discussion about the DEFAULT NULL values. Here's the SQL schema I use in my (highly) modified version of PHPesp. Might give some help here and there. stF |
|
From: James E. F. <jf...@uv...> - 2004-02-10 22:41:12
|
Matthew Gregg wrote: > On Sun, 2004-02-08 at 22:19, James E. Flemer wrote: > >>Matthew Gregg wrote: >> >>>I'm want to fix this bug, but need some clarification on permissions. >>>What designer permission level should grant access to the admrespondent >>>and admdesigner pages? >>>pgroup, puser or must the designer have both? The manage.php page allows >>>access to menu items to the "superuser" or a designer with "puser" or >>>"pgroup" permissions. >>> >>>http://sourceforge.net/tracker/index.php?func=detail&aid=754420&group_id=8956&atid=108956 >> >>I think my intent was that superuser could add designers and >>respondents, and designers could add respondents. However, if there is >>another preference I'll defer to someone who actually uses phpESP >>regularly. :-) > > How about this: > Designers with "puser" see the "Manage Respondent Accounts" menu and > have access to the related pages, since "puser" permission corresponds > to the "Administer Group Respondents" setting in the account setup. > > Designers cannot see nor access the "Manage Designer Accounts" > menu/pages. > > SuperUser does everything. +1 |
|
From: Charlie S. <Sm...@ld...> - 2004-02-10 16:22:23
|
Oh yes. Now I've dug a little deaper to see you say: TIMESTAMP(14) DEFAULT NULL. That works just fine. In oracle, DEFAULT NULL is the default behavior. >>> "Matthew Gregg" wrote 2/9/2004 6:17:48 PM >>> Yup, you are correct, see my earlier message in this thread that talks about mysql 3/4 behavior and this very thing. On Mon, 2004-02-09 at 10:07, Charlie Smith wrote: > I believe chagning these fields to nullable would be better. That way the > default value may be null, as designed in the first place. Then perhaps, > minimum amount of code need be changed.\ > ...snip... -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: Charlie S. <Sm...@ld...> - 2004-02-10 16:17:02
|
I got the impression that you wanted to change fields of NOT NULL DEFAULT '', to: NOT NULL But what I'm suggesting is changing them to allow nulls. So, you'd just get rid of the NOT NULL DEFAULT '' line altogether and replace with nothing. Is that ok? >>> "Matthew Gregg" wrote 2/9/2004 6:17:48 PM >>> Yup, you are correct, see my earlier message in this thread that talks about mysql 3/4 behavior and this very thing. On Mon, 2004-02-09 at 10:07, Charlie Smith wrote: > I believe chagning these fields to nullable would be better. That way the > default value may be null, as designed in the first place. Then perhaps, > minimum amount of code need be changed.\ > ...snip... -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: Charlie S. <Sm...@ld...> - 2004-02-10 16:16:44
|
I got the impression that you wanted to change fields of NOT NULL DEFAULT '', to: NOT NULL But what I'm suggesting is changing them to allow nulls. So, you'd just get rid of the NOT NULL DEFAULT '' line altogether and replace with nothing. Is that ok? >>> "Matthew Gregg" <gr...@mu...> 2/9/2004 6:17:48 PM >>> Yup, you are correct, see my earlier message in this thread that talks about mysql 3/4 behavior and this very thing. On Mon, 2004-02-09 at 10:07, Charlie Smith wrote: > I believe chagning these fields to nullable would be better. That way the > default value may be null, as designed in the first place. Then perhaps, > minimum amount of code need be changed.\ > ...snip... -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: Aaron A. <lt...@fr...> - 2004-02-10 03:38:55
|
I have just confirmed that bug. Any user has rights to add a designer if they navigate directly to manage.php?where=admdesigner -----Original Message----- From: php...@li... [mailto:php...@li...] On Behalf Of James E. Flemer Sent: Sunday, February 08, 2004 9:20 PM To: phpESP-devel Subject: Re: [phpesp-dev] Bug 754420 Matthew Gregg wrote: > I'm want to fix this bug, but need some clarification on permissions. > What designer permission level should grant access to the > admrespondent and admdesigner pages? > pgroup, puser or must the designer have both? The manage.php page > allows access to menu items to the "superuser" or a designer with > "puser" or "pgroup" permissions. > > http://sourceforge.net/tracker/index.php?func=detail&aid=754420&group_ > id=8956&atid=108956 I think my intent was that superuser could add designers and respondents, and designers could add respondents. However, if there is another preference I'll defer to someone who actually uses phpESP regularly. :-) -James ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: Matthew G. <gr...@mu...> - 2004-02-10 01:17:58
|
Yup, you are correct, see my earlier message in this thread that talks about mysql 3/4 behavior and this very thing. On Mon, 2004-02-09 at 10:07, Charlie Smith wrote: > I believe chagning these fields to nullable would be better. That way the > default value may be null, as designed in the first place. Then perhaps, > minimum amount of code need be changed.\ > ...snip... -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Matthew G. <gr...@mu...> - 2004-02-10 01:14:47
|
On Sun, 2004-02-08 at 22:19, James E. Flemer wrote: > Matthew Gregg wrote: > > I'm want to fix this bug, but need some clarification on permissions. > > What designer permission level should grant access to the admrespondent > > and admdesigner pages? > > pgroup, puser or must the designer have both? The manage.php page allows > > access to menu items to the "superuser" or a designer with "puser" or > > "pgroup" permissions. > > > > http://sourceforge.net/tracker/index.php?func=detail&aid=754420&group_id=8956&atid=108956 > > I think my intent was that superuser could add designers and > respondents, and designers could add respondents. However, if there is > another preference I'll defer to someone who actually uses phpESP > regularly. :-) How about this: Designers with "puser" see the "Manage Respondent Accounts" menu and have access to the related pages, since "puser" permission corresponds to the "Administer Group Respondents" setting in the account setup. Designers cannot see nor access the "Manage Designer Accounts" menu/pages. SuperUser does everything. > > -James > > > ------------------------------------------------------- > The SF.Net email is sponsored by EclipseCon 2004 > Premiere Conference on Open Tools Development and Integration > See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. > http://www.eclipsecon.org/osdn > _______________________________________________ > phpESP-devel mailing list > php...@li... > https://lists.sourceforge.net/lists/listinfo/phpesp-devel -- mcg ------------------------------------- The IT Lab (http://www.itlab.musc.edu) |
|
From: Charlie S. <Sm...@ld...> - 2004-02-10 00:41:58
|
I believe chagning these fields to nullable would be better. That way the default value may be null, as designed in the first place. Then perhaps, minimum amount of code need be changed. >>> "Matthew Gregg" <gr...@mu...> 2/6/2004 2:49:14 PM >>> I've fielded several problems lately on #phpESP relating to the mysql_populate.sql script. It appears it is failing on mySQL vs 4 and above. The fix looks to be simply changing all: NOT NULL DEFAULT '', to: NOT NULL, See bug #: 890830 I want to commit these changes to CVS, any commments? Also, I've had a feature request tagged to me for a while to implement LDAP respondent accounts. I have this implemented in a way that works for us(MUSC), but it's done in a way that would allow for other authentication methods to easily be used. Instead of extending the account/authentication functionality inside ESP, I choose to implement the concept of a "valid URI" that a survey can be called from. Then from Apache you can use any authentication method it supports(which is huge) to limit access to the Survey. For example: - The directory .../phpESP/public/access-ldap/ exists - The valid URI for a survey is access-ldap - Apache is configure as: <Location /access-ldap/> AuthName "(LDAP ID and Password)" AuthType Basic AuthLDAP "some ldap config here" require valid-user </Location> - The survey is activated. - It is accessed by the normal "/public/survey.php?name=blah" url and access is denied. - It is accessed by the "secured" URL "/public/access-ldap/survey.php?name=blah", a "Basic Auth" login is prompted by Apache. If the user has a valid account, they can access the survey. Do you guys like this approach? Hope I managed to explain it well enough. If so, I'll clean it up and send out a patch that against CVS for testing. If not, I'll keep it as a local extension. I'll take no response as a "go a head and do it" (-: -- mcg -- The IT Lab (http://www.itlab.musc.edu) ------------------------------------------------------- The SF.Net email is sponsored by EclipseCon 2004 Premiere Conference on Open Tools Development and Integration See the breadth of Eclipse activity. February 3-5 in Anaheim, CA. http://www.eclipsecon.org/osdn _______________________________________________ phpESP-devel mailing list php...@li... https://lists.sourceforge.net/lists/listinfo/phpesp-devel |
|
From: James E. F. <jf...@uv...> - 2004-02-09 03:35:22
|
Matthew Gregg wrote: > On Sun, 2004-02-08 at 18:03, James E. Flemer wrote: --snip-- > >>Having thought about this a little more, I think phpESP needs a bit more >>of an AAA solution. Well, maybe we can ignore the third "A" >>(accounting) for now, and just focus on authentication (authN) and >>authorization (authZ). I think that we should try to use PEAR::Auth for >>authN possibly adding to that project to have an Apache pseudo-"storage >>container". Then we need a simple but flexible authZ system. Right now >>authN and authZ are all rolled up into one, which makes it difficult to >>leverage existing authN systems. With separate "modules" one could >>easily get authn with ldap/apache/etc, but use (a subset of) the >>existing phpesp database for authz, or write a new authz module. >> >>Or maybe we should make a PEAR::AuthZ module that is designed around >>PEAR::Auth. >> >>Comments? > > Erg.. you make stuff hard :-) > I'll read up on PEAR::Auth and think about this. Well, an interim solution could be just to implement an apache auth module for phpESP as I first mentioned. I imagine that doing so would probably only take a few lines of code for respondents, and maybe a bit more for designers (unless you provide uniform authZ for all designers). -James |
24 messages has been excluded from this view by a project administrator.
