Problem encountered on "howtoforge.com/perfect_setup_centos_4.4"

Discussion in 'Server Operation' started by satimis, Mar 28, 2007.

  1. satimis

    satimis Member

    Hi folks,

    1)
    http://howtoforge.com/perfect_setup_centos_4.4_p4

    # mysqladmin -u root password myrootsqlpassword
    Code:
    Access denied for user \u2018root\u2019@'localhost\u2019 (using password: NO)
    
    # kill `cat /mysql-data-directory/mysql.pid`
    No complaint.

    What shall I do next? Repeat "mysqladmin -u root password myrootsqlpassword"?


    2)
    10 Postfix With SMTP-AUTH And TLS
    http://howtoforge.com/perfect_setup_centos_4.4_p5

    [root@server ssl]# openssl genrsa -des3 -rand /etc/hosts -out smtpd.key 1024
    Code:
    188 semi-random bytes loaded
    Generating RSA private key, 1024 bit long modulus
    .........................++++++
    .....++++++
    e is 65537 (0x10001)
    Enter pass phrase for smtpd.key:
    
    What shall I enter here? TIA


    # openssl req -new -key smtpd.key -out smtpd.csr
    It also requests "Enter pass phrase for smtpd.key"

    What shall I enter as well ?


    B.R.
    satimis
     
  2. satimis

    satimis Member

    Hi folks,

    On my previous posting
    I made a mistake leaving out "--" before "password"

    Retried as follows;


    [root@server ~]# mysqladmin -u root --password mypassword
    Code:
    Enter password: 
    
    Typing either "mypassword" or "YES" prompted;
    Code:
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: YES)'
    
    Also tried as "su -"

    Still failed


    satimis
     
  3. falko

    falko Super Moderator Howtoforge Staff

    I suggest you reinstall the system.

    Just specify a password. It doesn't matter which one.
     
  4. satimis

    satimis Member

    I have the same feeling that there is something wrong on this CentOS 4.4 amd64 box. I'll erase the complete OS later.

    No use, I tried half day without a breakthrough including groupremoving mysql and reinstalling them as per your howto. Still encountered the same problem.


    satimis
     
  5. satimis

    satimis Member

    Another round

    Hi folks,

    Erased the complete HD and started another round according to;
    http://www.howtoforge.com/perfect_setup_centos_4.4

    All steps went through w/o complaint.

    Coming to;
    http://www.howtoforge.com/perfect_setup_centos_4.4_p4

    # mysqladmin -u root password myrootsqlpassword
    went through w/o complaint

    # mysqladmin -h server1.example.com -u root password myrootsqlpassword (assuming it is ONE line)
    Code:
    mysqladmin: connect to server at 'server1.example.com' failed
    error: 'Lost connection to MySQL server during query'
    
    # cat /etc/hosts
    Code:
    127.0.0.1            localhost.localdomain  localhost
    192.168.0.100   server1.example.com  server1
    
    Pls advise which file I have to check? TIA


    Edit:
    I found following thread;
    http://www.howtoforge.com/forums/showthread.php?t=4078&highlight=mysqladmin+server1.example.com

    To my understanding I suppose skipping to run "mysqladmin -h server1.example.com -u root password myrootsqlpassword"


    on /etc/sysconfig/network-scripts/ifcfg-eth0
    IPADDR=192.168.0.180

    and

    on /etc/sysconfig/network-scripts/ifcfg-eth0:0
    IPADDR=192.168.0.101

    Is there any specific meaning on selecting the above IPADDR? On my router here "192.168.0.10" is reserved for Server. If changing "192.168.0.180" to "192.168.0.10" would this change affect the test?


    satimis
     
    Last edited: Mar 30, 2007
  6. falko

    falko Super Moderator Howtoforge Staff

    No, there was nothing wrong with the system, but you did something wrong, and telling you how to fix it would have taken longer than just reinstalling the system. :p

    Yes, skip this step for now. Later on you can use phpMyAdmin to check out which hostname is saved in the mysql.user table in the field "Host" (will be different from server1.example.com because otherwise your command would have succeeded).


    You don't need to create a virtual IP address. This is just an example for people that need it.
     
  7. satimis

    satimis Member

    Fail to start proftpd

    Hi folks,

    Section 12 ProFTPd

    # /etc/init.d/proftpd start
    Code:
    Starting proftpd: - getaddrinfo 'host.satimis.com' error: Name or service not known
    
    - warning: unable to determine IP address of 'host.satimis.com'
    - error: no valid servers configured
    - Fatal: error processing configuration file '/etc/proftpd.conf'
                                                                             [FAILED]
    
    Pls advise how to fix it. TIA



    Edit-1:

    I fixed my problem by putting "host.satimis.com host" to replace "localhost.localdomain localhost" on /etc/hosts. Thereafter proftpd started.


    Edit-2
    I completed the rest part according to the tutorial without problem. Tks falko for your nice howto-tutorial.


    Hi folks,

    1)
    Are there documents explaining the commands on the howto-tutorial mentioned instead of googling on each command or going through the respective site of each package? Man is too brief on their explanation.

    2)
    Is there a ISPConfig installation/config howto, other than follow;
    http://wiki.vpslink.com/index.php?title=ISPConfig

    ???


    TIA


    A further thought - ispconfig vs ravencore

    http://www.ravencore.com/

    What will be your opinion?



    B.R.
    satimis
     
    Last edited: Mar 31, 2007
  8. falko

    falko Super Moderator Howtoforge Staff

Share This Page