I can not connect FrontlineSMS to Mysql Database

[Juan Salvador Peñalver]

Greetings! I'm trying to configure FrontlinesSMS to work with my mysql database and I can not do, I put the data from the server, the port, the name of the database, user, password, everything! but does not connect, just lay onthe opening screen of the program. What should I do? I edit the file in the folder mysql.database config? I must create my own tables? which tables should I create? please, I would be very useful if someone could help me with that! thank you!

[kiwanja]

Hi Juan

 

There have been a number of Forum posts on MySQL. Check through some of them here - you may well find an answer:

 

http://frontlinesms.ning.com/forum/topic/search?q=mysql

 

Ken

[Alex Anderson]

Hi Juan, you shouldn't need to create your own tables or schema, but you'll need to create your own database and make sure that FrontlineSMS has permission to create tables within it.  If you could specify MySQL and FrontlineSMS versions that would also be helpful - I know there have been issues in the past with different versions of MySQL.

[Juan Salvador Peñalver]

Ready! and I could do it! had a problem with the port of the database! but I did! thank you very much!

[Florence Scialom]

Hey Juan,

 

Great to see you have worked this problem out, with support from Ken and Alex. Please do feel free to stay in touch if you have any other questions, and also to let us know how you are getting on in general with using FrontlineSMS for your work! \o/

 

Thanks,

Flo