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

Re: [phpesp-general] Upgrading

[Franky V. L. <lie...@te...>]

On Thu, 05 Feb 2009 05:01:58 +1100
Alison <pe...@al...> wrote:

> Hi,
> 
> looking at upgrading a live survey using version 1.8.2 to the latest
> version. Needless to say being live and in production one needs to be
> more than a little careful.
> 
> The Upgrade file just states the following:
> 
>   $ cd /usr/local/www/htdocs
>   $ mv phpESP phpESP.old
>   $ tar -zxf /path/to/phpESP-1.6.tar.gz
>   $ mv phpESP-1.6 phpESP
>   ... configure phpESP 1.6 ...
>   ... update database ...
>   ... test phpESP 1.6 ...
>   $ rm -rf phpESP.old
> 
> LInes 1 through 4 - no problems. But lines 5 and 6 aren't the most
> descriptive of "How". Is there a better set of notes somewhere?

well, configuring the new phpesp requires some getting used to, so read
the INSTALL doc as well, it explains in detail how to configure the new
system ("3. Configuring phpESP").
You might want to test a "fresh" install first, so as to understand the
config part (which is in fact very simple, but being different from
1.8.2 ...). An example config is provided
(admin/phpESP.ini.php.example), just rename it to admin/phpESP.ini.php,
and change what is needed (the defaults are found in
admin/phpESP.ini.php.default, but don't change that file).

The database upgrade is done automatically after you update the files
to the new version (and configured the new version). See the bottom
part ("UPDATING DATABASE") in the UPDATE doc.

Franky

[phpesp-general] Upgrading

[Alison <pe...@al...>]

Hi,

looking at upgrading a live survey using version 1.8.2 to the latest version. Needless to say being live and in production one needs to be more than a little careful.

The Upgrade file just states the following:

  $ cd /usr/local/www/htdocs
  $ mv phpESP phpESP.old
  $ tar -zxf /path/to/phpESP-1.6.tar.gz
  $ mv phpESP-1.6 phpESP
  ... configure phpESP 1.6 ...
  ... update database ...
  ... test phpESP 1.6 ...
  $ rm -rf phpESP.old

LInes 1 through 4 - no problems. But lines 5 and 6 aren't the most descriptive of "How". Is there a better set of notes somewhere?

Alison
PS. Couldn't find any facility to search the archived notes from this list. 

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Thanks for putting up with me Franky!
Sorry, I'm Cpanel only so I didn't really understand what you were  
talking about when you wrote "execute the sql statement" (though for a  
while there I was ready to execute my computer!!!)
Without the terminology for cpanel I'm pretty lost. Alls well that  
ends well.
Thank you again!
Eric

On Feb 3, 2009, at 5:23 PM, Franky Van Liedekerke wrote:

> eheh :-)
> That was also what I said (the admin vs root mail before), and since  
> you used phpmyadmin to enter the code manually, that might indeed be  
> the encoded version for "esp" :-) The sql query should've done the  
> same ...
> But again: where does this "admin" user come from?
>
> Franky
>
> On Tue, Feb 3, 2009 at 3:59 AM, Eric Hagley  
> <eh...@la...> wrote:
> It took a long time but finally I worked it out.
> You do have to revert to root but in the mysql database for password  
> you have to enter 7bb357162158ed46 which is code for esp.
> I was then able to get into my old files!
> Thank you to all!
> regards,
> Eric
>
> On Feb 1, 2009, at 11:26 PM, Franky Van Liedekerke wrote:
>
> On Sun, 1 Feb 2009 20:59:01 +0900
> Eric Hagley <eh...@la...> wrote:
>
> Sorry Franky, but also, in the email you sent there was no section
> "Auth". There is in the present table with a value "BASIC". Is auth
> needed?
> Again, thank you?
> Eric
>
> sorry, but this one I don't understand ... in the mysql tables,  
> there's
> no mentioning of auth/basic authentication types. That is only in the
> config file.
>
> Franky
>
>
>

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

