Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 10th January 2007, 15:03
Danielss89 Danielss89 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default Mysql server could not be reached

Hi, when i get to the point where i should write the mysql server i type localhost... i get "The mysql server could not be reached"... what should i do...

in my /etc/hosts are the following:

127.0.0.1 localhost localhost.localdomain
89.186.169.112 pottersiden.dk danielss89
::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

Is something missing?


//danielss89
Reply With Quote
Sponsored Links
  #2  
Old 10th January 2007, 15:09
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

Mine looks like this see if it makes a difference:

server1:/etc # vi hosts
#
# hosts This file describes a number of hostname-to-address
# mappings for the TCP/IP subsystem. It is mostly
# used at boot time, when no name servers are running.
# On small systems, this file can be used instead of a
# "named" name server.
# Syntax:
#
# IP-Address Full-Qualified-Hostname Short-Hostname
#

127.0.0.1 localhost.localdomain localhost

# special IPv6 addresses
::1 localhost ipv6-localhost ipv6-loopback

fe00::0 ipv6-localnet

ff00::0 ipv6-mcastprefix
ff02::1 ipv6-allnodes
ff02::2 ipv6-allrouters
ff02::3 ipv6-allhosts
212.xxx.xxx.xxx xxx.domainxxx.co.uk server1
212.xxx.xxx.xxx xxx.domainxxx.co.uk
Reply With Quote
  #3  
Old 10th January 2007, 15:21
Danielss89 Danielss89 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default

hmm it doesnt seem to work, should i restart enything after editing the file??
im still in the install, should i try to exit the install and do it over? or does it matter!!
Reply With Quote
  #4  
Old 10th January 2007, 15:27
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

change the host files and then restart your server and then re-run the install and see what happens.
Reply With Quote
  #5  
Old 10th January 2007, 15:42
Danielss89 Danielss89 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Hmm.. i tried reinstall.. and now i get this:


fileio.o: In function `tempname':
fileio.c.text+0x396): warning: the use of `mktemp' is dangerous, better use `mkstemp'
make[1]: Leaving directory `/install_ispconfig/compile_aps/zip-2.3'
cc -o unzip unzip.o crc32.o crctab.o crypt.o envargs.o explode.o extract.o fileio.o globals.o inflate.o list.o match.o process.o ttyio.o unreduce.o unshrink.o zipinfo.o unix.o -s
mv: cannot stat `binaries/ispconfig_tcpserver': No such file or directory
All prerequisites are fulfilled.
Here we go...


Warning: include(config.inc.php): failed to open stream: No such file or directory in /install_ispconfig/install.php on line 665

Warning: include(): Failed opening 'config.inc.php' for inclusion (include_path='.:') in /install_ispconfig/install.php on line 665

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /install_ispconfig/install.php on line 685
Could not connect to db
Restarting some services...
apache2: apr_sockaddr_info_get() failed for danielss89
apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
Stopping ftp server: proftpd.
Starting ftp server: proftpd - IPv4 getaddrinfo 'danielss89' error: Name or service not known
- warning: unable to determine IP address of 'danielss89'
- error: no valid servers configured
- Fatal: error processing configuration file '/etc/proftpd/proftpd.conf'
failed!
./setup2: line 1133: /etc/init.d/ispconfig_server: No such file or directory
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.


but i tried http://domain.tld:81

it just say page cannot be displayed

:/

what to do now
Reply With Quote
  #6  
Old 10th January 2007, 15:50
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

you cant get to the page because the install failed. The warnings at the top dont worry about. But the problem is that the password you specified for mysql access is wrong

Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) in /install_ispconfig/install.php on line 685
Could not connect to db

If you already have ispc installed and your updateing it you need to use the mysql password you specified during the initial install.

If this is a first install you need to specify a password with your mysql credentials.

If you are reinstalling make sure you delete the old install folders as described in other threads.

Hope this helps
Reply With Quote
  #7  
Old 10th January 2007, 16:19
Danielss89 Danielss89 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default

DAmnit... it still doesnt work..

i triyed delete all ispc files, and restart install... i still get the mysql server not reachable error...

my hosts file look's like this:

127.0.0.1 localhost localhost.localdomain
::1 localhost ip6-localhost ip6-loopback
fe00::0 ip6-localnet
ff00::0 ip6-mcastprefix
ff02::1 ip6-allnodes
ff02::2 ip6-allrouters
ff02::3 ip6-allhosts
89.186.169.112 www.potterskolen.dk potterskolen
89.186.169.112 http://potterskolen.dk potterskolen
89.186.169.112 localhost localhost.localdomain
Reply With Quote
  #8  
Old 10th January 2007, 16:51
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
Default

lets check its running netstat -tap and post the results.
Reply With Quote
  #9  
Old 10th January 2007, 16:56
Danielss89 Danielss89 is offline
Junior Member
 
