Ad Widget

Collapse

complete noob, totally lost...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • twiztid
    Junior Member
    • Mar 2007
    • 6

    #1

    complete noob, totally lost...

    Hi, complete newb here, some experience with linux, but none with mysql nor zabbix, i followed the directions in the wiki almost to a T.

    Everything goes along with no problems, only thing thats i got that was different was when i reached this stage, install zabbix-server-mysql snmpd, it also installs dbconfig (dont know what this is, but it says its required) and asks if i want dbconfig to create the database for me, or would i like to do it myself, dont know what to do at this point, i've tried both and neither have worked.

    So, with either option selected, I continue along the installation, and everything else goes seamlessly. Except that it never asks for my admin pass nor my zabbix pass.

    I goto 127.0.0.1/zabbix in my browser, and i get this error:
    Fatal error: Call to underfined function: mysql_pconnect() in /usr/share/zabbix/include/db.inc.php on line 32

    Ya I don't know what to do at this point, maybe a more in depth installation for complete noobs like myself would be helpful.

    EDIT:
    I've done more searching throughout the forum, ive added the line extension=mysql.so and it still doesnt work...I am at a loss. And also when i try and check mysql:
    zabbix:/home/zabbix# mysql -u zabbix -p ****** -h localhost
    Enter password:
    ERROR 1045 (28000): Access denied for user 'zabbix'@'localhost' (using password: NO)
    Last edited by twiztid; 31-03-2007, 08:18.
  • twiztid
    Junior Member
    • Mar 2007
    • 6

    #2
    ok, i've managed to fix that first error, i had installed php5-mysql and not php4-mysql.

    But now there's a new error. I'm guessing it has something to do with permissions, but no idea how to change it.

    Warning: mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'zabbix'@'localhost' (using password: YES) in /usr/share/zabbix/include/db.inc.php on line 32

    Warning: mysql_select_db() [function.mysql-select-db]: Access denied for user 'www-data'@'localhost' (using password: NO) in /usr/share/zabbix/include/db.inc.php on line 33

    Warning: mysql_select_db() [function.mysql-select-db]: A link to the server could not be established in /usr/share/zabbix/include/db.inc.php on line 33
    Error connecting to database [Access denied for user 'www-data'@'localhost' (using password: NO)]

    Comment

    • twiztid
      Junior Member
      • Mar 2007
      • 6

      #3
      so ive managed the get the frontend up and running, can access it from a remote PC. But the config in the frontend says the zabbix server is not running. WHY?!?! HOW?!?!

      and when i try to populate the database i get this;
      zabbix:/usr/share/zabbix-server# mysql -u zabbix -p zabbix < /usr/share/zabbix-server/schema.sql
      Enter password:
      ERROR 1050 (42S01) at line 25: Table 'services' already exists

      zabbix:/usr/share/zabbix-server# mysql -u zabbix -p zabbix < /usr/share/zabbix-server/data.sql
      Enter password:
      ERROR 1062 (23000) at line 30: Duplicate entry '1' for key 1

      Comment

      • rafael
        Junior Member
        • Sep 2006
        • 11

        #4
        mysql_pconnect error How-to

        here is a link on how to fix mysql_pconnect errors.
        http://dev.mysql.com/doc/refman/5.0/en/old-client.html

        this error is occurring because php is using mysql 4.x version instead of 5.x. You have to convert the db to use the 4.x style password.

        Comment

        Working...