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

[phpesp-general] Bulk cloning of surveys

[Jack C. <jc...@uo...>]

I've been searching the archives to see if anyone has posted a solution
for rapidly making multiple copies of a survey (within the same group) but
haven't found a match..

Does anyone have an automagic script for cloning a survey?  It wouldn't be too
difficult to come up with one, but if anyone has a script out there they would
be willing to share I'd be most grateful..


--
Jack Cooper
Analyst, Academic Services
Computing and Communication Services
University of Guelph
phone: (519) 824-4120 x58672
fax:   (519) 763-6143
email: jc...@uo...

Re: [phpesp-general] setting up database

[Jim B. <jp...@si...>]

* jonathan higgins <jon...@ya...> [2005-09-04 00:40]:
> Greetings,
>  
> I'm a little new at this and can't seem to figure how to get the phpesp database set up. I use a webhosting service that supports all necessary stuff. I even set up the Moodle (open source course management) all by my self with no problems or help. So I'm not sure why this is so difficult.

OK, here are some notes.  

These notes should work for a fresh install on most Unix systems.
If you are on Windows, I can't help you- sorry! 

If some steps have already been done you might have to skip over some parts.

First, get the software:  Select a download from one of the mirrors at:
http://prdownloads.sourceforge.net/phpesp/phpESP-1.7.5.tar.gz

Change directory to the top level of your webserver data directory
(usually  /usr/local/www/data   or /usr/local/www/htdocs )

Untar the source there:

   tar xvzf /path_to_download/phpESP-1.7.5.tar.gz

This creates a directory called phpESP and drops everything you need under there.

I've used permissions of the www user and group like this:

   chown -R  www:www phpESP

Next, (re)read the INSTALL document in the phpESP/doc directory, or check the website
at www.phpesp.org.

Next, your hosting provider will need to provide MySQL.  There are scripts in the phpESP
distribution that create the actual database.  Depending on your situation, you may
have to have the hosting provider run the create and populate script.

  create script is at:    scripts/db/mysql_create.sql

  populate script is at:  scripts/db/mysql_populate.sql



Check with your hosting provider if you have trouble with these steps.  They create
the phpesp databaase and populate the database with the tables and data used
by phpESP.

>  
> Basically, I don't know how or where to run the scripts to set up and population the database.
>  
> Also, there is no 'perl' folder in my cig-bin. Can I just create one there.

You probably don't need that.


>  
> Could anyone please give me the super-stupid layman step by step to getting phpESP up and running? The program is already on the webhost server www.mysite.com/phpesp.


Hmmm... the above statement makes it sound like the install has already been done.  
Well, try to reach the management page at:
 http://www.mysite.com/phpesp/admin/manage.php

If you get an error, (re)read the INSTALL doc above.  You might have to start from scratch
with a fresh install.  It *does work* if all the steps are followed.

If you get a login page, try logging into the management interface with
username root and password esp.

Once you are in, change the password.  There's a menu item on the management interface page.


>  
> Furthermore, if your help will include me running those scripts, then do the extensions need to be changed? There are txt files. What new extensions do I give them. Where do I put them in the directory structure before i run them?

No extensions need to be changed.  See the INSTALL doc.



Hope this helps.  It's way too late to think very clearly.  
Jim B.

[phpesp-general] setting up database

[jonathan h. <jon...@ya...>]

Greetings,
 
I'm a little new at this and can't seem to figure how to get the phpesp database set up. I use a webhosting service that supports all necessary stuff. I even set up the Moodle (open source course management) all by my self with no problems or help. So I'm not sure why this is so difficult.
 
Basically, I don't know how or where to run the scripts to set up and population the database.
 
Also, there is no 'perl' folder in my cig-bin. Can I just create one there.
 
Could anyone please give me the super-stupid layman step by step to getting phpESP up and running? The program is already on the webhost server www.mysite.com/phpesp.
 
Furthermore, if your help will include me running those scripts, then do the extensions need to be changed? There are txt files. What new extensions do I give them. Where do I put them in the directory structure before i run them?
 
Help!!!!!!!!!!!!!
 
Jonathan
 


Jonathan Higgins
PhD Candidate at Capella University (Leadership in Higher Education)
MA General Secondary Education
Pinghe Bilingual School
Internation Baccalaureate Diploma Program
261 Huangyang Rd.
Shanghai, China 201206
Ph# 138 1887 2062

