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

On 9 September 2015 06:48:58 Reuben Sankey <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> 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> 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

On 8 September 2015 22:57:33 Reuben Sankey <reuben.sankey@gmail.com> wrote:

Thanks,

missing the semicolon as you mentioned was the issue and redoing it helped

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> 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

On 8 September 2015 22:03:10 Tom Laermans <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/

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?

Thanks and regards,

Reuben

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http:/​/​postman​.​memetic​.​org/​cgi-bin/​mailman/​listinfo/​observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http:/​/​postman​.​memetic​.​org/​cgi-bin/​mailman/​listinfo/​observium

_______________________________________________
observium mailing list
observium@observium.org
http://postman.memetic.org/cgi-bin/mailman/listinfo/observium

_______________________________________________
observium mailing list
observium@observium.org
http:/​/​postman​.​memetic​.​org/​cgi-bin/​mailman/​listinfo/​observium