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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st February 2011, 00:09
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default Phpmyadmin does not connect to Mysql server

Hi Ive installed ISPconfig3 on Debian Squeeze on a dedicated server with 3 available IP's and everything works fine except for phpmyadmin.

When I create a database I can access phpmyadmin from the ISPconfig panel by clicking the connection to phpmyadmin from the sites/database interface, but I cannot login with the username and password I just set up.


I can login to mysql server from command line by doing

mysql -u root -p

so mysql server is running

remote access is also ticked

Ive set phpmyadmin interface on ISPconf to http://xx.xx.149.228/phpmyadmin/ which I can open but wont except username and password ( #1045 Cannot log in to the MySQL server
)

Any ideas how to start fault tracing?

Thanks

Alex
Reply With Quote
Sponsored Links
  #2  
Old 21st February 2011, 13:23
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 36,736
Thanks: 840
Thanked 5,596 Times in 4,407 Posts
Default

Please post the ouput of the command:

netstat -tap
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 22nd February 2011, 23:43
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Code:
server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address           Foreign Address         State                                                                                                         PID/Program name
tcp        0      0 41.72.149.229:www       66.220.158.248:53256    SYN_RECV                                                                                                      -
tcp        0      0 41.72.149.229:www       dsl-158-22.aei.ca:50492 SYN_RECV                                                                                                      -
tcp        0      0 *:ftp                   *:*                     LISTEN                                                                                                        30386/pure-ftpd (SE
tcp        0      0 41.72.149.230:domain    *:*                     LISTEN                                                                                                        29413/named
tcp        0      0 41.72.149.229:domain    *:*                     LISTEN                                                                                                        29413/named
tcp        0      0 server1.booknsta:domain *:*                     LISTEN                                                                                                        29413/named
tcp        0      0 localhost:domain        *:*                     LISTEN                                                                                                        29413/named
tcp        0      0 *:ssh                   *:*                     LISTEN                                                                                                        30110/sshd
tcp        0      0 localhost:953           *:*                     LISTEN                                                                                                        29413/named
tcp        0      0 *:smtp                  *:*                     LISTEN                                                                                                        18221/smtpd
tcp        0      0 localhost:10024         *:*                     LISTEN                                                                                                        28539/amavisd (mast
tcp        0      0 localhost:10025         *:*                     LISTEN                                                                                                        28453/master
tcp        0      0 localhost:mysql         *:*                     LISTEN                                                                                                        16730/mysqld
tcp        0      0 localhost:37403         localhost:mysql         ESTABLISHED                                                                                                   31428/amavisd (ch19
tcp        0      0 localhost:55884         localhost:www           TIME_WAIT                                                                                                     -
tcp        0      0 server1.booknstay.c:ssh u125.gpu93.samsun:40661 TIME_WAIT                                                                                                     -
tcp        0      0 localhost:40110         localhost:domain        TIME_WAIT                                                                                                     -
tcp        0      0 localhost:mysql         localhost:37403         ESTABLISHED                                                                                                   16730/mysqld
tcp        0      0 localhost:mysql         localhost:37372         ESTABLISHED                                                                                                   16730/mysqld
tcp        0    720 server1.booknstay.c:ssh u125.gpu93.samsun:43620 ESTABLISHED                                                                                                   18193/sshd: [accept
tcp        0     52 server1.booknstay.c:ssh 41-134-160-57.dsl:10553 ESTABLISHED                                                                                                   18178/0
tcp        0      0 localhost:37372         localhost:mysql         ESTABLISHED                                                                                                   30906/amavisd (ch19
tcp        0      0 server1.booknstay.c:ssh 41-134-160-57.dsl:59900 ESTABLISHED                                                                                                   17171/sshd: root@no
tcp        0      0 localhost:49492         localhost:ftp           TIME_WAIT                                                                                                     -
tcp6       0      0 [::]:pop3               [::]:*                  LISTEN                                                                                                        29323/couriertcpd
tcp6       0      0 [::]:imap2              [::]:*                  LISTEN                                                                                                        29295/couriertcpd
tcp6       0      0 [::]:http-alt           [::]:*                  LISTEN                                                                                                        14591/apache2
tcp6       0      0 [::]:www                [::]:*                  LISTEN                                                                                                        14591/apache2
tcp6       0      0 [::]:tproxy             [::]:*                  LISTEN                                                                                                        14591/apache2
tcp6       0      0 [::]:ftp                [::]:*                  LISTEN                                                                                                        30386/pure-ftpd (SE
tcp6       0      0 [::]:domain             [::]:*                  LISTEN                                                                                                        29413/named
tcp6       0      0 [::]:ssh                [::]:*                  LISTEN                                                                                                        30110/sshd
tcp6       0      0 ip6-localhost:953       [::]:*                  LISTEN                                                                                                        29413/named
tcp6       0      0 [::]:https              [::]:*                  LISTEN                                                                                                        14591/apache2
tcp6       0      0 [::]:imaps              [::]:*                  LISTEN                                                                                                        29312/couriertcpd
tcp6       0      0 [::]:pop3s              [::]:*                  LISTEN                                                                                                        29340/couriertcpd
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4931 ESTABLISHED                                                                                                   18129/apache2
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4929 ESTABLISHED                                                                                                   18164/apache2
tcp6       0      0 41.72.149.229%32197:www vc-41-26-242-9.umt:4514 FIN_WAIT2                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63328 ESTABLISHED                                                                                                   18191/apache2
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55121 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www crawl-66-249-71-1:43108 ESTABLISHED                                                                                                   17913/apache2
tcp6       0      0 41.72.149.230%32197:www b3090768.crawl.ya:52532 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4937 ESTABLISHED                                                                                                   18122/apache2
tcp6       0      0 41.72.149.229%32197:www llf320049.crawl.y:32855 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4927 ESTABLISHED                                                                                                   18242/apache2
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55119 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55119 TIME_WAIT                                                                                                     -
tcp6       0   1905 41.72.149.229%32197:www 196.214.92.50%169:2552  ESTABLISHED                                                                                                   -
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63329 ESTABLISHED                                                                                                   18192/apache2
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63326 ESTABLISHED                                                                                                   18190/apache2
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55120 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4939 ESTABLISHED                                                                                                   18091/apache2
tcp6       0      0 41.72.149.229%32197:www cpe-76-174-216-94:59501 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63327 ESTABLISHED                                                                                                   17899/apache2
tcp6       0      0 41.72.149.229%32197:www llf320049.crawl.y:58295 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-158-22.aei.ca:50568 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63325 ESTABLISHED                                                                                                   18165/apache2
tcp6       0      0 41.72.149.229%32197:www cpe-76-174-216-94:59500 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55118 TIME_WAIT                                                                                                     -
tcp6       0   6185 41.72.149.229%32197:www 196.214.92.50%170:2551  ESTABLISHED                                                                                                   -
tcp6       0      0 server1.booknstay.:pop3 41-134-160-57.dsl:60003 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.230%3219:pop3 41-134-160-57.dsl:60002 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4935 ESTABLISHED                                                                                                   18167/apache2
tcp6       0  21906 41.72.149.229%32197:www 196.214.92.50%170:2559  ESTABLISHED                                                                                                   -
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55117 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-146-232-167.te:4933 ESTABLISHED                                                                                                   18032/apache2
tcp6       0      0 41.72.149.229%32197:www host86-144-223-72:63330 ESTABLISHED                                                                                                   18241/apache2
tcp6       0      0 41.72.149.229%3219:pop3 41-134-160-57.dsl:60000 TIME_WAIT                                                                                                     -
tcp6       0   6908 41.72.149.229%32197:www vc-41-2-188-185.u:50954 ESTABLISHED                                                                                                   18162/apache2
tcp6       0      0 41.72.149.229%3219:pop3 41-134-160-57.dsl:60004 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.229%32197:www dsl-145-84-134.te:55111 TIME_WAIT                                                                                                     -
tcp6       0   1079 41.72.149.229%32197:www vc-41-2-188-185.u:50958 ESTABLISHED                                                                                                   18114/apache2
tcp6       0   6042 41.72.149.229%32197:www 196.214.92.50%171:2560  ESTABLISHED                                                                                                   -
tcp6       0      0 41.72.149.229%3219:pop3 41-134-160-57.dsl:60006 TIME_WAIT                                                                                                     -
tcp6       0      0 41.72.149.230%3219:pop3 41-134-160-57.dsl:60005 TIME_WAIT                                                                                                     -
tcp6       0   6924 41.72.149.229%32197:www 196.214.92.50%169:2558  ESTABLISHED                                                                                                   -
tcp6       0      1 41.72.149.229%32197:www out-fc247.tfbnw.n:44792 LAST_ACK                                                                                                      -
tcp6       0      0 41.72.149.230%3219:pop3 41-134-160-57.dsl:60005 TIME_WAIT                                                                                                     -
tcp6       0   6924 41.72.149.229%32197:www 196.214.92.50%170:2558  ESTABLISHED                                                                                                   -
tcp6       0   1622 41.72.149.229%32197:www vc-41-2-188-185.u:50972 ESTABLISHED
Reply With Quote
  #4  
Old 23rd February 2011, 15:43
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Code:
tcp        0      0 localhost:mysql         *:*                     LISTEN                                                                                                        16730/mysqld
MySQL is listening only on localhost. Can you change it so that it listens on all interfaces?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 24th February 2011, 03:00
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Ok I have done that, but still receive a

#1045 Cannot log in to the MySQL server error

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| c1test1 |
| dbispconfig |
| mysql |
+--------------------+
4 rows in set (0.00 sec)

The c1test1 db is what I created and cannot log into


Below done after doing #bind-address = 127.0.0.1 at mysql/my.cnf

server1:~# netstat -tap
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:ftp *:* LISTEN 30386/pure-ftpd (SE
tcp 0 0 41.72.149.230:domain *:* LISTEN 29413/named
tcp 0 0 41.72.149.229:domain *:* LISTEN 29413/named
tcp 0 0 server1.booknsta:domain *:* LISTEN 29413/named
tcp 0 0 localhost:domain *:* LISTEN 29413/named
tcp 0 0 *:ssh *:* LISTEN 30110/sshd
tcp 0 0 localhost:953 *:* LISTEN 29413/named
tcp 0 0 *:smtp *:* LISTEN 26410/smtpd
tcp 0 0 localhost:10024 *:* LISTEN 28539/amavisd (mast
tcp 0 0 localhost:10025 *:* LISTEN 28453/master
tcp 0 0 *:mysql *:* LISTEN 26602/mysqld
tcp 0 0 localhost:48158 localhost:domain TIME_WAIT -
tcp 1 0 localhost:50462 localhost:mysql CLOSE_WAIT 30223/amavisd (ch15
tcp 1 0 localhost:41943 localhost:mysql CLOSE_WAIT 30573/amavisd (ch15
tcp 0 0 localhost:mysql localhost:50462 FIN_WAIT2 -
tcp 0 0 localhost:57973 localhost:ftp TIME_WAIT -
tcp 0 52 server1.booknstay.c:ssh 41-134-160-57.dsl.:3611 ESTABLISHED 26348/0
tcp 0 0 localhost:42744 localhost:www TIME_WAIT -
tcp 0 0 server1.booknstay.c:ssh 41-134-160-57.dsl:57621 ESTABLISHED 26345/sshd: root@no
tcp 0 0 localhost:mysql localhost:41943 FIN_WAIT2 -
tcp6 0 0 [::]op3 [::]:* LISTEN 29323/couriertcpd
tcp6 0 0 [::]:imap2 [::]:* LISTEN 29295/couriertcpd
tcp6 0 0 [::]:http-alt [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:www [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:tproxy [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:ftp [::]:* LISTEN 30386/pure-ftpd (SE
tcp6 0 0 [::]:domain [::]:* LISTEN 29413/named
tcp6 0 0 [::]:ssh [::]:* LISTEN 30110/sshd
tcp6 0 0 ip6-localhost:953 [::]:* LISTEN 29413/named
tcp6 0 0 [::]:https [::]:* LISTEN 14591/apache2
tcp6 0 0 [::]:imaps [::]:* LISTEN 29312/couriertcpd
tcp6 0 0 [::]op3s [::]:* LISTEN 29340/couriertcpd
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50734 ESTABLISHED 26145/apache2
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50740 ESTABLISHED 26245/apache2
tcp6 0 924 41.72.149.229%32159:www adsl-36-0-47.asm.:50737 ESTABLISHED 26246/apache2
tcp6 0 0 41.72.149.229%32159:www adsl-36-0-47.asm.:50745 ESTABLISHED 26243/apache2
tcp6 0 0 41.72.149.229%32159:www llf320049.crawl.y:48890 TIME_WAIT -
tcp6 0 1190 41.72.149.229%32159:www adsl-36-0-47.asm.:50735 ESTABLISHED 26267/apache2
tcp6 0 5748 41.72.149.229%32159:www adsl-36-0-47.asm.:50736 ESTABLISHED 26277/apache2
tcp6 0 0 41.72.149.229%32159:www crawl-66-249-71-1:52333 ESTABLISHED 26044/apache2
tcp6 0 0 41.72.149.229%32159:www llf320049.crawl.y:51543 TIME_WAIT -
Reply With Quote
  #6  
Old 24th February 2011, 16:35
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Does the MySQL password contain any special characters?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 26th February 2011, 13:19
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

no, only uppercase and lowercase numbers and letters
Reply With Quote
  #8  
Old 27th February 2011, 21:42
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
Default

Can you log in with the new username on the shell?

Code:
mysql -u username -p
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #9  
Old 4th March 2011, 00:54
Bashewa Bashewa is offline
Junior Member
 
Join Date: Feb 2011
Posts: 14
Thanks: 1
Thanked 0 Times in 0 Posts
Default

Yes

mysql> mysql -u c1test1 -p
->
Reply With Quote
  #10  
Old 4th March 2011, 18:33
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,747 Times in 2,578 Posts
 
Default

Did the password work?
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
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
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 11:49
Problem with mail server and subdomains MyKE General 7 26th February 2010 11:18
Cannot send or receive mail farbrorc Installation/Configuration 6 24th January 2010 12:56
Unable to connect to mysql server Can't connect to local MySQL server through socket c7p Installation/Configuration 11 21st July 2009 11:27
MySQL problem satimis Server Operation 5 25th June 2008 16:41


All times are GMT +2. The time now is 23:35.


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