"The gift of God to this enlightened age is the knowledge of the oneness of mankind and of the fundamental oneness of religion. War shall cease between the nations, and by the will of God the Most Great Peace shall come; the world will be seen as a new world, and all men will live as brothers." - 'Abdu'l Baha

[phpesp-general] Table relationships

[Neil P. <ne...@uw...>]

Hello,
   I have 16 tables in my phpESP 1.7.2 database. I was examining table 
'Access' and noticed records where values of 'realm' are not in the 'realm' 
table and corresponding 'survey_id' values are not in the 'id' field of 
table 'survey'. Is there a document that describes how all the tables are 
related? Is there a process which would identify orphaned records such as I 
expect exist in the Access table? Is there a cleanup process?

.../neil patterson 

[phpesp-general] =?ISO-2022-JP?B?gXmNxJGXkE2BepDmkvaCzIyPgsmCwoKrgtyCtYLEMDE6MTQ6NTA=?=

[zbyayhve <zby...@xi...>]

DQqBi4GLgZqBi4FCgZqBQoGagYuBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGB
oYGhgaGBoYGhgaGBoYGhDQqBi4GahKyEqoSxhKqEsYSqhK2BoYN0g4qBW4OBgVuDi4NUgVuDcoNY
gsmRzomegrWCvYqukVOWs5e/g1SDQ4NngUkNCoGagYuEq4qukVOWs5e/gUmEq4GhkU+R45ailbeC
zIJPiX6CxZNzjYeCzIKigqKPl4Lwg1KDUoLFjKmCwoKvguuBSYFJDQqBi4GahK+EqoSzhKqEs4Sq
hK6BoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhgaGBoYGhDQqB
miAggcuBy4HLgUBodHRwOi8vd3d3Lm55YW4yLnR2Lw0KDQoNCoGZhJ+En4SfhJ+En4SfhJ+En4Sf
hJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfgeGPSILwjVSCpoLEgWOB4oSfgZkNCoFAgZ+B
Y4FjgZ+BQInEg1aBW4NZg5OCqo9Jgu2C6YFIgqKCooKmgUGCsYLqgqmC54FJgUWTwZXKjYaBQIGf
gWOBY4GfDQqBmYSfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+E
n4SfhJ+En4SfhJ+En4SfhJ+En4GZDQqBhIGEgYSBQIF5icSCzI9Jgu2C6IKxgruBQZP8guqL8oKi
j/OR1ILGkFOTvoLmgUmBeg0KDQqBQIFAgUCBQInEguCPSYLtguiBQYK7guuCu4Lrj0iCqoLigsGC
xJeIgtyCt4FCDQqBQIFAgUCBQIF1grGCzInEgUGKeYK1gqKCsYLGgqqJvYLJguCCyIKpgsGCvYLI
gp+BYCg7gsKERIFNKSCBdg0KgUCBQIFAgUCCu4LxgsiQuoKqlbeCsYKmgsSCq4K7gqSCxYK3gsuB
RYFFgUWBSA0KDQqBQIFAgUCBQILFguCBQYK/guWCwYLGkdKCwYLEgq2CvoKzgqKC5oFJgUgNCoFA
gUCBQIFAguCCv4LrgvGPl5CrgsyShoLJguCBdYp5grWCooKxgsaCqom9gsmC4ILIgqmCwYK9gsiC
n4FggXYNCoFAgUCBQIFAgsaSUYKigsSCooLpkGyCvYK/gqqR5ZCogqKC6YLNgriCxYK3guaBSA0K
DQqBQIFAgUCBQILGgqKCpI6Wgs2BRYFFgUWBSQ0KgUCBQIFAgUCDVoFbg1mDk5BegsGQt4LogsyJ
xILmguiC4IFBg1aBW4NZg5OCqo9Jgu2C6Y2hjLuN3YLMlfuCqg0KgUCBQIFAgUCDSYNng1KCyYtR
gqaCxIKigumPl5CrgvCV34LcgqaC4oK3gqKCzILFgs2BSIFIDQoNCoFAgUCBQIFAgruCtYLEgUGC
u4LxgsiPl5Crgr2Cv4LwjPiXpoLmgq2CZoJkgnOCt4LpgsmCzYFJDQoNCoFAgUCBQIFAgrGCv4Ln
gsyDVINDg2eCxYFBjqiK8YLogsiP7pXxgvCP0InugrWCxILcgreBSYFJDQoNCoHLgcuBy4FAaHR0
cDovL3d3dy5ueWFuMi50di8NCg0KDQqBmYSfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4Sf
hJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4GZDQqBhIGEgYSBQIF5lFKCppBzgquP
x4zzjFGCzI+XkKuCqpFfgqKW2oK+gUmBeg0KDQqBQIFAgUCBQJZej5eQq45Hjo+CzJOdjHaCyYLm
gumCxoFBicSCzJdckuiC8JFTgsSPwYm7grWCvTmMjo/jj3uCzQ0KgUCBQIFAgUCPl5CrgqqU5Ipy
k0mWs5ZolPWCyYLIgumCu4KkgsWCt4FCgWkqbipukrKC14FqDQoNCoFAgUCBQIFAib2MzILIgueB
QYF1gqCBYIFBicSCqo9Jgu2CwYK/guGCwYK9gsiBYIF2gsiBW4LxgsSBQQ0KgUCBQIFAgUCQU4LJ
g3yDYoNKg4qCxovzk7SCqoLFgquC4oK3gqKCqYLngsiC8YLFgreCy4FCDQoNCoFAgUCBQIFAl+GC
poLOicSCyYz8gq+CxINfg0ODR4Nig2eC8IK1gsSCooK9j5eQq4LNltqVV4LwjriCooFBDQqBQIFA
gUCBQIKzgueCyYFBgXmC0ILGicSCzJf2gXqC8Ip5grWC8YLFgqKCvY+XkKuCzQ0KgUCBQIFAgUCC
ooLcgrKC65f2gsyPSeCBgvCMfYKmgsSCooLpjaCCxYK1guWCpIFFgUWBRYFCDQoNCoFAgUCBQIFA
grGC8YLIg2CDg4OTg1iC8JOmgreO6ILNgsiCooLFgreC5oLLgVIogUyBzYFNKYJYIMvevCEhIA0K
gUCBQIFAgUCJxIKqj0mC7YLpjaGCsYK7gUGUUoKmj+OCqoLpj3WK1IFpgsaCq4FqgsiC8YLFgreB
SQ0KDQqBy4HLgcuBQGh0dHA6Ly93d3cubnlhbjIudHYvDQoNCg0KgZmEn4SfhJ+En4SfhJ+En4Sf
hJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+En4SfhJ+BmQ0KgZqB
moGagUCBeYLcgsaC34F6DQoNCoFAgUCBQIFAg1aBW4NZg5ODSYN0gsyMu43dgUGPl5CrgvCRX4Ki
guKCt4KtgsiCwYLEgumCzILNim2OwILFgreBQg0KgUCBQIFAgUCDiYNDg2+Di4LMkmqCvYK/guCC
0ILGgtyCuIlIgvCLeILfgsSCooLpgsWCtYLlgqSCqYLngUENCg0KgUCBQIFAgUCBd5P8guqL8oKi
gXgrgXeDiYNDg2+Di4+tgsiCooF4gYGB4YNugVuDjIOAgUmBSYHiDQoNCoFAgUCBQIFAgsaCooKk
i4aLyYLMlfuS9o6ugqqQrILol6eCv4LcgreBQg0KDQqBQIFAgUCBQINUg06DiYFFi8aO0oLwiOqQ
2JRyj5yCtYK9kE2XioLMj2+J74KijG6DVINDg2eCxYFBDQqBQIFAgUCBQInEgsySeILqgvCO5oLo
lt+CtYLEgt2C3IK5gvGCqYFIDQoNCoHLgcuBy4FAaHR0cDovL3d3dy5ueWFuMi50di8NCjE3NzMz
DQoNCg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSBodHRwOi8vZXRpZGUuNTEubmV0LyAtLS0tLS0t
LS0tLS0tLS0tLS0tLS0NCtLUyc/E2sjd08lWb2xsZXlNYWlsw+K30cjtvP63osvNo6y1q8TayN3T
61ZvbGxleU1haWzO3rnYo6zM2LTLyfnD96Oh

