KeexyBox's forum
Portal

Welcome, Guest
You have to register before you can post on our site.

Username
  

Password
  

Search Forums

(Advanced Search)

Forum Statistics
» Members: 8,784
» Latest member: Randypek
» Forum threads: 63
» Forum posts: 173

Full Statistics

Latest Threads
the last guy
Forum: Blacklist
Last Post: ngami
03-13-2023, 06:44 PM
» Replies: 0
» Views: 54
iptables issue with times...
Forum: Profiles
Last Post: rdavila
02-05-2023, 02:20 PM
» Replies: 1
» Views: 472
Custom iptables rules
Forum: Network
Last Post: rdavila
02-05-2023, 02:08 PM
» Replies: 1
» Views: 448
Schedule does not seem to...
Forum: Profiles
Last Post: rdavila
01-11-2023, 07:52 PM
» Replies: 1
» Views: 164
[RESOLVED] Install script...
Forum: Installation
Last Post: m_keexybox_user
01-03-2023, 02:22 PM
» Replies: 0
» Views: 270
Hardware
Forum: Users and devices connection management
Last Post: benoit
01-03-2023, 07:43 AM
» Replies: 1
» Views: 2,144
Captive Portal Authentica...
Forum: Captive portal
Last Post: gvtgvt
12-04-2022, 09:23 AM
» Replies: 0
» Views: 570
Captive Portal Options
Forum: Captive portal
Last Post: benoit
06-10-2022, 01:10 PM
» Replies: 1
» Views: 1,128
Installation on Pi Zero W
Forum: Installation
Last Post: devils13
05-20-2022, 01:55 AM
» Replies: 1
» Views: 1,655
Debian 11 (Bullseye)
Forum: Installation
Last Post: Vangerdahast
04-07-2022, 12:45 PM
» Replies: 0
» Views: 880

  the last guy
Posted by: ngami - 03-13-2023, 06:44 PM - Forum: Blacklist - No Replies

Awesome content, I love your post and will love to read more. Thanks
<a href= "https://achatunpermisdeconduire.com/" rel="dofollow"> Permis 2</a>

<a href= "https://patenteguidalinea.com/" rel="dofollow"> Comprare Patente </a>

<a href= "https://acheterunpermisdeconduirereele.com/" rel="dofollow"> Permis </a>

<a href= "https://kup-prawojazdy.com" rel="dofollow"> prawo jazdy </a>

<a href= "https://xn--fhrerschein-kaufen-m6b.com/" rel="dofollow"> Kaufen </a>

<a href= "https://cumpara-permisdeconducere.com/" rel="dofollow"> prawo jazdy </a>

<a href= "https://rijbewijskopennederlandonline.com/" rel="dofollow"> kopen </a>

permis

permis 1

cumpara

kup

italy

kuafen

kopem

Awesome content, I love your post and will love to read more. Thanks

<a href= "https://comprarlicenciadeconducirreal.com"> Licencia de Conducir </a>

<a href= "https://kupitivozackudozvoluonline.com"> kupiti vozacku dozvolu </a>

<a href= "https://kupitivozniskodovoljenje.com"> Kupi vozniško dovoljenje </a>

<a href= "https://real-document.com"> Buy Driving License </a>

<a href= "https://osta-ajokotti.com"> Ostaa Ajokortti </a>

<a href= "https://mccaysdrugcenter.com"> Buy a Gun </a>

Comprar

Kupiti

Croatia

Rijbewijs

Osta

Glocks

<a href= "https://ceadunastiomanacheannach.com/"> czech </a>
czech

Print this item

  iptables issue with timestart-timestop due to timezone
Posted by: rdavila - 01-12-2023, 02:40 AM - Forum: Profiles - Replies (1)

Hello everyone,

I found an issue that seems to be caused by iptables, but I wanted to check if it's known and if there are any workarounds.

My timezone is EST, which at the moment is UTC -05:00
I create a Schedule to give access on Wednesday from 18:00 to 20:00 EST.
This translates to Wednesday 23:00 to Thursday 01:00 UTC.

When I apply the Profile to a Device, it gets blocked at 19:00 EST.

The problem seems to be that the timestart and timestop parameters to iptables are translated to UTC, and this breaks the access.

Below is the iptables line created by KeexyBox.
-A FORWARD -m mac --mac-source nn:nn:nn:nn:nn:nn -m time --timestart 23:00:00 --timestop 01:00:00 --weekdays Wed -j 49_FORWARD

When the time is 19:00 EST, I think the following is what iptables interprets:

  • Time is 00:00 UTC
  • The timestart parameter is 23:00:00
  • 00:00 is before the timestart parameter
  • iptables decides that the rule does not apply

I hope this all made sense :-)

