[firebird-support] Granting Create Database via client api
With the advent of Firebird 3 Users who create databases must be given that permission by SYSDBA. However even to call the command ( listed below ) it seems you must already have a working connection to a database you cannot create using a client connection from another computer.database. How do we get around this catch 22. ie. In order to create a database in Firebird 3 by a non SYSDBA user, a connection must be made and the CREATE DATABASE privilege must be granted. But on a clean firebird system there is no database to connect to. How do you call: GRANT CREATE DATABASE TO USER without actually having a database connection
Re: [firebird-support] Re: Automating Firebird maintenance on Linux
On 17/4/19 11:12 pm, my...@techsol.org [firebird-support] wrote: Thanks Steve. That's interesting. I forgot about stopping xinetd. So if I understand you right, you are suggesting the following: 1. Review all FB processes (ps -ax | grep fbserver) and kill -9 on those Yikes. You shouldn't kill -9 anything as a matter of course. Only as a last resort. It doesn't give the program any chance to shut down cleanly, so there's every chance it will corrupt your database. Hamish
ODP: [firebird-support] Start/Stopping service
>> "Error occured during OpenService" >>>The specified service doens't exists as installed service (sorry I had to >>>translate from french) Run it as Windows admin Regards, Karol Bieniaszewski
[firebird-support] Start/Stopping service
Hello, I am using Firebird-3.0.3.32900_0_Win32.exe on XP when I try to start service in installed FB folder with C:\Firebird\Firebird_3_0>instsvc sta or instsvc sto I get that message "Error occured during OpenService" The specified service doens't exists as installed service (sorry I had to translate from french) Usually I start service from .bat file with net start "Firebird Server - firebird3" Where is the problem please ?
[firebird-support] Re: Compling from source.
Hi again, I tried it anyway - compiling with --with-builtin-libtommath - no joy. It failed at the same spot. ./configure --prefix=blah --with-builtin-libtommath What can I do now? Should I do some "magic" when compiling libtommath? What might that be? Any suggestions appreciated. Rgs, Pól...
RE: [firebird-support] Compling from source.
Hi Paul, > at a guess it looks like the libtommath you installed wasn't build with =fPIC > a must if you want to include its symbols in another shared library (Firebird) > Perhaps it would be easier if you used the configure command > --with-builtin-libtommath? Thanks for getting back to me so quickly. I'm not sure I understand. I actually did initially try --with-builtin-libtommath but that failed - I assumed because the library isn't present in the Firebird sources? But it's wasn't present on my system either - when I installed it, the compilation went further than without it. What will compiling now with --with-builtin-libtommath do that it didn't before? Sorry if I seem a bit obtuse, but this area really isn't my forte! Rgs, Pól...
RE: [firebird-support] Compling from source.
Hi again Paul, > Perhaps it would be easier if you used the configure command > --with-builtin-libtommath? I just tried compiling again - it failed at the same point as before. ./configure --prefix=blah --with-builtin-libtommath Should I try compiling the libtommath library myself with different options? What might they be? Rgs, Pól...
Re: [firebird-support] Re: Automating Firebird maintenance on Linux
Hi Myles, Yes, I believe we actually stopped xinetd first to prevent new connections from being made, then killed existing connections. When you connect to the database with xinetd stopped you have to connect using the local filesystem path, not the network path. -steve On Wed, Apr 17, 2019 at 10:20 AM my...@techsol.org [firebird-support] < firebird-support@yahoogroups.com> wrote: > > > Thanks Steve. That's interesting. I forgot about stopping xinetd. So if > I understand you right, you are suggesting the following: > > 1. Review all FB processes (ps -ax | grep fbserver) and kill -9 on those > 2. Shutdown the service of xinetd > 3. gfix to single user - then do maintenance > 4. Start xinetd again > > Does that sound right to you? > > Myles > > >
Re: [firebird-support] Re: Automating Firebird maintenance on Linux
17.04.2019 15:10, my...@techsol.org [firebird-support] wrote: > but gfix refuses to shutdown the database to single user maintenance mode if > there are any > existing connections to it. Use -force_shutdown. -- WBR, SD. ++ 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/
RE: [firebird-support] Compling from source.
<<(phew...), but that's where the fun begins - I hit an error! /usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: final link failed: nonrepresentable section on output collect2: error: ld returned 1 exit status make[3]: *** [Makefile:305: /home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] Error 1 make[3]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make[2]: *** [Makefile:180: master_process] Error 2 make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make[1]: *** [Makefile:66: firebird] Error 2 make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make: *** [Makefile:6: firebird] Error 2 [pol@UNKNOWN fb]$>> at a guess it looks like the libtommath you installed wasn't build with =fPIC a must if you want to include its symbols in another shared library (Firebird) Perhaps it would be easier if you used the configure command --with-builtin-libtommath? Regards Paul
[firebird-support] Re: Automating Firebird maintenance on Linux
Thanks Steve. That's interesting. I forgot about stopping xinetd. So if I understand you right, you are suggesting the following: 1. Review all FB processes (ps -ax | grep fbserver) and kill -9 on those 2. Shutdown the service of xinetd 3. gfix to single user - then do maintenance 4. Start xinetd again Does that sound right to you? Myles
[firebird-support] Compling from source.
Hi all, maybe it's because I'm a bit of a masochist, I like compiling systems from source whenever possible. I had an initial blip due to the tommath library being missing - no probs. - installed that. Now, I'm getting a problem that I can't figure out. When the compile hits the step below, I'm in above my pay grade . If you are able and kind enough to answer, please bear in mind that I'm not an expert in this area, so baby steps are de rigeur! :-) I ran: ./configure --prefix=/home/pol/Downloads/sw/db/fb/inst make .. .. lots of stuff... .. .. Then I hit this command: g++ -std=gnu++03 -Wl,--version-script,firebird.vers -pthread -shared -Wl,-soname,libfbclient.so.2 -Wl,-rpath,/lib -o /home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4 /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/MasterImplementation.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/alt.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/why.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/preparse.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/user_dsql.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/gds.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/PluginManager.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/keywords.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/perf.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/utl.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/DistributedTransaction.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/blob.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/array.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/config/os/posix/config_root.o /home/pol/Downloads/sw/db/fb/temp/Release/yvalve/config/os/posix/binreloc.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/remote.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/protocol.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/merge.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/inet.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/parser.o /home/pol/Downloads/sw/db/fb/temp/Release/auth/SecureRemotePassword/srp.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/client/interface.o /home/pol/Downloads/sw/db/fb/temp/Release/remote/client/BlrFromMessage.o /home/pol/Downloads/sw/db/fb/temp/Release/auth/SecureRemotePassword/client/SrpClient.o /home/pol/Downloads/sw/db/fb/temp/Release/auth/SecurityDatabase/LegacyClient.o /home/pol/Downloads/sw/db/fb/temp/Release/plugins/crypt/arc4/Arc4.o /home/pol/Downloads/sw/db/fb/temp/Release/common.a -L/home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib -lm -ldl -lcurses -ltommath (phew...), but that's where the fun begins - I hit an error! /usr/bin/ld: //usr/local/lib/libtommath.a(bn_mp_read_radix.o): relocation R_X86_64_32S against symbol `mp_s_rmap_reverse' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod.o): relocation R_X86_64_32 against symbol `mp_reduce' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: //usr/local/lib/libtommath.a(bn_s_mp_exptmod_fast.o): relocation R_X86_64_32 against symbol `mp_reduce_2k' can not be used when making a shared object; recompile with -fPIC /usr/bin/ld: final link failed: nonrepresentable section on output collect2: error: ld returned 1 exit status make[3]: *** [Makefile:305: /home/pol/Downloads/sw/db/fb/gen/Release/firebird/lib/libfbclient.so.3.0.4] Error 1 make[3]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make[2]: *** [Makefile:180: master_process] Error 2 make[2]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make[1]: *** [Makefile:66: firebird] Error 2 make[1]: Leaving directory '/home/pol/Downloads/sw/db/fb/gen' make: *** [Makefile:6: firebird] Error 2 [pol@UNKNOWN fb]$ OK - it *_seems_* to be telling me to recompile with -fPIC? Now, I did notice many of the previous steps looked something like this: g++ -I/home/pol/Downloads/sw/db/fb/src/include/gen -I/home/pol/Downloads/sw/db/fb/src/include -ggdb -DFB_SEND_FLAGS=MSG_NOSIGNAL -DLINUX -DAMD64 -pipe -MMD -fPIC -fmessage-length=0 -fno-delete-null-pointer-checks -O3 -fno-omit-frame-pointer -pthread -fno-rtti -std=gnu++03 -c /home/pol/Downloads/sw/db/fb/src/plugins/crypt/arc4/Arc4.cpp -o /home/pol/Downloads/sw/db/fb/temp/Release/plugins/crypt/arc4/Arc4.o The -fPIC flag is all present and accounted for in those previous commands. So, my question basically boils down to two parts a) is it the missing -fPIC that is causing the problem? b) if so, how do I add it into the mix? Please give me the actual command I need to run (think monkey-see, monkey-do!) rather than just As an aside, how come others haven't run into this problem? I would be grateful for any and all help that can be provided. I would also be interested in any explanations as to why this is happening to me in particular
[firebird-support] Firebird 3, nulls and integer division
Hi, I am (EVENTUALLY), getting around to upgrading from Firebird 2.5 to Firebird 3. I purchased the conversion guide, and so far so good, except for this problem, which I cannot find a mention of anywhere, no online, nor in conversion the guide: SELECT C.ENDDATE FROM CMN_PERIODS C WHERE (C.PERIOD = mod(:IPeriod, 100)) AND (C.YR = (:IPeriod / 100)) The error is: SQL error state =42000 Expression evaluation not supported. Invalid data type for division in dialect 3 Eventually, I figured out that this possibly happens on the Firebird 3 server when :IPeriod is null, since this now works: SELECT C.ENDDATE FROM CMN_PERIODS C WHERE (C.PERIOD = mod(:IPeriod, 100)) AND (C.YR = (coalesce(:IPeriod) / 100)) BUT, this also works! (ie. Does not give an error) SELECT C.ENDDATE FROM CMN_PERIODS C WHERE (C.PERIOD = mod(:IPeriod, 100)) AND (C.YR = (null / 100)) I am doing his via FastReports and FIBPlus datasets, so not sure if that is affecting things. The parameter type is set to Integer. I am going to go ahead and add coalesce to my 20 queries that have this in various reports, but would like to know if this is an intended side-effect (and my Google-Fu just not good enough to find the relevant documentation), and/or if there is some other better way I should be dealing with this problem rather (since I am not 100% understanding what has changed and why). Thanks Maya