1. Alexis Colon Lugo
  2. as SQLite DB Server
  3. Wednesday, May 01 2019, 11:57 AM
  4.  Subscribe via email
Hi
i need to made one app for iPad but i need to sync with my local mini server with valentina sqlite server.

can this works or no

thanks
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
For SQLite databases it is necessary to write database name with extension - ipadcr.db

Do you have a license in /opt/VServer/licenses?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 41
Alexis Colon Lugo Accepted Answer
yes lic is on the folder

pi@raspberrypi:/opt/VServer/licenses $ sudo ls
serials_190525 00105711.csv
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 42
Alexis Colon Lugo Accepted Answer
the info look ok
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 43
Sergey Pashkov Accepted Answer
The correct license file is named like:
license_lin_1234567890123456

Please add log entries about error - "unable to open database file".".
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 44
Alexis Colon Lugo Accepted Answer
pi@raspberrypi:/opt/VServer/vlogs $ sudo tail -f vserver_20190702_145540.log
2019-07-02 16:12:34.276280 (TID 1767887664): (UID 19) SqliteStatement 'SELECT RowID AS RowID, "accnum", "nombre", "apellidos", "tel", "email", "locate" FROM "main" ORDER BY "RowID" ASC LIMIT 500 OFFSET 0' remoteID 1816411040 registered.
2019-07-02 16:12:34.282497 (TID 1767887664): (UID 19) SqliteCursor remoteID 1816320744 registered.
2019-07-02 16:12:34.289773 (TID 1742709552): (UID 19) ERROR 0x68500: Sqlite db "ipadcr.db": Error : "cannot commit - no transaction is active".
2019-07-02 16:12:34.293344 (TID 1767887664): (UID 19) SqliteStatement 'SELECT RowID AS RowID, "accnum", "nombre", "apellidos", "tel", "email", "locate" FROM "main" ORDER BY "RowID" ASC LIMIT 500 OFFSET 0' remoteID 1816411040 unregistered.
2019-07-02 16:12:34.293544 (TID 1767887664): (UID 19) SqliteCursor remoteID 1816320744 unregistered.
2019-07-02 16:12:48.999540 (TID 1742709552): (UID 19) Closing SqliteDatabase 'ipadcr.db': OK
2019-07-02 16:12:48.999775 (TID 1742709552): (UID 19) SqliteDatabase 'ipadcr.db' remoteID 1837193216 unregistered.
2019-07-02 16:12:49.029642 (TID 1742709552): (UID 19) Closing SqliteDatabase 'iPadProjects.db': OK
2019-07-02 16:12:49.029872 (TID 1742709552): (UID 19) SqliteDatabase 'iPadProjects.db' remoteID 1816185120 unregistered.
2019-07-02 16:12:49.029999 (TID 1742709552): (UID 19) Closing vSqlite-connection. ( vSqlite-connections count: '0'. Available: '1')
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 45
Sergey Pashkov Accepted Answer
It is necessary to place the correct license file and restart the system.
Without the license, only one connection works and if you don't close it - the next connection attempt you get Error - "Service unavailable".
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 46
Alexis Colon Lugo Accepted Answer
I add new lic and reboot but is no working

pi@raspberrypi:/opt/VServer/vlogs $ sudo tail -f vserver_20190703_103631.log
vServer is still working though (single connection allowed).
You need to get a FREE license with 5 Valentina DB, 10 SQLite, and 10 REST connections
OR purchase a license with more connections at Paradigma Store <http://www.valentina-db.com/en/store>;.
You will get your license file by email. Drop it into licenses folder and start server.

2019-07-03 10:45:41.699078 (TID 1865544496): (UID 20) REST connection 20892e654aac205efd602227a00bbcb1 established with '10.123.0.3:57636'. ( available: '0')
2019-07-03 10:45:42.586646 (TID 1847587632): Start parsing 'ipadcr.db' Access Control List (ACL).
2019-07-03 10:45:42.595994 (TID 1847587632): Finish parsing 'ipadcr.db' Access Control List (ACL).
2019-07-03 10:45:42.630810 (TID 1847587632): (UID 20) URI: "/rest/session_20892e654aac205efd602227a00bbcb1;/sql_fast". Error - "Sqlite db "/opt/VServer/databases_sqlite/ipadcr.db": Error : "unable to open database file".".
2019-07-03 10:45:47.465207 (TID 1857151792): (UID 20) Closing REST connection 20892e654aac205efd602227a00bbcb1. ( available: '1')
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 47
Sergey Pashkov Accepted Answer
License is not recognized.
Is it a newly generated? Please send it to me to check (sergey_pashkov@valentina-db.com)
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 48
Sergey Pashkov Accepted Answer
The license is working on my server:
user@user:/opt/VServer/vlogs$ sudo cat vserver_20190704_060811.log
2019-07-04 06:08:11.516330 (TID 140384127850688): Database engine inited
Licence license_lin_4440801612235611 is registered to Alexis Colon Lugo.
Valid until 9999-12-31. Subscription valid until 2020-07-02.

What do you have at the top of your log file?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 49
Sergey Pashkov Accepted Answer
Ok, please try to remove serials_190702 00107980.csv (leave only license_lin_4440801612235611 in the /opt/VServer/licenses) and restart the server.
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 50
Ruslan Zasukhin Accepted Answer
Maybe you will start a new discussion for each separate issue?
Comment
There are no comments made yet.
  1. more than a month ago
  2. as SQLite DB Server
  3. # 51
  • Page :
  • 1
  • 2
  • 3


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories