Re: [firebird-support] Connecting to Superserver on CentOS 6
Hej, On 12.05.2015 00:45, 'David E. Wheeler' da...@justatheory.com [firebird-support] wrote: Firebirders, I have been using the firebird-classic RPM for testing Sqitch, connecting like so: isql-fb -u sysdba -p masterkey This worked well, but now I’d like to use superserver, instead. So I removed that RPM and installed 2.5.4.26856.0-1.el6 from EPEL and fired up the server with `sudo service firebird-superserver start`. But now the above command is unable to connect me: Have you checked the xinetd config? FB Classic server needs xinetd, writes a firebird.conf in /etc/xinetd.d $ isql-fb -u sysdba -p masterkey Use CONNECT or CREATE DATABASE to specify a database SQL create database 'foo'; Statement failed, SQLSTATE = 08004 connection rejected by remote interface What do I need to tweak to get it so that I can connect and create a database? The hosts file includes “localhost” as a name for 127.0.0.1, for what that’s worth, so I doubt it’s a host name issue. TIA, David Cheers, Marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Open Database xxxxx failed Creating Odbc DSN for Firebird 1.5
Hej, On 09.05.2015 23:11, vrynjo...@yahoo.com [firebird-support] wrote: Trying to create an odbc DSN for a .gdb database on firebird 1.5.6.5026-0 32bit. the os is windows 7 32 bit and the odbc driver is Firebird odbc 2.0.0.151 32bit. Database connection is successful in iBExpert but the connection to the firebird service manager fails when testing for connection in IB Expert.Odbc DSN is also failing with the error Open Database xxx failed Please help Would it bother you to share some more informations with us? Such as how your connection strings are lookinkg like? A marginal note by the way: you are shurely aware of the fact that Firebird versions up to Version 2.1 are not maintained any more. See http://www.firebirdsql.org/en/roadmap/ for more information. A first guess for your problem: Windows Firewall. hth, Marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Cannot install 2.5.4 on Linux Mint - gsec error
Hej, On 08.05.2015 12:35, David Nock dav...@accessitsoftware.com [firebird-support] wrote: This particular machine instance had no previous firebird install. However, I have tried purging the packages and reinstalling. Still have the same problem... On 8/05/2015 10:02 p.m., map...@gmail.com [firebird-support] wrote: Did you tried try to purge the packages and database before installing , it worked without issues on my ubuntu 14.04.x - purge the package manager installation - make shure there's nothing left in /etc, /var and /opt - reinstall with the .tar.gz. hth, Marucs No virus found in this message. Checked by AVG - www.avg.com http://www.avg.com Version: 2015.0.5863 / Virus Database: 4342/9723 - Release Date: 05/08/15 [Non-text portions of this message have been removed]
Re: [firebird-support] Database Size Is Not Reducing
On 07.04.2015 08:16, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: Then what could be the best way to reduce the database size? All suggestions are appreciated. Hej Vishal played around a little bit, unable to reproduce your problem. Even after setting some blobfields to NULL, leaving isql or flamerobin open and the update statement uncommitted, gbak -b with -l or -g or -l and -g : the backup files are all distinctly smaller than the backup with all blob content. Same for all the restored databases. What i've done: - System Win7 64, FB 2.5.2 - created a new database, new table t1 (id integer, blobfield blob subtype 0), all operations in the same directory - create first backup for empty db - insert 10 ids and random blob data - create second backup - update t1 set blob=null where id 2 - leave either flamerobin or isql statement uncommited - backup db to different names: both smaller than second backup - playing with backup options, backup to different names: still smaller than than the second backup - commit statement - backup db to different names: both smaller than second backup - playing with backup options, backup to different names: still smaller than than the second backup - restore all the backups to according names: size equals between all backups where i've done the update...set...null, all smaller than the original database with all 10 blobs. - opened all databases: blobs 3..10 are NULL So, question is: how do you do your backup/restore? cmd, service api, some 3rd Party components? Doublechecked file locations? Stumpled upon that to often for myself. hth, Marcus With Best Regards. Vishal [Non-text portions of this message have been removed]
Re: [firebird-support] Revert DB to previous version
On 18.03.2015 16:59, sboyd...@gmail.com [firebird-support] wrote: I need to be able to revert an existing 2.1 database to 2.0.5. How can I accomplish this. GBAK won't do it. It tells me: ERROR: Expected backup version 1,2,3,4,5,6 or 7. Found 8. Hej, you've done the backup with the 2.1 fb, that won't work IMHO the clean solution would be to create a new empty database with the appropriate structure and pump the data afterwards. hth, Marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird database seems to influence multi user ability
On 08.12.2014 14:28, Benny Schaich-Lebek bscha...@gmx.de [firebird-support] wrote: Hi, I have been an interbase guy about fifteen years ago and loved to see it go open source. I used to work with Paul Beach (Hello, if you're here,Paul) Now I ran across a problem with firebird and tried to solve it. unfortunately half of the stuff is in the dark because the original software running here is an accounting product (BUHL/Deltra office Software/Germany if you have heard about it). The weird thing is that the software does not connect to the server from a client if there is a specific .fdb file loaded (local access works). I now asked them to run a backup and that had a couple of messages: (gbak:cannot commit index MOV_CALITEMS_ORDERID gbak: ERROR:violation of FOREIGN KEY constraint MOV_CALITEMS_ORDERID on table MOV_CALENDARITEMS gbak: ERROR:Foreign key reference target does not exist gbak: ERROR:Problematic key value is (ORDERID = 4127) gbak:Database is not online due to failure to activate one or more indices. gbak:Run gfix -online to bring database online without active indices.) Specifically the last one makes me suspicious. How come that local access works then? I thought even local access always goes through the server? Hej, some questions: - by local connections you're talking about drive letter:\path\to\fdb? Or 127.0.0.1:., which would be a network connection, regardless of which host the connection comes from. - which version of Firebird? - which user? SYSDBA is allowed to connect an 'offline' database. He has to, else a database would only become a big jumbled piece of bits'n'bytes if one pulls the trigger gfix -shut ... Do you have the output of gstat -h database.fdb? What does the row Attributes say? marcus Any hints anybody? I know this is hard to determine as we do not know much about the program itself, but it seems the guys from the software shop have trouble to understand firebird... Regards, Benny Schaich Ex-Borland... [Non-text portions of this message have been removed]
Re: [firebird-support] Stability on newer windows ...
On 24.11.2014 12:09, Lester Caine les...@lsces.co.uk [firebird-support] wrote: On 19/11/14 18:18, Fabiano Kureck - Desenvolvimento SCI fabi...@sci10.com.br [firebird-support] wrote: Try using the 32 bit version of Firebird, maybe this can help you. Run 32bit Firebird 2.1.6 with 32bit apache and php but it is unfortunate a 64bit version of Windows7 which is all that was available at the time :( SINCE last week, there have been a number of windows updates culminating in a 151Mb download from the 11th Nov which is titled 'System Update Readiness Tool' and is described as being designed to fix problems with the update process which has resulted in problem with updates getting stuck! Exactly the problem we have been having and date wise this fits as well. Took 25 minutes to run it and now the 'update' status is actually showing 'up to date' which it last did a month ago. I did a full backup and restore to the databases but JUSThad WDZP (Server) Mon Nov 24 10:26:52 2014 Database: HISTORY internal gds software consistency check (cannot find tip page (165), file: tra.cpp line: 2494) Such errors will more like point to - problems with the harddisk - problems with cache logic - problems with the hdd/raid controller than Windows Updates. Or were there active connections while installing updates and rebooting the computer? This is the first message since it reset on Saturday! I am now looking to put new hardware in, but WHAT should I put on it software wise to be sure of stability. If we did not need the announcements it would be Linux, but on this site I am stuck with windows of some sort :( -- Lester Caine - G8HFL - Contact - http://lsces.co.uk/wiki/?page=contact L.S.Caine Electronic Services - http://lsces.co.uk EnquirySolve - http://enquirysolve.com/ Model Engineers Digital Workshop - http://medw.co.uk Rainbow Digital Media - http://rainbowdigitalmedia.co.uk [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird can't connect to host
On 14.11.2014 08:55, Andromeda andromedar...@gmail.com [firebird-support] wrote: Hello, I'm new in FirebirdSQL. I can't connect into my host address whereas it can connect to localhost successfully. It prompt show errors like this: |SQL connect 192.168.1.37:/var/lib/firebird/2.5/data/employee.fdb user 'SYSDBA' password 'masterkey'; Statement failed, SQLSTATE = 08006 Unable to complete network request to host 192.168.1.50. -Failed to establish a connection. | I have Googled about this for almost a month but I can't find the absolute way to solve this problem. My ufw firewall already deactivated, the port 3050 is opened, but it still can't connect into my host address, but easily connect to the 127.0.0.1. The Firebird classic server is running on Lubuntu Desktop 14.04.1 and the version of Firebird is 2.5. This problem occured since I reinstall/upgrading my OS from 13.xxx into 14.xxx Lubuntu version. On the previous OS, I never facing an error like this. What's going wrong here? Whether this problem related to OS version, or just a dumb error that I can't solve, I don't know and I very need an help from the experts, please. How do you start firebird, and in which mode? Classic, Superclassic or Superserver? If Classic : Do you have installed inetd/xinetd, enabled and configured it? Any help would be very appreciated, thank a lot in advance. Regards, Andromeda [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird on Mac
On 14.11.2014 21:04, 'William, David' david.will...@espn.com [firebird-support] wrote: Hi, I am trying to run Firebird on mac (our standard development platform). I have tried all server packages available on Firebirdsql.org . The installation process runs ok. But whenever I try to start the server, I get this: $ fbguard fbguard: Invalid user (must be firebird, interbase, interbas or root). If I try to start the server with the root password, nothing happens. No output at all and no server running. A little bit about my scenario: We have some desktop apps running on Windows and we would like to translate it to web app, keeping the same Firebird databases. We will use Ruby on Rails. We use Macs and we need to setup a local Firebird machine. My current Firebird installation have the following binaries: 16 -rwxr-xr-x 1 firebird firebird5259 Jul 9 09:26 changeMultiConnectMode.sh 24 -rwsr-sr-x 1 firebird firebird8576 Jul 9 09:26 fb_inet_server 1264 -rwxr-xr-x 1 firebird firebird 643936 Jul 9 09:26 fb_lock_print 1624 -rwxr-xr-x 1 firebird firebird 830060 Jul 9 09:26 fb_smp_server 496 -rwxr-xr-x 1 firebird firebird 253648 Jul 9 09:26 fbguard 504 -rwxr-xr-x 1 firebird firebird 254928 Jul 9 09:26 fbsvcmgr 520 -rwxr-xr-x 1 firebird firebird 264792 Jul 9 09:26 fbtracemgr 1080 -rwxr-xr-x 1 firebird firebird 552144 Jul 9 09:26 gbak 1224 -rwxr-xr-x 1 firebird firebird 623808 Jul 9 09:26 gdef 656 -rwxr-xr-x 1 firebird firebird 335844 Jul 9 09:26 gfix 1296 -rwxr-xr-x 1 firebird firebird 663112 Jul 9 09:26 gpre 1192 -rwxr-xr-x 1 firebird firebird 610228 Jul 9 09:26 gsec 1144 -rwxr-xr-x 1 firebird firebird 581820 Jul 9 09:26 gstat 1488 -rwxr-xr-x 1 firebird firebird 759696 Jul 9 09:26 isql 1152 -rwxr-xr-x 1 firebird firebird 586068 Jul 9 09:26 nbackup 1152 -rwxr-xr-x 1 firebird firebird 588604 Jul 9 09:26 qli Thanks. David William IIRC on Mac firebird installs in classic mode, so connections are dealt by forked server instances - that is in case of classic fb_inet_server You may try from the terminal: /path/to/isql -user SYSDBA -password whateveritis 127.0.0.1:/path/to/database for further informations: http://www.firebirdsql.org/file/documentation/papers_presentations/html/paper-fb-macosx.html hth, marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Firebird 2.0 Support Windows Server 2012?
On 11.11.2014 11:39, 'Knappich, Sven' s.knapp...@c-forum.de [firebird-support] wrote: Hello, we have a Software that only Support Firebird 2.0. With regards to the software company: Firebird 2.0 is discontinued since April 2012, which means no further development, error/bug fixing and that. So even if there is a problem running Firebird 2.0 on Win Server 2012 - it's very unlikely that someone will fix it. Now we had changed the OS from Windows Server 2003 to Windows Server 2012. After the Upgrade the OS the Firebird runs very slowly. You've made an in-place update from Win2003 Server to Win2012 Server? Or have you installed a new server with Win 2012 and reinstalled the software? The software manufacturer said that our Hardware is to bad for Firebird but we changed only the OS and no Hardware. See the regards first... Aside that - if they insist on bad hardware: they should be able to tell you which part of your hardware is 'bad'. There is no general bad hardware. The Windows Server 2012 runs in a VMWare environment. The Server 2003 was running in the same VMWare environment. The only thing we had increased was the RAM. From 8 to 16 GB. Should not be a problem running a server as vm Is there anything to configure in Server 2012? Is Firebird 2.0 Supportet with Server 2012? See regards... Thanks Reegards hth, Marcus Mit freundlichen Grüßen Sven Knappich system engineer service, projects support Computing Forum IT-Systemhaus Weiße Steige 2 73431 Aalen Phone: + 49 (0)7361 3701-44 Fax: + 49 (0)7361 3701-22 E-Mail: s.knapp...@c-forum.de mailto:s.knapp...@c-forum.de www.c-forum.de http://www.c-forum.de/ Geschäftsführender Inhaber: Vassilios Petridis Sitz des Unternehmens: Aalen, Deutschland USt-Id-Nr. DE 183 265 512 --- [Non-text portions of this message have been removed]
Re: Odp: [firebird-support] FB server installation a nd concurrent users limits on Windows Server
On 06.11.2014 20:22, af_12...@yahoo.com [firebird-support] wrote: Hi i am new to databases and i am going to choose Firebird. Supposing that i will have to interact with some MS server where are some already installed software, mail server and other softwares i were starting to ask if is there any limit about the number of concurrent Clients that could access simultaneously to the FB database. Some peoples are suggesting me to do not install FB server on a domain controller becouse i will risk a serious perfomance issue. Some Others are telling that is only a question of server,cache,page size ,etc i am getting confused becouse i've got some post of the 2012 talking about FB that solved this issue but other that tell's that also Microsoft suggest to do not install MSSQL on an acvite domain some more tells to do not install ON , other to do not install FB AS acting ALSO like a domain controller (does FB could act in that way?) all this becouse of a security functionality that Microsoft server apply on an DC my main doubt is : when i will have only 1 server on an already working network infrastructure of a customer and i will need to install my small application that will use FB in a c/s environment without having possibility to buy/install a second server , will i risk this PERFORMANCE ISSUE becouse of an incomatibility or i could solve it just changing the configuration of the MS server+ FB_db ? hej, to be honest - setting up an internal test system you may install whatever you want onto a single server - but keep in mind that it's internal test that must never go live into production! As rule of thumb/best praxis: Leave AD-Servers alone! Why? You don't want messed up AD-Servers. this are some posts (FB) http://dyemanov.blogspot.it/2012/03/firebird-vs-windows-file-system-caching.html (MS) http://support.microsoft.com/kb/2032911 (postgreSQL) http://help.theatremanager.com/book/export/html/1606 [Non-text portions of this message have been removed]
Re: [firebird-support] What is wrong with transactions here?
On 04.11.2014 16:21, simion_coro...@yahoo.fr [firebird-support] wrote: Hi! I have some lines in firebird.log like this: === cxv.servers.netTue Nov 4 11:37:38 2014 Sweep is started by SWEEPER Database SkyNetInt OIT 1221095, OAT 1231335, OST 1231313, Next 139981575359934 cxv.servers.netTue Nov 4 11:37:46 2014 Sweep is finished Database SkyNetInt OIT 1248701, OAT 1248707, OST 1248707, Next 1248709 === That's housekeeping for transactions. Depending on how applications are connect to the database and how the applications are handling their connects, statements and commits - you will see a gap between the oldes active and the next transaction. For example, you'll need firebirds isql and a shell (cmd, bash, whatever). Open a shell, create a database and a simple table within, one integer will be enough. Now insert 1 integer into that table and don't commit! Open a second shell, gstat -h with the database from above. Open a third shell, isql with the database do a couple of inserts and commit after each single one. A last insert, don't commit! Change to shell number two, gstat -h again: See the difference between oldest active and next transaction? Now switch to the first shell and commit the insert, close isql. What is gstat showing? Commit the last insert from the third shell close isql. Now you should have a difference of one between the oldest active and the next transaction. The bigger the gap (the transaction chain) gets, the slower each database action gets. Sweeping tries to detect and remove commited transactions in the chain to keep it short. The problem is: it requires database performance. So if the database is under heavy fire, it may be better to disable housekeeping and trigger it manually. Another option you should think about: How the connections and that are handled from the application side? Do you have a chance to optimize that handling? See also: https://www.ibphoenix.com/resources/documents/design/doc_21 https://www.ibphoenix.com/resources/documents/general/doc_67 http://conferences.embarcadero.com/article/32280/ sometime this happen in few hours. How can I find where is the problem? I don't know if it's important, a lot of lines is: = cxv.servers.netTue Nov 4 11:32:50 2014 INET/inet_error: read errno = 104 = as far as i know : same as winsock 10054 : unable to connect to client Thanks! [Non-text portions of this message have been removed]
Re: [firebird-support] What is the difference between these connection strings?
On 01.10.2014 13:27, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: On Wed, 01 Oct 2014 13:14:52 +0200, marcus mar...@antiphasis.net [firebird-support] firebird-support@yahoogroups.com wrote: Yes, you likely will loose the connection: greetings from the firewall. Albeit you have ticked the option Notify - i've seen it rarely. So as precautionary measure: Add the fbserver process to the exceptions or, at least: allow incoming tcp/3050, outgoing tcp/any. That should be enough. Tearing down the firewall isn't an option. The notify option only applies to user processes that require firewall access. As Firebird runs as a service which is isolated from your user session, you don't get a notification popup. Dooh! Me idiot - why haven't i thought about that... However I think that the Firebird installer should - optionally - arrange the Firewall exception. Mark [Non-text portions of this message have been removed]
Re: [firebird-support] What is the difference between these connection strings?
Hej, On 01.10.2014 12:50, brucedickin...@wp.pl [firebird-support] wrote: Hi guys, (I've already asked for this but my topic hasn't occured since two hours on the group so I am trying again.) I know that I can connect to Firebird (on Windows) by specifying connection string in two ways: 1. C:\MyDB.FDB 2. localhost:C:\MyFDB.FDB I am speaking here about local connection. Is there any difference between these two connection strings? I know that when I use localhost then TCP\IP protocol is used. What protocol is used in the first case? Is it possible that connection to database will become unavailable on some machines when I switch from first connection string to the second one? Yes, you likely will loose the connection: greetings from the firewall. Albeit you have ticked the option Notify - i've seen it rarely. So as precautionary measure: Add the fbserver process to the exceptions or, at least: allow incoming tcp/3050, outgoing tcp/any. That should be enough. Tearing down the firewall isn't an option. Thanks for your time. hth, Marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Can't connect to CentOS 7 service port 3050 from network
duque.herna...@yahoo.com [firebird-support] wrote: Hi to all I've just installed Firebird 2.5 SuperClassic on a new Linux CentOS 7 box. I tested local connections and are working fine. SELinux is disabled and firewall service is down. Have you tested local over service? e.g: isql 127.0.0.1:/db/test.gdb ? But when I try to connect from a workstation using telnet my-server 3050, is not responding. Neither I can see the 3050 port if I do lsof | grep 3050 on the host. Is there I've missed? Have you executed the script changeMultiConnectMode.sh? That's the one turning a classic into a superclassic. Do I need a 64 bit client for connecting to FB on a CentOS 7? No, the client bitness depends on the client os and/or requirements of the app. Any help will be appreciated. hth, marcus Best regards, Hernando. [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10
http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security discusses some points you should consider. And where to place databases - now, there are some common locations such as /var, /usr/var or /opt - but there is no general authoritative answer possible, as it depends on how the system is configured and what are the needs of operating the db. https://www.freebsd.org/doc/handbook/security.html discusses general freebsd security and links to some more toppics. And as written before: firebird is the only user who needs access to the databases. stevef...@yahoo.com [firebird-support] wrote: If someone posts an authoritative answer here on the Firebird support group, then everyone who is running FreeBSD/Firebird who needs help can see the answer in future and be helped. That is the main reason I have posted the question here. By the way, I have searched the www high and low, but could not find an answer and hence this is the only place I could post. Maybe I should have posted on the FreeBSD forums.. [Non-text portions of this message have been removed]
Re: [firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10
Perhaps you should read tutorials and documentation - that's the way most of the users have learned how to do this and that, asking questions for single topics. Your questions do not show any basic knowledge, neither of freebsd nor of firebird. You're asking for do my job, now! stevef...@yahoo.com [firebird-support] wrote: Maybe I should re-phrase my original question: Is there any recommended documentation somewhere about the secure recommended way to start Firebird service and all configuration after installation? [Non-text portions of this message have been removed]
Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10
stevef...@yahoo.com [firebird-support] wrote: I've successfully installed Firebird on FreeBSD 10 but can't seem to find documentation on the proper way to configure it to run at system startup. Somewhere on the www, I found that you should add the following line to/etc/rc.conf: firebird_enable=YES I did this and it seems to work. I also want SuperServer so I added to the same file: firebird_mode = superserver This seems to work too. What about the default database directory, permissions etc. What commands are required for this? Would be glad if an experienced FreeBSD admin could post a reply.TIA. Short answer: default database directory is configured in firebird.conf. chown -R firebird: /where/your/default/database/folder/points/tp common knowledge. [Non-text portions of this message have been removed]
Re: [firebird-support] Where is release 2.5.3 on FreeBSD?
stevef...@yahoo.com [firebird-support] wrote: On FreeBSD 10, the following command: pkg install databases/firebird25-server will only install version 2.5.2_5. How do I get it to pull version 2.5.3 from the sourceforge repository? Hej, first and foremost your question is not firebird-related, as with almost all distributions that use any kind of packaging mechanisms. a pkg install fetches and installs the current tested version of a pkg and it's dependencies, if there are any. Leaving the readymade pkg path you should look at the freebsd ports collection: https://www.freebsd.org/doc/en_US.ISO8859-1/books/handbook/ports-using.html Word of advice - if yoo aren't that familiar with freebsd and/or the packaging/ports mechanisms - stay on 2.5.2_5 until 2.5.3 becomes available. hth, Marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Date literals
grenzhan...@yahoo.com [firebird-support] wrote: Hi, I'm in the progress of converting an existing application from Sybase SQL (11.0.3 - from the stoneage) to Firebird.From Sybase (as well as some other databases I work with) I'm used to entering date literals as 'mmdd'.I keep getting Overflow occured during data type conversion.Is it true, that this date format isn't recognized by firebird?Which is the most common date format, can you recommend any format?Thanks Lutz May be this : http://www.firebirdsql.org/en/firebird-date-literals/ is of help. From a short skimming: Firebird uses the separator to decide, see the chapter Separators in Non-U.S. Dates at the half hth, marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Invalid request BLR execting UNION of views
kokok_ko...@yahoo.es [firebird-support] wrote: Hej, In a database, I execute the following code: select * from customer union select * from customer Mind you to tell us something more about the tables and the database? The above does not make sense, it is a reduced query to show the error. I get Invalid token. invalid request BLR at offset 4275. BLR syntax error: expected record selection expression clause at offset 4276, encountered 24. The first thought was a database corruption, but I have restored the database and passed the IBFirstAID application and no errors are detected. I use Firebird 2.5. What else can I try? I've tried a simple sample like https://en.wikipedia.org/wiki/Set_operations_%28SQL%29 and it's working like expected, no errors at all. Haven't used anything else than isql, firebird 2.5.2 on windows, freshly created database. Thank you hth, marcus [Non-text portions of this message have been removed]
Re: [firebird-support] Database Too Large.
IIRC that's the second user having problems with SAM Broadcast using firebird. The Product company Spacial Audio has its own support site at https://spacialaudio.zendesk.com/home, that should be your way to ask for help, as they do know how their application talks to the database. And, as Werner has written, the database size is not the problem. A database of 200 MB is a 'snack'... Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: Hi Stefano, To decrease database size you need to make backup/restore. Then, to keep its growth under control, you need to perform the following maintenance procedure: 1) stop Firebird server and then start it immediately (less than 3 sec downtime). 2) run gfix -sweep -user SYSDBA -pass masterkey database_path that's all. Regards, Alexey Kovyazin IBSurgeon
Re: [firebird-support] this keeps happening
MYKS51 my...@telus.net [firebird-support] wrote: Hello, Using SAM 2014.3 on Win7 system with built into SAM, Firebird. Whenever I try to reboot my computer it hangs at Shutting Down and though I've waited as long as 10 minutes it doesn't seem to continue so must hit reboot button. When I check the Event Viewer there are occurrences of the same error over and over,all related to Firebird SQL Server with this line of dialogue: C:\Program Files (x86)\SAMBC\firebird.conf: illegal line [UDF] Tried removing the line [UDF] but then SAM stops working? Any ideas? Thank You Hej, are you talking about SAM Broadcaster? They do have a support : https://spacialaudio.zendesk.com/categories/20069829-SAM-Broadcaster m. Myk (\o/) ./_\. PS: grabbed latest Firebird but it said if I overwrote the older version I would have to manually configure Firebird. Don't think that's in my scope of knowledge :(
Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?
loris.lu...@gmail.com [firebird-support] wrote: I need your help and/or suggestions to solve a (maybe uncommon) task. I searched a lot on the web and I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness of the conversion, many days, something must be wrong with this software) I have a large Firebird 2.5 DB (a couple of tables have few millions records) to convert from WIN1251 charset to UTF8 charset. Is there a way to do efficiently this kind of conversion? (preferably not using a intermediate text sql dump, that would not applicable because the size of the DB). I'm using Firebird on a linux machine, and I really like to do the job using a bash script, but I can fallback also using a remote Windows pc. Thanks for any suggestions. Best regards. Hej, maybe this one is of help: http://www.ibphoenix.com/resources/documents/design/doc_150 hth, Marcus
Re: [firebird-support] Cannot connect to remote FB Server
Hej, dennisktl...@yahoo.com wrote: Hi marcus, Thanks for your reply. Appreciate it. Yes it is able to ping, from server to client and vice versa. As for the routing information, i will try to get from the network administrator. Thanks. If ping is allowed between both parties - have you tried a telnet from client to server @ port 3050? Btw: you do have entries for port 3050 in the services on both sides? hth, Marcus
Re: [firebird-support] Cannot connect to remote FB Server
Hej, dennisktl...@yahoo.com wrote: I have problem connecting to FB server from a remote PC sitting on different subnet mask. It said Cannot attach to services manager everytime I tried to establish connection using TCP/IP mode. Server IP: 172.30.18.104 Gateway: 172.30.16.1 Client IP: 172.30.0.244 Gateway: 172.30.0.1 Do you have some routing informations or do you know the routing between the gateways? If ping is allowed: can you ping the server/the client? Firewall is off at both side. Port 3050 is opened. Anti-virus sofware is off. Local conncetion to database at server is fine. If I connect from a client PC which resides on the same network segment, it is working fine. I suspect is has something to do with the packet routing or have I missed anything here? Your help is very much appreciated. Thanks in advanced. hth, marcus
Re: [firebird-support] Firebird server 64 bit, OS 64 bit, Firebird client 32 bit
hej, vi...@t-online.hu wrote: Hi to all Guru ! For all I know, - The client application must be same bit, as Firebird client. Application 32 bit - Firebird client 32 bit Application 64 bit - Firebird client 64 bit. - Any client (32/64 bit) can connect to any Firebird server (32/64 bit). - 32 bit OS - 32 bit application - 64 bit OS - 32 bit/64 bit application. The question: on 64 bit Windows (more than 4G mem), with 32 bit application and Firebird client, gainful the Firebird 64 bit server usage ? Thanks. hmmm, IMHO not really. But it depends on what your app does with the server. An option i may think of - holding a lot of query/cache data in the memory. IIRC you'll need to rework the firebird.conf for that. From my experience: It is useful to use a 64er OS, so you have a lot of RAM to use for a lot of 32er applications. 64er applications would have to fit into that construct. And even an 64er OS uses a lot of 32er system processes and that. hth, Marcus
Re: [firebird-support] Firebird 2.5 under Windows 8 64bit
Hej, Thomas Steinmaurer wrote: Hello Dirk, I have a customer where Firebird 2.5.2 (32bit) is running under Windows 8 64bit. The following errors are repeatedly found in the firebird.log BARBAR (Server) Wed Feb 19 14:22:54 2014 Error in isc_attach_database() API call when working with security database operating system directive CreateFile failed Access denied BARBAR (Server) Wed Feb 19 14:37:42 2014 INET/inet_error: read errno = 10054 What causes these errors, especially the first? Well, I don't have Windows 8 running, but it sounds a bit like a permission issue, e.g. having Firebird installed in the program files folder and running Firebird under a user with restricted privileges ... Is Firebird running as a Windows service or as an application? Other than that, what Dmitry has suggested. In addition to what Thomas adn Dmitry have written: If fb is running as application, there is one more thing you should take care of: Where is firebird installed? %ProgramFiles% and %ProgramFiles(X86)% are under some protection, so that a regular user will have problems to change data. AFAIK fb running as application will run with current user rights, so that may be your problem. If running as Service, fb is running in system\service context and should not have those problems. hth, Marcus -- With regards, Thomas Steinmaurer http://www.upscene.com/ Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. ++ 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://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Udf returning VARCHAR
Hej, liviuslivius wrote: Hi, Why don`t you use CAST ( var as VARCHAR(NN)) i use but this is not natural way and i need to know if is possible to return varchar and how read http://www.firebirdsql.org/en/writing-udfs-in-delphi-for-interbase-firebird/, search for a topic called things. There's a little table describing what you are looking for. hth, marcus regards, Karol Bieniaszewski W dniu 2014-01-31 09:24:20 użytkownik Bogdan Mihalache bogdan.mihala...@soter.ro napisał: Why don`t you use CAST ( var as VARCHAR(NN)) ? *Bogdan MIHALACHE* *From:*firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] *On Behalf Of *liviuslivius *Sent:* Friday, January 31, 2014 10:22 AM *To:* firebir d-supp...@yahoogroups.com *Subject:* [firebird-support] Udf returning VARCHAR Hi, i try to find any example of writing and declaring udf function returning varchar instead of Char without success. Is this possible? regards, Karol Bieniaszewski ~-|**|PrettyHtmlStart|**|-~
Re: [firebird-support] Garbage collection / sweep not happening on super classic
Hej, rmcgi...@oceris.com wrote: Sweep interval: 0 IIRC a Sweep interval of 0 disables automatic sweeping?
Re: [firebird-support] arithmetic exception, numeric overflow, or string truncation
Hej, G G wrote: i have a table defined as: create table organisation ( orgid bigint not null, title varchar(30) not null, levels smallint not null, parent bigint , inuse char(1) default '1', constraint pk_organisation primary key (orgid) ); alter table organisation add constraint fk_parent2orgid foreign key (parent) references organisation (orgid) on delete no action on update no action and the stored procedure to for inserting data as: create procedure insertorg ( in_title varchar(30), in_level smallint, in_parent bigint) as declare variable insertsql varchar(90) = 'insert into organisation (title, levels, parent) values (:ptitle, :plevel, :pparent)'; begin if ((in_level =1 and in_parent is null) or (in_level 1 and in_parent is not null) ) then execute statement (insertsql) (ptitle := in_title, plevel := in_level, pparent := in_parent ); end ^ when i try to use the procedure to insert a new record in the table i get the following error message: arithmetic exception, numeric overflow, or string truncation string right truncation at procedure 'insertorg' line: 3, col: 1. however if i issue the insert command directly eg: insert into organisation (title, levels, parent) values ('main dept',1,null); this works fine. (There is a before inset trigger on the table that takes care of issuing a value for the primary key). What in the procedure is causing this error? I've tried the procedure without the if then statement and still receive the same error. First i would try the procedure without the insertsql-stuff. Marcus
Re: [firebird-support] Database Inaccessability
Hej Leyne, Sean wrote: Hilton, After you restart the server, run gstat with ‘header’ option and post the output here – before you open the database with your application. Sean You're thinking about a transaction chain that is that big? Being curious about the header information now... Marcus *From:*firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] *On Behalf Of *hil...@healthrad.co.za *Sent:* Wednesday, December 18, 2013 2:58 PM *To:* firebird-support@yahoogroups.com *Subject:* Re: [firebird-support] Database Inaccessability OS : windows server 2008 R2 x64... firebird v2.5.1 Firebird is running, I don't get any errors... all apps that access the firebird SQL database just hang, at the end of the 2-3 hours it responds, if I leave the app open it will suddenly respond at that time... even if I remove and re-install the firebird service it still waits the 2-3 hours before responding, if I try run a gfix on the db during this time it responds that the db might be corrupted... after the time if I run gfix it responds that the db is fine with no errors. *From: *Mark Rotteveel *Sent: *Wednesday 18 December 2013 19:55 *To: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Reply To: *firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Subject: *Re: [firebird-support] Database Inaccessability On 18-12-2013 13:48, hil...@healthrad.co.za mailto:hil...@healthrad.co.za wrote: I have a Firebird SQL database running on a HP ML350 Server, 16GB Ram and Dual Processors.. The Problem I have is when we restart this server, the Database is completely inaccessible for a minimum of 2 - 3 hours, can't even open Using a SQL Manager... any Ideas on what to look at?? after the 2-3Hours the db is accessible and works perfectly, it only happens when the server is restarted... You really need to provide a lot more detail. What OS, what Firebird version, what Firebird server type. Have you checked that Firebird is actually running? What error do you get when trying to access it? Have you checked the Firebird log My first impression would be that Firebird isn't started immediately. Mark -- Mark Rotteveel
Re: [firebird-support] FreeAdhocUDF: file functions - can not SAVE#92;LOAD blobs with unicode paths.
Hej, brucedickin...@wp.pl wrote: Hi guys, have anyone tried these functions? I can save and load ascii named blobs to disk but it does not work for unicode paths. For example: SELECT F_BLOBLOAD('E:\你好.txt') FROM RDB$DATABASE gives me an empty blob. I can not test it via FlameRobin because it is not able to properly create a query with unicode characters in it. I've tested it with Firebird Maestro but I got nothing (empty blob). The same with Delphi. It is very frustrating because I do not know where the problem lies: 1. Is CSTRING type a UTF-8 based type? It is required as an input path parameter. 2. Does Database character set can influence this? I've tried setup with NONE and UTF-8, nothing changes. 3. Perhaps those functions are not working with UTF-8 paths, but on the website it is written that they are UTF-8 compatibile (whatever that means?) 4. Perhaps everything is working fine but SQL Maestro is not sendingdata in valid text format, the same goes for Delphi. I lot of ifs, maybe someone has some experience with this? Thank you. Probably the wrong list? They have a own mailing list: http://freeadhocudf.org/mailing_eng.html
Re: [firebird-support] Replication of Firebird Databases (meany to one)
Hej all, Andrew Gable wrote: Hi all, Does anyone know any good free to use replication software. What i have is as follows I have 4-20 terminals with a database that holds all the products/ cashier ids etc in it and I want the system to sync the local database to it the server and then delete any data that his has processed can this be done with Replication or do I need to create my own app to handle this Sorry, could't resist: first answers @ google when searching for firebird replication http://www.firebirdsql.org/en/some-solutions-to-old-problems/ http://www.firebirdfaq.org/faq249/ http://www.symmetricds.org/ http://www.ibphoenix.com/download/tools/replication IIRC, Holger Klemt (ibexpert.net) has written an article about how to build your own replication some few years (~2005?) ago in a german developer magazin. There are several show stoppers buried in the database layout, such as ids, primary and foreign keys, unique values, generators and triggers. Also does anyone know anyway of checking to see if the server is online before connection to it in VB6 (via ODBC Driver) You will have no luck accessing the firebird services API via ODBC, as ODBC is data only. One option would be to work with something like try-catch(-finally). I don't know if that feature is available in VB6 Feel free to take a look at: - http://pythonhosted.org/fdb/usage-guide.html#working-with-services Even if not programming in python, it declares a lot about how to attach to a service. thanks Andy hth, Marcus ++ 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://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] wcdata.fdb file opened many times, hogging space !
Hej all jboss...@nwtel.ca wrote: No i'm not deleting any file. Sure? If not you, may it be a script or an application? Because dropping a database per fb service or isql statement (which may be the same) would not left over any hanging fb_inet processes. -we use the gfix script to stop the db every night, and make a backup. this is not releasing the hogged space (fb_inet process still running) ! we use gfix -user sysdba -password -shut full -force 0 wcdata.fdb, then the DB is dow, we we try to connect to it. -Then we decided to go with a service firebird2-5 stop, this this is not releasing the hogged space (fb_inet process still running) ! ?? But why?? One step earlier you've told the database to shutdown, so there cannot be any running fb_inet process, as they are invoked per (x)inetd. The database is shut down, any connection will be prohibited. -the only option is to do a pkill fb_inet, thus processes a killed, space is released. @MArk : by service api , do you mean using gfix to shut down the DB ? I am amazed i'm the on ly one having this issue, i did an standard install, no fancy config ! Playing around a little bit - even a forced shutdown on a database with open transactions - as soon as the gfix -shut is executed - there is NO single that has any connection to the database i've issued the shutdown to. Try to finish open transactions, may it be commiting or rolling back - errors. No new attachments to the database are allowed. So from this point on i can take the database out for a walk - and no single fb_inet process will miss it Being honest - smells like faulty firebird and/or connection and/or system handling. Thanks for your help ---In firebird-support@yahoogroups.com, mark@... wrote: On 21-11-2013 17:59, jbossert@... mailto:jbossert@... wrote: Hi Mark, Right now i'm looking in a way to reclaim the space right away without killing the process. Use the monitoring tables to kill connections. But how did you remove the file, did you delete it? Instead of deleting it through the file system, you might want to try dropping it using the service API. That will check if the database is still in use or not. Is it helping if i change the FB flavor to superclassic, assuming this fires only 1 instance of the db, so the file will be opened only 1 time ?! I don't know. Mark -- Mark Rotteveel
Re: [firebird-support] what should i think of when creating a shared server with firebird?
Hej, g80r...@gmail.com wrote: it's time we start creating servers for firebird. i thinking of shared servers, like they do on mysql on almost all shared server around the world. i am thinking of selling shared server accounts with firebird. what do i have to think of and what do i need to be successful? what you need - knowledge of firebird: see the official documentation - depending on the OS underneath - knowledge of security mechanisms. - some scripting knowlegde may be helpful simple question. and i need simple answers. simple enough?
Re: [firebird-support] what should i think of when creating a shared server with firebird?
See, some more precise questions once there was a project like phpmyadmin for interbase/firebird, called ibwebmin if i recall correcty. And it was alread abandoned some several years ago. Aside that, there MAY be some specific solutions hidden behind cobwebs in lost corners of the web. Oh, and take a look at ibexpert - they have done/they're doing some stuff with firebird and web - maybe also sharing. But all that one may have found out by a litte search, follow and read. g80r...@gmail.com wrote: too simple answer. i know all this. scripting i know. firebird i know. security i know. it's the same a a standard server with mysql. i asking this because there is not many firebird shared servers around. it has to be a reason for it. so i ask again what do i need to think of when creating a firebird shared server. what tools exists like control applets for users. let's say it on a linux server. and let's say it's also on a windows server. please give one better answer. ---In firebird-support@yahoogroups.com, marcus@... wrote: Hej, g80rock@... mailto:g80rock@... wrote: it's time we start creating servers for firebird. i thinking of shared servers, like they do on mysql on almost all shared server around the world. i am thinking of selling shared server accounts with firebird. what do i have to think of and what do i need to be successful? what you need - knowledge of firebird: see the official documentation - depending on the OS underneath - knowledge of security mechanisms. - some scripting knowlegde may be helpful simple question. and i need simple answers. simple enough?
Re: [firebird-support] Overflow occurred during data type conversion
Net Firebird wrote: my procedure code is as follows. CREATE PROCEDURE SP_GET_MINIWEB_EVENTS ( MINIWEB_NAME NAME, LANGUAGE_CODE LANGUAGE_CODE ) RETURNS ( EVENT_ID ID, EVENT_DATE Date, EVENT_TIME Time, TITLE EVENT_TITLE, DESCRIPTION DESCRIPTION, PRICE MONEY, VENUE VENUE, ADDRESS ADDRESS, WEBSITEURL WEBSITEURL, EVENT_TYPE_NAME NAME, PROVINCE_NAME PROVINCE_NAME ) AS BEGIN FOR SELECT e.event_id ,e.event_date ,e.event_time ,e.title ,e.description ,e.price ,e.venue ,e.address ,e.websiteurl ,et.event_type_name ,p.province_name FROM t_event e join event_type_translation et on (e.event_type_id=et.event_type_id) join language l on (l.language_code=et.language_code) join miniweb m on (m.party_id=e.party_id) join province p on (e.province_id=p.province_id) where m.miniweb_name=:MINIWEB_NAME and l.language_code=:language_code and e.event_date='today' order by e.event_date, e.event_time INTO :event_id, :event_date, :event_time, :title, :description, :price, :venue, :address, :websiteurl, :event_type_name, :province_name do SUSPEND; END Hej, what about some sample data? We don't have crystal balls Are you sure the problem is caused by the domain DESCRITPION? Aside that - ever thought about naming conventions? Naming a domain and use the same name as returning variable? Marcus On Mon, Oct 7, 2013 at 7:56 PM, Leyne, Sean s...@broadviewsoftware.com mailto:s...@broadviewsoftware.com wrote: __ You need to provide some better context (SP source code), the error message alone does not provide any details from which an explanation could be derived. __ __ __ __ Sean __ __ *From:*firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com] *On Behalf Of *Net Firebird *Sent:* Sunday, October 06, 2013 5:02 PM *To:* firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com *Subject:* [firebird-support] Overflow occurred during data type conversion __ __ When using in selectable stored procedure data type Varchar(8191) I keep getting __ __ Overflow occurred during data type conversion __ __ this is my domain CREATE DOMAIN DESCRIPTION AS Varchar(8191) COLLATE UNICODE_CI_AI; __ __ There is no conversion needed as the same domain is used in table field and stored procedure returns parameter. however when just doing select it works fine. but inside SP not. What might be the problem? FB 2.5.2 ++ 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://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] firebird performance on xeon cpu
安占江 wrote: I have some create table scripts, run well on most pc, but the hp server. hp server as bellow cpu xeon 2.8Ghz 4core not used hyperthreading mem 8gb disk 500gb 7.5k/s sata os win7 64 firebird.conf cpuaffinitymask=1 this scripts normally run less than 1s, but on there two server need more than 15s. First thoughts: - It is a native disk or it is a raid? - Any Cache controller? Cache controller battery empty? - Some antivirus software? hth, M. Bajohr
Re: [firebird-support] Detecting / Removal of Firebird
craigmas...@btinternet.com wrote: Can anyone help with how to detect if Firebird is installed on a server? A recent health check here has detected that an older version of one of our applications used to use Firebird and there are fragments that need removing. However, all attempts to find any trace of Firebird on the server are not detecting it. How can I detect / remove anything that is left over? Kind Regards, Craig S Massey (Corporate Systems Programme Manager) Barnsley Council, South Yorkshire. www.barnsley.gov.uk Hej, it depends on how and with what options firebird was installed. For example it may have been an embedded installation, where you have no real server instance one could locate in the registry. Another option for installation is a custom directory or a silent installation from a zip archive. I suggest to search the file system for gds32.dll and fbclient.dll, that are the most common files you should find. Also a run for security*.*db may be of help. And inspect the registry, search for - firebird - interbase hth, M. Bajohr
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]