1. Alexis Colon Lugo
  2. Valentina Database ADK
  3. Monday, April 08 2019, 02:04 PM
  4.  Subscribe via email
Hi
How i can config Rest Sqlite server in linux and connect my iPhone with XOJO app.

if any example for it

thanks
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
Yes, if it is behind the router
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 1
Alexis Colon Lugo Accepted Answer
ok
so i have to do port forwarding for my REST server (Yes/No)

thanks
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 2
Sergey Pashkov Accepted Answer
You can edit /opt/VServer/vserver.ini, find following lines and change Port_REST:
[REST]
; Port to listen REST clients.
; 0 - do not use REST port.
Port_REST=0

Or you can connect to Valentina port and change Port REST property of connection.

In both cases, it is necessary to restart:
sudo service vserver restart
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 3
Alexis Colon Lugo Accepted Answer
ok
cool
where i assigned REST port
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 4
Sergey Pashkov Accepted Answer
Hi Alexis,

The server is installed to /opt/VServer directory.
You can check its logs in the /opt/VServer/vlogs folder.

Do you mean open port in the firewall? The default Valentina port is 15432, REST port needs to be assigned
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 5
Alexis Colon Lugo Accepted Answer
hi
if i have to open any port number
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 6
Alexis Colon Lugo Accepted Answer
hi
who i now this install and working on the PI
after use sudo dpkg -i vserver_armhf_32_9_lin.deb
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 7
Sergey Pashkov Accepted Answer
Install from command line:
wget http://valentina-db.com/download/release/lin_arm_32/vserver_armhf_32_9_lin.deb
sudo dpkg -i vserver_armhf_32_9_lin.deb

If you want to generate reports, it is also necessary to install fonts.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 8
Alexis Colon Lugo Accepted Answer
ok thanks
If any instruction steps for install valentina server on Raspberry pi 3 B+ with Valentina server REST por test.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 9
Sergey Pashkov Accepted Answer
Hello Alexis,

In order to enable REST interface on the server, you should assign the value to "Port REST" property of Valentina connection and restart the server.

Here are examples of how to work with SQLite:
~/Paradigma Software/V4RB_9/Examples/REST

I recommend looking at the following:

  • iOS_vSQLite_Fast - open/close connection, execute basic SQL and get results
  • iOS_VReport_vSQLite - open/close connection, generate report, show it
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Database ADK
  3. # 10
  • Page :
  • 1


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