my database is on /var/lib/weewx/weewx.sdb
metfm@metfm:~$ ls -ail /var/lib/weewx
σύνολο 18692
264962 drwxr-xr-x 1 root root 18 Ιουν 21 14:20 .
269 drwxr-xr-x 1 root root 592 Φεβ 26 18:30 ..
270727 -rwxrwxrwx 1 root root 19140608 Ιουν 21 14:20 weewx.sdb
metfm@metfm:~$
Στις Τετάρτη 21 Ιουνίου 2023 στις 11:49:35 π.μ. UTC+3, ο χρήστης
gjr80 έγραψε:
No. The default Debian based distro database is
/var/lib/weewx/weewx.sdb. The archive directory is only used
(by default) for setup.py installs.
OP. Have you confirmed the location (and name) of your WeeWX
database? What does the following command show:
$ ls -ail /var/lib/weewx
Gary
On Wednesday, 21 June 2023 at 09:28:58 UTC+1
[email protected] wrote:
It should be /var/lib/weewx/archive/weewx.sdb
Can you give us a screenshot where the weewx.sdb is??
Στις Τετ, 21 Ιουν 2023, 11:03 ο χρήστης Δημήτρης Βήχος
<[email protected]> έγραψε:
debian installed. also triyng with sudo sqlite3
/var/lib/weewx/weewx.sdb same thing.
Στις Τετάρτη 21 Ιουνίου 2023 στις 9:55:34 π.μ. UTC+3,
ο χρήστης gjr80 έγραψε:
Have you customised your WeeWX install? You
appear to be using a package install so unless
you have changed it your WeeWX database should be
in /var/lib/weewx not /var/weewx.
Gary
On Wednesday, 21 June 2023 at 05:48:19 UTC+1
[email protected] wrote:
the commands with semi-colons. send me (with
sudo also and with suo su )
metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> SELECT dateTime, datetime(dateTime,
'unixepoch','localtime'), usUnits, rain FROM
archive WHERE dateTime > 1686881600 AND
dateTime <= 1686981600;
Error: unable to open database
"/var/weewx/weewx.sdb": unable to open
database file
metfm@metfm:~$
without semi-colons database open
metfm@metfm:~$ sudo sqlite3 /var/weewx/weewx.sdb
[sudo] password for metfm:
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> select datetime, datetime(dateTime,
'unixepoch','localtime'), rain from archive
where dateTime > 1686881600 and dateTime <=
1686981600
...> update archive set rain=12.6 where
dateTime = 1686975900
...> .quit
...>
metfm@metfm:~$ sudo wee_database
--rebuild-daily --from=2023-06-17 --to=2023-06-17
[sudo] password for metfm:
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is
bound to database 'archive_sqlite'
Daily summary for 2023-06-17 will be rebuilt.
Proceed (y/n)? y
Rebuilding daily summaries in database
'weewx.sdb' ...
Processed 276 records to rebuild 1 daily
summary in 0.12 seconds
Rebuild of daily summaries in database
'weewx.sdb' complete
metfm@metfm:~$ sudo /etc/init.d/weewx start
Starting weewx (via systemctl): weewx.service.
metfm@metfm:~$
but after restarting weewx no change in
database. no 12.6 plus mm who i needs
Στις Τρίτη 20 Ιουνίου 2023 στις 2:10:28 μ.μ.
UTC+3, ο χρήστης gjr80 έγραψε:
At a guess I would say your sqlite3
commands were never executed due to
missing semi-colons at the end of each
sqlite3 command line. Your commands are
basically fine, but you need to be
careful with the datetime/dateTime case
in the commands. No need for commits as
your are not processing multiple commands
as a transaction. When editing the
database you do need to be mindful of
your database units and make sure you use
the same units in your update queries. If
using sqlite command line the easiest
thing to do is to look at the usUnits
field. 1=US customary=inches,
16=Metric=cm, 17=MetricWX=mm. Whether you
use sqlite3 or a gui tool like
sqlitebrowser does not really matter,
just check that your data was changed
after you make the change and if using a
gui be very careful to not leave any
fields with null strings(though this is
usually associate with deleting data
rather than updating it). FWIW if using
sqlite3 I would use this sequence of
commands:
$ sqlite3 /home/weewx/archive/weewx.sdb
sqlite> SELECT dateTime,
datetime(dateTime,
'unixepoch','localtime'), usUnits, rain
FROM archive WHERE dateTime > 1686881600
AND dateTime <= 1686981600;
sqlite> UPDATE archive SET rain=12.6
WHERE dateTime = 1686975900;
sqlite> SELECT dateTime,
datetime(dateTime,
'unixepoch','localtime'), usUnits, rain
FROM archive WHERE dateTime=1686975900;
sqlite> .q
$ sudo wee_database --rebuild-daily
--date=2023-06-17
In terms of the Seasons skin your updated
data may causes changes to rain plots
(all except the 'today' plot), the June
2023 and 2023 NOAA format reports and the
statistics widget/page. All should come
good in time (max 24 hours) provided you
update your data sometime this month, but
if you want to speed things up delete all
your rain plots on your WeeWX machine. If
you update your data in say July you will
need to delete the June 2023 and 2023
NOAA format reports and all subsequent
NOAA format reports to force regeneration.
Can't speak for any other skins.
Gary
On Tuesday, 20 June 2023 at 07:04:56
UTC+1 [email protected] wrote:
here is me commands in terminal .
trying to plus 12.1 missing mm in 17
july total rainfall
metfm@metfm:~$ sudo sqlite3
/var/weewx/weewx.sdb
[sudo] password for metfm:
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> select datetime,
datetime(dateTime,
'unixepoch','localtime'), rain from
archive where dateTime > 1686881600
and dateTime <= 1686981600
...> update archive set rain=12.6
where dateTime = 1686975900
...> .quit
...>
metfm@metfm:~$ sudo wee_database
--rebuild-daily --from=2023-06-17
--to=2023-06-17
[sudo] password for metfm:
Using configuration file
/etc/weewx/weewx.conf
Using database binding 'wx_binding',
which is bound to database
'archive_sqlite'
Daily summary for 2023-06-17 will be
rebuilt.
Proceed (y/n)? y
Rebuilding daily summaries in
database 'weewx.sdb' ...
Processed 276 records to rebuild 1
daily summary in 0.12 seconds
Rebuild of daily summaries in
database 'weewx.sdb' complete
metfm@metfm:~$ sudo /etc/init.d/weewx
start
Starting weewx (via systemctl):
weewx.service.
metfm@metfm:~$
something missing? something im doing
wrong? the exetra mm never shows in
weewx restarting and updating.
Στις Σάββατο 17 Ιουνίου 2023 στις
12:11:40 μ.μ. UTC+3, ο χρήστης
Stefanos Kalaitzis έγραψε:
First find the range of
time(epoch) that you want to add
the rain
Enter to weeex.sdb
sudo sqlite3
/home/weewx/archive/weewx.sdb
Then check what values your
station recorded
select datetime,
datetime(dateTime,
'unixepoch','localtime'), rain
from archive where dateTime >
1686881600 and dateTime <=
1686981600;
Then correct the time you want
For example
update archive set rain=1.0 where
dateTime = 1686975900;
Then exit the db
.quit
Stop weewx
After all corrections rebuild the
data base for that day
sudo /home/weewx/bin/wee_database
--rebuild-daily --from=2023-06-17
--to=2023-06-17
Start weewx
Thats what i am doing when i have
to add some missing mm in my db
Στις Σάβ, 17 Ιουν 2023, 11:42 ο
χρήστης Δημήτρης Βήχος
<[email protected]> έγραψε:
i want like to add some mm to
my daily rainfall beacuse
after power loss , my console
(fine offset) have 10mm
above the weewx after the
power on again.
i had loss 10mm in my daily rain.
thank you!
--
You received this message
because you are subscribed to
the Google Groups
"weewx-user" group.
To unsubscribe from this
group and stop receiving
emails from it, send an email
to
[email protected].
To view this discussion on
the web visit
https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com
<https://groups.google.com/d/msgid/weewx-user/e96ce7e9-1085-46f6-adf4-b82275bf4df4n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed
to the Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving
emails from it, send an email to
[email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%40googlegroups.com
<https://groups.google.com/d/msgid/weewx-user/88595a49-17a9-4e1f-9fc1-6d884f9f1863n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
You received this message because you are subscribed to the
Google Groups "weewx-user" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%40googlegroups.com
<https://groups.google.com/d/msgid/weewx-user/f4d024d3-7dca-4a12-961f-1a3d85c05a07n%40googlegroups.com?utm_medium=email&utm_source=footer>.
