Menu
▾
▴
phpesp-general
|
From: Christopher A. <chr...@st...> - 2005-08-19 22:12:39
|
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...
|
|
From: Matthew G. <gr...@mu...> - 2005-08-19 22:23:13
|
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)
|
|
From: Harry M. <hj...@ta...> - 2005-09-09 21:37:46
|
OK - I admit it. I've lost/mistyped/forgotten the root password for my phpesp
installation, with a database full of responses that need to be presented
soon. :(
Is there a way to reset the root phpesp password? I have root on this system
(and HAVE remembered the root mysql DB).
Harry (just short of being a total bozo)
--
Cheers, Harry
Harry J Mangalam - 949 856 2847 (vox; email for fax) - hj...@ta...
<<plain text preferred>>
|
|
From: Christopher A. <chr...@st...> - 2005-08-19 22:27:52
|
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?
|
|
From: Matthew G. <gr...@mu...> - 2005-08-19 22:42:01
|
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)
|
|
From: Harry M. <hj...@ta...> - 2005-09-10 01:10:45
|
Partially answering my own question - I haven't been able to reset the root
password, but you can (assuming root on the MySQL DB) go in and wipe out
another password (which I had also forgotten) and give that user superuser
privs so that they in effect can control all the phpESP administration.
The phpESP root seems to be protected - I could blank his password but I
couldn't log in as root without a password.
HTH (other boneheads like me)
On Friday 09 September 2005 2:37 pm, Harry Mangalam wrote:
> OK - I admit it. I've lost/mistyped/forgotten the root password for my
> phpesp installation, with a database full of responses that need to be
> presented soon. :(
>
> Is there a way to reset the root phpesp password? I have root on this
> system (and HAVE remembered the root mysql DB).
>
> Harry (just short of being a total bozo)
--
Cheers, Harry
Harry J Mangalam - 949 856 2847 (vox; email for fax) - hj...@ta...
<<plain text preferred>>
|
|
From: Jim B. <jp...@si...> - 2005-09-10 14:28:09
|
* Harry Mangalam <hj...@ta...> [2005-09-09 21:11]:
>
> > Is there a way to reset the root phpesp password? I have root on this
> > system (and HAVE remembered the root mysql DB).
> >
Log into mysql phpesp database. Update the 'designer' table :
$ mysql -u root -p phpesp
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 462 to server version: 4.1.10a
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> update designer set password = PASSWORD('12345') where username = 'root';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> exit
Bye
$
Log into the phpESP management interface with user root and password 12345.
Hope this helps,
Jim B.
|
|
From: Harry M. <hj...@ta...> - 2005-09-12 14:08:34
|
Hi Jim,
Thanks for the help!
I agree that this should have solved things, but it didn't. I did the same
thing initially (actually cleared it), but this did not work. I still get
the error:
[ Incorrect User ID or Password, or your account has been disabled/expired. ]
when I try to log in as root after this reset.
However it does work for other users and like I said, I was able to set
another user to superuser to take control of the system.
hjm
On Saturday 10 September 2005 7:27 am, Jim Brown wrote:
> update designer set password = PASSWORD('12345') where username = 'root';
--
Cheers, Harry
Harry J Mangalam - 949 856 2847 (vox; email for fax) - hj...@ta...
<<plain text preferred>>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X