| Author |
Message |
|
Pumpi
New User
Joined: Wed Dec 14, 2005 8:37 am
Posts: 6
|
 Syslog plugin MySQL problem Hello Jimmy,
I have a problem to import the syslog.sql file into my MySQL server:
http://forums.cacti.net/viewtopic.php?t=10280&start=60
Answer from TheWitness
Quote: Pumpi,
It looks like cigamit has moved to MySQL 5.x which includes the default character set in hte dump syntax which is not well supported in MySQL 4.x.
TheWitness I'm running MySQL server version 4.0.18 on aSUSE Enterprise Server 9.
How can I use your version with my MySQL server version ?
Pumpi
|
| Wed Feb 01, 2006 8:34 am |
|
|
|
jimmy
Site Admin
Joined: Thu Nov 11, 2004 11:12 am
Posts: 2007
|
I have fixed the file in question, if you could redownload and then re-import the discover.sql, it should work now.
Thanks!
|
| Wed Feb 01, 2006 3:24 pm |
|
|
|
rfuller
New User
Joined: Sun Feb 05, 2006 3:11 pm
Posts: 1
|
Is there a way to get this plugin to work with MySQL 3.23.58. It errors out at
#1064 - You have an error in your SQL syntax near 'CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (seq)
) TYPE=MyISA' at line 13
|
| Sun Feb 05, 2006 3:16 pm |
|
|
|
Pumpi
New User
Joined: Wed Dec 14, 2005 8:37 am
Posts: 6
|
Same problem for me with 4.0.18:
Try to cut the timestamp line to:
`timestamp` timestamp NOT NULL default '',
'default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP' should be the default behaviour.
After this I was able to import the MySql dump file.
Pumpi
|
| Mon Feb 06, 2006 4:18 am |
|
|
|
renen
New User
Joined: Fri Feb 10, 2006 10:31 am
Posts: 2
|
Pumpi,
i have the the same problem.
Could you pls tell me what you've changed in the syslog.sql.
Regards,
Rene
|
| Fri Feb 10, 2006 10:34 am |
|
|
|
jimmy
Site Admin
Joined: Thu Nov 11, 2004 11:12 am
Posts: 2007
|
Sorry, the plugin is not meant to work on MySQL 3.X. Technically it can run find with a few tweaks, but its not something I want to support, as I don't run anything that "old" and it takes away a bit of the functionality I wanted.
|
| Fri Feb 10, 2006 10:43 am |
|
|
|
renen
New User
Joined: Fri Feb 10, 2006 10:31 am
Posts: 2
|
I' m running mysql 4.0.18
Rene
|
| Fri Feb 10, 2006 10:57 am |
|
|
|
jimmy
Site Admin
Joined: Thu Nov 11, 2004 11:12 am
Posts: 2007
|
The problem is with the statement "ON UPDATE CURRENT_TIMESTAMP" which was added in MySQL 4.1.2, this is only necessary for new hosts. I guess if there is enough demand, I can make a few modifications to the plugin so that it doesn't need it, or can work around it, but it just happens to make things alot easier when dealing with Windows hosts that dump the entire Event Log upon installing a Remote Syslog program.
I will see what it takes to remove that portion, and will release a new version once done.
|
| Fri Feb 10, 2006 2:06 pm |
|
|
