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
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
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?
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 -
My ISPConfig3 does not connect to phpmyadmin - what to check next sorry, mistake on posting, I put as new subject
Can I try purge and reinstall phpmyadmin, without creating dependency issues with ISPConfig and manage phpmyadmin ( mysql ) apart from ISP config?
Yes. What do you mean with that? You shouldn't change records created through ISPConfig in phpMyAdmin.
Probably not the best solution, but am now managing mysql via the package from http://www.adminer.org/ , all passwords and databases where set up in ISPconfig and work fine, still in the dark as to why phpmyadmin couldnt log in . But for now I dont need phpmyadmin and am happy to work with adminer.
i have got same proble. I have phpmyadmin installed on my admin server and i wanna connect to my db server. error is: #1045 Cannot log in to the MySQL server proplem is, that i have phpmyadmin database only on server admin, not on server db. Can i somehow make phpmyadmin to authenticate users from database which is on admin? or thats not necessary? lgoin to localhost on admin works fine config on admin server is: <?php /** * Debian local configuration file * * This file overrides the settings made by phpMyAdmin interactive setup * utility. * * For example configuration see /usr/share/doc/phpmyadmin/examples/config.default.php.gz * * NOTE: do not add security sensitive data to this file (like passwords) * unless you really know what you're doing. If you do, any user that can * run PHP or CGI on your webserver will be able to read them. If you still * want to do this, make sure to properly secure the access to this file * (also on the filesystem level). */ /** * Server(s) configuration */ $i = 0; // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. // You can disable a server config entry by setting host to ''. $i++; /** * Read configuration from dbconfig-common * You can regenerate it using: dpkg-reconfigure -plow phpmyadmin */ if (is_readable('/etc/phpmyadmin/config-db.php')) { require('/etc/phpmyadmin/config-db.php'); } /* Configure according to dbconfig-common if enabled */ if (!empty($dbname)) { /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ if (empty($dbserver)) $dbserver = 'localhost'; $cfg['Servers'][$i]['host'] = $dbserver; if (!empty($dbport)) { $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['port'] = $dbport; } //$cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysqli'; /* Optional: User for advanced features */ $cfg['Servers'][$i]['controluser'] = $dbuser; $cfg['Servers'][$i]['controlpass'] = $dbpass; /* Optional: Advanced phpMyAdmin features */ $cfg['Servers'][$i]['pmadb'] = $dbname; $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; $cfg['Servers'][$i]['relation'] = 'pma_relation'; $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; $cfg['Servers'][$i]['history'] = 'pma_history'; $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; $cfg['Servers'][$i]['tracking'] = 'pma_tracking'; /* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; /* Advance to next server for rest of config */ $i++; } /* Authentication type */ $cfg['Servers'][$i]['auth_type'] = 'cookie'; /* Server parameters */ $cfg['Servers'][$i]['host'] = 'db.example.tld'; $cfg['Servers'][$i]['connect_type'] = 'tcp'; //$cfg['Servers'][$i]['compress'] = false; /* Select mysqli if your server has it */ $cfg['Servers'][$i]['extension'] = 'mysql'; /* Optional: User for advanced features */ // $cfg['Servers'][$i]['controluser'] = 'pma'; // $cfg['Servers'][$i]['controlpass'] = 'pmapass'; /* Optional: Advanced phpMyAdmin features */ // $cfg['Servers'][$i]['pmadb'] = 'phpmyadmin'; // $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark'; // $cfg['Servers'][$i]['relation'] = 'pma_relation'; // $cfg['Servers'][$i]['table_info'] = 'pma_table_info'; // $cfg['Servers'][$i]['table_coords'] = 'pma_table_coords'; // $cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages'; // $cfg['Servers'][$i]['column_info'] = 'pma_column_info'; // $cfg['Servers'][$i]['history'] = 'pma_history'; // $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords'; /* Uncomment the following to enable logging in to passwordless accounts, * after taking note of the associated security risks. */ // $cfg['Servers'][$i]['AllowNoPassword'] = TRUE; /* * End of servers configuration */ /* * Directories for saving/loading files from server */ $cfg['UploadDir'] = ''; $cfg['SaveDir'] = '';
If you use Debian/Ubuntu, check out this link: http://www.absolutelytech.com/2010/06/22/howto-use-local-phpmyadmin-with-remote-mysql/
Can you connect to the remote server from the command line? Code: mysql -h [I]<remote_server>[/I] -u root -p
