Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jhala
  • Order by date
  1. jhala

    how does syslog-ng connect to mysql

    Here's an update... So I took out one of the destinations in the log line of the syslog-ng config. Restarted syslog-ng and it started working... and I only had one instance of the shell script in the process list... Then I went back and added the second destination again, log { source(net)...
  2. jhala

    how does syslog-ng connect to mysql

    damn, you're MONEY, thanks! I thought I read a configuration that had both...
  3. jhala

    how does syslog-ng connect to mysql

    In addition to logging to the mysqldb server, I am logging locally as well. And I see those logs being generated. I have also verified with a tcpdump. I don't understand why the second instance of the shell script is being generated. I killed them both off, and just ran ./syslog2mysql.sh &...
  4. jhala

    how does syslog-ng connect to mysql

    Thanks for the script. I've tried this previously, and it just sits there and doesn't send any data to the mysqldb server. On the syslog server, if I do ps -ef | grep mysql it returns: root 27707 27073 0 08:10 pts/1 00:00:00 /bin/bash ./syslog2mysql.sh root 27708 27707 0 08:10...
  5. jhala

    how does syslog-ng connect to mysql

    yeah, that doesn't make sense... you have to have the while loop in there...
  6. jhala

    how does syslog-ng connect to mysql

    I made the changes that you recommended, but I think there's a problem with the shell script because the established connections are not going away, just compounding... tcp 0 0 ip_of_mysqldb_server:3306 ip_of_syslog_server:35074 ESTABLISHED ... instead of being a...
  7. jhala

    how does syslog-ng connect to mysql

    I do see data in the tables. If I do a netstat -an from the mysqldb server I see many connections, maybe 28000 total! It seems they may be half open connections, or connections that just never finished or are finishing.... So as you say, they are getting queued up and taking time to finish...
  8. jhala

    how does syslog-ng connect to mysql

    I have a syslog server relaying packets to the mysqldb server. Whenever I try to connect to the database I get the following: # mysql -u root -p Enter password: ERROR 1040 (00000): Too many connections I have the above script by Patrick Danu running in cron: crontab -e -u root @reboot...
  9. jhala

    how does syslog-ng connect to mysql

    Thanks! I can't believe I didn't realize that... lol, I was just specifying the db, so how could it know where the db was if I didn't specify the host! Just did: mysql -u 'user' --password='password' -h 'ip_of_mysql_db_server' 'database_name' Also did a flush priv's. Thanks again
  10. jhala

    how does syslog-ng connect to mysql

    I've read the Debian link, but I'm still having issues configuring the mysql connection. I ran the command: mysql -u user --password="password" database_name OR mysql -u user database_name -p I type the password and it kicks back the error: ERROR 2002 (HY000): Can't connect to local MySQL...
  11. jhala

    how does syslog-ng connect to mysql

    Thanks for the reply. So there's nothing built into syslog-ng to make the mysql connection, and therefore I'm forced to have a script push the logs to the database?
  12. jhala

    how does syslog-ng connect to mysql

    I'm running syslog-ng v 1.6.11 on RHEL 4. I can log to local files with no problem. I want to also log to a mysql database. I have a mysql database server with a syslog database configured to receive logs. On the syslog-ng server, do I need mysql installed in order to make the mysql pipe...
  13. jhala

    Cloning a Hard Drive

    The drives are SATA. Thanks cndcadams. That is exactly what I did and it worked perfectly. And Thanks to everyone else who replied. It is greatly appreciated. Basically, I did: prtvtoc prtvtoc /dev/rdsk/c0t0d0s0 | /usr/sbin/fmthard -s - /dev/rdsk/c0t1d0s0 > /dev/null use iostat -En to see...
  14. jhala

    Cloning a Hard Drive

    I have two identical machines. One of the machines is built up and I want the image that drive to the other machine. What is the best way? Some options that I was thinking about: a. dd if= of= but then I've read there could be issues with unique identifiers. b. flarcreate to create the...
  15. jhala

    Recover Data

    Putting the bad drive back in didn't help so I re-partitioned the 'good' drive, and received a different message saying to run fsck. Good sign, right? lol I run: fsck -F ufs -y /dev/.... Receive message Bad Super Block, use and Alternate. I then use 32: fsck -F ufs -o b=32 /dev... Message is...
  16. jhala

    Recover Data

    Thanks for the ideas PopKorn. I'll put that failed drive back in and hope for the best. I'll let you know what happens. --John
  17. jhala

    Recover Data

    Hello, I am running Solaris 8 Enterprise. I had 2 drives in RAID 1. One of the drives failed and it was still up and running. I replaced the drive. I ran the command: prtvtoc /dev/rdsk/c1t0d0s1 | fmthard -s - /dev/rdsk/c1t1d0s1 Unfortunately, I didn't realize the drives were switched when...
  18. jhala

    CSG 1.1 and WI4 and PS4

    Hello, Existing Environment: Existing MFXP1.0 environment with NFuse Classic 1.7 and CSG 1.1 and STA working fine, servers are Windows 2000. New environment: Separate PS4 farm, separate webserver with WI4, both servers Windows 2003. Question: Can I leverage the CSG 1.1 in Existing environment...
  19. jhala

    PS4 64 bit on 2003 64bit

    Everything I read says not to install .net 2.0 because it is no yet fully compatible with PS4, but mainly not compatible with WI4.
  20. jhala

    PS4 64 bit on 2003 64bit

    I have a Windows 2003 64 Bit Server. Remapped Drives. No windows updates to install. I'm setting up the pre-requisites for PS4 64 bit edition. I've installed from the CD: Java Runtime Environment Version 1.4.2_06 .NET Framework Version 1.1 When I try to install .NET Framework v1.1 SP1 from...

Part and Inventory Search

Back
Top