Initial setup on UIbuntu - SQL syntax error when creating the observium DB
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
You put the identified by part in twice?
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 8 September 2015 21:57:32 Reuben Sankey reuben.sankey@gmail.com 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 list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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 -uroot -p <mysql root password> mysql>CREATE DATABASE observium DEFAULT CHARACTER SETutf8 COLLATE utf8_general_ci; mysql>GRANT ALLPRIVILEGES ONobservium.*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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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 -uroot -p <mysql root password> mysql>CREATE DATABASE observium DEFAULT CHARACTER SETutf8 COLLATE utf8_general_ci; mysql>GRANT ALLPRIVILEGES ONobservium.*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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
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
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
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
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
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
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
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
OK thanks,
I went into the config.php file and it was default so I changed the username and password field and now that's fixed.
Next issue: is this OK?
*Command* reuben@ubuntu-Observium-1:/opt/observium$ apache2ctl restart *Error* AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message httpd not running, trying to start (13)Permission denied: AH00072: make_sock: could not bind to address [::]:80 (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down AH00015: Unable to open logs Action 'restart' failed. The Apache error log may have more information. reuben@ubuntu-Observium-1:/opt/observium$
Other than that the commands all worked fine
Logging via web page goes here (below - default Apache page), so I assume the error above affects this.
Thanks again,
[image: Inline image 1]
Regards
Reuben
On Wed, Sep 9, 2015 at 10:35 PM, Adam Armstrong adama@memetic.org wrote:
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 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
_______________________________________________ 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
You need to be root (or use sudo) to restart apache!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 14 September 2015 09:23:29 Reuben Sankey reuben.sankey@gmail.com wrote:
OK thanks,
I went into the config.php file and it was default so I changed the username and password field and now that's fixed.
Next issue: is this OK?
*Command* reuben@ubuntu-Observium-1:/opt/observium$ apache2ctl restart *Error* AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message httpd not running, trying to start (13)Permission denied: AH00072: make_sock: could not bind to address [::]:80 (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down AH00015: Unable to open logs Action 'restart' failed. The Apache error log may have more information. reuben@ubuntu-Observium-1:/opt/observium$
Other than that the commands all worked fine
Logging via web page goes here (below - default Apache page), so I assume the error above affects this.
Thanks again,
[image: Inline image 1]
Regards
Reuben
On Wed, Sep 9, 2015 at 10:35 PM, Adam Armstrong adama@memetic.org wrote:
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 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
_______________________________________________ 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
Ok yes thanks, I clicked and tried sudo, but same initial error (excluding the restart permission);
AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
but found that adding this sorts that error:
$ echo "ServerName localhost" | sudo tee /etc/apache2/conf-available/fqdn.conf && sudo a2enconf fqdn
However - Apache2 page still shows when browsing to the IP address.
Thanks R
Regards
Reuben
On Mon, Sep 14, 2015 at 11:14 PM, Adam Armstrong adama@observium.org wrote:
You need to be root (or use sudo) to restart apache!
Adam.
Sent with AquaMail for Android http://www.aqua-mail.com
On 14 September 2015 09:23:29 Reuben Sankey reuben.sankey@gmail.com wrote:
OK thanks,
I went into the config.php file and it was default so I changed the username and password field and now that's fixed.
Next issue: is this OK?
*Command* reuben@ubuntu-Observium-1:/opt/observium$ apache2ctl restart *Error* AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message httpd not running, trying to start (13)Permission denied: AH00072: make_sock: could not bind to address [::]:80 (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:80 no listening sockets available, shutting down AH00015: Unable to open logs Action 'restart' failed. The Apache error log may have more information. reuben@ubuntu-Observium-1:/opt/observium$
Other than that the commands all worked fine
Logging via web page goes here (below - default Apache page), so I assume the error above affects this.
Thanks again,
[image: Inline image 1]
Regards
Reuben
On Wed, Sep 9, 2015 at 10:35 PM, Adam Armstrong adama@memetic.org wrote:
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 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
_______________________________________________ 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 http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
This is because your virtual host hasn't been properly configured. Didn't you have this same problem earlier, and we already fixed it?
adam. On 14/09/2015 21:39:13, Reuben Sankey reuben.sankey@gmail.com wrote: Ok yes thanks, I clicked and tried sudo, but same initial error (excluding the restart permission); AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message
but found that adding this sorts that error:
$ echo "ServerName localhost" | sudo tee /etc/apache2/conf-available/fqdn.conf && sudo a2enconf fqdn
However - Apache2 page still shows when browsing to the IP address.
Thanks R
Regards
Reuben
On Mon, Sep 14, 2015 at 11:14 PM, Adam Armstrong <adama@observium.org [mailto:adama@observium.org]> wrote:
You need to be root (or use sudo) to restart apache! Adam. Sent with AquaMail for Android http://www.aqua-mail.com [http://www.aqua-mail.com] On 14 September 2015 09:23:29 Reuben Sankey <reuben.sankey@gmail.com [mailto:reuben.sankey@gmail.com]> wrote: OK thanks,
I went into the config.php file and it was default so I changed the username and password field and now that's fixed.
Next issue: is this OK?
Command reuben@ubuntu-Observium-1:/opt/observium$ apache2ctl restart
Error AH00558: apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1. Set the 'ServerName' directive globally to suppress this message httpd not running, trying to start (13)Permission denied: AH00072: make_sock: could not bind to address [::]:80 (13)Permission denied: AH00072: make_sock: could not bind to address 0.0.0.0:80 [http://0.0.0.0:80] no listening sockets available, shutting down AH00015: Unable to open logs Action 'restart' failed. The Apache error log may have more information. reuben@ubuntu-Observium-1:/opt/observium$
Other than that the commands all worked fine
Logging via web page goes here (below - default Apache page), so I assume the error above affects this.
Thanks again,
[Inline image 1]
Regards
Reuben
On Wed, Sep 9, 2015 at 10:35 PM, Adam Armstrong <adama@memetic.org [mailto:adama@memetic.org]> wrote:
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 [mailto: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 [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@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
participants (4)
-
Adam Armstrong -
Adam Armstrong -
Reuben Sankey -
Tom Laermans