Logging in to isp config

Hi,
I can't seem to reach the isp Config login page when I type my ip address in the address bar like so: http://192.168.x.x:81 or https://192.168.x.x:81 am I doing something wrong? If so, what?

I followed the guide on here for the perfect setup ubuntu (http://howtoforge.com/perfect_setup_ubuntu_5.10) and I don't know whats wrong with it.

Any help is greatly appreciated.

 

These look like they may be errors:

Thars all I found in the install log.

On this command: /etc/init.d/ispconfig_server restart I get

netstat -tap Gives me the following:

Code:

Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State    PID/Program name
tcp        0      0 localhost.localdo:32770 *:*                     LISTEN   6212/hpiod
tcp        0      0 localhost.localdo:32771 *:*                     LISTEN   6227/python
tcp        0      0 localhost.localdo:mysql *:*                     LISTEN   11623/mysqld
tcp        0      0 *:ftp                   *:*                     LISTEN   15690/proftpd: (acc
tcp        0      0 192.168.1.103:domain    *:*                     LISTEN   19234/named
tcp        0      0 localhost.locald:domain *:*                     LISTEN   19234/named
tcp        0      0 localhost.localdoma:ipp *:*                     LISTEN   7887/cupsd
tcp        0      0 *:nessus                *:*                     LISTEN   7962/nessusd: waiti
tcp        0      0 *:smtp                  *:*                     LISTEN   15668/master
tcp        0      0 localhost.localdoma:953 *:*                     LISTEN   19234/named
tcp        0      0 localhost.localdo:50684 localhost.localdoma:ipp ESTABLISHED6914/gnome-cups-ico
tcp        0      0 192.168.1.103:60285     64.233.185.83:www       ESTABLISHED9636/firefox-bin
tcp        0      0 localhost.localdo:32770 localhost.localdo:48158 ESTABLISHED6212/hpiod
tcp        0      0 localhost.localdo:48158 localhost.localdo:32770 ESTABLISHED6227/python
tcp        0      0 localhost.localdoma:ipp localhost.localdo:50684 ESTABLISHED7887/cupsd
tcp6       0      0 *:imaps                 *:*                     LISTEN   23901/couriertcpd
tcp6       0      0 *:pop3s                 *:*                     LISTEN   23799/couriertcpd
tcp6       0      0 *:pop3                  *:*                     LISTEN   23724/couriertcpd
tcp6       0      0 *:imap2                 *:*                     LISTEN   23843/couriertcpd
tcp6       0      0 *:www                   *:*                     LISTEN   7861/apache2
tcp6       0      0 *:ssh                   *:*                     LISTEN   6450/sshd
tcp6       0      0 ip6-localhost:953       *:*                     LISTEN   19234/named
tcp6       0      0 *:https                 *:*                     LISTEN   7861/apache2

Had to put it in a code box so it didnt make smilies.

 

this was a fresh install

 

I guess a lot of things went wrong with your installation - did you try to install more than once?

Please run these commands:

Code:

rm -fr /root/ispconfig
rm -fr /home/admispconfig

Also delete the ISPConfig database, if it exists (have a look here: http://www.howtoforge.com/forums/showthread.php?t=1102 ).

Then unpack the ISPConfig tar.gz again and try another installation.

 

thank you till and falko for your help so far,

yes I ran the instalation again because it said it stopped when I entered the mysql password wrong then on the second install atempt it didnt ask for any mysql information, and when I installed mysql it didnt ask me for a password so im trying to reset/change it I found some information on that here: http://dev.mysql.com/doc/refman/5.0/en/resetting-permissions.html but I am not able to follow it very easily.

I ran those commands and I didnt get any errors or messages.

I looked at that other thread but I need to reset the mysql password to continue.

All help is greatly appreciated.

 

Have a look at the mysqladmin command in this thread: http://www.howtoforge.com/forums/showthread.php?t=1581&highlight=mysqladmin

 

this command: mysqladmin -u root password yourrootsqlpassword seems to require that you have a mysql password and this command: mysqladmin -u root -p<current_password> password <new_password> seems to be for resetting the password but you have to have a password to reset and on this page it says

but in terminal if I leave the password blank it says it fails to connect:

Code:

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: NO)'

is there any easier way to do it? or is there an interface that can be used instead of doing everything through terminal?

Sorry for not understanding this very good but im new to it.
thankyou for your help so far.

 

If you set up MySQL for the first time, then you have the user root with an empty password. You can then run

Code:

mysqladmin -u root password yourrootsqlpassword

which will set root's password to yourrootsqlpassword.

If root already has a password, you must run

Code:

mysqladmin -u root -p[I]current_password[/I] password [I]new_password[/I]

instead to set a new password for root where current_password is root's current password and new_password is root's new password.

 

when i run: mysqladmin -u root password yourrootsqlpassword I get:

 

What's in /etc/hosts?

 

It says:

Code:

127.0.0.1 localhost.localdomain localhost jrdserver1

# The following lines are desirable for IPv6 capable hosts
::1 ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts

I don't have a domain name if that makes any diference.

 

Hm...
Can you try

Code:

mysqladmin -h 127.0.0.1 -u root password yourrootsqlpassword

instead?

 

hmm... it looks like that wouldve worked, heres the message I get:

 

Please post /etc/mysql/my.cnf here.

 

ok here it is:

thanks for your patience with me

 

You can remove

Code:

bind-address = 127.0.0.1

from /etc/mysql/my.cnf and restart MySQL, although I don't think this has anything to do with your problem.

I guess you have wrong values in the Host coumn in the user table of the mysql database. The problem is: how do we change it if we can't access it?
And I wonder how the wrong values went into there? Maybe someone accessed the MySQL database when it didn't have a password and changed the values...

 

I didnt tell anyone that would have known how to do it or would have been able to get the server's ip...

Would it just be best to uninstall mysql as well as ispconfig and then reinstall?

 

You don't have to tell anyone about it. There are people out there scanning the net for things like these... Therefore you should set a MySQL password immediately after installation!

Uninstalling MySQL won't help because it doesn't remove the databases... You should consider a clean reinstall.