-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 01/08/2014 4:53 PM, Adrian Sevcenco wrote: > On 08/01/2014 04:46 PM, Petru Ratiu wrote: >> On Fri, Aug 1, 2014 at 4:19 PM, Adrian Sevcenco <[email protected]> >> wrote: >> >>> On 08/01/2014 03:44 PM, Bogdan-Stefan Rotariu wrote: >>>> >>>>> On Aug 1, 2014, at 15:27, Adrian Sevcenco <[email protected]> >>>>> wrote: >>>>> >>>>> in zabbix.conf.php am serverul de mysql pus cu 127.0.0.1 >>>> >>>> 127.0.0.1 si localhost nu sunt acelasi lucru, localhost se conecteaza >>>> pe socket, 127.0.0.1 pe tcp, pune localhost si in config sau adauga >>>> allow si de la 127.0.0.1 >>> ok... >>> 1. am facut grant si pentru 127.0.0.1 (sa fie) >>> grant all privileges on zabbix.* to 'zabbix'@'localhost' with grant >>> option; >>> grant all privileges on zabbix.* to 'zabbix'@'127.0.0.1' with grant >>> option; >>>
ca sa creezi user cu drpturi doar pe tabela lui: CREATE USER 'teste'@'%' IDENTIFIED BY '*****'; GRANT USAGE ON *.* TO 'teste'@'%' IDENTIFIED BY '*****'; CREATE DATABASE `zabbix` ; GRANT ALL PRIVILEGES ON `zabbix`.* TO 'teste'@'%'WITH GRANT OPTION; unde % echivalent cu orice host >> >> doua comentarii (nu stiu eu zabbix, da' la mysql cat de cat stiu de-un 5): >> - la astea trebuie si identified by 'mycoolpassword' (probabil de-aia nu-ti >> merge) > astea le-am dat primele dar nu le-am luat la copy-paste (daca nu le > aveam nu puteam sa fac "mysql -u zabbix zabbix -p", nu?) > >> - "with grant option" inseamna ca-i dai voie sa faca alti useri, nu cred ca >> asta vrei. > eu nu stiu mysql de loc .. dar am vazut comanda pe undeva si in > disperarea mea am bagat si asta ... doar sa mearga :D > > momentan imi e paralel .. serverul de mysql oricum nu e disponibil remote.. > > Problema cea mai mare e ca pot sa ma conectez din cli la mysql si > zabbixul nu poate .. daca nu puteam nici eu macar aveam ceva de > corectat.. dar asa nu stiu ce face si ce nu face zabbix-ul... > > Multumesc! > Adrian > > > > > > _______________________________________________ > RLUG mailing list > [email protected] > http://lists.lug.ro/mailman/listinfo/rlug <?php // Zabbix GUI configuration file global $DB; $DB['TYPE'] = 'MYSQL'; $DB['SERVER'] = 'localhost'; $DB['PORT'] = '0'; $DB['DATABASE'] = 'zabbix'; $DB['USER'] = 'teste'; $DB['PASSWORD'] = '******'; // SCHEMA is relevant only for IBM_DB2 database $DB['SCHEMA'] = ''; $ZBX_SERVER = 'stats.my-dom.ro'; $ZBX_SERVER_PORT = '80'; $ZBX_SERVER_NAME = 'Stats Central'; $IMAGE_FORMAT_DEFAULT = IMAGE_FORMAT_PNG; ?> Eu nu il am pe centos 6.5 dar nu am avut probleme de conectare la mysql... Mai verifica o data daca in fisierul zabbix.conf.php e parola corecta cu cea setata in mysql eventual mai schimba o data parola. - - pentru verificare din linie: bash# mysql -uteste -p Daca nu te descurci cu mysql in linie de comanda cred ca e mai usor pentru tine sa instalezi phpmyadmin ( interfata web ) - -- Bogdan T [email protected] www.direkt.ro -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.19 (MingW32) Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJT28qyAAoJEJQyDft8z6osqe0IAIwfGnf057TN1cFyYU5Q2tjZ nTgwU8juCE3NOJx5lhFYu8Ig2UwUnJpNJYSzb8NOxiyjxQzjlXImnCwS2i8JnC/E VKAwfY7KYu0JTjN4vRpNO/5Mn3nh6uPvK0dE7dZmnA9v8WaWnGH8pRkA600Sm05x TbwvnsnUZ053ApLGRsE5MveBIWMkBIhnY2SH3YTo7IRCe+jW99JQfWy0tTYQ5ckP DzoIM2tSbXIO87fxQnk/OgvNHmbUBTInmDWRSTfDkrAXRFRXzzyEqctdOgN7Uif6 BptQoHCkgJBOJpi3uMW/KIvOfg9leNs/2drOYi8EwcowJnMuL3fqlTtcfoC4hmw= =rsvj -----END PGP SIGNATURE----- _______________________________________________ RLUG mailing list [email protected] http://lists.lug.ro/mailman/listinfo/rlug
