Messages

1

22.7 Legacy Series / Re: configd.py Error sqlite error while executing DROP TABLE

« on: February 01, 2023, 10:48:08 am »

Have still the following error after Update to 23.1_6

Code: [Select]

2023-01-30T14:57:15 Error configd.py [f9bee656-6298-4dcf-b44f-d104d2aa3af0] Script action stderr returned "b"pkg: sqlite error while executing SELECT count(name) FROM sqlite_master WHERE type='table' AND name='repodata'; in file pkgdb.c:2345: database is locked\npkg: Repository OPNsense contains no repodata table, need to re-create database\npkg: sqlite error whil""


Code: [Select]

2023-01-30T14:57:15 Error configd.py [ce08aa03-0906-4025-8b4b-7bc62dac74b5] Script action stderr returned "b'pkg: sqlite error while executing CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc TEXT NOT NULL,osversion TEXT,arch TEXT NOT NULL,maintainer TEXT NOT NULL,www TEXT,prefix TEXT N'"

Do someone know, how to fix them?

Thx

2

22.7 Legacy Series / configd.py Error sqlite error while executing DROP TABLE

« on: January 19, 2023, 01:55:25 pm »

Hello,

upgraded today to V22-7-11 and recognized the following Syslog errors in backend:

Code: [Select]

2023-01-19T12:30:30 Error configd.py [dc4fc17f-1320-4ae5-86d3-969fb0e120ec] Script action stderr returned "b'pkg: sqlite error while executing DROP TABLE repo_update; in file pkgdb.c:2320: attempt to write a readonly database'"


Code: [Select]

2023-01-19T12:30:29 Error configd.py [82367a10-f22f-47e9-97b3-b8bf83c2579f] Script action stderr returned "b'pkg: sqlite error while executing CREATE TABLE packages (id INTEGER PRIMARY KEY,origin TEXT,name TEXT NOT NULL,version TEXT NOT NULL,comment TEXT NOT NULL,desc TEXT NOT NULL,osversion TEXT,arch TEXT NOT NULL,maintainer TEXT NOT NULL,www TEXT,prefix TEXT N'"


Code: [Select]

2023-01-19T12:29:43 Error configd.py Timeout (120) executing : interface newip 'lagg0'


Code: [Select]

2023-01-19T12:23:49 Error configd.py Timeout (120) executing : interface newip 'lagg0_vlan

How to solve them?

thx

3

22.7 Legacy Series / Re: Cron for OpenVPN

« on: December 28, 2022, 01:07:01 pm »

Still have frequent OpenVpn Client disconnects and the connection is not automatically restarted...

Manually diaqble and enable the connection works fine...

4

Virtual private networks / Re: openvpn server setup rules question

« on: December 28, 2022, 01:04:15 pm »

still have this issue that i cannt set OpenVPN address in the rule on the auto generated tab

5

22.7 Legacy Series / Re: Need Help - Debugging slow webgui

« on: December 05, 2022, 04:14:08 pm »

Recognized the slow Gui as well. DNS Lookup to FW Hostname is working ok.
Deleted all Logs, slowness still persists.

Have still these errors in System: Log Files: Web GUI

Code: [Select]

2022-12-05T11:06:05 Error lighttpd (server.c.1588) server started (lighttpd/1.4.67)
2022-12-05T11:06:05 Error lighttpd (server.c.2097) server stopped by UID = 0 PID = 80455
2022-12-04T14:15:51 Error lighttpd (server.c.1588) server started (lighttpd/1.4.67)
2022-12-04T14:15:51 Error lighttpd (server.c.2097) server stopped by UID = 0 PID = 34252

In my Case when I connect via IP Address to the Box the GUI is reacting fast…, connecting via FW Hostname is still slow…

BR

6

22.7 Legacy Series / Re: Cron for OpenVPN

« on: December 03, 2022, 01:44:56 pm »

Hello,
Thanks for the code. I’m having exactly the same issue, and try to restart the openvpn service via custom cron job.

What I did till now is:

Created File actions_custom.conf under Path /usr/local/opnsense/service/conf/actions.d/

Pasted your Code but changed

Code: [Select]

type:script

to

Code: [Select]

type:script_output


