Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

On Mon, Feb 19, 2018 at 10:21 AM, peshk...@mail.ru [firebird-support] <
firebird-support@yahoogroups.com> wrote:
>
>
> The problem is where should we place tmp files (including lock files and
> other shared files) now. Application cache may be at any moment cleaned
> which will cause problems if fb engine is running. Do you have better ideas
> than /storage/emulated/legacy/firebird ?
> __._,_.__
>
I'm totally lost with Android folder structure,
each version have a different hierarchy, folder links, and permission
rules...

On my devices (one Android 4.4 and two 6.0) only the 4.4 have the folder
/storage/emulated/legacy .
The 6.0 have /storage/emulated/0

So, I don't have no idea of a place that works among several versions.

I will try to find more information about this.


ps:

Worse... I have the embedded running on Android 6 but on 4.4 I'm getting
the error :
SQL Message : -904
Unsuccessful execution caused by an unavailable resource.

Engine Code: 335544375
Engine Message :
unavailable database

both for local and remote connections and everything is in the same place


Regards
jGoncalves
_,_._,___



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

On Mon, Feb 19, 2018 at 9:16 AM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> ---In firebird-support@yahoogroups.com,  wrote :
> >
>
> > files/firebird/intl/libfbintl. so
> /*The icu files are not in the distributed tar */
>
>   This is wrong structure, where do you get it ?
>

Trying  to use the same structure from Windows:

libclient in on folder and then the plugins and int folders relative to
this.