Join Date: Jan 2007
Posts: 21
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Code:
root@danielss89:/# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State       PID/Program name
tcp        0      0 localhost:mysql         *:*                     LISTEN     14267/mysqld
tcp        0      0 localhost:www           *:*                     LISTEN     18423/apache2
tcp        0      0 localhost:webmin        *:*                     LISTEN     13785/perl
tcp        0      0 localhost:domain        *:*                     LISTEN     29490/named
tcp        0      0 localhost:ssh           *:*                     LISTEN     18302/sshd
tcp        0      0 localhost:smtp          *:*                     LISTEN     26733/exim4
tcp        0      0 localhost:www           port108.ds1-gl.ad:11795 TIME_WAIT  -
tcp        0      0 localhost:www           cpe.atm2-0-72278.0:1696 TIME_WAIT  -
tcp        0      0 localhost:www           cpe.atm2-0-72278.0:1698 ESTABLISHED890/apache2
tcp        0      0 localhost:www           cpe.atm2-0-72278.0:1699 ESTABLISHED972/apache2
tcp        0      0 localhost:www           0x50a47334.odnxx4:52127 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a47334.odnxx4:52128 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a5be7b.sgnxx1:62247 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a5be7b.sgnxx1:62246 TIME_WAIT  -
tcp        0      0 localhost:www           0x50c409be.bynxx8.:1847 ESTABLISHED1038/apache2
tcp        0      0 localhost:www           0x50c409be.bynxx8.:1848 ESTABLISHED957/apache2
tcp        0      0 localhost:www           cpe.atm2-0-72278.0:1694 TIME_WAIT  -
tcp        0      0 localhost:www           cpe.atm2-0-72278.0:1689 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a47334.odnxx4:52141 FIN_WAIT2  -
tcp        0      0 localhost:www           0x50a47334.odnxx4:52146 FIN_WAIT2  -
tcp        0      0 localhost:www           87.104.48.7:65283       FIN_WAIT2  -
tcp        0      0 localhost:www           d40a710e.rev.stofa:3446 TIME_WAIT  -
tcp        0      0 localhost:www           d40a710e.rev.stofa:3442 TIME_WAIT  -
tcp        0      0 localhost:www           0x535c1542.odnxx9.:3598 ESTABLISHED881/apache2
tcp        0      0 localhost:www           0x535c1542.odnxx9.:3599 ESTABLISHED943/apache2
tcp        0      0 localhost:www           87.104.48.7:65197       FIN_WAIT2  -
tcp        0      0 localhost:www           x1-6-00-0c-e5-c0-1:1909 ESTABLISHED935/apache2
tcp        0      0 localhost:www           x1-6-00-0c-e5-c0-1:1908 ESTABLISHED898/apache2
tcp        0      0 localhost:www           0x5733daa7.bynxx1:13696 ESTABLISHED889/apache2
tcp        0      0 localhost:www           87.104.48.7:65171       FIN_WAIT2  -
tcp        0      0 localhost:www           0x57327b62.kjnxx8:64498 TIME_WAIT  -
tcp        0      0 localhost:www           port124.ds1-md.ad:12281 TIME_WAIT  -
tcp        0      0 localhost:www           port124.ds1-md.ad:12282 TIME_WAIT  -
tcp        0      0 localhost:www           port124.ds1-md.ad:12278 TIME_WAIT  -
tcp        0      0 localhost:www           port124.ds1-md.ad:12279 TIME_WAIT  -
tcp        0      0 localhost:www           0x535dac0d.arcnxx1:3959 ESTABLISHED933/apache2
tcp        0      0 localhost:www           0x535dac0d.arcnxx1:3957 ESTABLISHED975/apache2
tcp        0      0 localhost:www           0x535dac0d.arcnxx1:3949 TIME_WAIT  -
tcp        0      0 localhost:www           d40a710e.rev.stofa:3566 TIME_WAIT  -
tcp        0      0 localhost:www           d40a710e.rev.stofa:3564 TIME_WAIT  -
tcp        0      0 localhost:www           5634fc02.rev.stof:14507 ESTABLISHED885/apache2
tcp        0      0 localhost:www           0x5735cfb5.hinxx4:49957 ESTABLISHED1236/apache2
tcp        0      0 localhost:www           0x5735cfb5.hinxx4:49959 ESTABLISHED1034/apache2
tcp        0      0 localhost:www           x1-6-00-04-76-dd-b:1689 ESTABLISHED985/apache2
tcp        0      0 localhost:www           x1-6-00-04-76-dd-b:1690 ESTABLISHED1238/apache2
tcp        0      0 localhost:ssh           0x503e3ddd.hknxx1:23469 ESTABLISHED23759/sshd: daniels
tcp        0      0 localhost:www           0x535ea543.aaanxx1:4347 FIN_WAIT2  -
tcp        0      0 localhost:www           0x535ea543.aaanxx1:4349 FIN_WAIT2  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2451 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2452 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2442 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2441 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2434 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2435 TIME_WAIT  -
tcp        0      0 localhost:www           0x535b6292.naenxx:27634 TIME_WAIT  -
tcp        0      0 localhost:www           0x535ea543.aaanxx1:4327 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2436 TIME_WAIT  -
tcp        0      0 localhost:www           195.249.106.2:40880     ESTABLISHED963/apache2
tcp        0      0 localhost:www           195.249.106.2:40884     ESTABLISHED896/apache2
tcp        0      0 localhost:www           194.182.168.210:1766    ESTABLISHED1250/apache2
tcp        0      0 localhost:www           194.182.168.210:1765    ESTABLISHED1033/apache2
tcp        0      0 localhost:www           50C57F8D.flatrate:22064 FIN_WAIT2  -
tcp        0      0 localhost:www           0x5733f1e7.vgnxx6.:1580 TIME_WAIT  -
tcp        0      0 localhost:www           5634fc02.rev.stof:14534 ESTABLISHED15292/apache2
tcp        0      0 localhost:www           0x5733f1e7.vgnxx6.:1591 ESTABLISHED15261/apache2
tcp        0      0 localhost:www           0x5733f1e7.vgnxx6.:1598 ESTABLISHED934/apache2
tcp        0      0 localhost:www           0x5733f1e7.vgnxx6.:1592 ESTABLISHED1249/apache2
tcp        0      0 localhost:www           217.60.118.194:1899     FIN_WAIT2  -
tcp        0      0 localhost:www           0x535c1c2c.bynxx1:26765 FIN_WAIT2  1247/apache2
tcp        0      0 localhost:www           0x535c1c2c.bynxx1:26509 ESTABLISHED884/apache2
tcp        0      0 localhost:www           217.60.118.194:1900     FIN_WAIT2  -
tcp        0      0 localhost:www           0x50a07c1e.naenxx7:1329 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a07c1e.naenxx7:1328 TIME_WAIT  -
tcp        0      0 localhost:www           0x50a07c1e.naenxx7:1331 ESTABLISHED15201/apache2
tcp        0      0 localhost:ssh           0x503e3ddd.hknxx1:25129 ESTABLISHED30746/sshd: daniels
tcp        0      0 localhost:www           0x50a07c1e.naenxx7:1332 ESTABLISHED928/apache2
tcp        0   2368 localhost:ssh           0x503e3ddd.hknxx1:26149 ESTABLISHED13928/sshd: daniels
tcp        0      0 localhost:www           0x555300be.adsl.c:22591 TIME_WAIT  -
tcp        0      0 localhost:www           3e6bb640.rev.stofa:1860 ESTABLISHED962/apache2
tcp        0      0 localhost:www           3e6bb640.rev.stofa:1859 ESTABLISHED15263/apache2
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2427 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2424 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2425 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2418 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2419 TIME_WAIT  -
tcp        0      0 localhost:www           0x555300be.adsl.c:22593 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2411 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2412 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2413 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2392 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2398 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2397 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2390 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2391 TIME_WAIT  -
tcp        0   5644 localhost:www           x1-6-00-16-36-2f-f:2277 ESTABLISHED1239/apache2
tcp        0      0 localhost:www           83.95.177.115:1548      TIME_WAIT  -
tcp        0      0 localhost:ssh           0x503e3ddd.hknxx1:26185 ESTABLISHED13941/sshd: daniels
tcp        0      0 localhost:www           x1-6-00-16-36-2f-f:2272 ESTABLISHED901/apache2
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2380 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2381 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2371 TIME_WAIT  -
tcp        0      0 localhost:www           0x5552b496.adsl.c:29162 TIME_WAIT  -
tcp        0      0 localhost:www           0x535b6292.naenxx:27698 ESTABLISHED15285/apache2
tcp        0      0 localhost:www           0x5552b496.adsl.c:29161 TIME_WAIT  -
tcp        0      0 localhost:www           0x5731c820.svgnxx4:2372 TIME_WAIT  -
tcp        0      0 localhost:www           0x535b6292.naenxx:27703 ESTABLISHED1035/apache2
Reply With Quote
  #10  
Old 10th January 2007, 17:00
mphayesuk mphayesuk is offline
Senior Member
 
Join Date: Sep 2005
Location: UK, East Midlands
Posts: 517
Thanks: 1
Thanked 3 Times in 3 Posts
Send a message via MSN to mphayesuk
 
Default

Ok everything looks fine with that, can you connect to the database manually from the command prompt.

try:

mysql -u root -p

and then enter the password.

see what happens
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
php Apps email not going through palkat General 8 21st September 2011 05:35
Statistic not working mzo Installation/Configuration 49 20th April 2011 12:19
MySql on Ubuntu 6.06 LTS Server Bubo Server Operation 7 5th January 2007 16:23
Email - Ueb-Miau mazhar Installation/Configuration 5 21st December 2005 10:01
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 02:30


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


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