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