Page 1 of 1
MySQL tables - Creation problem
Posted: Mon 29 Aug 2016 2:29 pm
by Fedx
Hi everybody,
I'm using Cumulus MX on RPI3 and I'm trying to upload my realtime.txt but i have a problem.
When I try to create new tables (Monthly, Dayfile and realtime) to my db, the system shows first shows me this message "attempting create" and then thi error message: parsererror
What can I do?
Thanks for your time.
Re: MySQL tables - Creation problem
Posted: Mon 29 Aug 2016 3:39 pm
by BigOkie
Do the table or tables get created? It could be a permissions issue on the MySql server.
Re: MySQL tables - Creation problem
Posted: Mon 29 Aug 2016 3:42 pm
by steve
If you zip up the MX diags folder and attach it to a reply in this thread, I'll see if I can see anything.
Edit: But it does seem to be some kind of issue with the server, as suggested above.
Re: MySQL tables - Creation problem
Posted: Mon 29 Aug 2016 8:44 pm
by jdc
Many shared hosting packages do not allow remote connections and this is exactly the response MX gives when trying to create a table.
Re: MySQL tables - Creation problem
Posted: Mon 29 Aug 2016 9:05 pm
by Fedx
Here's my MXdialog files.
I'm thinking, as you told, there is a problem with connection to my db.
I'm using a free hosting service called Altervista. Maybe this service does not accept external connection, but it is very strange, because there are lots of Cumulus weather websites running on Altervista. So, I think there is a way to solve my problem.
Is there another way so send my realtime files to my free web space without using mySQL parameters?
Thank you for your support.
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 8:43 am
by steve
2016-08-29 15:48:43.545 Can't connect to MySQL server on 'castelliaria@localhost' (10061):
Could not resolve host 'castelliaria@localhost'
2016-08-29 15:49:11.366 Error encountered during MySQL operation.
Have you configured the host name for the SQL server correctly?
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 9:16 am
by Fedx
I have tried with a lot of combination.
I have entered (in the field host name) my nickname (castelliaria), localhost, my website, my ftp website, everything.
Same error (parsererror)
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 9:23 am
by Fedx
Is there another way to send my data (monthly, dayfile and realtime) to my web space?
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 9:31 am
by steve
You need to use the name of the SQL server. It's still possible that your hosting doesn't allow remote SQL connections, so...
...another way to do this is to use PHP -
http://wiki.sandaysoft.com/a/ImportCumulusFile
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 10:46 am
by mcrossley
Fedx wrote:Is there another way to send my data (monthly, dayfile and realtime) to my web space?
Well, you can just FTP the data files and not use SQL at all, or as Steve has pointed you to, use the SQL import script that is used by Cumulus 1 users.
Re: MySQL tables - Creation problem
Posted: Tue 30 Aug 2016 1:44 pm
by Fedx
Ok, thank you very much.
Your help is very precious to me.
I'll try to fix my problem. I'll let you know.
Thank you again, have a nice day.