Welcome to the Cumulus Support forum.

Latest Cumulus MX V4 release 4.4.2 (build 4085) - 12 March 2025

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

If you are posting a new Topic about an error or if you need help PLEASE read this first viewtopic.php?p=164080#p164080

MySQL tables - Creation problem

Topics about the Beta trials up to Build 3043, the last build by Cumulus's founder Steve Loft. It was by this time way out of Beta but Steve wanted to keep it that way until he made a decision on his and Cumulus's future.

Moderator: mcrossley

Locked
Fedx
Posts: 9
Joined: Fri 05 Aug 2016 9:31 pm
Weather Station: PCE - FSW20
Operating System: Raspbian
Location: Rome

MySQL tables - Creation problem

Post 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.
BigOkie
Posts: 283
Joined: Tue 28 May 2013 1:06 am
Weather Station: Davis VP2 Plus
Operating System: Raspian Bookworm (RPi 3b)
Location: Tulsa, OK

Re: MySQL tables - Creation problem

Post by BigOkie »

Do the table or tables get created? It could be a permissions issue on the MySql server.
User avatar
steve
Cumulus Author
Posts: 26672
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MySQL tables - Creation problem

Post 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.
Steve
User avatar
jdc
Posts: 142
Joined: Tue 19 Jun 2012 8:51 pm
Weather Station: Davis VP2 : Instromet
Operating System: Win 10
Location: Portsoy,.
Contact:

Re: MySQL tables - Creation problem

Post 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.
Fedx
Posts: 9
Joined: Fri 05 Aug 2016 9:31 pm
Weather Station: PCE - FSW20
Operating System: Raspbian
Location: Rome

Re: MySQL tables - Creation problem

Post 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.
You do not have the required permissions to view the files attached to this post.
User avatar
steve
Cumulus Author
Posts: 26672
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MySQL tables - Creation problem

Post 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?
Steve
Fedx
Posts: 9
Joined: Fri 05 Aug 2016 9:31 pm
Weather Station: PCE - FSW20
Operating System: Raspbian
Location: Rome

Re: MySQL tables - Creation problem

Post 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)
Fedx
Posts: 9
Joined: Fri 05 Aug 2016 9:31 pm
Weather Station: PCE - FSW20
Operating System: Raspbian
Location: Rome

Re: MySQL tables - Creation problem

Post by Fedx »

Is there another way to send my data (monthly, dayfile and realtime) to my web space?
User avatar
steve
Cumulus Author
Posts: 26672
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: MySQL tables - Creation problem

Post 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
Steve
User avatar
mcrossley
Posts: 14388
Joined: Thu 07 Jan 2010 9:44 pm
Weather Station: Davis VP2/WLL
Operating System: Bullseye Lite rPi
Location: Wilmslow, Cheshire, UK
Contact:

Re: MySQL tables - Creation problem

Post 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.
Fedx
Posts: 9
Joined: Fri 05 Aug 2016 9:31 pm
Weather Station: PCE - FSW20
Operating System: Raspbian
Location: Rome

Re: MySQL tables - Creation problem

Post 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.
Locked