A little bit of help - VP2

[Mapantz]

That is usually caused by the User not having the correct host name which should be the IP address of the computer logging into the database which is given to you by the error message.

Edit the User with phpMyAdmin and change the Host field to use it as text and then enter the IP address stated in the error message. Check that you have All Privileges and then Save and you should be able to connect.

That doesn't sound right to me.
A: I can adjust/add/remove items from a database I currently have with other software.
B: My IP address is dynamic

I've tried connecting to the current database I have on there, but that fails on MX too.

Host name: IP of my server
Username and password are 100% correct, as is the database name.

Shouldn't it be myusername@localhost that connects to the database?

[steve]

B: My IP address is dynamic

You'll need to give wildcard permissions for your user, to allow it access from any address.

GRANT ALL ON mydatabase.* TO 'myuser'@'%';FLUSH PRIVILEGES;

I'm not sure whether you also need to do this first:

CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

[Mapantz]

B: My IP address is dynamic

You'll need to give wildcard permissions for your user, to allow it access from any address.

GRANT ALL ON mydatabase.* TO 'myuser'@'%';FLUSH PRIVILEGES;

I'm not sure whether you also need to do this first:

CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

That got it Steve! Thank you.

[Mapantz]

I've only just spotted this on my page, i'm not entirely sure if its a bug or not?

I have done my webtags for sunrise, moonrise, sunset and moonset like this:

Code: Select all

<#sunrise format="H:mm tt">
<#moonrise format="H:mm tt">
<#sunset format="H:mm tt">
<#moonset format="H:mm tt">

Sunrise and moonrise get processed correctly:

Sunrise: 6:37 AM
Moonrise: 6:13 AM

Sunset and moonset process like this:

Sunset: 18:02 PM
Moonset: 17:31 PM

[PaulMy]

Is that not correct?

Paul

[PaulMy]

oops finally see the 24 hour time and PM

Paul

[mcrossley]

H for 24h time, h for 12h time. The tag is doing what you have set, 24 hours with am/pm indicator.

[Mapantz]

H for 24h time, h for 12h time. The tag is doing what you have set, 24 hours with am/pm indicator.

Yep, you're right! I know why I got confused, because of the morning times and using them without the leading zero..
whoops!

Thank you!

[Mapantz]

Hi
I had to update my router's firmware earlier, so I popped offline for ten minutes.. before I did that, I closed Cumulus. After ten mins or so, I started Cumulus again, and naturally it downloaded the archive (1 min intervals) - It then updated the Mar16log.txt, I suddenly remembered I might need to update MySQL, but it already had done so. The data that had been sent was in 1 minute intervals for ten minutes (10 entries) instead of every 10 minutes. I just wanted to check that it is normal? Nice job that it automatically updates MySQL!

Cheers.

[steve]

When it does any kind of updates, logging etc, from archive data, it does it at the archive interval, i.e. one update per archive entry - it's the only sensible approach. This is one reason that the Cumulus documentation recommends that you uses the same interval in the station as you do in Cumulus, then everything is consistent.

[Mapantz]

When it does any kind of updates, logging etc, from archive data, it does it at the archive interval, i.e. one update per archive entry - it's the only sensible approach. This is one reason that the Cumulus documentation recommends that you uses the same interval in the station as you do in Cumulus, then everything is consistent.

Thanks Steve - I've set the data logger to 10 minutes.