Mysql

Discussion in 'Installation/Configuration' started by ejs, Aug 10, 2005.

  1. ejs

    ejs New Member

    what is causing this error? When i do the install it creates the mysql db but it is blank. I have tried to reinstall. I deleted the db and the isp file in the root before the reinstall. As per your instructions on another thread i did not put in the www and used the ip address for the rest of the domain name.


    ########## INSTALLATION ##########

    Preparing files. Please wait a moment...
    All prerequisites are fulfilled.
    Here we go...
    Please enter your MySQL server:localhost
    Please enter your MySQL user:root
    Please enter your MySQL password:
    OK
    Please enter a name for the ISPConfig database (e.g. db_ispconfig): db_ispconfig
    Please enter the IP address of the ISPConfig web (e.g. 192.168.0.1):xxx.xxx.xxx.xxx
    OK
    Please enter the host name (e.g. www):
    Please enter the domain (e.g. xyz.de):xxx.xxx.xxx.xxx
    OK
    Please select the protocol (http or https (SSL encryption)) to use to access the ISPConfig system:
    1) HTTPS
    2) HTTP
    Your Choice: 2

    Connected successfully to MySQL server
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
    Restarting some services...
    Shutting down postfix: [ OK ]
    Starting postfix: [ OK ]
    Shutting down proftpd: [ OK ]
    Starting proftpd: [ OK ]
    Starting ISPConfig system...
    /root/ispconfig/httpd/bin/apachectl startssl: httpd started

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    No results found!FreshClam is already running!
    ISPConfig system is now up and running!
    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.

    [root@ns1 install_ispconfig]#
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    Reinstall ISPConfig, when you are asked for mySQL username and password provide a valid username and password that are allowed to connect to ISPConvig via a network connection from localhost.
     
  3. ejs

    ejs New Member

    same responce

    Ok i added a new user in mysql with all the rights you can give a user on the localhost. got the same responce? It is creating the data base but it is empty. what can i try next? Also i can not use the uninstall comand because of the issue. So i been deleting the isp file in the root folder. Is that enough to get rid of the program for reinstall? Also been deleting the db shell it creates in Mysql.


    ########## INSTALLATION ##########

    Preparing files. Please wait a moment...
    All prerequisites are fulfilled.
    Here we go...
    Please enter your MySQL server:localhost
    Please enter your MySQL user:ej
    Please enter your MySQL password:
    OK
    Please enter a name for the ISPConfig database (e.g. db_ispconfig):db_ispconfig
    Please enter the IP address of the ISPConfig web (e.g. 192.168.0.1):xxx.xxx.xxx.xxx
    OK
    Please enter the host name (e.g. www):
    Please enter the domain (e.g. xyz.de):xxx.xxx.xxx.xxx
    OK
    Please select the protocol (http or https (SSL encryption)) to use to access the ISPConfig system:
    1) HTTPS
    2) HTTP
    Your Choice: 2

    Connected successfully to MySQL server
    ERROR 1045 (28000): Access denied for user 'ej'@'localhost' (using password: YES)
    Restarting some services...
    Shutting down postfix: [ OK ]
    Starting postfix: [ OK ]
    Shutting down proftpd: [ OK ]
    Starting proftpd: [ OK ]
    Starting ISPConfig system...
    /root/ispconfig/httpd/bin/apachectl startssl: httpd started

    Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
    No results found!FreshClam is already running!
    ISPConfig system is now up and running!
    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.
     
    Last edited: Aug 11, 2005
  4. falko

    falko Super Moderator Howtoforge Staff

    Are you sure you used the right MySQL password for that user?

    Can you post the output of
    Code:
    netstat -tap
    here?
     
  5. ejs

    ejs New Member

    Yes i am putting in the right password for root and the other account i created.



    [root@ns1 ~]# netstat -tap
    Active Internet connections (servers and established)
    Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
    tcp 0 0 *:imaps *:* LISTEN 2204/xinetd
    tcp 0 0 *:32769 *:* LISTEN 1849/rpc.statd
    tcp 0 0 *:pop3s *:* LISTEN 2204/xinetd
    tcp 0 0 *:mysql *:* LISTEN 21760/mysqld
    tcp 0 0 *:pop3 *:* LISTEN 2204/xinetd
    tcp 0 0 *:imap *:* LISTEN 2204/xinetd
    tcp 0 0 *:sunrpc *:* LISTEN 1831/portmap
    tcp 0 0 *:10000 *:* LISTEN 2555/perl
    tcp 0 0 *:81 *:* LISTEN 28291/ispconfig_htt
    tcp 0 0 adsl-068-213-093-013:domain *:* LISTEN 1805/named
    tcp 0 0 *:ftp *:* LISTEN 4820/proftpd: (acce
    tcp 0 0 adsl-xxx.xxx.xxx.xxx:domain *:* LISTEN 1805/named
    tcp 0 0 adsl-xxx.xxx.xxx.xxx:domain *:* LISTEN 1805/named
    tcp 0 0 localhost.localdomai:domain *:* LISTEN 1805/named
    tcp 0 0 localhost.localdomain:ipp *:* LISTEN 2160/cupsd
    tcp 0 0 localhost.localdomain:5335 *:* LISTEN 2142/mDNSResponder
    tcp 0 0 *:smtp *:* LISTEN 4787/master
    tcp 0 0 localhost.localdomain:rndc *:* LISTEN 1805/named
    tcp 0 16 adsl-xxx.xxx.xxx.xxx.s:pop3 206-216-114-243.colo.:31248 ESTABLISHED 27875/ipop3d
    tcp 0 0 adsl-xxx.xxx.xxx.xxx.s:smtp mail3.ProductChoicePan:5249 TIME_WAIT -
    tcp 0 0 *:http *:* LISTEN 2393/httpd
    tcp 0 0 *:ssh *:* LISTEN 2195/sshd
    tcp 0 0 *:8090 *:* LISTEN 2393/httpd
    tcp 0 0 *:https *:* LISTEN 2393/httpd
    tcp 0 0 adsl-xxx.xxx.xxx.xxx.si:ssh adsl-xxx.xxx.xxx.xxx.s:4771 ESTABLISHED 27882/1
     
  6. ejs

    ejs New Member

    Ok
    After some more testing i come to notice a few things. I reloaded the system and this time i did not do any updates. Also i noticed that the password for the the mysql does not like symbols like # $ @ *.

    After i reloaded again and set the password for mysql in alfha only everything is working so far.
     

Share This Page