eheh :-)
That was also what I said (the admin vs root mail before), and since you
used phpmyadmin to enter the code manually, that might indeed be the encoded
version for "esp" :-) The sql query should've done the same ...
But again: where does this "admin" user come from?

Franky

On Tue, Feb 3, 2009 at 3:59 AM, Eric Hagley <eh...@la...>wrote:

> It took a long time but finally I worked it out.
> You do have to revert to root but in the mysql database for password you
> have to enter 7bb357162158ed46 which is code for esp.
> I was then able to get into my old files!
> Thank you to all!
> regards,
> Eric
>
> On Feb 1, 2009, at 11:26 PM, Franky Van Liedekerke wrote:
>
>  On Sun, 1 Feb 2009 20:59:01 +0900
>> Eric Hagley <eh...@la...> wrote:
>>
>>  Sorry Franky, but also, in the email you sent there was no section
>>> "Auth". There is in the present table with a value "BASIC". Is auth
>>> needed?
>>> Again, thank you?
>>> Eric
>>>
>>
>> sorry, but this one I don't understand ... in the mysql tables, there's
>> no mentioning of auth/basic authentication types. That is only in the
>> config file.
>>
>> Franky
>>
>
>
>

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

It took a long time but finally I worked it out.
You do have to revert to root but in the mysql database for password  
you have to enter 7bb357162158ed46 which is code for esp.
I was then able to get into my old files!
Thank you to all!
regards,
Eric

On Feb 1, 2009, at 11:26 PM, Franky Van Liedekerke wrote:

> On Sun, 1 Feb 2009 20:59:01 +0900
> Eric Hagley <eh...@la...> wrote:
>
>> Sorry Franky, but also, in the email you sent there was no section
>> "Auth". There is in the present table with a value "BASIC". Is auth
>> needed?
>> Again, thank you?
>> Eric
>
> sorry, but this one I don't understand ... in the mysql tables,  
> there's
> no mentioning of auth/basic authentication types. That is only in the
> config file.
>
> Franky

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Dear Franky and all,

Thank you again!
Sorry, I did what you said Franky, however still no luck.
I'm wondering if I can set up a new instance and move the information  
from the old databases to the new instance so I can access the  
information?
regards,
eric

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Sun, 1 Feb 2009 21:01:50 +0900
Eric Hagley <eh...@la...> wrote:

> And (hopefully soon) finally, is the language meant to be UTF8-cgi
> or the latin1_swedish_ci ?
> Thank you again!
> Eric
>

everything is (or should be) utf-8. The database files themselves might
be latin1, but that is mysql stuff. The content is utf8.

Franky

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Sun, 1 Feb 2009 20:59:01 +0900
Eric Hagley <eh...@la...> wrote:

> Sorry Franky, but also, in the email you sent there was no section  
> "Auth". There is in the present table with a value "BASIC". Is auth  
> needed?
> Again, thank you?
> Eric

sorry, but this one I don't understand ... in the mysql tables, there's
no mentioning of auth/basic authentication types. That is only in the
config file.

Franky

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Sun, 1 Feb 2009 20:56:08 +0900
Eric Hagley <eh...@la...> wrote:

> Hello there Franky, many thanks for taking the time to share your  
> experience. It is greatly appreciated.
> 
> Sorry, just to be sure I understand, do you want me to:
> delete / drop the phpesp_designer section (whole thing) from the  
> database and remake it?
> Or do you want me to click on the structure button of the  
> phpesp_designer section, delete / drop just the admin user line and  
> add a new admin line, followed by the other info you mentioned,
> Or do you want me to just type over the old admin user name (didn't  
> work previously).
> in regard the esp password, can that be typed just as "esp" or is  
> there a string of characters for code?
> 
> Sorry to bother, but I don't want to make things any worse!

Hi Eric,

no, don't delete the whole phpesp_designer section. Just use phpmyadmin
(or whatever you have at your disposal), go to your database and into
the phpesp_designer table and remove the one line that mentions the
admin user. Then execute the sql statement: 