Code: [Select]

configctl custom restart
Service `openvpn' has been restarted.


Via Command Line its working openvpn service can be stopped / started / restarted

But the Issues for me are still:
1 . When configctl custom restart via command line is executed, just the first openvpn client connection is restarted. But I have 2. connections. How to adapt the script to restart all openvpn Client connections?


2. Tried yet several times with Firewall Reboots, configd reload etc. to get the Custom Cron-Job working, but no success unfortunately... And i dont want to edit corntab File directly, as with the next System Update the modifications are gone...

Can anyone give me a hint here?

BR
Crissi

7

Virtual private networks / openvpn server setup rules question

« on: November 30, 2022, 03:30:18 pm »

Hello,

i have a question regarding the openvpn ssl server setup. I have followed the documentation here https://docs.opnsense.org/manual/how-tos/sslvpn_client.html and i can successfully connect with my mobile phone.
I tried now, to set under Firewall – Rules – Register - OpenVPN (auto generated when SSL Server is started) like Allow Access to internal DNS Server, but I’m missing there under Destination to set OpenVPN address ..

When I assign an Interface for example OPEN_VPN_SRV there I have then the possibility to set the address (s. screenshot), and i can also name the Entry to have a better overview.



My questions are:
a.)   Is this the right way to go to set the assign an Interface when I want to build specific Rules for the VPN Clients?
b.)   If yes, is there a way to Hide the auto generated Menu Entry OpenVPN somehow, or did I oversee something in the Setup to do this?

Thx
BR
Crissi

8

22.7 Legacy Series / configd.py error Timeout 120

« on: November 14, 2022, 05:07:16 pm »

Hello,

updated to 22.7.7_1 and get configd.py error Timeout 120 in backend log

9

22.7 Legacy Series / Re: Errorlighttpd unknown config-key: server.dir-listing 22.7.2

« on: November 14, 2022, 05:03:20 pm »

Hello,

Updated to 22.7.7_1 and get the following error in gui log:

10

22.7 Legacy Series / Re: Errorlighttpd unknown config-key: server.dir-listing 22.7.2

« on: August 21, 2022, 03:35:16 pm »

Thanks Franco 

11

Web Proxy Filtering and Caching / Re: C-ICAP / ERROR: Unable to find specified template

« on: August 21, 2022, 03:34:28 pm »

  Yes.. seems like

12

22.7 Legacy Series / Re: VlanXX shows up as vlan01 ?

« on: August 21, 2022, 03:29:07 pm »

Im also a bit confused here. All my VLANs previously created under Interfaces – Other Types – VLAN are shown under Devices like:

Code: [Select]

lagg0_VLAN10
lagg0_VLAN15
lagg0_VLAN18
etc.

New created VLAN with 22.7.2 is shown under Device just as vlan01

13

Virtual private networks / 22.7.2 VPN Client Connections stopped - Cron Job?

« on: August 21, 2022, 03:13:50 pm »

I have the Problem that the VPN Client Connections just stopped the next day. I can start them in the Gui without any problem, but the following day they are just stopped again. Checking the Log Files give no indications, why the Services are stopped. When doing the Openvpn Client connections from a DD WRT Router they are stable, running for month without any problem an no disconnects..

I found here an older post about to add a cron job:

Code: [Select]

https://forum.opnsense.org/index.php?topic=9051.0

I was wondering if this is still the way to go with 22.7.2 as the post is from 2018.

Also as in the post written, this adaptation will not be in the backup. Is there a other solution, what will also survive future firmware updates?

Thx!

14

Web Proxy Filtering and Caching / Re: C-ICAP / ERROR: Unable to find specified template

« on: August 18, 2022, 02:20:35 pm »

Update to 22.7.2 issue still present...

15

22.7 Legacy Series / Errorlighttpd unknown config-key: server.dir-listing 22.7.2

« on: August 18, 2022, 02:19:26 pm »

Hello,

have updated to 22.7.2 and get the follwoing error in the gui log:

Code: [Select]

2022-08-18T13:11:09 Error lighttpd (configfile.c.1287) WARNING: unknown config-key: server.dir-listing (ignored)

Login via Gui works fine, just wondering how to solve.

Thx!