Re: [phpesp-general] evaluation of phpESP

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

Christopher Adams wrote:

> I am evaluating phpESP as a possible large scale application offered 
> as a service to a couple hundred organizations, with potentially many 
> thousands of survey responses. I have been creating surveys and 
> testing them and now I have a couple of general questions for those 
> that have been using it for awhile. Some are fairly obvious to me, but 
> I will ask anyway. Note: this is not criticism of the software, just 
> an analysis with a critical eye, information that needs to be reported 
> to a higher-up for evaluation.
>
> Authentication/access: I understand how the users/groups work and it 
> seems to work quite well. I am wondering if anyone is doing 
> authentication into the surveys by querying an existing mysql user 
> database. We can run our users through our proxy with their regular 
> authentication off a mysql database, but it would be nice if we could 
> integrate that with the survey creation, editing, testing, 
> administering  permissions.

If you are using Apache and the "REMOTE_USER" environment variable is 
set, phpESP will use assign that user to the survey response.  So all 
you really need to do is get a "basic auth" from Apache before the user 
can access the survey.  For survey creation, edit, admin, you'd need to 
extend the authentication methods in phpESP.  We currently do LDAP along 
with the internal DB.

>
> Capacity/scalability: This could potentially have several hundred 
> survey s being created during the same period of time and potentially 
> there could be tens of thousands of responses. I understand the power 
> and limitations of mysql and assume that this would be mostly 
> dependent on the server speed and capacity.
>
Only limitation you may run into here is PHP memory and timeout limits 
when you export survey data.

