3/6/2017
Topic:
Read Only SQLITE?
cramermp
|
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? |
3/7/2017
Topic:
Read Only SQLITE?
cramermp
|
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. |
3/9/2017
Topic:
Read Only SQLITE?
cramermp
|
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. |