MySQL database for FL

[Santiago Baena]

Hi,

I wanted to add MySQL to the FL database, but when I configure it, it says this error "Cannot open connection; nested exception is org.hibernate.exception.JDBCConnectionException: Cannot open connection."

 

Thanks for your help!

 

Santiago

[MIchael Wanyoike]

Hi Santiago,

Have you done the following:

1. Created a database in MySQL, you can name the database frontlinesms or any other name

2. Checked if you can access the database via the command line terminal. To access a MySQL database, you should type something like this inside the command terminal: mysql -u <username> -p <database>

If you need assistance on how to do any of the above, please let me know.

Let me know if the command works.

Thanks,

Michael.

[Santiago Baena]

Hi,

I have created a new EER model called "FrontlineSMS", in the default server called "MySQL55". I can access  to mySQL trhough their command line but dont know what to do now. And FL still displays the same message...

 

Thanks

 

Santiago

[MIchael Wanyoike]

Hi,

EER model is not the same as a database. If you are using the MySQL Workbench, first create a New Connection from the home page. Give it any name you want e.g. 'default'. Double click the newly created connection, enter your root password. When you successfully log in, a new tab should appear. You should be able to see a list of databases (also known as schemas) on the side. If FrontlineSMS is not listed, click on the 'create a new schema' icon at the top. Enter FrontlineSMS for name then click apply. The new database should now appear on the side.

Alternatively, you can just access mySQL via command line and execute this command : CREATE DATABASE FrontlineSMS;

Now go back to FrontlineSMS and try to connect.

Hope this helps.

Thanks,

Michael.

[Santiago Baena]

I created the database (schema) as you explained, but FL doesnt connect yet. My settings are:

sever.name: MySQL55

server.port: 3306

database.name: FrontlineSMS

username: root

Password: <mypassword>

 

Thanks,

 

Santiago

[MIchael Wanyoike]

In server.name, change MySQL55 to localhost

That should fix the problem.

Thanks,

Michael.

[Santiago Baena]

Wonderful! It helped! Thanks!

 

Now I would like to manage tables from MySQL workbench, but I am not very familiar with it, how can I export and import data to FL through MySQL?

 

Thanks a lot

 

Santiago

[MIchael Wanyoike]

Great to hear it works.

In the MySQL Workbench, go to its home tab, on the Server Administration section,

click New Server Instance. Complete the wizard that appears. Accept the defaults. When its complete, a new item ("mysqld@localhost) should appear. Double click it and give it a minute to load. A new tab will appear, on the side panel click the Data Export menu.

I hope from there you can manage the export options. Please be aware that the export feature in this tool can only export the database in SQL format. If you want to export data into different formats such as CSV, I would recommend you look for other 3rd party MySQL tools such as phpMyAdmin that support more export formats.

Thanks,

Michael.