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 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
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
[image: 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 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? > [image: Inline image 1] > > Thanks and regards, > > Reuben > > > _______________________________________________ > observium mailing listobservium@observium.orghttp://postman.memetic.org/cgi-bin/mailman/listinfo/observium > > > _______________________________________________ > observium mailing list > 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
observium mailing list 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
observium mailing list 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