> Help/support/upgrading: How often is the software upgraded and is that 
> based on a response to user input? Do users post patches, add-ons, 
> etc.? Does the Developer list take input from users and is the General 
> list the one-stop-shop for help?
>
I am basically the only core developer, with Kon Angelopoulos submitting 
a few large patches.  I'll gladly accept any well written patch that 
implements something that is beneficial to the general phpESP 
community.  Input from the user/developer lists and RFE's from 
Sourceforge are considered.  Help can be obtained from mailing lists or 
from the IRC channel(when i'm available).

> Statistical output/analysis: Are there any problems with the 
> compilation of data? Are users creating add-ons that offer other ways 
> of analyzing the data.
>
A few user add-ons have been submitted to the mailing list.  You would 
need to search the list to find them.  You should be able to do any 
statistical analysis you need from the exported data.

>
> Thank you for any information that you may want to share.

[phpesp-general] evaluation of phpESP

[Christopher A. <chr...@st...>]

I am evaluating phpESP as a possible large scale application offered as 
a service to a couple hundred organizations, with potentially many 
thousands of survey responses. I have been creating surveys and testing 
them and now I have a couple of general questions for those that have 
been using it for awhile. Some are fairly obvious to me, but I will ask 
anyway. Note: this is not criticism of the software, just an analysis 
with a critical eye, information that needs to be reported to a 
higher-up for evaluation.

Authentication/access: I understand how the users/groups work and it 
seems to work quite well. I am wondering if anyone is doing 
authentication into the surveys by querying an existing mysql user 
database. We can run our users through our proxy with their regular 
authentication off a mysql database, but it would be nice if we could 
integrate that with the survey creation, editing, testing, administering 
  permissions.

Capacity/scalability: This could potentially have several hundred survey 
s being created during the same period of time and potentially there 
could be tens of thousands of responses. I understand the power and 
limitations of mysql and assume that this would be mostly dependent on 
the server speed and capacity.

Help/support/upgrading: How often is the software upgraded and is that 
based on a response to user input? Do users post patches, add-ons, etc.? 
Does the Developer list take input from users and is the General list 
the one-stop-shop for help?

Statistical output/analysis: Are there any problems with the compilation 
of data? Are users creating add-ons that offer other ways of analyzing 
the data.


Thank you for any information that you may want to share.
-- 


Christopher Adams
L

[phpesp-general] checkboxes min/max

[mad <mad...@gm...>]

The Help file lists: "Checkboxes min #=09max # (not implemented yet)". =20

Well, I have to create a survey where I need to set a max #.  I was
thinking I might be able to do this if I embed the survey into a php,
then add my own javascript at the top. Has anybody done this?

Any ideas/suggestions would be appreciated.

Thanks,
-Madison

[phpesp-general] Looking for phpesp survey developer ASAP

[Daryl C. <co...@ho...>]

<html><div style='background-color:'><DIV>
<DIV>
<P>To whom it may concern:</P>
<P>My name is Daryl Coston of CostonDesign.com.&nbsp; I'm currently looking for a developer to create&nbsp; weekly surveys consisting of 25 to 30 questions.&nbsp; I'm really looking for someone who is dedicated and can produce these surveys on a timely bases.&nbsp; Please all serious inquires only.&nbsp; Also please provide your hourly charge.&nbsp; Work needed ASAP</P>
<P>Thanks</P>
<P>Daryl Coston<BR><BR><BR></P>
<DIV>***********************************************
<DIV>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<FONT color=#ff0000>CostonDesign&nbsp;&nbsp; </FONT><FONT color=#000000>Internet Web Design and Web Hosting</FONT></DIV>
<DIV>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;and 360 Virtual Tours</DIV>
<DIV><FONT color=#ff0000><FONT color=#000000>*</FONT>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT><A href="http://www.costondesign.com/"><FONT color=#ff0000>http://www.costondesign.com</FONT></A></DIV>
<DIV>*&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</DIV>
<DIV>*</DIV>
<DIV>***********************************************</DIV></DIV></DIV></DIV></div></html>

[phpesp-general] Re: phpESP-general digest, Vol 1 #624 - 1 msg

[Mark R. <mar...@co...>]

I will be out of the office for an undetermined amount of time due to a family emergency.


For sales assistance, please contact Kristine Miller at 717.666.4072


For customer service, please contact Jaime Eide at 1-888-7CONCEPT or email cus...@co...


Thank you for understanding.


Mark Rebert
Managing Director
Concept Connections

[phpesp-general] Re: phpESP-general digest, Vol 1 #623 - 1 msg

[Mark R. <mar...@co...>]

I will be out of the office for an undetermined amount of time due to a family emergency.


For sales assistance, please contact Kristine Miller at 717.666.4072


For customer service, please contact Jaime Eide at 1-888-7CONCEPT or email cus...@co...


Thank you for understanding.


Mark Rebert
Managing Director
Concept Connections

[phpesp-general] Re: phpESP-general digest, Vol 1 #622 - 5 msgs

[Mark R. <mar...@co...>]

I will be out of the office for an undetermined amount of time due to a family emergency.


For sales assistance, please contact Kristine Miller at 717.666.4072


For customer service, please contact Jaime Eide at 1-888-7CONCEPT or email cus...@co...


Thank you for understanding.


Mark Rebert
Managing Director
Concept Connections

Re: [phpesp-general] password confusion

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

Any user you add as a Designer can access the management interface.  You
should ASAP change the root designer password.

On Fri, 2005-08-19 at 15:29 -0700, Christopher Adams wrote:
> Thanks. So, the 'root' user is always the user that logs into the 
> management interface and that shouldn't be changed. Correct?
> 
> 
> Christopher Adams
> Library Systems Analyst
> Oregon State Library
> 503-378-4243 258
> chr...@st...
> 
> 
> Matthew Gregg wrote:
> > You should be able to change the root password from the Designer page in
> > the management interface.
> > On Fri, 2005-08-19 at 15:13 -0700, Christopher Adams wrote:
> > 
> >>I am a little confused about passwords when configuring phpESP. I have 
> >>the application working and so far, there don't seem to be any problems. 
> >>So, you may ask why this guy is trying to fix something that isn't broken.
> >>
> >>Well, it stems from confusion about passwords. Just by  chance, though 
> >>maybe I had read it somewhere, I finally was able get to the management 
> >>screen by using username: root, password: esp. However, I would like to 
> >>change this, but can't quite see where to do it. The installation help 
> >>says to change the default password from 'phpesp' before executing the 
> >>'mysql_create.sql' script. I assume that means for the 'phpesp' user 
> >>that is created. I didn't change the default password in the script 
> >>before running it and so it says:
> >>
> >>INSERT INTO user (host, user, password) VALUES ( 'myserver',
> >>   'phpesp', PASSWORD('phpesp'));
> >>
> >>Then it says to use this same password when configuring phpESP. That 
> >>would be the section in phpESP.ini.php, which says:
> >>
> >>// Database connection information
> >>$ESPCONFIG['db_host'] = 'myserver.anywhere.com';
> >>$ESPCONFIG['db_user'] = 'otheruser';
> >>$ESPCONFIG['db_pass'] = 'otherpass';
> >>$ESPCONFIG['db_name'] = 'phpesp';
> >>
> >>However, I entered a username/password that is different from the phpesp 
> >>username/password, and one that allows me to access teh 'phpesp' 
> >>database. Everything works fine.
> >>
> >>
> >>So, the bottom line is, what should I be doing and how can I change the 
> >>admin username/password for management?
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> 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] password confusion

