Created question in FIWARE Q/A platform on 29-07-2015 at 16:07
Please, ANSWER this question AT http://stackoverflow.com/questions/31704141/how-to-configure-cygnus-to-save-in-mysql

Question:
How to configure Cygnus to save in mysql

Description:
I'm trying to configure Cygnus in order to persist Orion context data in a MySQL database. I have installed phpmyadmin, and I'm trying to use this database to save the data. The whole workflow is the following one: Orion recives some data, then it is sent to Cygnus, and finally Cygnus sends it to the SQL db.

This is my configuration:

1. OrionMySQLSink configuration
2. channel name from where to read notification events
   cygnusagent.sinks.mysql-sink.channel = mysql-channel
3. sink class, must not be changed
   cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink
4. the FQDN/IP address where the MySQL server runs
   cygnusagent.sinks.mysql-sink.mysql_host = x.y.z.w
5. the port where the MySQL server listens for incomming connections
   cygnusagent.sinks.mysql-sink.mysql_port = 3306
6. a valid user in the MySQL server
   cygnusagent.sinks.mysql-sink.mysql_username = root
7. password for the user above
   cygnusagent.sinks.mysql-sink.mysql_password = xxxxxxxxxxxx
8. how the attributes are stored, either per row either per column (row, column)
   cygnusagent.sinks.mysql-sink.attr_persistence = column