Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st September 2011, 02:10
briand0713 briand0713 is offline
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default Login password isn't working

I set the password a couple months ago and wrote it down as far as I knew. When I tried it, I kept getting an incorrect response. I also tried the default admin/admin password but that also failed. I was wondering if there's anyway I could manually adjust the password by editting config files while SSHing into the shell and if so, what would the procedure be?

OS: OpenSUSE v11.2
ISPConfig: v3
Reply With Quote
Sponsored Links
  #2  
Old 21st September 2011, 09:25
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 99 Times in 95 Posts
Default

In /usr/local/ispconfig/server/lib/mysql_clientdb.conf you can find the root login for mysql.

Also, bookmark this website:
http://www.faqforge.com/linux/contro...n-ispconfig-3/

It has tons of simple stuff you might run into once in a while.
__________________
Real men don't backup... Real men cry!

http://www.e-rave.nl/
Reply With Quote
The Following User Says Thank You to Mark_NL For This Useful Post:
falko (21st September 2011)
  #3  
Old 21st September 2011, 15:19
briand0713 briand0713 is offline
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Mark_NL View Post
In /usr/local/ispconfig/server/lib/mysql_clientdb.conf you can find the root login for mysql.

Also, bookmark this website:
http://www.faqforge.com/linux/contro...n-ispconfig-3/

It has tons of simple stuff you might run into once in a while.
thanks but this wasn't the information I needed but it will come in handy if I ever lose my mysql password.

What I need is the admin client login information for ISPConfig so I can login to the admin account when I goto http://192.168.1.110:8080

EDIT: Ok I checked the website you mentioned. I got this error when inputting the mysql password:

Code:
 mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)

Last edited by briand0713; 21st September 2011 at 15:25.
Reply With Quote
  #4  
Old 21st September 2011, 16:29
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 99 Times in 95 Posts
Default

Is mysql running?

Code:
netstat -tapn | grep 3306
ls -al /var/run/mysql/
cat /etc/mysql/my.cnf | egrep -v '^#|^$'
show us the output of these commands
__________________
Real men don't backup... Real men cry!

http://www.e-rave.nl/
Reply With Quote
  #5  
Old 21st September 2011, 18:53
briand0713 briand0713 is offline
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Mark_NL View Post
Is mysql running?

Code:
netstat -tapn | grep 3306
ls -al /var/run/mysql/
cat /etc/mysql/my.cnf | egrep -v '^#|^$'
show us the output of these commands
This is the output of those commands:

Code:
server1:~ # netstat -tapn | grep 3306
server1:~ # ls -al /var/run/mysql/
total 12
drwxr-xr-x  2 mysql mysql 4096 Sep 20 19:24 .
drwxr-xr-x 23 root  root  4096 Sep 20 19:25 ..
-rw-r--r--  1 root  root    22 Sep 20 19:24 tmpdir
server1:~ # cat /etc/mysql/my.cnf | egrep -v '^#|^$'
cat: /etc/mysql/my.cnf: No such file or directory
my.cnf is located in /etc/ unless if that's a completely different file all together. Here's what I got when I did: cat /etc/my.cnf | egrep -v '^#|^$'


Code:
server1:/etc # cat /etc/my.cnf | egrep -v '^#|^$'
[client]
port            = 3306
socket          = /var/run/mysql/mysql.sock
[mysqld]
port            = 3306
socket          = /var/run/mysql/mysql.sock
datadir = /var/lib/mysql
skip-locking
key_buffer_size = 16M
max_allowed_packet = 1M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M
log-bin=mysql-bin
binlog_format=mixed
server-id       = 1
[safe_mysqld]
log-error       = /var/log/mysql/mysqld.log
socket          = /var/run/mysql/mysql.sock
[mysqldump]
socket          = /var/run/mysql/mysql.sock
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
[myisamchk]
key_buffer_size = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
[mysqld_multi]
mysqld     = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
log        = /var/log/mysqld_multi.log
Reply With Quote
  #6  
Old 21st September 2011, 19:22
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 99 Times in 95 Posts
Default

MySQL is not running, i bet that's why you can't log in at all

If you start mysql, you should mostlikely be able to log into the ispconfig admin again
__________________
Real men don't backup... Real men cry!

http://www.e-rave.nl/
Reply With Quote
  #7  
Old 21st September 2011, 19:41
briand0713 briand0713 is offline
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by Mark_NL View Post
MySQL is not running, i bet that's why you can't log in at all

If you start mysql, you should mostlikely be able to log into the ispconfig admin again
hmm strange. Probably the reason I couldn't login to ISPConfig in the first place. I tried to START and RESTART mysql but I don't think it worked

Code:
server1:/etc # chkconfig --add mysql
mysql                     0:off  1:off  2:on   3:on   4:off  5:on   6:off
server1:/etc # /etc/init.d/mysql start
Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds
                                                                                           done
server1:/etc # mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
server1:/etc # /etc/init.d/mysql restart
Restarting service MySQL
Shutting down service MySQL                                                                done
Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds
                                                                                           done
Reply With Quote
  #8  
Old 22nd September 2011, 07:22
briand0713 briand0713 is offline
Junior Member
 
Join Date: Jul 2008
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I think I solved the problem. I guess my harddrive was filled up. I was having similar problems trying to get my Minecraft server running. I thought it was just something local but instead it was the harddrive. I cleared up some files and now mysql, ispconfig, and minecraft are running.

thanks
Reply With Quote
  #9  
Old 22nd September 2011, 09:25
Mark_NL Mark_NL is offline
Senior Member
 
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 99 Times in 95 Posts
 
Default

hahaha, nice one

(gotta keep that one in mind when trouble shooting next time)
__________________
Real men don't backup... Real men cry!

http://www.e-rave.nl/
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ispconfig 3 cant receive emails lishaw1968 Installation/Configuration 25 19th August 2013 10:37
F11 courier-imap fails. Nachogrande General 6 1st November 2010 17:55
squirrelmail and postfix witoszek General 12 1st December 2009 18:07
Error: Password error: [IN-USE] Internal login failure PacketPaul Installation/Configuration 1 4th October 2007 00:27
Password error: Login failed on access e-mail foxphiles General 4 25th October 2006 15:47


All times are GMT +2. The time now is 13:47.


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