[Christopher A. <chr...@st...>]

Thanks. So, the 'root' user is always the user that logs into the 
management interface and that shouldn't be changed. Correct?


Christopher Adams
Library Systems Analyst
Oregon State Library
503-378-4243 258
chr...@st...


Matthew Gregg wrote:
> You should be able to change the root password from the Designer page in
> the management interface.
> On Fri, 2005-08-19 at 15:13 -0700, Christopher Adams wrote:
> 
>>I am a little confused about passwords when configuring phpESP. I have 
>>the application working and so far, there don't seem to be any problems. 
>>So, you may ask why this guy is trying to fix something that isn't broken.
>>
>>Well, it stems from confusion about passwords. Just by  chance, though 
>>maybe I had read it somewhere, I finally was able get to the management 
>>screen by using username: root, password: esp. However, I would like to 
>>change this, but can't quite see where to do it. The installation help 
>>says to change the default password from 'phpesp' before executing the 
>>'mysql_create.sql' script. I assume that means for the 'phpesp' user 
>>that is created. I didn't change the default password in the script 
>>before running it and so it says:
>>
>>INSERT INTO user (host, user, password) VALUES ( 'myserver',
>>   'phpesp', PASSWORD('phpesp'));
>>
>>Then it says to use this same password when configuring phpESP. That 
>>would be the section in phpESP.ini.php, which says:
>>
>>// Database connection information
>>$ESPCONFIG['db_host'] = 'myserver.anywhere.com';
>>$ESPCONFIG['db_user'] = 'otheruser';
>>$ESPCONFIG['db_pass'] = 'otherpass';
>>$ESPCONFIG['db_name'] = 'phpesp';
>>
>>However, I entered a username/password that is different from the phpesp 
>>username/password, and one that allows me to access teh 'phpesp' 
>>database. Everything works fine.
>>
>>
>>So, the bottom line is, what should I be doing and how can I change the 
>>admin username/password for management?