INSERT INTO phpesp_designer (username, password, fname, lname, realm,
pdesign, pstatus, pdata, pall, pgroup, puser, disabled) VALUES ('root',
PASSWORD('esp'), 'ESP', 'Superuser', 'superuser', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'N')

If you're unsure, give me the phpmyadmin access and I'll change it for
you.

Franky

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

And (hopefully soon) finally, is the language meant to be UTF8-cgi or  
the latin1_swedish_ci ?
Thank you again!
Eric

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Sorry Franky, but also, in the email you sent there was no section  
"Auth". There is in the present table with a value "BASIC". Is auth  
needed?
Again, thank you?
Eric

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Hello there Franky, many thanks for taking the time to share your  
experience. It is greatly appreciated.

Sorry, just to be sure I understand, do you want me to:
delete / drop the phpesp_designer section (whole thing) from the  
database and remake it?
Or do you want me to click on the structure button of the  
phpesp_designer section, delete / drop just the admin user line and  
add a new admin line, followed by the other info you mentioned,
Or do you want me to just type over the old admin user name (didn't  
work previously).
in regard the esp password, can that be typed just as "esp" or is  
there a string of characters for code?

Sorry to bother, but I don't want to make things any worse!

Thank you again,

Kind regards,

Eric

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

This should be fine, but the password maybe not.
To be sure, do this in phpmyadmin:

- delete the admin user from the designer table-
- execute the following statement in phpmyadmin (all on one line):

INSERT INTO designer (username, password, fname, lname, realm, pdesign,
pstatus, pdata, pall, pgroup, puser, disabled) VALUES ('root',
PASSWORD('esp'), 'ESP', 'Superuser', 'superuser', 'Y', 'Y', 'Y', 'Y',
'Y', 'Y', 'N')

After that, the user "root" exists with password "esp", as superuser.
Btw: it's a bit weird, but the default administrator user is "root",
not "admin". Did you change this?

Franky

On Sun, 1 Feb 2009 15:18:00 +0900
Eric Hagley <eh...@la...> wrote:

> An afterthought, I'm also wondering if these sections of the  
> phpesp_designer table are all correct or not.
> 
> username 	admin
> password 	*4ACFE3202A5FF5CF467898FC58AAB1D615029441
> auth 	BASIC
> realm 	superuser
> fname 	ESP
> lname 	Superuser
> email 	NULL
> 
> pdesign 	Y
> pstatus 	Y
> pdata 	Y
> pall 		Y
> pgroup 	Y
> puser 	Y
> disabled 	N
> changed 	0000-00-00 00:00:00
> expiration 	0000-00-00 00:00:00
> 
> Again, many thanks for your assistance.
> Kind regards,
> Eric
> 
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by:
> SourcForge Community
> SourceForge wants to tell your story.
> http://p.sf.net/sfu/sf-spreadtheword
> _______________________________________________
> phpESP-general mailing list
> php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpesp-general
> 

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Sorry to keep bugging you all but I'm also wondering if the collation  
in the tables should be latin1_swedish_ci (Swedish case insensitive)?
That is what it is at the moment.
Seems a little strange. Should it not be UTF-8?
Still searching for answers - perhaps grabbing at straws???
Thank you again.
Regards,
Eric

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

An afterthought, I'm also wondering if these sections of the  
phpesp_designer table are all correct or not.

username 	admin
password 	*4ACFE3202A5FF5CF467898FC58AAB1D615029441
auth 	BASIC
realm 	superuser
fname 	ESP
lname 	Superuser
email 	NULL

pdesign 	Y
pstatus 	Y
pdata 	Y
pall 		Y
pgroup 	Y
puser 	Y
disabled 	N
changed 	0000-00-00 00:00:00
expiration 	0000-00-00 00:00:00

