| Subject | Re: [firebird-support] Problem to deploy application |
|---|---|
| Author | Fabricio D. Rossi |
| Post date | 2007-09-10T03:54:56Z |
hi again!!!
I solve the problem, but a don't know if is the best way.
Now can create database, table, make inserts, drop database, etc, from my application.
The structure of directory and files is the following:
/opt/my-apps
|-- bin
| |-- my-application
|-- lib
| |-- bin
| | |-- int
| | | |--fbintl
| | | |--fbintl.conf
| | |-- fb_lock_mgr
| |-- firebird.conf
| |-- firebird.msg
| |-- security2.fdb
| |-- libfbembed.so -> libfbembed.so.2
| |-- libfbembed.so.2 -> libfbembed.so.2.0.1
| |-- libfbembed.so.2.0.1
| |-- libicudata.so -> libicudata.so.30.0
| |-- libicudata.so.30 -> libicudata.so.30.0
| |-- libicudata.so.30.0
| |-- libicui18n.so -> libicui18n.so.30.0
| |-- libicui18n.so.30 -> libicui18n.so.30.0
| |-- libicui18n.so.30.0
| |-- libicuuc.so -> libicuuc.so.30.0
| |-- libicuuc.so.30 -> libicuuc.so.30.0
| |-- libicuuc.so.30.0
|-- db
|-- |-- mydb.fdb
and set the environment thus:
export FIREBIRD=/opt/my-apps/lib
export LD_LIBRARY_PATH=/opt/my-apps/lib
Any knows if this is correct way to distribute a application what use a firebird embedded?????
In Debian/Ubuntu work.
Thanks again.
Fabricio.
----- Mensaje original ----
De: Fabricio D. Rossi <planetaguru@...>
Para: firebird-support@yahoogroups.com
Enviado: domingo 9 de septiembre de 2007, 3:46:18
Asunto: [firebird-support] Problem to deploy application
Hi!
I need deploy my application to many linux box (debian/ubuntu) , but I have many problems to do it.
My limitation is :I cannot install Firebird Server and the access to database must be embedded.
I installed de package libfbembed2 but when I want create the database from application i have the next error:
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_ immediate failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544373
Engine Message :
operating system directive open failed
Permission denied
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_ immediate failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544373
Engine Message :
operating system directive open failed
Permission denied
The package libfbembeded2 contains libfbembed.so. 2.0.1 and a symblink libfbembed.so. 2 to libfbembed.so. 2.0.1.
Another test that makes is copy from directory of firebird/lib to the directory of my application and set LD_LIBRARY_PATH, but the error is: "error while loading shared libraries: libfbembed.so. 2: cannot open shared object file: No such file or directory"
The ask is: "what is the best way to distribute my application with firebird embedded?"
I desire is this directory
/opt/XXX/bin
/opt/XXX/lib
/opt/XXX/database
This program must be run as non-root privileges
My environment is:
Framework: boost/stl
IDE: Eclipse with plugin CDT
Access to Firebird: IBPP
Operating System: Debian Testing
Thank you and sorry for my english.
Fabricio.
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo. com/
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo.com/
[Non-text portions of this message have been removed]
I solve the problem, but a don't know if is the best way.
Now can create database, table, make inserts, drop database, etc, from my application.
The structure of directory and files is the following:
/opt/my-apps
|-- bin
| |-- my-application
|-- lib
| |-- bin
| | |-- int
| | | |--fbintl
| | | |--fbintl.conf
| | |-- fb_lock_mgr
| |-- firebird.conf
| |-- firebird.msg
| |-- security2.fdb
| |-- libfbembed.so -> libfbembed.so.2
| |-- libfbembed.so.2 -> libfbembed.so.2.0.1
| |-- libfbembed.so.2.0.1
| |-- libicudata.so -> libicudata.so.30.0
| |-- libicudata.so.30 -> libicudata.so.30.0
| |-- libicudata.so.30.0
| |-- libicui18n.so -> libicui18n.so.30.0
| |-- libicui18n.so.30 -> libicui18n.so.30.0
| |-- libicui18n.so.30.0
| |-- libicuuc.so -> libicuuc.so.30.0
| |-- libicuuc.so.30 -> libicuuc.so.30.0
| |-- libicuuc.so.30.0
|-- db
|-- |-- mydb.fdb
and set the environment thus:
export FIREBIRD=/opt/my-apps/lib
export LD_LIBRARY_PATH=/opt/my-apps/lib
Any knows if this is correct way to distribute a application what use a firebird embedded?????
In Debian/Ubuntu work.
Thanks again.
Fabricio.
----- Mensaje original ----
De: Fabricio D. Rossi <planetaguru@...>
Para: firebird-support@yahoogroups.com
Enviado: domingo 9 de septiembre de 2007, 3:46:18
Asunto: [firebird-support] Problem to deploy application
Hi!
I need deploy my application to many linux box (debian/ubuntu) , but I have many problems to do it.
My limitation is :I cannot install Firebird Server and the access to database must be embedded.
I installed de package libfbembed2 but when I want create the database from application i have the next error:
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_ immediate failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544373
Engine Message :
operating system directive open failed
Permission denied
*** IBPP::SQLException ***
Context: Database::Create
Message: isc_dsql_execute_ immediate failed
SQL Message : -902
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements
Engine Code : 335544373
Engine Message :
operating system directive open failed
Permission denied
The package libfbembeded2 contains libfbembed.so. 2.0.1 and a symblink libfbembed.so. 2 to libfbembed.so. 2.0.1.
Another test that makes is copy from directory of firebird/lib to the directory of my application and set LD_LIBRARY_PATH, but the error is: "error while loading shared libraries: libfbembed.so. 2: cannot open shared object file: No such file or directory"
The ask is: "what is the best way to distribute my application with firebird embedded?"
I desire is this directory
/opt/XXX/bin
/opt/XXX/lib
/opt/XXX/database
This program must be run as non-root privileges
My environment is:
Framework: boost/stl
IDE: Eclipse with plugin CDT
Access to Firebird: IBPP
Operating System: Debian Testing
Thank you and sorry for my english.
Fabricio.
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo. com/
<!--
#ygrp-mkp{
border:1px solid #d8d8d8;font-family:Arial;margin:14px 0px;padding:0px 14px;}
#ygrp-mkp hr{
border:1px solid #d8d8d8;}
#ygrp-mkp #hd{
color:#628c2a;font-size:85%;font-weight:bold;line-height:122%;margin:10px 0px;}
#ygrp-mkp #ads{
margin-bottom:10px;}
#ygrp-mkp .ad{
padding:0 0;}
#ygrp-mkp .ad a{
color:#0000ff;text-decoration:none;}
-->
<!--
#ygrp-sponsor #ygrp-lc{
font-family:Arial;}
#ygrp-sponsor #ygrp-lc #hd{
margin:10px 0px;font-weight:bold;font-size:78%;line-height:122%;}
#ygrp-sponsor #ygrp-lc .ad{
margin-bottom:10px;padding:0 0;}
-->
<!--
#ygrp-mlmsg {font-size:13px;font-family:arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg table {font-size:inherit;font:100%;}
#ygrp-mlmsg select, input, textarea {font:99% arial, helvetica, clean, sans-serif;}
#ygrp-mlmsg pre, code {font:115% monospace;}
#ygrp-mlmsg * {line-height:1.22em;}
#ygrp-text{
font-family:Georgia;
}
#ygrp-text p{
margin:0 0 1em 0;}
#ygrp-tpmsgs{
font-family:Arial;
clear:both;}
#ygrp-vitnav{
padding-top:10px;font-family:Verdana;font-size:77%;margin:0;}
#ygrp-vitnav a{
padding:0 1px;}
#ygrp-actbar{
clear:both;margin:25px 0;white-space:nowrap;color:#666;text-align:right;}
#ygrp-actbar .left{
float:left;white-space:nowrap;}
.bld{font-weight:bold;}
#ygrp-grft{
font-family:Verdana;font-size:77%;padding:15px 0;}
#ygrp-ft{
font-family:verdana;font-size:77%;border-top:1px solid #666;
padding:5px 0;
}
#ygrp-mlmsg #logo{
padding-bottom:10px;}
#ygrp-vital{
background-color:#e0ecee;margin-bottom:20px;padding:2px 0 8px 8px;}
#ygrp-vital #vithd{
font-size:77%;font-family:Verdana;font-weight:bold;color:#333;text-transform:uppercase;}
#ygrp-vital ul{
padding:0;margin:2px 0;}
#ygrp-vital ul li{
list-style-type:none;clear:both;border:1px solid #e0ecee;
}
#ygrp-vital ul li .ct{
font-weight:bold;color:#ff7900;float:right;width:2em;text-align:right;padding-right:.5em;}
#ygrp-vital ul li .cat{
font-weight:bold;}
#ygrp-vital a{
text-decoration:none;}
#ygrp-vital a:hover{
text-decoration:underline;}
#ygrp-sponsor #hd{
color:#999;font-size:77%;}
#ygrp-sponsor #ov{
padding:6px 13px;background-color:#e0ecee;margin-bottom:20px;}
#ygrp-sponsor #ov ul{
padding:0 0 0 8px;margin:0;}
#ygrp-sponsor #ov li{
list-style-type:square;padding:6px 0;font-size:77%;}
#ygrp-sponsor #ov li a{
text-decoration:none;font-size:130%;}
#ygrp-sponsor #nc{
background-color:#eee;margin-bottom:20px;padding:0 8px;}
#ygrp-sponsor .ad{
padding:8px 0;}
#ygrp-sponsor .ad #hd1{
font-family:Arial;font-weight:bold;color:#628c2a;font-size:100%;line-height:122%;}
#ygrp-sponsor .ad a{
text-decoration:none;}
#ygrp-sponsor .ad a:hover{
text-decoration:underline;}
#ygrp-sponsor .ad p{
margin:0;}
o{font-size:0;}
.MsoNormal{
margin:0 0 0 0;}
#ygrp-text tt{
font-size:120%;}
blockquote{margin:0 0 0 4px;}
.replbq{margin:4;}
-->
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo.com/
[Non-text portions of this message have been removed]