Re: [phpesp-general] password confusion

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

You should be able to change the root password from the Designer page in
the management interface.
On Fri, 2005-08-19 at 15:13 -0700, Christopher Adams wrote:
> I am a little confused about passwords when configuring phpESP. I have 
> the application working and so far, there don't seem to be any problems. 
> So, you may ask why this guy is trying to fix something that isn't broken.
> 
> Well, it stems from confusion about passwords. Just by  chance, though 
> maybe I had read it somewhere, I finally was able get to the management 
> screen by using username: root, password: esp. However, I would like to 
> change this, but can't quite see where to do it. The installation help 
> says to change the default password from 'phpesp' before executing the 
> 'mysql_create.sql' script. I assume that means for the 'phpesp' user 
> that is created. I didn't change the default password in the script 
> before running it and so it says:
> 
> INSERT INTO user (host, user, password) VALUES ( 'myserver',
>    'phpesp', PASSWORD('phpesp'));
> 
> Then it says to use this same password when configuring phpESP. That 
> would be the section in phpESP.ini.php, which says:
> 
> // Database connection information
> $ESPCONFIG['db_host'] = 'myserver.anywhere.com';
> $ESPCONFIG['db_user'] = 'otheruser';
> $ESPCONFIG['db_pass'] = 'otherpass';
> $ESPCONFIG['db_name'] = 'phpesp';
> 
> However, I entered a username/password that is different from the phpesp 
> username/password, and one that allows me to access teh 'phpesp' 
> database. Everything works fine.
> 
> 
> So, the bottom line is, what should I be doing and how can I change the 
> admin username/password for management?
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] password confusion

[Christopher A. <chr...@st...>]

I am a little confused about passwords when configuring phpESP. I have 
the application working and so far, there don't seem to be any problems. 
So, you may ask why this guy is trying to fix something that isn't broken.