Again, many thanks for your assistance.
Kind regards,
Eric

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Thank you again Alison,
Unfortunately though, still no luck. I put a variety of different  
names in the admin and the code you gave me in password. Clicked save.  
But each time I still get the same "incorrect username or password"  
error message. I've cleared cookies in the browser and restarted the  
browser a few times too to check that. Still no luck. If anyone has  
some ideas, I would be most grateful.
Kind regards,
Eric

Re: [phpesp-general] Unable to access the admin page.

[Alison <pe...@al...>]

Eric, 

the Username isn't encrypted, and as such should just be "admin". Only the password is encrypted. 

Alison



At 09:22 AM 1/02/2009, you wrote:
>Many thanks Alison for this. I did as you said. I pasted the "code"  
>you sent both into the username and password section. Unfortunately  
>there was no luck. I'm using a mac. Would this have something to do  
>with things? (different keystrokes perhaps?) Again, your assistance is  
>much appreciated.

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Many thanks Alison for this. I did as you said. I pasted the "code"  
you sent both into the username and password section. Unfortunately  
there was no luck. I'm using a mac. Would this have something to do  
with things? (different keystrokes perhaps?) Again, your assistance is  
much appreciated.

Re: [phpesp-general] Unable to access the admin page.

[Alison <pe...@al...>]

Hi Eric,

everything you are doing is correct, but simply entering a password into the designer table won't work as in all probability it's encrypted in some way. 

Try entering the following:-  *4ACFE3202A5FF5CF467898FC58AAB1D615029441

Cut and paste it. If successful it should give you a password of "admin".

Alison
PS. you need the asterisk at the beginning.



At 01:22 AM 1/02/2009, you wrote:
>Thank you again for your reply.
>I'm not sure if I'm doing things correctly, but this is what I did.
>I entered into my cpanel. Entered into the MySQL database, at the  
>bottom of that page is the PHP MyAdmin.
>I clicked there. I clicked the subdomain on the left that is holding  
>phpesp. The list of tables appears.
>I clicked the "browse" button beside the "phpesp_desiner" table.
>I clicked the "edit" button of that table.
>I entered in a new user name and password.
>I clicked "go" where the "save and return to previous screen" button is.
>I went to try and log into my site, but still could not.
>Am I not doing something correctly here?
>Not sure if you can help - but if so, I would be most grateful.
>Kind regards,
>Eric

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

Thank you again for your reply.
I'm not sure if I'm doing things correctly, but this is what I did.
I entered into my cpanel. Entered into the MySQL database, at the  
bottom of that page is the PHP MyAdmin.
I clicked there. I clicked the subdomain on the left that is holding  
phpesp. The list of tables appears.
I clicked the "browse" button beside the "phpesp_desiner" table.
I clicked the "edit" button of that table.
I entered in a new user name and password.
I clicked "go" where the "save and return to previous screen" button is.
I went to try and log into my site, but still could not.
Am I not doing something correctly here?
Not sure if you can help - but if so, I would be most grateful.
Kind regards,
Eric

Re: [phpesp-general] Unable to access the admin page.

[Jamison-Powell, S. <S.J...@sh...>]

Sorry, I didn't update either.  My set up was similar to Eric's.  I hadn't made any changes to the php script and the only change
seemed to have been the MySQL update.  I managed to get my information by accessing the MsSQL database and pulling the fields apart
one by one.  My hosting company were no help (stating that nothing had changed and it must be the code rather than their end) and I
have gone with Googledocs (with another provider) now.  Hardly ideal (as I really liked phpESP) but as I am only really a user,
rather than someone who actually knows what they are talking about, it seemed the best option.
 
Sue
 
 

________________________________

From: Eric Hagley [mailto:eh...@la...]
Sent: Fri 30/01/2009 09:24
To: php...@li...
Subject: Re: [phpesp-general] Unable to access the admin page.



My apologies for not supplying this information initially. Stupid of 
me. I greatly appreciate the time you are giving.

