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
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
Moderator: mcrossley
-
Fedx
- Posts: 9
- Joined: Fri 05 Aug 2016 9:31 pm
- Weather Station: PCE - FSW20
- Operating System: Raspbian
- Location: Rome
MySQL tables - Creation problem
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.
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
Do the table or tables get created? It could be a permissions issue on the MySql server.
- 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
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.
Edit: But it does seem to be some kind of issue with the server, as suggested above.
Steve
- 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
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
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.
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.
- 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
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?
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
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)
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
Is there another way to send my data (monthly, dayfile and realtime) to my web space?
- 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
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
...another way to do this is to use PHP - http://wiki.sandaysoft.com/a/ImportCumulusFile
Steve
- 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
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 wrote:Is there another way to send my data (monthly, dayfile and realtime) to my web space?
-
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
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.
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.