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