search

ajrockefeller / openfpc

Automatically exported from code.google.com/p/openfpc
0 stars 0 forks source link

NODENAME with periods (MySQL illegal char) #18

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. New Install
2. Modify openfpc-default.conf
3. Set the node name to something like sensor.top.level.domain
5. Continue as per normal with session capture enabled.

What is the expected output? What do you see instead?
OpenFPC functional. Instead, it fails to create the MySQL tables as there are 
periods in the tablename.

What version of the product are you using? On what operating system?
Latest OpenFPC from svn under Debian.

Please provide any additional information below.
Periods are illegal characters in MySQL database/table names. I discovered this 
today when trying to install a new OpenFPC sensor who's nodename included 
periods.

It would be good if mentioned in the config file, or when creating the database 
using dbmaint, that periods are illegal chars. (Would have saved me hours 
today!)

Database and table names cannot contain “/”, “\”, “.”, or 
characters that are not permitted in file names.  
http://dev.mysql.com/doc/refman/5.0/en/identifiers.html

Thanks Guys :)

Original issue reported on code.google.com by SecListI...@gmail.com on 20 Jun 2011 at 5:46

GoogleCodeExporter commented 8 years ago

Original comment by leon.j.w...@gmail.com on 20 Jun 2011 at 1:43