[phpesp-general] Re: Changing the expiration dates on designer tables

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

You need to get into phpesp database using mysql or phpmyadmin if installed
and run 1 of the following queries

if you are adding a name you can run the following query:

INSERT INTO designer (username, password, fname, lname, realm, pdesign,
pstatus, pdata, pall, pgroup, puser, disabled, expiration)
 VALUES ('NameHere', PASSWORD('esp'), 'ESP', 'Superuser', 'superuser', 'Y',
'Y', 'Y', 'Y', 'Y', 'Y', 'N', timestamp('2008-01-01 00:00:00'));

to change the expiration on an existing record run the following query:

update designer set expiration =3D timestamp('2020-01-01 00:00:00') where
username =3D 'NameHere';

make sure to commit the changes

commit;

command to see all the records and values in the designer table:

select * from designer;


On 2/2/06, Gael Jobard <jo...@cy...> wrote:

> I have a similar problem it seems, could you please tell me how to change
> the expiration date ?
> Thanks !
>
>
> harry amarantidis a =E9crit :
>
> Thanks Tim,
>
> That's exactly what was going on. I changed the expiration date and now
> I'm up and running.
>
> Harry
>
>
> On 2/1/06, Tim Keely <tim...@st...> wrote:
> >
> > Hi Harry,
> >
> > The code base is not tested against SQL 5 yet.
> >
> > I found that I had to reset the expiration date on the esp root user
> > manually to expire in 1 year later.  The default is "00:00:00:"  or som=
e
> > such
> >
> > Good luck.
> >
> > TK
> >
> > >Send phpESP-general mailing list submissions to
> > >       php...@li...
> > >
> > >To subscribe or unsubscribe via the World Wide Web, visit
> > >       https://lists.sourceforge.net/lists/listinfo/phpesp-general
> > >or, via email, send a message with subject or body 'help' to
> > >       php...@li...
> > >
> > >You can reach the person managing the list at
> > >       php...@li...
> > >
> > >When replying, please edit your Subject line so it is more specific
> > >than "Re: Contents of phpESP-general digest..."
> > >
> > >
> > >Today's Topics:
> > >
> > >   1. login failure (harry amarantidis)
> > >
> > >--__--__--
> > >
> > >Message: 1
> > >Date: Tue, 31 Jan 2006 17:09:56 -0500
> > >From: harry amarantidis < har...@gm...>
> > >To: php...@li...
> > >Subject: [phpesp-general] login failure
> > >
> > >------=3D_Part_4646_16717938.1138745396511
> > >Content-Type: text/plain; charset=3DISO-8859-1
> > >Content-Transfer-Encoding: quoted-printable
> > >Content-Disposition: inline
> > >
> > >I am also getting a login failure. I put the proper username and
> > password
> > >but I get an error.
> > >
> > >I have a Windows XP machine with the following
> > >
> > >I installed apache 2.2.0,
> > > mysql 5.0.18,
> > > php5.1.1
> > > using the package from xampp.
> > >
> > >and phpESP
> > >
> > >I ran all of the scripts and made sure all usernames and passwords wer=
e
> > >there
> > >
> > >I get the following screen using the test.php
> > >
> > >Note:
> > >the following values are in red
> > >
> > >SAPI: apache2handler
> > >magic_quotes_gpc: Yes
> > >dBase: No
> > >LDAP: No
> > >
> > >
> > >
> > >  PHP Information
> > >
> > >   - Version: 4.4.1-pl1
> > >   - OS: WINNT
> > >   - SAPI: apache2handler
> > >   - register_globals: No
> > >   - magic_quotes_gpc: Yes
> > >   - magic_quotes_runtime: No
> > >   - safe_mode: No
> > >   - open_basedir:
> > >
> > > PHP Extensions
> > >
> > >   - dBase: No
> > >   - GD: Yes -- bundled (2.0.28 compatible)
> > >   - GNU Gettext: Yes
> > >   - LDAP: No
> > >   - MySQL: Yes
> > >   - PHP Extension Dir (compiled): c:\php4
> > >   - PHP Extension Dir (run time): C:\Program
> > Files\xampp\php\extensions\
> > >
> > > phpESP Settings
> > >
> > >   - Expected ESP_BASE: C:\Program Files\xampp\htdocs\phpESP/
> > >   - Expected base_url: localhost/phpesp/
> > >   - *Loading phpESP.ini.php ...*
> > >   - ESP_BASE: C:\Program Files\xampp\htdocs\phpESP/
> > >   - base_url: http://localhost/phpESP/
> > >   - Version: 1.8
> > >   - Debug: No
> > >
> > > phpESP Language Settings
> > >
> > >   - GNU Gettext: Real
> > >   - default_lang: en_US
> > >   - current lang: en_US
> > >   - available langs: da_DK, de_DE, el_GR, en_US, es_ES, fi, fi_FI,
> > >   fr_FR, hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT, sv_SE
> > >   (da, de, el, en, es, fi, fr, it, ja, nl, pt, sv)
> > >   - GNU Gettext test: Passed
> > >   - Catalog Open Test: Yes
> > >
> > > PHP Session Test
> > >
> > >   - session.save_path: C:\Program Files\xampp\tmp
> > >   - Counter: 2
> > >
> > >------=3D_Part_4646_16717938.1138745396511
> > >Content-Type: text/html; charset=3DISO-8859-1
> > >Content-Transfer-Encoding: quoted-printable
> > >Content-Disposition: inline
> > >
> > ><div>I am also getting a login failure. I put the proper username and
> > passw=3D
> > >ord but I get an error.</div>
> > ><div>&nbsp;</div>
> > ><div>I have a Windows XP machine with the following</div>
> > ><div>&nbsp;</div>
> > ><div>I installed apache 2.2.0,</div>
> > ><div>&nbsp;mysql 5.0.18,</div>
> > ><div>&nbsp;php5.1.1</div>
> > ><div>&nbsp;using the package from xampp.</div>
> > ><div>&nbsp;</div>
> > ><div>and phpESP</div>
> > ><div>&nbsp;</div>
> > ><div>I ran all of the scripts and made sure all usernames and password=
s
> > wer=3D
> > >e there</div>
> > ><div>&nbsp;</div>
> > ><div>I get the following screen using the test.php</div>
> > ><div>&nbsp;</div>
> > ><div>Note:</div>
> > ><div>the following values are in red</div>
> > ><div>&nbsp;</div>
> > ><div>SAPI: apache2handler</div>
> > ><div>magic_quotes_gpc: Yes</div>
> > ><div>dBase: No</div>
> > ><div>LDAP: No</div>
> > ><div>&nbsp;</div>
> > ><div>&nbsp;</div>
> > ><div>&nbsp;</div>
> > ><div>
> > ><table>
> > ><tbody align=3D3D"left">
> > ><tr>
> > ><th>PHP Information</th></tr>
> > ><tr>
> > ><td>
> > ><ul>
> > ><li>Version: <font color=3D3D"green">4.4.1-pl1</font>=3D20
> > ><li>OS: <font color=3D3D"green">WINNT</font>=3D20
> > ><li>SAPI: <font color=3D3D"red">apache2handler</font>=3D20
> > ><li>register_globals: <font color=3D3D"green">No</font>=3D20
> > ><li>magic_quotes_gpc: <font color=3D3D"red">Yes</font>=3D20
> > ><li>magic_quotes_runtime: <font color=3D3D"green">No</font>=3D20
> > ><li>safe_mode: <font color=3D3D"green">No</font>=3D20
> > ><li>open_basedir: <font
> > color=3D3D"green"></font></li></li></li></li></li></l=3D
> > >i></li></li></ul></td></tr>
> > ><tr>
> > ><th>PHP Extensions</th></tr>
> > ><tr>
> > ><td>
> > ><ul>
> > ><li>dBase: <font color=3D3D"red">No</font>=3D20
> > ><li>GD: <font color=3D3D"green">Yes</font> -- bundled (2.0.28compatibl=
e)=3D20
> > ><li>GNU Gettext: <font color=3D3D"green">Yes</font>=3D20
> > ><li>LDAP: <font color=3D3D"red">No</font>=3D20
> > ><li>MySQL: <font color=3D3D"green">Yes</font>=3D20
> > ><li>PHP Extension Dir (compiled): <font
> > color=3D3D"green">c:\php4</font>=3D20
> > ><li>PHP Extension Dir (run time): <font color=3D3D"green">C:\Program
> > Files\xa=3D
> > >mpp\php\extensions\</font>
> > </li></li></li></li></li></li></li></ul></td></t=3D
> > >r>
> > ><tr>
> > ><th>phpESP Settings</th></tr>
> > ><tr>
> > ><td>
> > ><ul>
> > ><li>Expected ESP_BASE: <font color=3D3D"green">C:\Program
> > Files\xampp\htdocs\=3D
> > >phpESP/</font>=3D20
> > ><li>Expected base_url: <font
> > color=3D3D"green">localhost/phpesp/</font>=3D20
> > ><li><b>Loading phpESP.ini.php ...</b><br>
> > ><li>ESP_BASE: <font color=3D3D"green">C:\Program
> > Files\xampp\htdocs\phpESP/</=3D
> > >font>=3D20
> > ><li>base_url: <font color=3D3D"green"><a href=3D3D"
> > http://localhost/phpESP/">ht=3D
> > >tp://localhost/phpESP/</a></font>=3D20
> > ><li>Version: <font color=3D3D"green">1.8</font>=3D20
> > ><li>Debug: <font color=3D3D"green">No</font>
> > </li></li></li></li></li></li></=3D
> > >li></ul></td></tr>
> > ><tr>
> > ><th>phpESP Language Settings</th></tr>
> > ><tr>
> > ><td>
> > ><ul>
> > ><li>GNU Gettext: <font color=3D3D"green">Real</font>=3D20
> > ><li>default_lang: <font color=3D3D"green">en_US</font>=3D20
> > ><li>current lang: <font color=3D3D"green">en_US</font>=3D20
> > ><li>available langs: <font color=3D3D"green">da_DK, de_DE, el_GR, en_U=
S,
> > es_E=3D
> > >S, fi, fi_FI, fr_FR, hu_HU, it_IT, ja_JP, nl_NL, pt_BR, pt_PT,
> > sv_SE</font>=3D
> > ><br>(<font color=3D3D"green">da, de, el, en, es, fi, fr, it, ja, nl, p=
t,
> > sv</=3D
> > >font>
> > >)=3D20
> > ><li>GNU Gettext test: <font color=3D3D"green">Passed</font>=3D20
> > ><li>Catalog Open Test: <font color=3D3D"green">Yes</font>
> > </li></li></li></li=3D
> > >></li></li></ul></td></tr>
> > ><tr>
> > ><th>PHP Session Test</th></tr>
> > ><tr>
> > ><td>
> > ><ul>
> > ><li>session.save_path: <font color=3D3D"green">C:\Program
> > Files\xampp\tmp</fo=3D
> > >nt>=3D20
> > ><li>Counter: 2 </li></li></ul></td></tr></tbody></table></div>
> > >
> > >------=3D_Part_4646_16717938.1138745396511--
> > >
> > >
> > >
> > >--__--__--
> > >
> > >_______________________________________________
> > >phpESP-general mailing list
> > > php...@li...
> > >https://lists.sourceforge.net/lists/listinfo/phpesp-general
> > >
> > >
> > >End of phpESP-general Digest
> >
> >
> > --
> > *******************
> > Tim Keely
> > IT Manager - Management Science and Engineering
> > School of Engineering
> > Stanford University
> > mailto:tim...@st...
> >
>
>