[firebird-support] backup security3.fdb
Hello, I'm trying to find out how to backup security DB in Firebird 3. I googled that in Firebird 2 it was possible via Service Manager. And for Firebird 3 I found if "Firebird 3.0.3 Release Notes" that I can enable RemoteAccess for security3.fdb in databases.conf, but I don't like this option very much. Also there was somewhere written that I can "establish a direct, embedded connection to the security database". But I'm not sure I can do this with Firebird in SuperServer mode. Please, what is the best way? Best regards, Jakub
Re: [firebird-support] Firebird 3.0 Column name length
On 09/12/2019 09:05, Nikolay Marinov kok...@yahoo.com [firebird-support] wrote: > using WIN1251 , this query works fine in FB 2.5 > > select '123' as "Това е едно дълго име на колона" from rdb$database; > > under FB 3.0 it doesn't: > can't format message 13:198 -- message file > C:\Windows\SYSTEM32\firebird.msg not found. > arithmetic exception, numeric overflow, or string truncation. > string right truncation. > expected length 31, actual 31. This is probably related to [CORE-2350][1], see also Firebird 3 release notes, section "Enforcement of Length Limit for Local Alias and Variable Names". I guess the problem is that column names internally in Firebird are UNICODE_FSS, and those 31 Cyrillic characters are more than 31 bytes in UNICODE_FSS. Mark [1]: http://tracker.firebirdsql.org/browse/CORE-2350 -- Mark Rotteveel
[firebird-support] Re: Firebird server resource recommendation for remote server?
Chuck Belanger phytot...@lanset.com [firebird-support] a écrit : > NewsReader : Mozilla/5.0 (Windows NT 10.0; WOW64; rv:60.0) Gecko/20100101 > Thunderbird/60.9.1 > Newsgroups : gmane.comp.db.firebird.user > Reply-To : firebird-support@yahoogroups.com > > Oh, yeah. We are using FB 3+ (latest ver), 64 bit on the server. Hello, Being in the case, I will try to answer you even if my English is that of google ;-) I have VMs win2k8 r2 6 or 8 cores and 16giga with FB3 databases of 80 to 300 giga average on a node in Germany connected from Finland. Points to consider in the order: 1) Network response time between client / server. Between 14ms & 30ms it's not bad. Attention to the network in PAT / NAT 2) Disk system, SSD is almost mandatory if you are working in native FB connection with forced writing. 3) Do not send a scan of the lungs in a blob native connection! use a micro or web service for that. 4) Query the DB via stored procedures. 5) Type of SLA of the provider. 6) Make several test from various suppliers on ipv4 wired before starting to work on the project -- Norbert Saint Georges http://tetrasys.fi ++ 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/
[firebird-support] Firebird server resource recommendation for remote server?
Hello: Getting ready to launch a project which uses a remote DB to store and disseminate client data as it is assigned to various practitioners within a health network. We have been using a very funky old Windows Server 2008 RC2, with minimal ram (I think 3gb) and only 1 cpu, for the remote server during development and I would like to hear your opinions about what would be a good starting server for the project. We are looking into getting a new hosting service. My background is an acupuncturist who has made doing Delphi desktop programming and working with Firebird my hobby and parttime job. Just letting you know that so you can anticipate my level of experience with the topic. I managed to set up the current server just by following directions (from Mantis) and all the Firebird references I could find. Other than that, I really did not know what I was doing. And had no previous experience with this. Since 2003 I have developed a desktop program to do a particular medical protocol. In the last few years the protocol's developer, is getting ready to pull back on his own clinic work as he gets closer to retiring and would like to mentor practitioners by assigning his clients to them and monitor their progress and give support to the practitioners. Initially, there are only two practitioners that work up to his expectations and they would handle perhaps 3-20 clients per day. The work would still be done on the individual desktop programs with their local DB, but I have added threaded (IBObject based) routines to send/retrieve client data to the remote DB. This allows for the mentor to review the patient progress and when indicated, to re-assign patients to other practitioners. Also, his office will bill the patients and pay the practitioners. There are 9 threaded routines that connect separately to the remote DB for each desktop program running. They do not all run at the same time, but several do overlap. The server itself is hosting a Mantis BT web site. There are 3 DBs there, 1 small authorization/security DB for the program; 1 modest sized DB (initially a few hundred Mbs) that will store session PDFs; and the main patient session records which is starting out at 500 mb, because of commonly shared protocol data, and could grow to multi-Gb in a year or so. What I am seeing in development are variable processing times for the exact same routines, for the exact same data running all over the map. In one instance (the initial remote DB check for new patients and their data) ranges from a low of 6 seconds to as much as 1:09 minutes. I believe this has everything to do with the funky server, but I am truly interested in making sure when switching to another host that we start off with enough resources to handle what I describe. Can you give me more details about what to ask for? Thank you, Chuck Belanger
[firebird-support] Firebird 3.0 Column name length
using WIN1251 , this query works fine in FB 2.5 select '123' as "Това е едно дълго име на колона" from rdb$database; under FB 3.0 it doesn't: can't format message 13:198 -- message file C:\Windows\SYSTEM32\firebird.msg not found.arithmetic exception, numeric overflow, or string truncation.string right truncation.expected length 31, actual 31.