blox

   

HomeBLOX Support

Get help with installing and configuring Blox SBC

Read Only SQLITE? Messages in this topic - RSS

cramermp
cramermp
Posts: 3


3/6/2017
cramermp
cramermp
Posts: 3
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?

Attachments:
Capture.PNG
0 link
bloxsupport1
bloxsupport1
Posts: 120


3/7/2017
bloxsupport1
bloxsupport1
Posts: 120
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
cramermp
Posts: 3


3/7/2017
cramermp
cramermp
Posts: 3
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
cramermp
Posts: 3


3/9/2017
cramermp
cramermp
Posts: 3
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
bloxsupport1
Posts: 120


3/9/2017
bloxsupport1
bloxsupport1
Posts: 120
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
Cliff Farley
Posts: 2


5/2/2017
Cliff Farley
Cliff Farley
Posts: 2
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
bloxsupport1
Posts: 120


5/2/2017
bloxsupport1
bloxsupport1
Posts: 120
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
mkeys
Posts: 6


5/10/2017
mkeys
mkeys
Posts: 6
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
bloxsupport1
Posts: 120


5/10/2017
bloxsupport1
bloxsupport1
Posts: 120
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
mkeys
Posts: 6


5/11/2017
mkeys
mkeys
Posts: 6
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
Sepp
Posts: 7


6/27/2017
Sepp
Sepp
Posts: 7
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
bloxsupport1
Posts: 120


6/27/2017
bloxsupport1
bloxsupport1
Posts: 120
hello sebastian,
Can you run the following command and send us output

$ rpm -qa | grep blox

$ cat /etc/issue
0 link
Sepp
Sepp
Posts: 7


6/27/2017
Sepp
Sepp
Posts: 7
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
bloxsupport1
Posts: 120


6/27/2017
bloxsupport1
bloxsupport1
Posts: 120
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
Sepp
Posts: 7


6/28/2017
Sepp
Sepp
Posts: 7
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
bloxsupport1
Posts: 120


6/28/2017
bloxsupport1
bloxsupport1
Posts: 120
output of following command ?

$ php -v
0 link
Sepp
Sepp
Posts: 7


6/28/2017
Sepp
Sepp
Posts: 7
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
bloxsupport1
Posts: 120


6/29/2017
bloxsupport1
bloxsupport1
Posts: 120
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
bloxsupport1
Posts: 120


6/30/2017
bloxsupport1
bloxsupport1
Posts: 120
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






Powered by blox.org 1.0.0.0 © 2015