phpesp-general — General discussion, questions, and annoucements about phpESP

[phpesp-general] Authentication working for me in IIS

[Hannan, S. R. \(HSC\) <Sco...@ou...>]

It took a lot of poking around, and a couple of very minor tweaks to the
phpESP code, but I have authentication working great in phpESP under
Windows 2003 using IIS 6 with PHP 5 (running with compatibility for 4)
and MySQL 4.1

=20

In manage.php under the admin directory, I have this:

=20

      if($ESPCONFIG['auth_design']) {

            if(!manage_auth(

                        _addslashes(@$_SERVER['PHP_AUTH_USER']),

                        _addslashes(@$_SERVER['PHP_AUTH_PW'])))

=20

=20

I have only anonymous authentication turned on... every other auth
method is off (Basic, NT, etc)

=20

I believe I also added 'addslashes' in a lib include somewhere that
passes the username and password into the database, but that is only
because I had a password that had a slash in it and it wasn't working.

Scott R. Hannan

=20

Re: [phpesp-general] I have a php error "Failed to initilize storage module"

[Matthew G. <gr...@mu...>]

Google reveals this might be the problem:
http://bugs.php.net/bug.php?id=25876

On Sun, 2005-01-16 at 02:51 +0000, chh...@UC... wrote:
> safari browser on an apple ibook OS X 10.3.7 sees the following error:
> 
> Fatal error: session_start(): Failed to initialize storage module. in
> /var/www/html/phpESP/admin/
> manage.php on line 11
> 
> for 
> 
> http://visarts-undergrad.ucsd.edu/phpESP/admin/manage.php
> 
> background:
> 
> this is a fairly stock install of Redhat AS 3 
> httpd-2.0.46-44.ent
> libghttp-1.0.9-8.1
> redhat-config-httpd-1.1.0-4
> 
> php-ldap-4.3.2-19.ent
> php-mysql-4.3.2-19.ent
> php-odbc-4.3.2-19.ent
> php-4.3.2-19.ent
> php-imap-4.3.2-19.ent
> 
> mysql-3.23.58-2.3
> mysql-server-3.23.58-2.3
> mod_auth_mysql-20030510-1.ent
> mysql-devel-3.23.58-2.3
> mysql-bench-3.23.58-2.3
> php-mysql-4.3.2-19.ent
> libdbi-dbd-mysql-0.6.5-5
> 
> php is both recognized by apache and according to the php test page has the correct mysql
> modules 
> load:
> 
> http://visarts-undergrad.ucsd.edu/test.php
> 
> I have mysql installed and running from the command line.  databasename, username,
> password work 
> from the command line:
> I have put mysql databasename, username, and password in to mysql_create, mysql_populate, 
> php.ini.php
> ran the scripts with sudo just fine no errors
> 
> This is with the 1.7rc1 as well as 1.6.1.  only visual differnt is that 1.7 has the error
> on line 11 and 1.6 
> has it on line 9
> 
> 
> any suggestion what I might be missing?  any info that might be helpful?
> 
> thanks
> Chris
> 
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] I have a php error "Failed to initilize storage module"

[<chh...@UC...>]

safari browser on an apple ibook OS X 10.3.7 sees the following error:

Fatal error: session_start(): Failed to initialize storage module. in
/var/www/html/phpESP/admin/
manage.php on line 11

for 

http://visarts-undergrad.ucsd.edu/phpESP/admin/manage.php

background:

this is a fairly stock install of Redhat AS 3 
httpd-2.0.46-44.ent
libghttp-1.0.9-8.1
redhat-config-httpd-1.1.0-4

php-ldap-4.3.2-19.ent
php-mysql-4.3.2-19.ent
php-odbc-4.3.2-19.ent
php-4.3.2-19.ent
php-imap-4.3.2-19.ent

mysql-3.23.58-2.3
mysql-server-3.23.58-2.3
mod_auth_mysql-20030510-1.ent
mysql-devel-3.23.58-2.3
mysql-bench-3.23.58-2.3
php-mysql-4.3.2-19.ent
libdbi-dbd-mysql-0.6.5-5

