HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   password (http://www.howtoforge.com/forums/showthread.php?t=359)

m u r 22nd August 2005 19:08

password
 
Is there any way to retrieve or reset the admin password for ISPConfig? Am I screwed?

I'm almost positive I'm entering the right password, but ISPConfig won't let me in. I can still login on the machine as root.

falko 22nd August 2005 21:06

You can use phpMyAdmin. In your ISPConfig database, go to the table sys_user and fill in "admin" (using MySQL's MD5 function!) in the passwort column of the user admin.

m u r 22nd August 2005 21:09

What's the easiest way to install phpMyAdmin outside of ISPConfig, and will that mess up ISPConfig?

What's the MD5 function?

till 22nd August 2005 21:47

Quote:

Originally Posted by m u r
What's the easiest way to install phpMyAdmin outside of ISPConfig, and will that mess up ISPConfig?

If you have already a site configured in ISPConfig that has php enabled, you can install phpmyadmin there. Download it from the phpmyadmin homepage and follow the installation instructions inside the phpmyadmin package.


Quote:

Originally Posted by m u r
What's the MD5 function?

Thats a function in mySQL. The SQL query to update the password is:

Code:

UPDATE sys_user SET passwort = md5('myNewPassword') WHERE username = 'admin'

m u r 22nd August 2005 22:08

I am a complete novice, and I apologize.

Thanks for your reply. I do have sites set up, but I don't think there are databases yet.

the following are the phpMyAdmin install instructions, but I do not understand some things:

1. Untar or unzip the distribution (be sure to unzip the subdirectories): tar -xzvf phpMyAdmin_x.x.x.tar.gz in your webserver's document root Does this mean the box's root? . . . /root/ ? . If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp.

2. Ensure that all the scripts have the appropriate owner (if PHP is running in safe mode, having some scripts with an owner different from the owner of other scripts will be a problem). See FAQ 4.2 for suggestions. Do I need to worry about this?

3. Open the file config.inc.php in your favorite editor and change the values WHERE do I change the values? for host, user, password and authentication mode to fit your environment. Here, "host" means the MySQL server host: rmweb.rwhm.net?. Have a look at Configuration section for an explanation of all values. Please also read the remaining of this Installation section for information about authentication modes and the linked-tables infrastructure.

4. It is recommended that you protect the directory in which you installed phpMyAdmin (unless it's on a closed intranet, or you wish to use HTTP or cookie authentication), for example with HTTP-AUTH (in a .htaccess file). See the multi-user sub-section of the FAQ for additional information, especially FAQ 4.4. Do I need to worry about this?

5. Open the file <www.your-host.com>/<your-install-dir>/index.php rmweb.rwhm.net/ ? /index.php
in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode.

Sorry for all this, but I'm going crazy and am desperate for help!

thebigfing 22nd August 2005 22:15

The PHP my admin can be download from here and can be installed by draging and dropping and then change the config file.

MD5 is a description you can create a MD5 hashe on this website:

http://thebigfing.no-ip.com/convert/

The Big Fing

m u r 22nd August 2005 22:23

Drag and drop where? I downloaded it and it's unpacked in the root's home folder. I'm sorry. I need specific instructions. I am completely lost.

thebigfing 22nd August 2005 22:57

You must drag and drop it in your website folder so you can reeche it whit your webbrouwser. You must also edit the config file the coments give you there atvice so that you now what you must type in.

m u r 23rd August 2005 00:47

OK, I uploaded phpMyAdmin onto the site and can access it. I clicked "browse" next to sys_user in my ispconfigdb. I checked the user "admin" and clicked the pencil to edit it. The row "passwort," I selected the MD5 function, and entered "UPDATE sys_user SET passwort = md5('myNewPassword') WHERE username = 'admin'" in the value input. Then I clicked "go" at the bottom of the first section of fields. I wasn't sure if I needed to do anything after that.

and . . .

I still can't login.

Earlier . . . I logged into the box as root and changed the password for the user "admispconfig," thinking it was the password to login to port 81. Could this be the reason?

falko 23rd August 2005 01:13

2 Attachment(s)
I've made 2 screenshots that show you how to do it.


All times are GMT +2. The time now is 06:16.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.