Re: Can't log to MySQL after its upgrade

["Senthil Prabu.S" <prabu333 () hotpop com>]

> I just upgraded my MySQL database from version 4.0.22 to 4.1.7 and I
> am no longer able to make Snort to log to the database.

> The Snort services fail to run (the error is in the Event Viewer is:
."database: mysql_error: Can't initialize character set 33 (path:
> default)") and if I try to run it manually, I get the following
> error:
> - ----------------------------------------------------------------------
> - ------------------------------
> File 'c:\mysql\\share\charsets?.conf' not found (Errcode: 22)
> Character set '#33' is not compiled character set and is not
> specified in the 'c:\mysql\\share\Index' file
> ERROR: database: mysql_error: Can't initialize character set 33
> (path: default)
> Fatal Error, Quitting..
> - ----------------------------------------------------------------------
> - ------------------------------

If your `Index' file doesn't contain the name for the character set, your 
program will display the following error message:

ERROR 1105: File '/usr/local/share/mysql/charsets/?.conf'
not found (Errcode: 2)
In this case, you should either get a new Index file or manually add the 
name of any missing character sets to the current file.

SOLUTION:

 Just add the following line into "Index" file, a new row (with encoding 
you can use)  : "cp1251 33"



--
HTH,

Senthil Prabu.S


If you are smart enough to know that you're not smart enough to be an
Engineer, then you're in Business.
______________________________________________________ 




-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now. 
http://productguide.itmanagersjournal.com/
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users