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!
There have been a number of Forum posts on MySQL. Check through some of them here - you may well find an answer:
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.
Ready! and I could do it! had a problem with the port of the database! but I did! thank you very much!
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/