Print this item

  Schedule does not seem to be working
Posted by: rdavila - 01-09-2023, 06:52 PM - Forum: Profiles - Replies (1)

Hello everyone,

I created a Profile with a schedule to only allow connections to the Internet during certain times of the day. I can see the Device is using the correct Profile, but I can still access the Internet on that Device outside of the Scheduled Time.

Below are the details of the Schedule configuration. (please see the attached file "Schedule Screenshot.jpg" for a screenshot of the schedule)
The goal is to allow access to the Internet only during the following times:

  • Monday through Thursday - 6:00pm to 7:00pm
  • Friday -  3:00pm to 10:00pm
  • Saturday - 12:00pm to 8:00pm
As a test, I browsed to a website today Monday at 1:25pm, which is outside of the Schedule, and I was able to access the Internet.
(please see the attached file "Access Log Screenshot.jpg" for a screenshot of the Access Log page)

If I click on the little "Eye Icon" in the Access Log page, it takes me to the Connection Information page for that Device, which confirms the correct Profile is being assigned.
(please see attached "Connection Information screenshot.jpg)

Any ideas of what I might be doing wrong?

Thanks in advance!



Attached Files Thumbnail(s)
           
Print this item

  Custom iptables rules
Posted by: rdavila - 01-09-2023, 03:49 PM - Forum: Network - Replies (1)

Hi everyone,

I hope this is the correct place to post this.

I want to add a few custom rules to iptables and I want them to be applied at boot time. Unfortunately there is no place in the KeexyBox Web Gui to enter custom iptable rules.

I checked /opt/keexybox and /etc for clues, but could not find any.

Where can I add custom iptables rules so they are saved and not overwritten by KeexyBox at boot time?

Thanks in advance!

Print this item

  [RESOLVED] Install script failing on Raspberry Pi model 2B
Posted by: m_keexybox_user - 01-03-2023, 02:22 PM - Forum: Installation - No Replies

I get the following error message:

Code:
Installing required Python modules...
Collecting mysql
Collecting MySQL-python
  Using cached https://files.pythonhosted.org/packages/a5/e9/51b544da85a36a68debe7a7091f068d802fc515a3a202652828c73453cad/MySQL-python-1.2.5.zip
Collecting mysql-connector
Collecting wget
Building wheels for collected packages: MySQL-python
  Running setup.py bdist_wheel for MySQL-python ... error
  Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-Zjx58n/MySQL-python/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" bdist_wheel -d /tmp/tmptdBSvSpip-wheel- --python-tag cp27:
  running bdist_wheel
  running build
  running build_py
  creating build
  creating build/lib.linux-armv7l-2.7
  copying _mysql_exceptions.py -> build/lib.linux-armv7l-2.7
  creating build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/__init__.py -> build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/converters.py -> build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/connections.py -> build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/cursors.py -> build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/release.py -> build/lib.linux-armv7l-2.7/MySQLdb
  copying MySQLdb/times.py -> build/lib.linux-armv7l-2.7/MySQLdb
  creating build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/__init__.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/CR.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/ER.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/FLAG.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/REFRESH.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  copying MySQLdb/constants/CLIENT.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
  running build_ext
  building '_mysql' extension
  creating build/temp.linux-armv7l-2.7
  arm-linux-gnueabihf-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fdebug-prefix-map=/build/python2.7-HeKf1z/python2.7-2.7.13=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-armv7l-2.7/_mysql.o
  In file included from _mysql.c:46:0:
  /usr/include/mysql/mysql.h:285:14: error: duplicate member ‘reconnect’
   unsigned int reconnect;
                ^~~~~~~~~
  /usr/include/mysql/mysql.h:288:11: error: duplicate member ‘reconnect’
     my_bool reconnect;  /* set to 1 if automatic reconnect */
             ^~~~~~~~~
  error: command 'arm-linux-gnueabihf-gcc' failed with exit status 1

  ----------------------------------------
  Failed building wheel for MySQL-python
  Running setup.py clean for MySQL-python
Failed to build MySQL-python
Installing collected packages: MySQL-python, mysql, mysql-connector, wget
  Running setup.py install for MySQL-python ... error
    Complete output from command /usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-Zjx58n/MySQL-python/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-2N5i3k-record/install-record.txt --single-version-externally-managed --compile:
    running install
    running build
    running build_py
    creating build
    creating build/lib.linux-armv7l-2.7
    copying _mysql_exceptions.py -> build/lib.linux-armv7l-2.7
    creating build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/__init__.py -> build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/converters.py -> build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/connections.py -> build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/cursors.py -> build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/release.py -> build/lib.linux-armv7l-2.7/MySQLdb
    copying MySQLdb/times.py -> build/lib.linux-armv7l-2.7/MySQLdb
    creating build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/__init__.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/CR.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/FIELD_TYPE.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/ER.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/FLAG.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/REFRESH.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    copying MySQLdb/constants/CLIENT.py -> build/lib.linux-armv7l-2.7/MySQLdb/constants
    running build_ext
    building '_mysql' extension
    creating build/temp.linux-armv7l-2.7
    arm-linux-gnueabihf-gcc -pthread -DNDEBUG -g -fwrapv -O2 -Wall -Wstrict-prototypes -fno-strict-aliasing -Wdate-time -D_FORTIFY_SOURCE=2 -g -fdebug-prefix-map=/build/python2.7-HeKf1z/python2.7-2.7.13=. -fstack-protector-strong -Wformat -Werror=format-security -fPIC -Dversion_info=(1,2,5,'final',1) -D__version__=1.2.5 -I/usr/include/mysql -I/usr/include/python2.7 -c _mysql.c -o build/temp.linux-armv7l-2.7/_mysql.o
    In file included from _mysql.c:46:0:
    /usr/include/mysql/mysql.h:285:14: error: duplicate member ‘reconnect’
     unsigned int reconnect;
                  ^~~~~~~~~
    /usr/include/mysql/mysql.h:288:11: error: duplicate member ‘reconnect’
       my_bool reconnect;  /* set to 1 if automatic reconnect */
               ^~~~~~~~~
    error: command 'arm-linux-gnueabihf-gcc' failed with exit status 1

    ----------------------------------------
Command "/usr/bin/python -u -c "import setuptools, tokenize;__file__='/tmp/pip-build-Zjx58n/MySQL-python/setup.py';f=getattr(tokenize, 'open', open)(__file__);code=f.read().replace('\r\n', '\n');f.close();exec(compile(code, __file__, 'exec'))" install --record /tmp/pip-2N5i3k-record/install-record.txt --single-version-externally-managed --compile" failed with error code 1 in /tmp/pip-build-Zjx58n/MySQL-python/
Errors on installing required packages

---- Checking installation of required packages for Keexybox ----

Checking installed packages
mariadb-server: OK
mariadb-client: OK
default-libmysqlclient-dev: OK
apache2: OK
libapache2-mod-php: OK
bridge-utils: OK
sudo: OK
ntp: OK
acl: OK
arp-scan: OK
php: OK
php-gettext: OK
php-gd: OK
php-intl: OK
php-json: OK
php-mysql: OK
php-readline: OK
php-curl: OK
python-pip: OK
python-dev: OK
python-mysqldb: OK
libproc-daemon-perl: OK
libfile-pid-perl: OK

Checking installed python modules
mysql: FAILED
MySQL-python: FAILED
mysql-connector: FAILED
wget: FAILED

-----------------------------------------------
Some required packages for Keexybox are missing
Installation aborted!
-----------------------------------------------


Upon inspection of the header file, it is a bit surprising to find reconnect being attempted to be defined in multiple places:

Code:
unsigned int reconnect;
unsigned int reconnect;
  enum mysql_status status;
  my_bool       free_me;                /* If free in mysql_close */
  my_bool       reconnect;              /* set to 1 if automatic reconnect */


Upon further re-runs and inspection, it appears that something is inserting the line below when it shouldn't and it's inserting it in a rather dumb way (doesn't check if this already exists and inserts it regardless)
Code:
unsigned int reconnect;


Upon checking further, the following code in "keexybox_21.04.2_raspios10/util/install_scripts/02_install_required_pkg.sh" seems to be adding the offending line:
Code:
# Fix issue when install MySQL connector for Python
sed '/st_mysql_options options;/a unsigned int reconnect;' /usr/include/mysql/mysql.h -i.bkp


Commenting out the 'sed' line as in below fixed the problem in the original post for me:

Code:
# Fix issue when install MySQL connector for Python
# sed '/st_mysql_options options;/a unsigned int reconnect;' /usr/include/mysql/mysql.h -i.bkp
Print this item

  Hardware
Posted by: emmsch - 12-27-2022, 05:22 AM - Forum: Users and devices connection management - Replies (1)

Hi Guys,

Thanks for the great software. This is regarding hardware for the software. Pi boards are hard to get nowadays. Is there an alternative hardware (similar to pi model) that can be used? Can it be installed in an android box? which is compact and so much easier to get.

Regards,

Emmanuel

Print this item

  Captive Portal Authentication success but no internet connected
Posted by: gvtgvt - 12-04-2022, 09:23 AM - Forum: Captive portal - No Replies

installed Keexybox in debian in local machine and using router with virtual server , captive portal forwarded to public static ip all works fine and from public ip everything is working but no mac details fetched after authentication successful and after auth success not able to use internet in browser even not ping using cmd prompt, need to install keexybox in private cloud like aws or azure , it is possible to done authentication of remote users using wireless lan controlelr like tplink omada controller and tplink based access point with External Portal Server (using keexybox).

Note: using Access point (Tplink Eap225) MAC is showing blank in Keexybox and DHCP is not enabled in Keexybox.

Print this item

  Captive Portal Options
Posted by: itpilot - 06-02-2022, 06:04 AM - Forum: Captive portal - Replies (1)

please guys can you assist me

firstly let me say thank you for an amazing product

1. how do i change the Background of the Captive Portal with a Picture?

2. how do I Add two Additional Fields for the Registration Page?

any help greatly appreciated

Print this item

  Installation on Pi Zero W
Posted by: devils13 - 05-19-2022, 12:06 AM - Forum: Installation - Replies (1)

Hi,

I am a noob to Raspberry Pi and Linux.  I need some parental control tools for my kids' iPads.  I came across this great website.  I used the Pi-hole on my RP zero w for some time.  

I tried to install KeexyBox but, it didn't work. So, wondering if you could have a look at what I've done and tell me what went wrong.

Install KeexyBox by flashing MicroSD

  1. Download Raspios Lite image bundled with latest KeexyBox. - 

  2. Use balenaEtcher to flash the downloaded .img.xz image on your MicroSD.

  3. Insert MicroSD card in your Raspberry PI.

  4. Plug a RJ45 cable between your Raspberry PI and your internet router.

  5. Plug micro USB power supply.

I followed the above except for the Step 4 since Pi Zero doesn't have a socket for a RJ45 cable. But, I created a wpa_supplicant.cont file with my wifi credentials (I did this because I didn't have a HDMI cable).  

For some reason, it didn't connect to the internet.  My questions is that do I need RJ45 cable to use the above method? 

I also did try to Install KeexyBox from installation script.
1. installed Raspberry Pi OS Lite (without desktop environment) 32 bit
2. connected to wifi via ssh
3. set APT repository (not 100% sure if I did this correctly though)
4. followed installation scripts.

As the installation went through, I could see a lot of 'Failed' lines e.g. bridge-tool, apache, php getext, php gd, database, python etc...

So, it failed to install KeexyBox at the end.  

thanks for your time.

Print this item

  Debian 11 (Bullseye)
Posted by: Vangerdahast - 04-07-2022, 12:45 PM - Forum: Installation - No Replies

Hello there,

was anyone successful in running KeexyBox on a Debian 11 (Bullseye) Linux?

I updated to it on my Raspi and now it is not possible anymore to login to the WLAN-Access Point.

If someone could offer me a clue on which entries to check for enabling the WLAN-Access Point again, it would be a great help  Wink

Probably the mysql Driver for the new python needs to be updated?

Output of /opt/keexybox/keexyapp/logs/cli-error.log

2022-04-07 12:26:56 Error: [PDOException] SQLSTATE[HY000] [2002] No such file or directory in /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Driver.php on line 92
Stack Trace:
#0 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Driver.php(92): PDO->__construct()
#1 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Driver/Mysql.php(105): Cake\Database\Driver->_connect()
#2 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Schema/BaseSchema.php(44): Cake\Database\Driver\Mysql->connect()
#3 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Dialect/MysqlDialectTrait.php(62): Cake\Database\Schema\BaseSchema->__construct()
#4 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Schema/Collection.php(51): Cake\Database\Driver\Mysql->schemaDialect()
#5 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Schema/CachedCollection.php(41): Cake\Database\Schema\Collection->__construct()
#6 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Database/Connection.php(390): Cake\Database\Schema\CachedCollection->__construct()
#7 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Table.php(558): Cake\Database\Connection->getSchemaCollection()
#8 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Query.php(269): Cake\ORM\Table->getSchema()
#9 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Query.php(167): Cake\ORM\Query->addDefaultTypes()
#10 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Table.php(1778): Cake\ORM\Query->__construct()
#11 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Table.php(1361): Cake\ORM\Table->query()
#12 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/ORM/Table.php(1611): Cake\ORM\Table->find()
#13 /opt/keexybox/keexyapp/src/Shell/BoxShell.php(73): Cake\ORM\Table->get()
#14 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Console/CommandRunner.php(383): App\Shell\BoxShell->initialize()
#15 /opt/keexybox/keexyapp/vendor/cakephp/cakephp/src/Console/CommandRunner.php(162): Cake\Console\CommandRunner->runShell()
#16 /opt/keexybox/keexyapp/bin/cake.php(12): Cake\Console\CommandRunner->run()
#17 {main}

The other logs are not as actual as this one (29th of March 2022, but my test system is not running daily!).

Print this item