They should usually all be different.
The username and password for MySQL when running Observium scripts is taken from config.php, the lines near the top of that file. These should match what you configured for the Observium user a couple of steps earlier.
adam. On 09/09/2015 11:30:20, Reuben Sankey reuben.sankey@gmail.com wrote: OK thanks,
There are 3 passwords I have (local OS login, mySQL root, mySQL observium) - should they all be the same?
It seems to try to use my local OS user account (via sudo) to access run the update.php (i.e. it doesn't ask me for a username or password for mySQL).
What should I change / how should I change it?
Thanks again,
R
Regards
Reuben
On Wed, Sep 9, 2015 at 9:51 PM, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote:
Hi Reuben, It seems that your config.php doesn't have the same mysql user/password as what you configured earlier. Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 9 September 2015 06:48:58 Reuben Sankey <reuben.sankey@gmail.com [mailto:reuben.sankey@gmail.com]> wrote: Or from /opt/observium;
reuben@ubuntu-Observium-1:/opt/observium$ sudo php includes/update/update.php [sudo] password for reuben: MySQL Error: Access denied for user 'USERNAME'@'localhost' (using password: YES)
R
Regards
Reuben
On Wed, Sep 9, 2015 at 4:47 PM, Reuben Sankey <reuben.sankey@gmail.com [mailto:reuben.sankey@gmail.com]> wrote:
Thanks,
Changed to putty / ssh.
Next issue:
Setup the MySQL database and insert the default schema: php includes/update/update.php
error message (tried using sudo, tried a machine and service restart):
Could not open input file: includes/update/update.php
Observium dir contents:
reuben@ubuntu-Observium-1:~$ cd /opt/ reuben@ubuntu-Observium-1:/opt$ cd observium/ reuben@ubuntu-Observium-1:/opt/observium$ ls add_device.php delete_device.php LICENSE snmp.conf.example adduser.php discovery.php mibs snmpd.conf.example check-errors.php housekeeping.php poller.php snmptrap.php check-services.php html poller-wrapper.py syslog.php config.php includes README tests config.php.default INSTALL rename_device.php update config_to_json.php irc.php scripts reuben@ubuntu-Observium-1:/opt/observium$
Thanks again,
R
Regards
Reuben
On Wed, Sep 9, 2015 at 9:59 AM, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote:
You should ssh to the system after its installed rather than the vsphere cliebt. Life is way too short to do this stuff by hand ;) Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 8 September 2015 22:57:33 Reuben Sankey <reuben.sankey@gmail.com [mailto:reuben.sankey@gmail.com]> wrote: Thanks,
missing the semicolon as you mentioned was the issue and redoing it helped
[Inline image 3]
P.S. I cannot copy or paste text into the VMWare vSphere client sorry - so reverted to screenshotting
Thanks
R.
Regards
Reuben
On Wed, Sep 9, 2015 at 9:11 AM, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote:
Indeed. You need to be very careful typing commands from documentation, it's so easy to make mistakes! In this case you seem to have duplicated the second part of the statement, likely because you missed the semicolon and typed it again with the semicolon, leading to a duplicate! Just do that part again, and it'll be fine! Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 8 September 2015 22:03:10 Tom Laermans <tom.laermans@powersource.cx [mailto:tom.laermans@powersource.cx]> wrote: Hi Reuben,
You assume correctly. However, the statement you entered in your mysql client is not the one from our documentation (so the syntax error is logical) - please try again.
Tom
PS: you could just paste the text instead of a screenshot of text...
On 08/09/2015 22:57, Reuben Sankey wrote:
Hi,
Im setting up Observium on ubuntu server 14.04.1 LTS. Using the guide: http://www.observium.org/docs/debian_ubuntu/ [http://www.observium.org/docs/debian_ubuntu/]
All going well until I get to the SQL database bit and have issues: mysql -u root -p <mysql root password> mysql> CREATE DATABASE observium DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; mysql> GRANT ALL PRIVILEGES ON observium.* TO 'observium'@'localhost' -> IDENTIFIED BY '<observium db password>';
I assume the <observium db password> is to be replaced with a password? [Inline image 1]
Thanks and regards,
Reuben
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium%40observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org [mailto:observium@observium.org] http://postman.memetic.org/cgi-bin/mailman/listinfo/observium [http://postman.memetic.org/cgi-bin/mailman/listinfo/observium]
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium