Ubuntu Servers :: Syslong-ng -> Mysql For Cacti Syslog Plugin Setup?
Aug 16, 2011
I guess with major changes to syslog-ng, php-syslog going to licensing cost, and major overhaul to the syslog plugin with cacti - alot of documention was either disjointed, outdated or I just couldn't find it.this was performed on an 11.04 Ubuntu Server tall. I already had Cacti up and running and just needed to make it also a syslog collector.This guide assumes you already have mysql running, and cacti is already in place. If something looks wrong - please correct me. I am doing this from memory - trying to remember what all I had to do, and not a super admin.Required ubuntu install packages:libdbd-mysql syslog-ngcacti install packages:[URL]
Stop syslog-ng if you want. Changes should not take effect until you restart it.Should save the default syslog-ng configuration if you want to be safe. Below is the absolute minimum you need to get this working.Configuration on ubuntu is location in /etc/syslog/syslog-ng.conf Also make sure you fill in the proper username and password for mysql.
Code:
@version: 3.1
#Bare minimum syslog-ng configuration
[code]....
View 1 Replies
ADVERTISEMENT
Jul 23, 2009
I have just migrate from UBUNTU to Fedora 11. Tried to install cacti by 'yum install cacti' everything presumably went correctly. But when trying to get cacti running on a browser it's showing:
Code:
FATAL: Cannot connect to MySQL server on 'localhost'. Please make sure you have specified a valid MySQL database name in 'include/config.php'
Checked everything else including installing new mysqld-server (using yum install) and still not working.
Trying the installation steps from [URL], but could not find where mysql was installed. Mysqld should already be running, cos I can see it using webmin-server-mysql. Did a test as shown on [URL], everything seems ok. No major problem when using UBUNTU with apt-get install.
View 8 Replies
View Related
Apr 25, 2010
I am trying to set up a webserver using Ubuntu server with the EHCP plugin. I have it working and can access the EHCP page by using the IP address on my local network (192.168.0.4) So far so good. I then set uo a domain using the Domain add new(custom)from the sidebar. I provided the following info:
domainname - learner
Panel - me
Panel password - me2
Ftp user - DACL
ftp password cullompton
Great I have now got a folder structure including httpdocs for that domain, I can also use filezilla to upload webpages etc to that folder, and have uploaded a page called index.htm One problem remains - what address do I type into the web browser to see the webpage. I've tried 192.168.0.4/learner which is what I expected to work.this will only ever be used as a web server on a local network, never on the WAN.
View 9 Replies
View Related
Sep 7, 2010
mention an example step by step procedure for adding a PLUGIN in Cacti. And also mention what does a PLUGIN serve in Cacti ? I am a newbie to cacti please consider my silly questions.
View 1 Replies
View Related
Jan 6, 2010
I downloaded template for cacti to make graphs from eth interface.is imported and showed in graph templates, but when I choose to creat new graph, it is not there.
View 2 Replies
View Related
Oct 19, 2009
is this command exact or do I replace anything with my own setu
" yum install mysql mysql-devel mysql-server "
who can't tell what has to be changed for "My server name" and "my setup"
View 8 Replies
View Related
Jun 12, 2010
I have a LAMP on Ubuntu 10.4 The MySQL is binded to a specific IP of a lan. When the system starts, the MySQL fails to start returning this error
[Code]...
View 3 Replies
View Related
Mar 26, 2010
I set up a servber on my local machine, & also PHp - Both working fine.I'm trying to load up MYSQL i have installed it, & *can* start/stop the server. however if I do anything else with it, I get this error :-
Quote:
root@gordon-desktop:~# sudo mysqladmin -u root -h localhost password MYPASSWORD
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: NO)'
Query :-
1) How do I know MYSQL is actually active ? (apart from the message it says that its statrted (or stopped).
2) Is there a way to
a) Find out the usernames that are recorded on the MYSQL server ?
b) set / RESET the 'root' username (I know MYSQL root user is different to PC root user)
c) anything else I can do on the PHP / website code to see if MYSQL is working
(as yet, no tables / databases etc have been set up - as I can't get past this error message - I get the same error when setting up a database.)
Ps I did allow my usermname (when logged in to ubuntu) to edit / create files in the /usr/www/ directory (but it is still OWNED by 'root' - that directory)
View 4 Replies
View Related
Mar 11, 2011
how to setup an Active/Active Load Balanced and High Available (If one of the nodes is down the system still runs) MySQL cluster. I have found quite a few howto's but I have some things unclear in my mind. I found a few solutions like this one: [URL] or this: [URK] Those are using two or four MySQL nodes, two Load Balancers to avoid a single point of failure but only one MySQL cluster management server. What happens if the MySQL cluster management fails?
I have also found a "MySQL Master-Master Circular Replication" technique but from what I read, with this option there is a chance that conflicts will arise if node A and node B both insert an auto-incrementing key on the same table.
View 1 Replies
View Related
Jan 7, 2011
My syslog is showing a lot of entries like the following: Quote:
[Code]....
I think I have messed up my media setup:
[Code]....
View 4 Replies
View Related
Jan 24, 2011
Ive been asked by my boss to set up a ubuntu machine that will be used as a syslog server. He wants a GUI as a posed to a CLI. He would also perfer to have it non web based. We already have cati installed but he is not keen on the syslog side of that. Does anyone know of any other syslog programs?
View 1 Replies
View Related
Jun 17, 2010
I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this
* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.
So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.
View 1 Replies
View Related
Jan 14, 2011
i was trying to allow remote access to mysql by following mysql was running perfectly until i got here :
Code:
/sbin/iptables -A INPUT -i eth0 -s 192.168.1.0/24 -p tcp --destination-port 3306 -j ACCEPT
i changed my.cnf bind-address line to : "bind-address = 127.0.0.1" and nothing
[code]....
View 4 Replies
View Related
May 2, 2010
On this Ubuntu 8.04.4 LTS server, I want to log the messages from a Linksys router. So I made this change to "/etc/init.d/sysklogd" SYSLOGD="-r" Then in "/etc/syslog.conf" I added the following to the top of the file: Code: if $fromhost isequal 'Linksys' then /var/log/Linksys.log & ~
Then I rebooted the server. But there is no "/var/log/Linksys.log" file.
View 4 Replies
View Related
Aug 12, 2010
When building 8.04 servers, I reconfigure snmpd's logging options to prevent copious low priority messages being logged whenever our network management workstation polls them. I edit /etc/default/snmpd and change line 11 from:
Code:
SNMPDOPTS='-Lsd -Lf /dev/null ...'
to:
[code]....
View 2 Replies
View Related
Nov 9, 2010
I wish it was under better circumstances...very morning at 6:25am syslog-ng stops logging, right after it attempts to log rotate. its odd... the daemon doesnt die... it gets a new PID, but doesnt write the output to /var/log/syslog.Yet if I manually restart or reload syslog-ng it works great... its just like it doesnt like the logrotate...I have googled around and tried a few things...first I changed the postrotate in the logrotate.d/syslog-ng
--------/etc/logrotate.d/syslog-ng---------
/var/log/syslog {
rotate 7
[code]....
View 2 Replies
View Related
Jul 13, 2011
Is there a way to force the syslog ie /var/log/messages to restart at say 1:00 am instead of 7:55 or so each morning?
View 4 Replies
View Related
Mar 10, 2011
I'm guessing its possible but I can't seem to find any documentation on how to do this.I've tried playing with entries at the top of my syslog.conf file like:
*.* @172.20.10.1 # 1 server, works file
*.* @172.20.10.1,172.20.20.11 # doesn't work
*.* @172.20.10.1 172.20.20.11 # nor this
*.* @172.20.10.1,@172.20.20.11 # nor this
*.* @172.20.10.1 @172.20.20.11 # nor this
View 3 Replies
View Related
Dec 7, 2010
This server (running suse 11.1) was approaching a year of uptime when last night it became unresponsive @ max cpu and was given a hard reset. Suddenly mysql no longer works, it fails to secure a socket and shuts down. The error log says it can't load a bunch of stuff in /usr/lib/mysql/plugin/ because there's no such directory, then aborts after the unknown option --skip-federated. If I comment out skip-federated in /etc/my.cnf mysql will start, but users get access denied--I can't say if the same is true for root, I don't have root credentials for mysql.
This is all very funny because I need to finish/present my final project in a few hours and also happen to be the server admin, yet haven't been able to dig myself out of this hole, 5 hours has produced virtually no progress.
View 1 Replies
View Related
Dec 11, 2010
I am looking for an open source syslog server which accumulate the each and every log of Windows, Solaris, Linux and network devices. Currently I am using Syslog-ng which is not fulfiling my requirement in Windows clients, as I need the logs of every action which user performed after logon.
View 2 Replies
View Related
Mar 9, 2010
I'm running a syslog server on ubuntu 7.04. Can I somehow have it email me if it finds a certain thing in the log? For example. I'm running a PRI and when the PRI goes down, it logs a "DEACTIVED" in the log. I would like an email telling me this so I know to get on it and fix it.
View 9 Replies
View Related
Sep 16, 2010
I recently upgraded a Ubuntu server from version 8.04 to 10.04 and after a reboot the webmin and syslog-ng server do not start at boot anymore. I can start them manually by doing /etc/init.d/webmin start and /etc/init.d/syslong-ng start and everything works fine until I root again. Granted this machine is rarely rebooted but when it is, I don't want to have to remember to start these services. I have tried a full removal of syslog-ng and reinstall but to no avail. The entries are in the rc directories like they should and the links are valid.
View 1 Replies
View Related
Jan 28, 2011
I am running a headless Ubuntu 10.04 server with the 2.6.32-28-generic kernel. For what I can figure out no single direct cause I get a high load average and the following syslog output at random intervals. Generally the load average will drop back down to normal however the kernel errors will still continue What little I have been able to find has pointed to memory issues. I am not totaly convinced this is the cause as the server will be showing >50% free when the errors are happening.
[code]...
View 2 Replies
View Related
Apr 19, 2011
How do clients handle offline syslog servers?Will the log files be buffered locally to be sent to the syslog server when it comes back online, or will any log data generated during downtime be lost in cyber space?
View 1 Replies
View Related
Jul 23, 2015
I just switched form MySQL to MariaDB for my WordPress website which is run with Apache, but I had a little problem logging in. So, I backed up all of my databases, deleted all of MySQL's configuration files, and reinstalled MariaDB. However, now I'm completely unable to login to MariaDB.
Whenever I try to, it says: ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded.
Also, why didn't MariaDB ask me to set up a password during the installation process like MySQL does?
View 8 Replies
View Related
Mar 31, 2010
I have a load balancer with 2 web servers behind it. The web servers rsync with cloud storage to update their apache directories 1 time every hour. Apache is just running php pages that pull/push data to a DB so they dont need to be updated that often. However I need to figure out how to implement a Master/Master MySQL setup to have my web servers point to for the PHP stuff. I need to implement it without having a single point of failure. The Load balancers are useless for failover as they only detect availability based on Ping request. So putting a master/master setup behind a Load Balancer is out. what is the best way to setup the master/master mysql in a HA setup without the use of a load balancer provided by the host?
View 2 Replies
View Related
Feb 14, 2011
turn up the level of logging that my DHCP Server is writing to SYSLOG?I can't seem to find a syslog.conf file to edit.
View 1 Replies
View Related
Jan 17, 2010
Currently Im having a syslog server that consolidate firewall logs on port 514 udp. Im also having a IDS device that I wish to push its logs to this particular syslog server so that I can retrieve my IDS logs on this server as well.
Is it possible to do so?Having syslog listening on port 514 for both firewall and IDS logs? If it is possible will the logs be recorded in a single log file?Or will it be recorded in a separate log file ie. firewall.log, IDS.log etc?? I wish to have them in separate individual log files or else there will be hard time segregating the log entries in a single file. Can anyone advice on how to achieve this??
View 2 Replies
View Related
Mar 14, 2010
I ended up setting up a basic linux file server as a pdc for that office. Our main office is a windows 2000 ads domain. The two offices are connected with a vpn. I only have two users at the new location so I simply have the linux and samba usernames/passwords setup manually. I would like to know if it is possible to setup a domain trust between the two sites so I don't have to create a username/password in the remote site for every user at the main office to access. I did some searching but came up empty.
View 5 Replies
View Related
May 5, 2009
trying to replace syslog with syslog-ng. When I:
yum erase syslog,
wants to remove everything else that (presumably) has syslog as a dependency. how do I replace the dependency on syslog with a dependency on syslog-ng?
View 3 Replies
View Related
