openqrm with lxc

Discussion in 'HOWTO-Related Questions' started by quinohe, Jan 10, 2011.

  1. quinohe

    quinohe New Member

    There is something i need to ask before i can go any further with my server.
    Although i completed the howto successfully.
    The howto used is this one;
    During the installation i get a warning:
    WARNING: include path for php has changed!                          
          libphp-adodb is no longer installed in /usr/share/adodb. New        
          installation path is now /usr/share/php/adodb.                      
          Please update your php.ini file. Maybe you must also change your    
          web-server configuration. 
    Need i do something with this?
    And if so, what is needed todo, this?
    ln -s /usr/share/adodb /usr/share/php/adodb 

    When you need to login to mysql there is stated you use the password created in E6.2,
    i think this must be E6.1.

    Just to be sure, is this mysql code correct, and enough?

    mysql> create database openqrm;
    Query OK, 1 row affected (0.01 sec)
    mysql> GRANT ALL PRIVILEGES ON `openqrm`.* TO 'root'@'localhost' IDENTIFIED BY 'passwrd' WITH GRANT OPTION ;
    Query OK, 0 rows affected (0.01 sec)
    mysql> flush privileges;
    Query OK, 0 rows affected (0.01 sec)
    mysql> quit
    tail -f /var/log/messages
    Jan 10 12:08:00 openqrm logger: openQRM-cmd-queu NOTICE : Running 5c42b1fd1dc22f49a426252baf3c74b0 : /usr/share/openqrm/bin/dbclient -K 10 -y -i /usr/share/openqrm/etc/dropbear/dropbear_rsa_host_key -p 1667 [email protected] "/usr/share/openqrm/bin/openqrm-cmd sed -i -e 's/^OPENQRM_DATABASE_SERVER=.*/OPENQRM_DATABASE_SERVER=localhost/g' -e 's/^OPENQRM_DATABASE_NAME=.*/OPENQRM_DATABASE_NAME=openqrm/g' -e 's/^OPENQRM_DATABASE_USER=.*/OPENQRM_DATABASE_USER=root/g' -e 's/^OPENQRM_DATABASE_PASSWORD=.*/OPENQRM_DATABASE_PASSWORD=secret/g' /usr/share/openqrm/etc/openqrm-server.conf"
    Jan 10 12:08:03 openqrm logger: openQRM engine: Running as root cmd : sed -i -e s/^OPENQRM_DATABASE_SERVER=.*/OPENQRM_DATABASE_SERVER=localhost/g -e s/^OPENQRM_DATABASE_NAME=.*/OPENQRM_DATABASE_NAME=openqrm/g -e s/^OPENQRM_DATABASE_USER=.*/OPENQRM_DATABASE_USER=root/g -e s/^OPENQRM_DATABASE_PASSWORD=.*/OPENQRM_DATABASE_PASSWORD=secret/g /usr/share/openqrm/etc/openqrm-server.conf
    Jan 10 12:08:03 openqrm logger: 
    Jan 10 12:08:04 openqrm logger: openQRM-cmd-queu NOTICE : Running 7a14a88ffd1df4e68349292467dc08a5 with custom cmd-timeout 60
    Jan 10 12:08:04 openqrm logger: openQRM-cmd-queu NOTICE : Running 7a14a88ffd1df4e68349292467dc08a5 : /usr/share/openqrm/bin/dbclient -K 10 -y -i /usr/share/openqrm/etc/dropbear/dropbear_rsa_host_key -p 1667 [email protected] "/usr/share/openqrm/bin/openqrm-cmd /usr/share/openqrm/bin/openqrm init_config"
    Jan 10 12:08:08 openqrm logger: openQRM engine: Running as root cmd : /usr/share/openqrm/bin/openqrm init_config
    Jan 10 12:08:10 openqrm openQRM init-config[28909]: Initialyzing the openQRM Database
    Jan 10 12:08:14 openqrm openQRM init-config[29090]: ERROR: Initialyzing the openQRM Database failed !
    Jan 10 12:08:14 openqrm logger: Initializing the openQRM-database ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) Reloading configuration files for periodic command scheduler: cron.
    Jan 10 12:14:45 openqrm nagios3: Auto-save of retention data completed successfully.
    The login page for openqrm.localdomain works, but i get no further than step3,
    where it's asking for used database and password.

    Still in the process of learning, i really need some help!

    Thanks in advance,
    Last edited: Jan 11, 2011
  2. quinohe

    quinohe New Member


    Think i found something,
    It is about the openqrm password for mysql.

    I used a password looking a lot like this one: '[email protected]$word'.
    But when i use this one, it works: '89PasSword'
    I can login to the website with the last one.

    What i find out was that some characters are used in other ways,
    it seems to be about quoting and escaping.
    It took me all day to solve that puzzle!

    But still don't know how all the characters are used,
    it's a bit overwhelming this mysql
    Guess i will figure it out in the end.:D

    Still like to use a more secure passwrd, like the first one!
    Didn't find a suitable solution, says i should quote '*' , and thats what i did.:confused:

    So, now a have access to the website there is still something wrong.
    When i try to enable a plug-in, for instance nagios, there is a message:
    Timeout while enabling nagios3
    In fact none of the plugins will enable.


    Well figured this one out to.
    When u are using a bridged setup, consider changing your openqrm server interface from eth0 into br0.
    You do this by editing /usr/share/openqrm/etc/openqrm-server.conf.
    You should do this before you execute 'make start'.

    Everything is working now, all the plugins are working.
    Took me some time, and answered all my own.:)

    Hope this is of some use to someone else.

    Last edited: Jan 12, 2011

Share This Page