If you use Cumulus, please donate Image

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

MYSQL Setup

Discussion of version 3 of Cumulus, which runs on Windows, Linux, and OS X. All Cumulus MX queries in here, please.
User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

MYSQL Setup

Postby vpokroglo » Wed Apr 19, 2017 7:14 pm

Could anyone please write step by step tutorial to setup mysql settings in CumulusMX.

I spend hours to set up, but always get parsererror when clicking on either button - Create monthly, Create dayfile...
What does Port settings (default 3306) mean?

If I do importing with ImportCumulusFile.php script it is working OK.

Any suggestion? Thanks.
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Wed Apr 19, 2017 7:21 pm

you need to create a SQL table ie like (Cumulus) then in Cumulus setting put the name of SQL table then save them setting the click at the bootom Create database table

User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

Re: MYSQL Setup

Postby vpokroglo » Wed Apr 19, 2017 7:26 pm

I already done database
I got database name, user name, password.
I also got tables done ImportCumulusFile.php script.

I have Monthly, Realtime and Dayfile table already done.

The only problem is updating tables with cumulusMX.
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Wed Apr 19, 2017 7:30 pm

ok i hade this prob have u click on Monthly log file upload and you will see a box Enable and have u tick it


and is you sql on the same as where u hosting Cumulus from

User avatar
steve
Cumulus Author
Posts: 25819
Joined: Mon Jun 02, 2008 6:49 pm
Weather Station: Davis VP2
Operating System: Raspbian
Location: Sanday, Orkney
Contact:

Re: MYSQL Setup

Postby steve » Wed Apr 19, 2017 7:34 pm

There's only one step, fill in the details correctly that correspond to your MySQL server host, account and database. If you've done it correctly, then perhaps your server does not allow connections from other hosts.
Steve
-----
Hosting available for Cumulus web sites. See http://sandaysoft.com/forum/viewtopic.php?f=2&t=11876

Like Cumulus and want to support it? Please donate! Image

User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

Re: MYSQL Setup

Postby vpokroglo » Thu Apr 20, 2017 7:16 pm

steve wrote:There's only one step, fill in the details correctly that correspond to your MySQL server host, account and database. If you've done it correctly, then perhaps your server does not allow connections from other hosts.


Voilaaa, My host only alows connections to MySql from static IP address.

Thanks for help!
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Thu Apr 20, 2017 7:54 pm

where is ur SQL sever?

User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

Re: MYSQL Setup

Postby vpokroglo » Thu Apr 20, 2017 7:58 pm

dazza1223 wrote:where is ur SQL sever?


At my webhosting provider.


I am already querying for static IP address. That will solve my problem.
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Thu Apr 20, 2017 8:04 pm

did u ask them what wrong as it might be something there end mate
i have my sql on the same server Cumulus and i have the raspberry pi 3 i just pay for my website name and pornt it to my server

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Thu Apr 20, 2017 8:06 pm

ps i see u have Raspberry Pi 2 why do u do the same here mate

User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

Re: MYSQL Setup

Postby vpokroglo » Thu Apr 20, 2017 8:15 pm

Yes I know, that I could host my site on raspberry and only pay for domain name. ... but I have some more Years already paid to my web hosting provider, so I can transfer on raspberry when my hosting plan ends....
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Thu Apr 20, 2017 8:17 pm

o ok well as u said have u ask them? to c if there know as thay can see the logs u cant so may be better asking them mate

User avatar
vpokroglo
Posts: 48
Joined: Thu Feb 24, 2011 7:45 pm
Weather Station: WS-2350
Operating System: Raspberry Pi 2
Location: Slovenija

Re: MYSQL Setup

Postby vpokroglo » Thu Apr 20, 2017 8:25 pm

dazza1223 wrote:o ok well as u said have u ask them? to c if there know as thay can see the logs u cant so may be better asking them mate



Yes I have already asked them... see some posts upper (Voilaa....).
They do not allow connections from dynamic IP to Mysql.
I have dynamic IP. So i must get static IP first and then I could use CumulusMX built in Mysql settings.
Image

dazza1223
Posts: 169
Joined: Sun Jan 25, 2015 8:41 pm
Weather Station: davis vantage vue
Operating System: raspberry pi 3
Location: worthing
Contact:

Re: MYSQL Setup

Postby dazza1223 » Thu Apr 20, 2017 8:27 pm

ok 8-)

User avatar
Mapantz
Posts: 402
Joined: Sat Dec 17, 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 10 x64 - A beast.
Location: Wareham, Dorset - UK

Re: MYSQL Setup

Postby Mapantz » Thu Apr 20, 2017 8:51 pm

vpokroglo wrote:Yes I have already asked them... see some posts upper (Voilaa....).
They do not allow connections from dynamic IP to Mysql.
I have dynamic IP. So i must get static IP first and then I could use CumulusMX built in Mysql settings.


Does Cpanel not have a 'Remote MySQL' option? I'm on a dynamic IP address, and I was having to continually add my IP address to allow a connection to it. I have now entered my DynDNS, which points to my IP address, and will update at the router level if my IP address changes.
Image
Image


Return to “Cumulus MX”

Who is online

Users browsing this forum: No registered users and 3 guests