Well, it stems from confusion about passwords. Just by  chance, though 
maybe I had read it somewhere, I finally was able get to the management 
screen by using username: root, password: esp. However, I would like to 
change this, but can't quite see where to do it. The installation help 
says to change the default password from 'phpesp' before executing the 
'mysql_create.sql' script. I assume that means for the 'phpesp' user 
that is created. I didn't change the default password in the script 
before running it and so it says:

INSERT INTO user (host, user, password) VALUES ( 'myserver',
   'phpesp', PASSWORD('phpesp'));

Then it says to use this same password when configuring phpESP. That 
would be the section in phpESP.ini.php, which says:

// Database connection information
$ESPCONFIG['db_host'] = 'myserver.anywhere.com';
$ESPCONFIG['db_user'] = 'otheruser';
$ESPCONFIG['db_pass'] = 'otherpass';
$ESPCONFIG['db_name'] = 'phpesp';

However, I entered a username/password that is different from the phpesp 
username/password, and one that allows me to access teh 'phpesp' 
database. Everything works fine.


So, the bottom line is, what should I be doing and how can I change the 
admin username/password for management?
-- 


Christopher Adams
Library Systems Analyst
Oregon State Library
503-378-4243 258
chr...@st...

[phpesp-general] Re: phpESP-general digest, Vol 1 #621 - 7 msgs

[Mark R. <mar...@co...>]

I will be out of the office for an undetermined amount of time due to a family emergency.


For sales assistance, please contact Kristine Miller at 717.666.4072


For customer service, please contact Jaime Eide at 1-888-7CONCEPT or email cus...@co...


Thank you for understanding.


Mark Rebert
Managing Director
Concept Connections

Re: [phpesp-general] running scripts on remote host

[Jim B. <jp...@si...>]

* Christopher Adams <chr...@st...> [2005-08-18 19:22]:
> I have installed phpESP. I am now trying to run the scripts, 
> mysql_create.sql and mysql_populate.sql.
> 
> I run MYSQL on one server and the scripts live on another server.
> 
> So, from the server running MYSQL, I issued the command:
> 
> mysql -u root -p -h host.with.scripts < /www/scripts/db/mysql_create.sql
> 
> 
> I get the following message:
> 
> bash: /www/scripts/db/mysql_create.sql: No such file or directory
> 
> 
> The path to the scripts is correct, the user is root and password is 
> correct. What do I have to do to run this script on the remote host?
> -- 


Hi Christopher,

Ideally, the scripts should be on the same host as the database.

Any command given on the command line that takes input via  the
input redirect operator '<' will have to have the input file
available locally.  You could copy them to the /tmp directory
on the database host and run the command:

mysql -u root -p -h host.with.scripts phpesp < /tmp/mysql_create.sql
or 
mysql -u root -p phpesp  < /tmp/mysql_create.sql


on the database host.

That should work.


Best Regards,
Jim B.

[phpesp-general] running scripts on remote host

[Christopher A. <chr...@st...>]

I have installed phpESP. I am now trying to run the scripts, 
mysql_create.sql and mysql_populate.sql.

I run MYSQL on one server and the scripts live on another server.

So, from the server running MYSQL, I issued the command:

mysql -u root -p -h host.with.scripts < /www/scripts/db/mysql_create.sql


I get the following message:

bash: /www/scripts/db/mysql_create.sql: No such file or directory


The path to the scripts is correct, the user is root and password is 
correct. What do I have to do to run this script on the remote host?
-- 


Christopher Adams

Re: [phpesp-general] Installing into directory other then phpesp

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

See the phpesp.ini.php file.  It should be relatively obvious what needs
to change.
On Wed, 2005-08-17 at 13:57 -0600, RICK HANZLIK wrote:
>  
> What needs to be changed If I want to install the software into a
> directory other then phpesp? and where is this parameter located?
>  
> Rick Hanzlik CSC, EE, CNE
> 
> Network Engineer
> 
> 801.401.8455 Voice
> 
> 801.401.9455 Fax
> 
> rj...@sp...
> 
>  
> 
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

[phpesp-general] Rank style questions

[mad <ma...@ma...>]

I need to create a survey that includes a rank style question. Basically there 
will be a list of options, and the user will have to put them in order of 
preference. The question would look something like this...

http://www.demochoice.org/dcballot.php?poll=toxin&bb=on