php is both recognized by apache and according to the php test page has the correct mysql
modules 
load:

http://visarts-undergrad.ucsd.edu/test.php

I have mysql installed and running from the command line.  databasename, username,
password work 
from the command line:
I have put mysql databasename, username, and password in to mysql_create, mysql_populate, 
php.ini.php
ran the scripts with sudo just fine no errors

This is with the 1.7rc1 as well as 1.6.1.  only visual differnt is that 1.7 has the error
on line 11 and 1.6 
has it on line 9


any suggestion what I might be missing?  any info that might be helpful?

thanks
Chris

Re: [phpesp-general] problem with espi18n.inc

[Piersante S. <se...@un...>]

I am still tying to setup phpesp 1.6.1 in OS/2 (yes, it is working, but 
still having problems with gettext). Being quite a PHP dumb, I have 
troubles understanding the following few lines of code in espi18n.inc
=============================
  foreach ($_langs as $_lang) {

[snip]

    if (isset($_locales[$_lang])) {
                 $lang = $_lang;
[etc]
=============================
This is in the esp_setlocale_ex() funtion, and it is where the language 
would be set according to the browser preferences.
$_langs is a string array of languages accepted by the browser, in the form:
$_langs[1]= en_US
$_langs[2]= en
$_langs[3]= it
etc
so $_lang is a string assuming each of those values in turn.


$_locales is also an array of strings, containing all the languages 
supported by phpesp(contained in the \locale directory). So it has the form:

$_locales[1]= da_DK
$_locales[2]= de_DE
$_locales[3]= en_US
etc...


So, what  $_locales[$_lamg] would mean?
Wouldn't the array $_locales expect an integer as the index, rather than 
a string like $_lang?

Accordingly, im my experiments the expression (isset($_locales[$_lang])) 
never get true, even if the requested language (contained in $_lang) is 
actually supported and present in $_locales. Thus,  $lang remains empty, 
and the language is always set to the default set in phpesp.ini.php.

What am I missing?
What is that code actually doing?

thanks,

Piersante

Re: [phpesp-general] where are the installation directions?

[Matthew G. <gr...@mu...>]

docs directory has some useful information.
On Thu, 2005-01-13 at 11:20 -0700, Robyn Marschke wrote:
> Can somebody point me to the directions to install phpesp after
> downloading?
> 
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] where are the installation directions?

[Robyn M. <rma...@uc...>]

Can somebody point me to the directions to install phpesp after
downloading?

Re: [phpesp-general] two questions

[Matthew G. <gr...@mu...>]

On Tue, 2005-01-11 at 15:32 -0500, Christopher Zorn wrote:
> Hello, I have two questions. 
> 
> First, is it possible to add pictures to questions? I would like to add
> a visual aid to a multiple choice question. 
> 
Anywhere you can add text you can add <img src=> tags to include images.

> Second, when I try to do a Cross Analysis I get the following mysql error:
> 
> Error opening survey. [ ID:79 ] [ You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY A.response_id' at line 7]
> 
I'll look into this.

> Any help will be appreciated! 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

Re: [phpesp-general] Re: problem with gettext()

[Piersante S. <se...@un...>]

James E. Flemer wrote:
> Under the "PHP Extensions" part of the test page, is "GNU Gettext" a Yes 
> or No?  If it is a No, then the gettext module for PHP is not loaded 
> (even if you asked it to be).  You will not be able to use gettext 
> features until you can get the module to load.  I have no clue about PHP 
> on OS/2.

In fact it looks like a bug in the PHP port: I just discovered that 
running phpinfo() returns gettext "enabled" when loaded using CGI and 
"not enabled" when run through the Apache module. This is using the same 
php.ini, of course :-(

> By the way, the list address is php...@li..., 
> not phpesp-general-admin.

ops! my apologies.

thanks

Piersante

[phpesp-general] two questions

[Christopher Z. <zo...@mu...>]

Hello, I have two questions. 

First, is it possible to add pictures to questions? I would like to add
a visual aid to a multiple choice question. 

Second, when I try to do a Cross Analysis I get the following mysql error:

Error opening survey. [ ID:79 ] [ You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY A.response_id' at line 7]

Any help will be appreciated! 

[phpesp-general] Re: problem with gettext()

[James E. F. <jf...@uv...>]

Under the "PHP Extensions" part of the test page, is "GNU Gettext" a Yes 
or No?  If it is a No, then the gettext module for PHP is not loaded 
(even if you asked it to be).  You will not be able to use gettext 
features until you can get the module to load.  I have no clue about PHP 
on OS/2.

If you don't need language translation you can run just fine with 
emulated gettext.

By the way, the list address is php...@li..., 
not phpesp-general-admin.

-James

Piersante Sestini wrote:
> I am running apache2 and php 4.3.10 with gettext, mysql and gd 
> extensions enabled.
> 
> The test.php script confirms that I do have gd and mysql, but gettext 
> fails and is reported as "emulated".
> 
> What does that means exactly? Is that a bug in my PHP (I use OS/2, not 
> very popular nowadays) or there is something that I can do to fix it? I 
> know that GNU gettext binaries are available for os/2: should I install 
> it somehow?
> 
> thanks,
> Piersante

[phpesp-general] Correlation of data

[Kent V. <kvi...@up...>]

Hi Folks,

I'm trying to cross tabulate two items in my survey but for some reason, 
the second question does not have any of the check boxes I need to 
select it for cross tablulation. The first question is a "radio button" 
question, the second is a "rate (1.5)" type question. I want to know, 
how the selections of the first question impacted the selection of the 
other question (for example, the first question was staff, student, 
faculty - the other question had several choices, like newspaper, 
bookmarks, presentations - I want to know how many people who chose 
staff also chose newspaper and that sort of thing!)

I'm getting really frustrated trying to find this answer

Best Regards
Kent

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Kent Villard                       KVI...@UP...
IT Resource Developer              University of PEI
Charlottetown, Prince Edward Island, Canada C1A 4P3
=-=  Voice: (902) 566-0941 Fax: (902) 566-0917  =-=
"You can have it cheap, quick or working; choose two"

[phpesp-general] Re [13]:

[Milagros M. <sw...@ya...>]

<html><head><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head><body bgcolor="#FFFFF8" text="#75FD0D"><p><a href="http://gyu.nhgaembl.info/?ewMMMjfIOil1_2Knklfojl"><IMG SRC="cid:part1.02000507.05080905@zqu...@ya..." border="0" ALT=""></a></p><p><font color="#FFFFFC">Nascar in court?  Witchcraft I'm terribly sorry,</font></p><p><font color="#FFFFF2">Samsung AOL</font></p></body></html>

[phpesp-general] combining questions

[Sunil J. <pav...@co...>]

Matt:  Thx for the response.  I thought so myself.  But this would be a 
good functionality to have, just for collection of name and address.  
This way the program can be used to create even a small customer 
response survey, for example, or a customer enquiry form.
-sunil

Begin forwarded message:

> You can't combine questions on the survey itself, but you should be 
> able
> to combine them after you export to CSV.
>
> On Thu, 2004-12-23 at 05:52 -0500, Sunil Joshi wrote:
>> How can I group a set of questions, under one question?  eg.  if I
>> wanted the person to fill out their name and address, it makes no 
>> sense
>> to have them fill out a separate question for first name, last name,
>> address 1, etc.
>>
>> is this possible?
>> www.jayateas.com
>> PREMIUM TEAS FROM THE HIGHLANDS
>>
www.jayateas.com
PREMIUM TEAS FROM THE HIGHLANDS

Re: [phpesp-general] grouping questions

[Matthew G. <gr...@mu...>]

You can't combine questions on the survey itself, but you should be able
to combine them after you export to CSV.

On Thu, 2004-12-23 at 05:52 -0500, Sunil Joshi wrote:
> How can I group a set of questions, under one question?  eg.  if I 
> wanted the person to fill out their name and address, it makes no sense 
> to have them fill out a separate question for first name, last name, 
> address 1, etc.
> 
> is this possible?
> www.jayateas.com
> PREMIUM TEAS FROM THE HIGHLANDS
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] grouping questions

[Sunil J. <pav...@co...>]

How can I group a set of questions, under one question?  eg.  if I 
wanted the person to fill out their name and address, it makes no sense 
to have them fill out a separate question for first name, last name, 
address 1, etc.

is this possible?
www.jayateas.com
PREMIUM TEAS FROM THE HIGHLANDS

Re: [phpesp-general] Limiting responses by IP

[Matthew G. <gr...@mu...>]

It's not possible to do this currently.  However the CSV export of
results will contain the IP address of the survey response.  You could
use that to "limit" the responses.

On Fri, 2004-12-10 at 22:02 -0700, Erek Dyskant wrote:
> Hi All,
> 	I would like to create a public survey (no http auth required)
> but only allow one response per IP address.
> 	How would I go about doing this?
> 
> Regards,
> Erek
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 

[phpesp-general] Limiting responses by IP

[Erek D. <er...@nb...>]

Hi All,
	I would like to create a public survey (no http auth required)
but only allow one response per IP address.
	How would I go about doing this?

Regards,
Erek

RE: [phpesp-general] Cross Tabulation problems

[Roman Y. <Ro...@ss...>]

Kent,

What type of questions you are cross analyzing. Not all types are fitted =
for cross analysis.
I can't remember the exact ones and don't access to phpESP right this =
second.

Roman


-----Original Message-----
From: php...@li... on behalf of Kent =
Villard
Sent: Wed 12/8/2004 21:07
To: php...@li...
Subject: [phpesp-general] Cross Tabulation problems
=20
Hi Folks,

When I try to cross tabulate my survey results I get this error:

Error opening survey. [ ID:2 ] [ You have an error in your SQL syntax=20
near ') ORDER BY A.response_id' at line 7]

Odd...
Any suggestions

phpESP 1.6.1
Kent

--=20
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D=
-=3D-=3D-=3D-=3D-=3D-=3D-=3D
Kent Villard                       KVI...@UP...
IT Resource Developer              University of PEI
Charlottetown, Prince Edward Island, Canada C1A 4P3
=3D-=3D  Voice: (902) 566-0941 Fax: (902) 566-0917  =3D-=3D
"You can have it cheap, quick or working; choose two"

[phpesp-general] Cross Tabulation problems

[Kent V. <kvi...@up...>]

Hi Folks,

When I try to cross tabulate my survey results I get this error:

Error opening survey. [ ID:2 ] [ You have an error in your SQL syntax 
near ') ORDER BY A.response_id' at line 7]

Odd...
Any suggestions

phpESP 1.6.1
Kent

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Kent Villard                       KVI...@UP...
IT Resource Developer              University of PEI
Charlottetown, Prince Edward Island, Canada C1A 4P3
=-=  Voice: (902) 566-0941 Fax: (902) 566-0917  =-=
"You can have it cheap, quick or working; choose two"

[phpesp-general] Mysql 4.1

[Aaron A. <li...@fr...>]

Are there any known issues with phpESP and mysql 4.1?

-- 
Aaron Axelsen
li...@fr...

Great hosting, low prices.  Modevia Web Services LLC -- http://www.modevia.com

Re: [phpesp-general] HOW TO insert the (real-time) results of a survey into a web page

[James E. F. <jf...@uv...>]

Which is a somewhat obfuscated way of saying that you might need to 
change the extension on the page from ".html" to ".php".
-James

Matthew Gregg wrote:
> The page you're adding the "<?php $sid=SID; $results=1;
> include('/home/mpmitri/public_html/poll1/public/handler.php'); ?>"
> must be a PHP page that your web server will execute.  So for example if
> your current home page is index.html and your web server servers .html
> pages as static html then the PHP include will fail.
> 
> On Wed, 2004-12-01 at 18:44 -0800, Michael Mitri wrote:
> 
>>I can not insert the survey into an existing pag.  I have placed the
>>PHP tag in the HTML page but it dose not work...all i get is the
>>script.  I have been trying to do this for three days 8 houres each
>>day.   I have no clue what i am doing.   All I want to do is have the
>>phpESP placed on my homepage.  This is the second software that I have
>>tryed...my main problem is that i have no clue hoe to work
>>with .php....ggggrrrrr im going crazy
>>
>>The HELP page makes it sound so easy "If you would like to insert the
>>(real-time) results of a survey into a web page, use the following PHP
>>code.<?php $sid=SID; $results=1;
>>include('/home/mpmitri/public_html/poll1//public/handler.php'); ?> "  
>>
>>I tryed that but it dose not work.
>>
>>Yes I am a newbie. Mike
>>
>>
> 
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general

Re: [phpesp-general] HOW TO insert the (real-time) results of a survey into a web page

[Matthew G. <gr...@mu...>]

The page you're adding the "<?php $sid=SID; $results=1;
include('/home/mpmitri/public_html/poll1/public/handler.php'); ?>"
must be a PHP page that your web server will execute.  So for example if
your current home page is index.html and your web server servers .html
pages as static html then the PHP include will fail.

On Wed, 2004-12-01 at 18:44 -0800, Michael Mitri wrote:
> I can not insert the survey into an existing pag.  I have placed the
> PHP tag in the HTML page but it dose not work...all i get is the
> script.  I have been trying to do this for three days 8 houres each
> day.   I have no clue what i am doing.   All I want to do is have the
> phpESP placed on my homepage.  This is the second software that I have
> tryed...my main problem is that i have no clue hoe to work
> with .php....ggggrrrrr im going crazy
> 
> The HELP page makes it sound so easy "If you would like to insert the
> (real-time) results of a survey into a web page, use the following PHP
> code.<?php $sid=SID; $results=1;
> include('/home/mpmitri/public_html/poll1//public/handler.php'); ?> "  
> 
> I tryed that but it dose not work.
> 
> Yes I am a newbie. Mike
> 
> 

[phpesp-general] HOW TO insert the (real-time) results of a survey into a web page

[Michael M. <mp...@ya...>]

I can not insert the survey into an existing pag.  I have placed the PHP tag in the HTML page but it dose not work...all i get is the script.  I have been trying to do this for three days 8 houres each day.   I have no clue what i am doing.   All I want to do is have the phpESP placed on my homepage.  This is the second software that I have tryed...my main problem is that i have no clue hoe to work with .php....ggggrrrrr im going crazy

The HELP page makes it sound so easy "If you would like to insert the (real-time) results of a survey into a web page, use the following PHP code.<?php $sid=SID; $results=1; include('/home/mpmitri/public_html/poll1//public/handler.php'); ?> "  

I tryed that but it dose not work.

Yes I am a newbie. Mike

Re: [phpesp-general] cant login after installation

[Matthew G. <gr...@mu...>]

You most likely have php running as CGI instead of an Apache module.
phpESP can't authenticate properly with php running as CGI.  Search the
list archives for more info and a work around.
On Wed, 2004-11-24 at 10:59 -0500, Pons, Lisa (ponslm) wrote:
> I cant login after installation.
> 
> I've read through some posting and am having the same trouble as others.I
> get the 401 Unauthorized page...
> 
> I am entering root/esp... all lower case.
> 
> If I edit the config file, and turn off authorizations, no problem. But of
> course, I cant use it that way. 
> 
> How can I get in and manage users? Can I create a new superuser right in
> mysql?
> 
> Lisa Pons-Haitz
> 
> Webmaster
> University Libraries
> University of Cincinnati
> lis...@uc...
> (513)556-1431
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now. 
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] never mind: fixed

[Pons, L. (ponslm) <PO...@UC...>]

Not sure what happened, but I deleted the mysql database, then recreated it,
ran all the sql files (including the update one, which I didnt do before),
and then reinstalled phpesp and changed config file, and all is well.

Thanks!

Lisa Pons-Haitz

Webmaster
University Libraries
University of Cincinnati
lis...@uc...
(513)556-1431