I am working on a project for a ‘redudant’ teamspeak server wtih aws. Ive got most of what I need done, however I’m running into a snag. Teamspeak A is the primary server, and is running fine. I need to copy the database from server A to server B. I’m doing this via S3 and … Read more
CentOS8 is distributed with sqlite3 version 3.26. I would like to build a php 7.4 RPM with the version 3.35 of sqlite3. Do you any advice to do so ? Answer Use Fedora instead of CentOS, and its packages of php and sqlite. Perhaps confined to VMs or containers for applications requiring such a stack. … Read more
I’ve got a Jenkins/Nginx server running. But I get the error from Django: attempt to write a readonly database So I solved this problem by changing the ownership of the project folder to the default user: chown -R joren . Now Django is working properly, but Jenkins doesn’t seem to agree because now it is … Read more
My authentication fails with java.sql.SQLException: no such table: credentials where credentials is the name of the user/password table. I have checked the db file and the table is there. I think you also get this error when sqlite jdbc can’t even find the file. I am specifying my realm in a META-INF/context.xml file. Is there … Read more
I’m been playing around with SQlite at work, specifically with trying to get the sqlite3 command line tool to accept stdin instead of a file. Sounds easy enough, on linux you can execute a command like: echo ‘test’ | sqlite3 test.db ‘.import /dev/stdin test’ unfortunately – our machines at work run AIX (5 & 6) … Read more
I’m looking to auto pull an xml file from an offsite url and merge it into a sqlite db every two hours. The server is lamp. (If it is too difficult to do for sqlite, then merging the xml into a mysql table would also be fine.) xml: <entries> <entry> <name>John Smith</name> <age>20</age> <gender>male</gender> </entry> … Read more
When I try to deploy my Rails application to an Apache server using Passenger, I get the following error in the logs: undefined symbol: sqlite3_initialize I get the same error when just running webrick using “rails s”. How do I fix this? I’m using the latest Rails 3.0.9 and whatever the default SQLite is when … Read more
So I have a dedicated machine running Ubuntu 12.04 server with FreePBX 2.9. Earlier I was attempting to familiarize myself with SQL via sqlite3, but I received this dreaded error: SQLite header and source version mismatch So I saw a possible fix was to remove sqlite3 from the system and re-install. I did, and I … Read more
Using: CentOS 6 Asterisk 12 cdr_sqlite3_custom.so cdr_sqlite3_custom.conf (deliberately simplified): [master] table=>cdr columns=>calldate, clid, test values=>’${CDR(start)}’,’${CDR(clid)}’,’test’ Resulting in database lacking CDR values: sqlite> select * from cdr; AcctId|calldate|clid|test 1|||test 2|||test 3|||test 4|||test IDs are incementing, test value is there, but it doesn’t want to grab CDR variables from values=>’${CDR(start)}’,’${CDR(clid)}’,’test’ Any ideas where the problem might be? … Read more
In a Fedora system, I need to convert the Owncloud’s SQLite database into a MySQL/MariaDB database I started installing MySQL: # systemctl enable mysqld # systemctl start mysqld $ mysql_secure_installation then $ mysql -u root -p CREATE USER ‘owncloud_user’@’localhost’ IDENTIFIED BY ‘12345’; CREATE DATABASE IF NOT EXISTS owncloud; GRANT ALL PRIVILEGES ON owncloud.* TO ‘owncloud_user’@’localhost’ … Read more
