cramermp Posts: 3
3/6/2017
|
Installed blox on a VM and installed freeblox. However, when I try to use freeblox to change things, i get the following errors: Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /home/freeblox/www/htdocs/shield/Model/device_settings_model.php on line 141" There are about 15 of these that pop up really quick, then vanish with a "settings successfully saved" message. I recorded my desktop so I could capture the errors, as I don't see these getting logged, but then I don't know where the logs are kept.
I went into one of the php files mentioned, and found a reference to db_mgr.php, so I took a look and saw a SQLite database in /etc/freeblox_config/DB . Looking at messages regarding SQLite and this error, it looked like a file permissions problem, so I changed permissions on the DB folder and the files within to 777. I know this is a huge security risk, but I'm just seeing if I can get it to work somehow; unfortunately opening the permissions on these files/this folder did nothing to resolve my problem.
This is a fresh distro install with essentially zero configuration on it; not sure why I can't start basic configuration, did I mess up somewhere in the install, maybe?
|
|
0
link
|
bloxsupport1 Posts: 232
3/7/2017
|
Hello, Can you please tell us the version of blox you are using, did you rebooted the machine after installing the freeblox? If not please do reboot and try once again You can also contact us through skype at "blox.support" for online support
Thanks & Regards Blox Support Team
cramermp wrote:
Installed blox on a VM and installed freeblox. However, when I try to use freeblox to change things, i get the following errors: Warning: SQLite3Stmt::execute(): Unable to execute statement: attempt to write a readonly database in /home/freeblox/www/htdocs/shield/Model/device_settings_model.php on line 141" There are about 15 of these that pop up really quick, then vanish with a "settings successfully saved" message. I recorded my desktop so I could capture the errors, as I don't see these getting logged, but then I don't know where the logs are kept.
I went into one of the php files mentioned, and found a reference to db_mgr.php, so I took a look and saw a SQLite database in /etc/freeblox_config/DB . Looking at messages regarding SQLite and this error, it looked like a file permissions problem, so I changed permissions on the DB folder and the files within to 777. I know this is a huge security risk, but I'm just seeing if I can get it to work somehow; unfortunately opening the permissions on these files/this folder did nothing to resolve my problem.
This is a fresh distro install with essentially zero configuration on it; not sure why I can't start basic configuration, did I mess up somewhere in the install, maybe?
|
|
0
link
|
cramermp Posts: 3
3/7/2017
|
Should be the latest available; 1.0.0.44. You can see the version number in the top right of the attached image I provided in my first message.
Yes, I rebooted the machine when I saw the issue, thinking that perhaps something had locked the file in use.
I won't be able to skype to discuss this issue until tomorrow, but I likely will then.
|
|
0
link
|
cramermp Posts: 3
3/9/2017
|
What is the best time to reach support? I'm the US. I tried contacting you today at 1pm (-6 UTC), and waited for contact until 5pm, but I'm guessing it's night time in India.
Also, I went wrong when I did a 'yum upgrade', I think, so I did a fresh install, and now freeblox seems to be working.
Unfortunately, I could not configure a network interface, because when adding a new interface the "DEVICE" only has "None" available to select. I tried rebooting to fix, and on reboot something deleted my network configuration. Using 'setup' again didn't work to restore the configuration. I manually created /etc/sysconfig/network-scripts/ifcfg-eth0 and got my interface working again, but I still can't add any network interfaces or use the 'setup' tool to make changes.
|
|
0
link
|
bloxsupport1 Posts: 232
3/9/2017
|
Hello, Blox Support will be available from 10.00 AM to 5.00 PM IST
For listing out the interfaces installed through the freeblox GUI Please press the refresh button in the Network Status panel in the dashboard
Thanks & Regards Blox Support Team
cramermp wrote:
What is the best time to reach support? I'm the US. I tried contacting you today at 1pm (-6 UTC), and waited for contact until 5pm, but I'm guessing it's night time in India.
Also, I went wrong when I did a 'yum upgrade', I think, so I did a fresh install, and now freeblox seems to be working.
Unfortunately, I could not configure a network interface, because when adding a new interface the "DEVICE" only has "None" available to select. I tried rebooting to fix, and on reboot something deleted my network configuration. Using 'setup' again didn't work to restore the configuration. I manually created /etc/sysconfig/network-scripts/ifcfg-eth0 and got my interface working again, but I still can't add any network interfaces or use the 'setup' tool to make changes.
|
|
0
link
|
Cliff Farley Posts: 2
5/2/2017
|
Interesting we had pretty much the exact same issue with the very latest download. We blew it away and reloaded everything and it worked but just to have the same issue with the network configuration. It took some time until we figured out we needed to press the refresh button before you could essentially do anything. Love the system so far and haven't even gotten it fully functional yet. The refresh button not really intuitive though.
Have a great day. Cliff
|
|
0
link
|
bloxsupport1 Posts: 232
5/2/2017
|
Hello Cliff,
Thanks for your feedback. Usage of Refresh button used mainly after migrating to newer version(once), to ensure the system integrity if migration failed unexpectedly.
Thanks
|
|
0
link
|
mkeys Posts: 6
5/10/2017
|
Hello, I'm a new user testing freeblox. I ran into this problem also. If you install from iso, then yum update to centos 6.9 after the first boot, this will break database read/write.
Regards, Matt
|
|
0
link
|
bloxsupport1 Posts: 232
5/10/2017
|
mkeys wrote:
Hello, I'm a new user testing freeblox. I ran into this problem also. If you install from iso, then yum update to centos 6.9 after the first boot, this will break database read/write.
Regards, Matt
Hello Matt,
We don't support other ISO, if you have any requirement to do so, please contact support@blox.org
Thanks
|
|
0
link
|
mkeys Posts: 6
5/11/2017
|
bloxsupport1 wrote:
Hello Matt,
We don't support other ISO, if you have any requirement to do so, please contact support@blox.org
Thanks
It's your ISO ...
$ md5sum Blox-1.0.4-8-stable-x86_64.iso 31aa4b3ad0311ec2c91fc1fb560e4908 Blox-1.0.4-8-stable-x86_64.iso
At first boot :
dhclient eth0 yum clean all yum update -y reboot
.. at second boot:
# md5sum freeblox.tar 47f26a3fc161a9f3ee82e23289574495 freeblox.tar
tar -xvf freeblox.tar cd freeblox
# md5sum freeblox-1.0.4-8.x86_64.rpm dfdf4f44876d4061dec08d0704ae36d5 freeblox-1.0.4-8.x86_64.rpm
rpm -ivh freeblox-1.0.4-8.x86_64.rpm reboot
... at third boot login as default admin/admin then try to make a change like the admin password.
Regards, Matt
|
|
0
link
|
Sepp Posts: 7
6/27/2017
|
Hi everyone, I'm new to this application and just started working with it. I'm having the above posted issues, too. When I'm clicking on Refresh on the Network status I get the same error. I can't change my password either. I tried all the steps stated above which did not resolve the problems at all.
I hope you can help me Best wishes Sebastian
|
|
0
link
|
bloxsupport1 Posts: 232
6/27/2017
|
hello sebastian, Can you run the following command and send us output
$ rpm -qa | grep blox
$ cat /etc/issue
|
|
0
link
|
Sepp Posts: 7
6/27/2017
|
Thanks for the fast reply. $rpm -qa | grep blox showed the following: blox_opensips-1.0.4-8.x86_64 blox_ministun_client--1.0.4-8.x86_64 blox_security-1.0.4-8.x86_64 blox-rpm-keys-1.0.4-8.x86_64 blox_rtppinhole-1.0.4-8.x86_64 blox_core-1.0.4-8.x86_64 blox_rtpengine-1.0.4-8.x86_64 freeblox-1.0.4-8.x86_64
$cat /etc/issue showed: Blox 1.0.4
Best regards Sebastian edited by Sepp on 6/27/2017
|
|
0
link
|
bloxsupport1 Posts: 232
6/27/2017
|
Hello Sabastian,
Can you reinstall freeblox rpm again using following command
$ rpm -ivh --force freeblox-1.0.4.x86_64.rpm
username: admin password: admin
Let know if you get error. also send us the output of
$ ls -lRt /etc/freeblox* and $ ps aux | grep blox
edited by bloxsupport1 on 6/27/2017 edited by bloxsupport1 on 6/27/2017
|
|
0
link
|
Sepp Posts: 7
6/28/2017
|
Hi, the reinstallation did not resolve the problem... This is what ls -lRt /etc/freeblox* showed me: total 28 drwxr-xr-x. 2 root root 4096 Jun 28 09:00 conf.d -rw-r--r--. 1 root root 1840 Jun 26 14:08 webserver.pem -rw-r--r--. 1 root root 384 Mar 6 07:30 blox_webui_certconf -rw-r--r--. 1 root root 1646 Mar 6 07:30 lighttpd.conf -rw-r--r--. 1 root root 186 Mar 6 07:30 modules.conf -rw-r--r--. 1 root root 46 Mar 6 07:30 webauth.conf -rw-r--r--. 1 root root 17 Mar 6 07:30 webport.conf
/etc/freeblox/conf.d: total 24 -rw-r--r--. 1 root root 714 Mar 6 07:30 access_log.conf -rw-r--r--. 1 root root 448 Mar 6 07:30 auth.conf -rw-r--r--. 1 root root 953 Mar 6 07:30 cgi.conf -rw-r--r--. 1 root root 1036 Mar 6 07:30 fastcgi.conf -rw-r--r--. 1 root root 2965 Mar 6 07:30 mime.conf -rw-r--r--. 1 root root 391 Mar 6 07:30 ssi.conf
/etc/freeblox_conf: total 4 drwxr-xr-x. 2 root root 4096 Jun 28 09:00 DB
/etc/freeblox_conf/DB: total 420 -rw-r--r--. 1 root root 142336 Jun 28 09:00 freeblox.db.persist -rw-r--r--. 1 root root 142336 Mar 27 14:20 freeblox.db -rw-r--r--. 1 root root 142336 Mar 27 14:20 freeblox.db.default
Here is the output of ps aux | grep blox: root 1848 0.0 0.0 26240 800 ? Ss 09:01 0:00 nginx: master process /usr/local/ngx-blox/sbin/nginx root 1873 0.0 0.0 8152 492 ? S 09:01 0:00 /usr/bin/inotify-recursive /var/log/blox-notify root 2011 0.0 0.3 58924 3104 ? S 09:01 0:00 /usr/sbin/freeblox -f /etc/freeblox/lighttpd.conf root 2018 0.0 0.8 245096 8612 ? Ss 09:01 0:00 /usr/bin/php-cgi -c /etc/php.ini.freeblox root 2047 0.2 0.6 245320 6540 ? S 09:01 0:00 /usr/bin/php-cgi -c /etc/php.ini.freeblox root 2684 0.0 0.0 105372 868 pts/1 S+ 09:04 0:00 grep blox
Thank in advance Best wishes Sebastian
|
|
0
link
|
bloxsupport1 Posts: 232
6/28/2017
|
output of following command ?
$ php -v
|
|
0
link
|
Sepp Posts: 7
6/28/2017
|
PHP 5.4.41 (cli) (build: May 15 2015 09:23:14) Copyright (c) 1997-2014 The PHP Group Zend Engine v2.4.0, Copyright (c) 1998-2014 Zend Technologies edited by Sepp on 6/28/2017
|
|
0
link
|
bloxsupport1 Posts: 232
6/29/2017
|
Hello Sebastian, Is it possible to provide us remote access ? you can send the credential and access info to support@blox.org Thanks
|
|
0
link
|
bloxsupport1 Posts: 232
6/30/2017
|
Incase anyone facing the similar issue, please disable the selinux and reboot refer: https://www.centos.org/docs/5/html/5.1/Deployment_Guide/sec-sel-enable-disable.html
|
|
0
link
|
pleekit Posts: 8
8/4/2018
|
I re-enabled my SELINUX to enforcing.
Then applied this command setsebool -P httpd_unified 1
And did not see this issue again. The selinux logs /var/log/audit gives some clues as to what is being denied.
Did a yum update on the Blox SBC to Centos 6.10 but on a VMWare instance. Not sure if anything else is broken.
Still haven't been able to successfully install it via USB CD-ROM on my Qotom J1900 Quad LAN server.
|
|
0
link
|