[firebird-support] CentOS Linux 7 (Core): Can't connect through network(local and remote)
Hi all, I am new on Firebird usage but i am facing a problem with the local network connection. After trying to apply all the suggestions from the firebird Quick Start guide and other online declarations, the same issues remains. I have already opened the firewall port 3050 for tcp. Firebird Config: DatabaseAccess = Full Providers = Remote,Engine12,Loopback RemoteServiceName = gds_db IPv6V6Only = 0 ServerMode = Classic Results of commands: connect 3C-A9-F4-5B-24-2C:employee user SYSDBA password masterkey; Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Same results with the localhost attempt: SQL> connect localhost.localdomain:employee user SYSDBA password masterkey; Statement failed, SQLSTATE = 28000 Your user name and password are not defined. Ask your database administrator to set up a Firebird login. Any help will be appreciate Sincerely,
[firebird-support] Firebird and LibreOffice Base 6.3
I am trying to migrate an MS-Access application to LibreOffice. I got all tables transferred, now I am working at re-making all forms and reports. I get stuck on this. Table "Gezinnen" 3 columns: gezinsid primary key autonummer gezinsnaam varchar huwelijksdatum date (in english marriage date) Now I want to make a query with a parameter which should refer to the month of huwelijksdatum, the query reads as select "gezinsnaam", extract(month from "Gezinnen"."huwelijksdatum") from "Gezinnen"; that works OK now adding the parameter: select "gezinsnaam", extract(month from "Gezinnen"."huwelijksdatum") from "Gezinnen" where extract(month from "Gezinnen"."huwelijksdatum")=:huwmaand; When I run this, I get the dialogue to ask for the value of huwmaand, but whatever I tried, just a digit, or # around it as a date or " or ', I always get "Incorrect type for setString". I'm at loss as I read in the Firebird FAQ (or whatever it is from Firebird) that extract(month..) returns a smallint, so where do I go wrong?? I tried to get around this by saving the first select as a query, works OK and then opening a second query which takes the first as its source, and add the parameter there, but no success. BTW: I do this on Win10, but using the the same odb on Linux Mageia 6 with the same version of LibreOffice gives the same result. Regards Herman Viaene -- Plus je dors, mieux je me porte (Gaston Lagaffe) Hoe meer ik slaap, hoe beter ik me voel (Guus Flater) The more I sleep, the better I feel (Gomer Goof)
[firebird-support] UDF written in Visual Studio C giving "malformed string" on accents in characters
I have a UDF that needs to takes a couple of CSTRING(255) arguments and returns CSTRING(8000), but it needs to be able to handle accented characters like in French.. The UDF is written in C and compiled in MS Visual Studio, using the normal "char" character type. I tried changing that to wchar_t but that just completely broke it - you could call it successfully, but the result was wrong. (I also changed the data type definitions in the external function declaration when I did that to "CSTRING(len) CHARACTER SET UTF8" but that didn't help.) Any suggestions of how to change the C code and/or the compiler options and/or the external function declaration to make this all work? Our DB is all UTF8 data, though in fact that UDF doesn't access the data in the DB. Thank you.
[firebird-support] Re: using parameters with EVENT firebird 2.5+
20.09.2019 13:16, Rustam rusta...@ukr.net wrote: > I don't now API details, but my idea: what if we can specify 'mask' in > Event name on clients, e.g. "ORDER_CHANGED*"? > > Then client subscribes to event "ORDER_CHANGED*", and his code receive > all events, who name is starting with "ORDER_CHANGED". This cannot work in the current API. Dmitry
[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10
Use compressed tarball, instead of rpm package . https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.tar.gz You me have to install libtommath (apt-get install libtommath) and create a softlink as /usr/lib/x86_64-linux-gnu/libtommath.so.1 pointing to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.rpm > > After run install.sh I got: > > //opt/firebird/WhatsNew// > //./usr/sbin/rcfirebird// > //./etc/init.d/firebird// > //Done.// > //Deleting...// > //Done.// > //update-rc.d: warning: start and stop actions are no longer supported; > falling back to defaults// > //update-rc.d: warning: start runlevel arguments (2 3 5) do not match > firebird Default-Start values (2 3 4 5)// > //Starting Firebird server: // > //Fixing firebird's shell to /bin/sh// > // > //Starting Firebird server: Please enter new password for SYSDBA user: > master// > //use gsec -? to get help// > //Unable to complete network request to host "localhost".// > //Failed to establish a connection.// > //unable to open database// > // > //Please enter new password for SYSDBA user: > //Please enter new password for SYSDBA user:/ > [^C] > > Netstat shows nothing. > > After start /opt/bin/firebird/fbserver manually I got: > > /root@debian9:/opt/firebird/bin# ./fbserver // > //I/O error during "open" operation for file " "open" operation for file > " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file "own// > ///firebird/fb_trace_jGV7dm"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory/ > > What can I du to run firebird server? Edit /opt/firebird/firebird.conf? > > > > >
[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10
Use compressed tarball, instead of rpm package . https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.tar.gz You me have to install libtommath (apt-get install libtommath) and create a softlink as /usr/lib/x86_64-linux-gnu/libtommath.so.1 pointing to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.rpm > > After run install.sh I got: > > //opt/firebird/WhatsNew// > //./usr/sbin/rcfirebird// > //./etc/init.d/firebird// > //Done.// > //Deleting...// > //Done.// > //update-rc.d: warning: start and stop actions are no longer supported; > falling back to defaults// > //update-rc.d: warning: start runlevel arguments (2 3 5) do not match > firebird Default-Start values (2 3 4 5)// > //Starting Firebird server: // > //Fixing firebird's shell to /bin/sh// > // > //Starting Firebird server: Please enter new password for SYSDBA user: > master// > //use gsec -? to get help// > //Unable to complete network request to host "localhost".// > //Failed to establish a connection.// > //unable to open database// > // > //Please enter new password for SYSDBA user: > //Please enter new password for SYSDBA user:/ > [^C] > > Netstat shows nothing. > > After start /opt/bin/firebird/fbserver manually I got: > > /root@debian9:/opt/firebird/bin# ./fbserver // > //I/O error during "open" operation for file " "open" operation for file > " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file "own// > ///firebird/fb_trace_jGV7dm"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory/ > > What can I du to run firebird server? Edit /opt/firebird/firebird.conf? > > > > >
[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10
Use compressed tarball, instead of rpm package . https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.tar.gz You me have to install libtommath (apt-get install libtommath) and create a softlink as /usr/lib/x86_64-linux-gnu/libtommath.so.1 pointing to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.rpm > > After run install.sh I got: > > //opt/firebird/WhatsNew// > //./usr/sbin/rcfirebird// > //./etc/init.d/firebird// > //Done.// > //Deleting...// > //Done.// > //update-rc.d: warning: start and stop actions are no longer supported; > falling back to defaults// > //update-rc.d: warning: start runlevel arguments (2 3 5) do not match > firebird Default-Start values (2 3 4 5)// > //Starting Firebird server: // > //Fixing firebird's shell to /bin/sh// > // > //Starting Firebird server: Please enter new password for SYSDBA user: > master// > //use gsec -? to get help// > //Unable to complete network request to host "localhost".// > //Failed to establish a connection.// > //unable to open database// > // > //Please enter new password for SYSDBA user: > //Please enter new password for SYSDBA user:/ > [^C] > > Netstat shows nothing. > > After start /opt/bin/firebird/fbserver manually I got: > > /root@debian9:/opt/firebird/bin# ./fbserver // > //I/O error during "open" operation for file " "open" operation for file > " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file "own// > ///firebird/fb_trace_jGV7dm"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory/ > > What can I du to run firebird server? Edit /opt/firebird/firebird.conf? > > > > >
[firebird-support] Re: Install firebird SS 2.5 on Debian 9/10
Use compressed tarball, instead of rpm package . https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.tar.gz You me have to install libtommath (apt-get install libtommath) and create a softlink as /usr/lib/x86_64-linux-gnu/libtommath.so.1 pointing to /usr/lib/x86_64-linux-gnu/libtommath.so.1.1.0 Regards On 9/19/19 1:40 PM, 'moj.mail.qmail' moj.mail.qm...@gmail.com [firebird-support] wrote: > Hello, could someone help me install fb 2.5 on Debian 9 (buster)? > > I've installed Firebird from > https://github.com/FirebirdSQL/firebird/releases/download/R2_5_9/FirebirdSS-2.5.9.27139-0.amd64.rpm > > After run install.sh I got: > > //opt/firebird/WhatsNew// > //./usr/sbin/rcfirebird// > //./etc/init.d/firebird// > //Done.// > //Deleting...// > //Done.// > //update-rc.d: warning: start and stop actions are no longer supported; > falling back to defaults// > //update-rc.d: warning: start runlevel arguments (2 3 5) do not match > firebird Default-Start values (2 3 4 5)// > //Starting Firebird server: // > //Fixing firebird's shell to /bin/sh// > // > //Starting Firebird server: Please enter new password for SYSDBA user: > master// > //use gsec -? to get help// > //Unable to complete network request to host "localhost".// > //Failed to establish a connection.// > //unable to open database// > // > //Please enter new password for SYSDBA user: > //Please enter new password for SYSDBA user:/ > [^C] > > Netstat shows nothing. > > After start /opt/bin/firebird/fbserver manually I got: > > /root@debian9:/opt/firebird/bin# ./fbserver // > //I/O error during "open" operation for file " "open" operation for file > " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file " "open" operation for file " "open" > operation for file " "open" operation for file " "open" operation for > file " "open" operation for file "own// > ///firebird/fb_trace_jGV7dm"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory// > //"// > //-Error while trying to open file// > //-No such file or directory/ > > What can I du to run firebird server? Edit /opt/firebird/firebird.conf? > > > > >
Re: [firebird-support]using parameters with EVENT firebird 2.5+
On 2019-09-20 12:16, Rustam rusta...@ukr.net [firebird-support] wrote:
> I am also looking for somthing like that. Typical task - inform
> clients about changes in some records: client need an record ID.
>
>> It's hardly compatible with the existing events architecture and
>> API, so
>> I'm still somewhat sceptical about its implementation.
>>
>> Dmitry
>
> I don't now API details, but my idea: what if we can specify 'mask' in
> Event name on clients, e.g. "ORDER_CHANGED*"?
>
>>
>
> Then client subscribes to event "ORDER_CHANGED*", and his code receive
> all events, who name is starting with "ORDER_CHANGED".
>
> On DB side in trigger we can fire event like that:
>
> POST_EVENT('ORDER_CHANGED' || new.ID)
>
> In client's code he get an actual event name, like '
> ORDER_CHANGED'. Then he can parse received string as he need.
You could try and use Firebird 3's RDB$RECORD_VERSION to check what
changed. However that approach has its flaws, because it is possible
that 'older' record versions will appear when an 'older' transaction is
committed after a 'newer' transaction with a higher transaction id, and
depending on how you use the record version pseudo-column, you might
miss those records.
Mark
[firebird-support]using parameters with EVENT firebird 2.5+
I am also looking for somthing like that. Typical task - inform clients about
changes in some records: client need an record ID.
It's hardly compatible with the existing events architecture and API, so
I'm still somewhat sceptical about its implementation.
Dmitry
I don't now API details, but my idea: what if we can specify 'mask' in Event
name on clients, e.g. "ORDER_CHANGED*"?
Then client subscribes to event "ORDER_CHANGED*", and his code receive all
events, who name is starting with "ORDER_CHANGED".
On DB side in trigger we can fire event like that:
post_event('ORDER_CHANGED' || new.ID)
In client's code he get an actual event name, like ' ORDER_CHANGED'. Then
he can parse received string as he need.
Re: [firebird-support] Upgrade to FB 3 or Wait for FB 4
Hi, migration from 3.0 to 4.0 should be straightforward, while migration from 2.5 to either 3.0. or 4.0 requires some effort and hence will take some of your time. As 2.5 line will be discontinued with 4.0 release, it's better to start migrating now to 3.0 and upgrade to 4.0 later (if you would ever need features from 4.0, because bug fixes in 4.0.x will also appear in 3.0.x maintenance releases). best regards Pavel Cisar IBPhoenix Dne 19. 09. 19 v 22:16 Hugo Eyng hugoe...@msn.com [firebird-support] napsal(a): > Dear Friends. > > Now a days we are running FB 2.5.8, but we know that we will upgrade FB. > > So I would like listening your opinion about what is the better choice: > Upgrading to FB 3 and after to FB 4 or wait and upgrading directly finto FB 4? > > Off course this is a question that can be answered more than one way, but I > would like to know what should I consider to decide. > > > Atenciosamente, > > + + Hugo Eyng + + > ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
