Open grleblanc opened 8 years ago
Alright so I was able to find a work around. The reason this was failing is because the DB schema for the session DB is requiring SID be an INT. As you can see the in openfpc-cx2db file, the database INSERT is passing the $HOSTNAME variable into that column (aka the node name). Which, is most definitely not a int.
I went into the default config file and changed NODENAME to 1, nuked all the table info, restarted OpenFPC and all is working.
Thanks gleblanc1783, this was a great help!! I changed line 41 in openfpc-cx2db to our $HOSTNAME = 1; and commented out line 91
now it logs to the db. I guess the long term fix is to change openfc-dbmaint to the correct schema
Face Palm!! I understand your fix now--change NODENAME in your openfpc-default.conf (or whatever) to an integer. Much better than editing program files... I didn't have to drop the db, just restart openfpc
Hi all, I am running this on a new Ubuntu 16.04 server install and I am getting an error in the (/var/log/openfpc-cx2db-Default_Node.log) log file.
DBD::mysql::st execute failed: Incorrect integer value: 'Default_Node' for column 'sid' at row 1 at /usr/bin/openfpc-cx2db line 482, <FILE> line 8.
I can see the pcaps being saved, sessions being written but it doesn't look like its saving the session data into the DB.