...or a slightly more fancy one...

http://www.demochoice.org/dcballot.php?poll=toxin

Is there any way to do this in phpESP?   If not, does anybody have any 
recommendations on another package that does do this.

I'm experienced in php and mysql.

Thanks,
-Madison

question = ( to ) ? be : ! be;
 		-- Wm. Shakespeare

[phpesp-general] Rank style questions

[mad <mad...@gm...>]

I need to create a survey that includes a rank style question. Basically=20
there
will be a list of options, and the user will have to put them in order of
preference. The question would look something like this...

http://www.demochoice.org/dcballot.php?poll=3Dtoxin&bb=3Don

...or a slightly more fancy one...

http://www.demochoice.org/dcballot.php?poll=3Dtoxin

Is there any way to do this in phpESP? If not, does anybody have any
recommendations on another package that does do this.

I'm experienced in php and mysql.

Thanks,
-Madison

question =3D ( to ) ? be : ! be;
-- Wm. Shakespeare

Re: [phpesp-general] Unable to download data from 1.7.2

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

You are using 1.7.5?
On Tue, 2005-08-16 at 11:50 -0600, RICK HANZLIK wrote:
>  
> I am having the exact problem as Mr. Li and Mr.. Eddy. I have
> installed the latest stable(?) version of PHPESP and everything works
> fine except that I can not download or save a copy of the CSV file to
> my machine or the server. I get the same error as Mr.. Li. Has anyone
> got this to work yet and if so what must we do?
> Rick Hanzlik CSC, EE, CNE
> 
> Network Engineer
> 
> 801.401.8455 Voice
> 
> 801.401.9455 Fax
> 
> rj...@sp...
> 
>  
> 
> 
-- 
mcg
-------------------------------------
The IT Lab (http://www.itlab.musc.edu)

Re: [phpesp-general] Unable to download data from 1.7.2

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

There was a javascript problem in 1.7.2 that should have been fixed in
1.7.5, what version is this relating to?
On Tue, 2005-08-16 at 14:00 -0400, Jim Brown wrote:
> * RICK HANZLIK <rj...@sp...> [2005-08-16 13:53]:
> >  
> > I am having the exact problem as Mr. Li and Mr.. Eddy. I have installed
> > the latest stable(?) version of PHPESP and everything works fine except
> > that I can not download or save a copy of the CSV file to my machine or
> > the server. I get the same error as Mr.. Li. Has anyone got this to work
> > yet and if so what must we do?
> > 
> > Rick Hanzlik CSC, EE, CNE
> > 
> > Network Engineer
> > 
> > 801.401.8455 Voice
> > 
> > 801.401.9455 Fax
> > 
> > rj...@sp...
> 
> 
> I have the same problem.  This is what I did, but it's not a phpESP solution.
> 
> I produced a survey report and saved it on my localhost.
> 
> I then read the report into OpenOffice Calc  using the 'Insert -> Link to External Data'
> feature.  I selected the report HTML file and it pulled right in.
> 
> From there it was cut and paste until I got what i wanted.
> 
> I saved to MS Excell 2003 and also to Excel 2000.
> 
> YMMV.
> 
> Best Regards,
> Jim B.
> 
> 
> 
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
> _______________________________________________
> 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] Unable to download data from 1.7.2

[Jim B. <jp...@si...>]

* RICK HANZLIK <rj...@sp...> [2005-08-16 13:53]:
>  
> I am having the exact problem as Mr. Li and Mr.. Eddy. I have installed
> the latest stable(?) version of PHPESP and everything works fine except
> that I can not download or save a copy of the CSV file to my machine or
> the server. I get the same error as Mr.. Li. Has anyone got this to work
> yet and if so what must we do?
> 
> Rick Hanzlik CSC, EE, CNE
> 
> Network Engineer
> 
> 801.401.8455 Voice
> 
> 801.401.9455 Fax
> 
> rj...@sp...


I have the same problem.  This is what I did, but it's not a phpESP solution.

I produced a survey report and saved it on my localhost.

I then read the report into OpenOffice Calc  using the 'Insert -> Link to External Data'
feature.  I selected the report HTML file and it pulled right in.

From there it was cut and paste until I got what i wanted.

I saved to MS Excell 2003 and also to Excel 2000.

YMMV.

Best Regards,
Jim B.