Re: [firebird-support] Re: Question about Temp Directory
ma_golyo wrote: Hi! Temp dir is used only when there is not enough free memory for dataset ordering (ORDER BY or GROUP BY). --- In firebird-support@yahoogroups.com, trskopotrskopo@... wrote: Hi all, I set temp directory for firebird 2.5.1 Super Server in firbird.conf like this : TempDirectories =e:\;d:\temp On Win 7 64, also set environment like these : - FIREBIRD_TMP = e:\;d:\temp - TEMP = e:\ - TMP = e:\ How do I know, firebird using that temporary directory? Running a few query via flamerobin, seems that firebird not using that directory. Thanks and regards, Anto Hej, simply point your tempdir to something non-existant and try to restore a database. It will stop at the end and you'll not getting it done. That's what the temp dir is used for, too. hth, Marcus
Re: [firebird-support] guest user
hej, - create custom user - grant needed rights for user on table hth, marcus Sergio wrote: Hello, sorry if this is a silly question, but I'm googling it and can't find the answer... I need to create test user which is not allowed to drop or alter anything of the database metadata. Just read or write records from some tables... I'm using FB 2.5 Thanks! ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ 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: http://docs.yahoo.com/info/terms/
Re: [firebird-support] New User
Hej, Marco Sucuzhañay wrote: estimated as I can create a user with read permissions to a table in my database firebird, thanks. grant select on table to user; hth, marcus [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
Re: [firebird-support] Re: Rename database command
From my little knowlegde i would guess Robert is talking about the delta between the oldest active transaction and next transaction. But as long as i do not know anything about the application (event listeners, long time transactions and that) and the environment (Number of active connections and that) Robert writes about (may be he has in an earlier post) , it is just peeking around. just my EUR 0,02, Marcus Alexandre Benson Smith wrote: Em 5/6/2013 13:33, Leyne, Sean escreveu: Alexandre, While I completely agree with your points. I read the OP as meaning that they are running out of transactions ID (given the current 2GB limit) -- they have an 800GB database, so a large number of transactions would/could be expected, so transactions ID could get exhausted. In that case, a backup/restore would be required, but a weekly cycle is excessive (it means that the db is handling more than 3550 transactions per second!!! Very unlikely). Sean Hi Sean ! I read that, but the point I was talking about is related to this phrase: It became clear to us that to keep the system going we have to run a backup/restore every weekend because of slow downs when transaction counts got too high But I don't think that the transaction count getting too high would lead to a server slowdown. see you ! ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] Rename index?
First guess: create a new Index with the appropriate name and drop the old Kjell Rilbe kjell.ri...@datadia.se wrote: Any simple way (including update in an rdb$... table) to rename an index? Drop/recreate is a bit expensive on 200+ million record tables... The rename is motivated by a renamed column and my desire to keep the name of the index in sync. Regards, Kjell -- -- Kjell Rilbe DataDIA AB E-post: kjell.ri...@datadia.se Telefon: 08-761 06 55 Mobil: 0733-44 24 64 ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Aliases and Windows 7
Hi Walter, Walter wrote: Hi, this is the path of the fdb file: C:\Users\Desy\Documents\FB this is the aliases.conf (on the server machine): XFILES = C:\Users\Desy\Documents\FB\XFILES.FDB There are some no-go areas for sharing files and/or folders: %SYSTEMROOT% %PROGRAMFILES% %PROGRAMFILES(X86)% %PROGRAMDATA% %USERPROFILE% Reason: Security and Privacy. So it is easier to create a separate folder for databases which is out of the security scope. syl, marcus the error occours both with local or remote access. For example, I had Firebird installed on a Windows 2003 machine (named AD2K3), which has this aliases.conf: XFILES = C:\DATI\FB\XFILES.FDB And I can access it from any client with AD2K3:XFILES ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
Re: [firebird-support] Overflow during backup. Apparent date problem.
Hej, are there any anormal entries in the firebird log? homerjones1941 mailto:ho...@agencybusys.com Freitag, 17. Mai 2013 20:35 Using GBAK via IBExpert, I get the following message. I don't know how to fix it (or find it). Overflow occurred during data type conversion. conversion error from string 2013-04-11. gds_$receive failed. ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] autodate and autofill columns
hej, AFAIK that cannot be handled by firebird on its own, as fb has no anchor to the outer world as long as there is no active connection. cheers, marcus dice_in_trouble mailto:dice_in_trou...@yahoo.com Samstag, 20. April 2013 14:22 hello i have a firebird database in which i have columns namely date, name, balance and payment i want my software to publish a list of the content with the date being adjusted daily and the content being the same, e.g. date name balance payment 20/4/13 client1 100 20/4/13 client2 200 then tomorrow it will auto fill the cells with the same data on the name and balance columns but the date will be set on the current date. is this possible? if it is can somebody help me on this matter? btw i am using zeoslib and delphi 7 thanks ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] Password Recovery
Hej, you're talking about encrypted data stored in the db? Then you'll have no luck, as data is encrypted by the app that's writing the data. Ii mailto:ii_tungt...@ymail.com Donnerstag, 11. April 2013 10:48 i have problem with my softwarethat software using a encryption passwordand i forget that passwordthis software using firebird...whether passwords are encrypted in the firebird be opened normally??please help mewhat should i do to unlock the password??? sorry if my english is not good ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
Re: [firebird-support] Does anyone know ExitCode/ErrorLevel values for gfix?
Hej, AFAIK there are no dedicated return codes for gfix. So you'll get a non-zero return code if there is a problem while executing gfix, but not from gfix when there are any problems with a database. cheers, Marcus un_spoken schrieb: Hi guys. My application needs to call gfix every day to check our clients databases. How can I know the result of gfix execution? I would not like to parse the output messages from the console. I would like to know the ExitCode returned by the gfix executable but I can not find description for it on the Internet. Could anyone provide me with this information? Thanks. ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links
Re: [firebird-support] Install Firebird SS in Ubuntu Linux by apt-get or tar.gz /install.sh
I've made best experience with the native tar.gz, as there are no external dependencies aside of a recent glibc. cheers, marcus piraju1379 mailto:assisinformat...@gmail.com Donnerstag, 14. März 2013 23:17 I'm installing Firebird Super Server version 2.5.2 on Linux Ubuntu. 1. Install by apt-get or 2. Download the file FirebirdSS-2.5.2.26539-0.i686.tar.gz and install by ./install.sh Which option do you recommend? Which option most used in business? ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