>
>   For correct structure look at android build here
>
> https://github.com/FirebirdSQL/firebird/releases/
> download/R3_0_3/Firebird-3.0.3.32900-0.arm.tar.gz
>
>   It contains subfolders :
> /bin with executables (you don't need it for embedded),
> /lib with libfbclient.so (you don't have it and this is the reason for
> errors you see)
>
>
I will try that later.

Regards
jGoncalves

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

On Mon, Feb 19, 2018 at 10:04 AM, Jorge Gonçalves 
wrote:

>
>
>
>
>>
>>   For correct structure look at android build here
>>
>> https://github.com/FirebirdSQL/firebird/releases/download/
>> R3_0_3/Firebird-3.0.3.32900-0.arm.tar.gz
>>
>>   It contains subfolders :
>> /bin with executables (you don't need it for embedded),
>> /lib with libfbclient.so (you don't have it and this is the reason for
>> errors you see)
>>
>>
> I will try that later.
>

My mistake to assume that the structure are the same from windows.

Keeping the original structure does the job.

But I think that the FB team should work on this, since the process of
installing on Android is not a easy job.

Because there are a fixed structure is impossible to use the lib folder to
install the native libraries.





Thanks



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [firebird-support] Android Question

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Hi,
I think that the server are impossible to run on Android higher than 5.


About the embedded version I got it to run with the help of Vlad.

The process is a little tricky.

1º
You must put the files( libfbclient, libEngine12, .. ) on asset folder and
then copy that to app/files folder.
The folder structure must be kept in order to work.

ex :
/app.com/files/fb/firebird.conf
/app.com/files/fb/firebird.msg
/app.com/files/fb/lib/libfbclient.so
/app.com/files/fb/plugins/libEngine12.so
/app.com/files/fb/intl/intl.conf
/app.com/files/fb/intl/libfbintl.so

I don't know if all files are necessary.
The process of putting native libraries on the lib folder will not work
because the embedded version must have the above structure.


2º
Load the libfbclient using then full path.


3º
FB tries to create the lock file on /data/local/tmp. In versions higher
than 5 this folder isn't writable.
You may set env variable  FIREBIRD_LOCK  to app/cache.

After that you should have the embedded version running.

You can follow the "FB3 Embedded on Android" topic that I had yesterday.

Regards
jGoncalves



On Mon, Feb 19, 2018 at 10:13 PM, Kurt Federspiel federonl...@yahoo.com
[firebird-support] <firebird-support@yahoogroups.com> wrote:

>
>
> Ola Jorge.
>
> I tried installing on Rooted N7 with Android 5.1 and got a similar
> result.  I think I'm going to drop this for now; there are other solutions
> that will take a bit less time.
>
> Thanks everyonegreat responses as always.
> Kurt.
>
>
>
>
>
> On Thursday, February 15, 2018 11:56 AM, "Jorge Gonçalves
> projo...@gmail.com [firebird-support]" <firebird-support@yahoogroups.com>
> wrote:
>
>
>
> Tried to run the last version on a rooted device and I have gotten:
> Error only position independent executables are supported.
>
> It seems that since android 5 only pie executables are supported.
>
> I will try the embedded version this weekend.
>
> On 15 Feb 2018 5:20 p.m., "Kurt Federspiel federonl...@yahoo.com
> [firebird-support]" <firebird-support@yahoogroups.com> wrote:
>
>
> Thanks, Carlos.
>
> I'll take a look this weekend and see what I can come up with...
> Kurt.
>
>
>
>
>
>
> On Thursday, February 15, 2018 3:55 AM, "'Carlos H. Cantu'
> lis...@warmboot.com.br [firebird-support]" <firebird-support@yahoogroups.
> com <firebird-supp...@yahoogroups..com>> wrote:
>
>
>
> Yes, there is, but afaik, there isn't any doc, guide or how-to available
> :-(
>
> You can download FB for Android in firebirdsql.org and try to figure out
> by yourself. If you are successful, it would be nice if you can write a
> how-to describing the entire process.
>
> []s
> Carlos
> Migration Guide to Firebird 3 - http://www.firebirdnews.org/
> migration-guide-to-firebird-3/
> <http://www.firebirdnews.org/migration-guide-to-firebird-3/>
> www.firebirdnews.org - www.FireBase.com.br
>
>
>
>
>
> Greets...been awhile since I stopped by...
>
> I'm doing some work on Android and want a bit more security that the
> "none" provided by Sqlite.  Is there any way to run Firebird embedded in an
> App on Android?
>
> I'm going to assume without a rooted device (or SYSTEM), a JNI and
> low-level installation that this is a no-go, but I had to ask.
>
> Thanks.
> Kurt.
>
>
>
>
>
> 
>


<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Yes, it's working now, thanks.


Regards
jGoncalves


Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Feb 18, 2018 at 11:45 PM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> ---In firebird-support@yahoogroups.com,  wrote :
> >
> > setting the FIREBIRD_LOCK to app/cache  solve the problem.
>
>   Good
>
> > Now I have get privilege error but this time is a FB error.
> >
> > FB is working now.
> >
> > SQL Message : -607
> > This operation is not defined for system tables.
> >
> > Engine Code: 335544351
> > Engine Message :
> > unsuccessful metadata update
> > CREATE TABLE TMP_INSERT_TEST failed
> > There is no privilege for this operation
>
>   Embedded engine doesn't verify user password but still requires correct
> user
> name and checks all SQL operations against it. I guess, you provide no
> user name
> and engine uses OS user name. Obviously, it have no SQL privileges.
>
>   So, provide correct user name when attaching to database (password could
> be
> omitted in embedded case).
>
>
> Regards,
> Vlad
>
> 
>

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

setting the FIREBIRD_LOCK to app/cache  solve the problem.

Now I have get privilege error but this time is a FB error.

FB is working now.

SQL Message : -607
This operation is not defined for system tables.

Engine Code: 335544351
Engine Message :
unsuccessful metadata update
CREATE TABLE TMP_INSERT_TEST failed
There is no privilege for this operation

Thanks
jGoncalves




Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

On Sun, Feb 18, 2018 at 11:16 PM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> ---In firebird-support@yahoogroups.com,  wrote :
>
> > Yes, putting firebird.conf and firebird.msg one folder above gives some
> progress..
>
>   Good to know. Looks like wrong build configuration, will investigate it
>
> ...
> > Can not access lock files directory /data/local/tmp/firebird/
>
>   Usually, firebird creates this folder by itself
>
> > It seems that the user can't access to data/local/tmp
> > I can only access to /data/local/tmp  as root
>
>   Seems you found a root of the problem. As a quick workaround you may set
> FIREBIRD_LOCK environment variable to the some accessible folder. The
> variable should be set before your app start or even by your app but before
> first call of Firebird API.
>
> Hope it helps,
> Vlad
>
>
> 
>

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Yes, putting firebird.conf and firebird.msg one folder above gives some
progress..


SQL Message : -904
Unsuccessful execution caused by an unavailable resource.

Engine Code: 335544992
Engine Message :
Can not access lock files directory /data/local/tmp/firebird/

It seems that the user can't access to data/local/tmp
I can only access to /data/local/tmp  as root



On Sun, Feb 18, 2018 at 10:37 PM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
> > ---In firebird-support@yahoogroups.com,  wrote :
> >
> > Same error.
> >
> > I'm more inclined to something related with relative paths or similar.
> >
> > If you notice the fbclient is trying to read firebird.msg from the wrong
> folder.
>
>   Yes, it is strange. What if put modified firebird.conf (and
> firebird.msg) one folder above ?
>
> Regards,
> Vlad
>
>
> 
> <#m_-1410101366622491327_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
>
> 
>

Re: [firebird-support] Re: FB3 Embedded on Android

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Same error.

I'm more inclined to something related with relative paths or similar.

If you notice the fbclient is trying to read firebird.msg from the wrong
folder.



On Sun, Feb 18, 2018 at 10:00 PM, hv...@users.sourceforge.net
[firebird-support]  wrote:

>
>
>
>   Add firebird.conf file and change
>
> #Providers = Remote,Engine12,Loopback
>
> by
>
> Providers = Engine12
>
> Idea is to see what error is returned by Engine12 provider (if any).
> Probably something wrong with privileges at file system level.
>
> Regards,
> Vlad
> 
>



Virus-free.
www.avast.com

<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>

Re: [firebird-support] Android Question

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Tried to run the last version on a rooted device and I have gotten:
Error only position independent executables are supported.

It seems that since android 5 only pie executables are supported.

I will try the embedded version this weekend.

On 15 Feb 2018 5:20 p.m., "Kurt Federspiel federonl...@yahoo.com
[firebird-support]"  wrote:



Thanks, Carlos.

I'll take a look this weekend and see what I can come up with...
Kurt.






On Thursday, February 15, 2018 3:55 AM, "'Carlos H. Cantu'
lis...@warmboot.com.br [firebird-support]" 
wrote:



Yes, there is, but afaik, there isn't any doc, guide or how-to available :-(

You can download FB for Android in firebirdsql.org and try to figure out by
yourself. If you are successful, it would be nice if you can write a how-to
describing the entire process.

[]s
Carlos
Migration Guide to Firebird 3 - http://www.firebirdnews.org/
migration-guide-to-firebird-3/
www.firebirdnews.org - www.FireBase.com.br





Greets...been awhile since I stopped by...

I'm doing some work on Android and want a bit more security that the "none"
provided by Sqlite.  Is there any way to run Firebird embedded in an App on
Android?

I'm going to assume without a rooted device (or SYSTEM), a JNI and
low-level installation that this is a no-go, but I had to ask.

Thanks.
Kurt.

Re: [firebird-support] nbackup : Error assessing database due a missing delta file

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

>Restore your database from backup and never use nbackup with this bugged
FB version any
>more.

Done ...


>From which version is safe to use nbackup ?

[firebird-support] nbackup : Error assessing database due a missing delta file

[Jorge Gonçalves projo...@gmail.com [firebird-support]]

Hi,

I'm having a problem assessing a database due a missing delta file in our
datacenter.
I have tried the flowing commands to repair the database without success.


nbackup -F 506408949.mycloudpie.com
Failure: Database is not in state (2048) to be safely fixed up


nbackup -N 506408949.mycloudpie.com
[
PROBLEM ON "attach database".
I/O error during "open" operation for file "/srv/databases/firebird/
506408949.mycloudpie.com.fdb.delta"
-Error while trying to open file
-No such file or directory
SQLCODE:-902
]
Failure: Database error


Any ideas how to recover the database ?

ps  : This problem arises sometimes in our datacenter and our IT guys don't
now the reason for that. Any idea how to prevent this problem to appear
again in the future ?

FB Version : 2.5.2.26539
Server :  Opensuse 13.1

 Regards
jGoncalves