I downloaded the latest version of phpesp 10 days ago. (2.1.2)
My provider did not mention a change of php - the provider stated that 
the only thing they had done in the last week was upgrade MySQL.
I only have access to the last 300 error logs but none appear. (Those 
logs are for today only).
The server is running 5.2.5 PHP
It is running 5.0.51 MySQL (as mentioned, upgraded last night and 
problems occurred when I woke up this morning)
Again, many thanks for taking time to look at this. Any assistance is 
greatly appreciated.
Kind regards,
Eric

------------------------------------------------------------------------------
This SF.net email is sponsored by:
SourcForge Community
SourceForge wants to tell your story.
http://p.sf.net/sfu/sf-spreadtheword
_______________________________________________
phpESP-general mailing list
php...@li...
https://lists.sourceforge.net/lists/listinfo/phpesp-general

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Fri, Jan 30, 2009 at 10:24 AM, Eric Hagley <eh...@la...>wrote:

> My apologies for not supplying this information initially. Stupid of
> me. I greatly appreciate the time you are giving.
>

no prob :-)


> I downloaded the latest version of phpesp 10 days ago. (2.1.2)
> My provider did not mention a change of php - the provider stated that
> the only thing they had done in the last week was upgrade MySQL.
> I only have access to the last 300 error logs but none appear. (Those
> logs are for today only).
> The server is running 5.2.5 PHP
> It is running 5.0.51 MySQL (as mentioned, upgraded last night and
> problems occurred when I woke up this morning)
>

 And I forgot to mention this, it's the mysql upgrade that is the cause
(probably an upgrade from mysql 4 to 5 happened?).
To solve this, use phpmyadmin (or anything alike) to reset the password for
the root user (use the mysql PASSWORD function for this).
It is weird though, normally I take this into account ...

Have you tried login in into the admin section?

Franky

Re: [phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

My apologies for not supplying this information initially. Stupid of  
me. I greatly appreciate the time you are giving.

I downloaded the latest version of phpesp 10 days ago. (2.1.2)
My provider did not mention a change of php - the provider stated that  
the only thing they had done in the last week was upgrade MySQL.
I only have access to the last 300 error logs but none appear. (Those  
logs are for today only).
The server is running 5.2.5 PHP
It is running 5.0.51 MySQL (as mentioned, upgraded last night and  
problems occurred when I woke up this morning)
Again, many thanks for taking time to look at this. Any assistance is  
greatly appreciated.
Kind regards,
Eric

Re: [phpesp-general] Unable to access the admin page.

[Franky V. L. <lie...@te...>]

On Fri, Jan 30, 2009 at 6:01 AM, Eric Hagley <eh...@la...>wrote:

> I also have recently had exactly the same problem as Jamison-Powell,
> Susan
> I was using PHPesp on a site hosted by a hosting company. No problems.
> I wake up today and when I try to log in "[ Incorrect User ID or
> Password, or your account has been disabled/expired. ]" is displayed.
> I tried to change the password via phpMyAdmin / phpesp_designer but
> still cannot access.
> My hosting company said that last night all they did was update mysql
> to latest version. 5.0.67. Could this have done something? If so, how
> can i work around it to access the information?
> Please advise asap.
> I really need to access the data!
> I would greatly appreciate help.
> Kind regards,
> Eric
>

Most of these times I ask questions/give tips, and  never get to hear wether
the problem is resolved...
But anyway, here goes:

- what version of phpesp are you using?
- did your provider change PHP versions?
- any errors in the webserver logs?

Franky

[phpesp-general] Unable to access the admin page.

[Eric H. <eh...@la...>]

I also have recently had exactly the same problem as Jamison-Powell,  
Susan
I was using PHPesp on a site hosted by a hosting company. No problems.
I wake up today and when I try to log in "[ Incorrect User ID or  
Password, or your account has been disabled/expired. ]" is displayed.
I tried to change the password via phpMyAdmin / phpesp_designer but  
still cannot access.
My hosting company said that last night all they did was update mysql  
to latest version. 5.0.67. Could this have done something? If so, how  
can i work around it to access the information?
Please advise asap.
I really need to access the data!
I would greatly appreciate help.
Kind regards,
Eric