Re: [Firebird-devel] ICU. VS2010 project files
On Fri, Apr 29, 2011 at 10:49 AM, Vlad Khorsun hv...@users.sourceforge.net wrote: we must provide binaries inside our Windows package :( Yes, that is right. I don't object to agreeing on a specific version of ICU for each release. We would just change the build script as required. (Presumably we will need .lib files.) Our main problem is likely to be finding icu binaries built with MSVC10. ICU 4.6 (more exactly icu4c 4.6 and latest 4.6.1) are built using MSVC10, so this is not an issue. BTW, we still have no MSVC10 at our build farm, but this is another question... Not much would change as far as packaging is concerned. We would just include the icu dlls as now, except their location at package time will / may be different. Of courses, we may get lucky and ibm will have upgraded their ridiculous icu build system and we could just incorporate it again into the windows build. However, if it hasn't been changed it would require a ton of work for each icu version, which is one of the reasons why we haven't upgraded icu. One note. Binary packages at IBM site http://download.icu-project.org/files/icu4c/4.6.1/icu4c-4_6_1-Win32-msvc10.zip http://download.icu-project.org/files/icu4c/4.6.1/icu4c-4_6_1-Win64-msvc10.zip contains relatively big ICU libraries. Size of 3 dll's needed for Firebird is more than 16MB, the biggest is icudt46.dll (14.4MB) which contains a lot of unused by FB data. Should i said that whole FB folder have similar size ? Here http://apps.icu-project.org/datacustom/ we can see what could be removed without any harm. We should decide (at least for Windows) a) will we provide ICU libraries - within our packages (as with FB2.x), or I vote for this one - ask users to download ICU from IBM site, or Asking users to download separate package is prone to errors : there will be a flood of questions : where do i download ... firebird doesn't work out of the box (matching icu versions hell) - provide separate package with just 3 DLL's we need it should be optional and for people who want slim firebird b) will we provide default (fat) ICU libraries or our customized (light) version ? Provide fat icu in first stage and if is requested make it light (hdd space/bandwidth is realy cheap these days) and doesn't worth to spend to much time in overoptimizing the used space Creating a light package is a good idea for embedders but that want to create small packages but that should be optional package -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] R: List of keywords?
On Tue, May 3, 2011 at 9:07 PM, Thomas Steinmaurer t...@iblogmanager.com wrote: Hi! Messaggio originale Ogg: [Firebird-devel] List of keywords? is there somewhere a list of keywords, which an tool/application developer should access as delimited identifier in a dialect 3 database? Maybe you refer to http://www.firebirdsql.org/rlsnotesh/rlsnotes25.html#rnfb25-reswords and http://www.firebirdsql.org/rlsnotesh/rlsnotes210.html#rnfb20x-reswords I hoped, there is a one stop place, but I guess I have to go through the various release notes. I also found this: http://www.firebirdsql.org/doc/contrib/standardSQLkeywords.html While it's a list per SQL standard, it doesn't mention what Firebird version treats what term as keyword. Also Cosmin created a list of keywords If anyone's interested, I attached a csv of reserved keywords (marked with '*') for 2.0.6, 2.1.3 and 2.5.0 respectively, brute-force tested using table name, column name, exception name and generator name as identifiers. The list of keywords is the union of keywords list from SQL standards 92, 99, 2003 and 2010 draft, Interbase 6, 6.5, 7 and Firebird 1.0-2.5. https://spreadsheets.google.com/ccc?key=0AgmDDYc8dMVzdDc2NnlpbUdHaWJBcU51c01wdjV3Rnchl=en And is always up to date in svn http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/branches/B2_5_Release/src/dsql/keywords.cpp?revision=52871view=markup Maybe it should be generated as one of the examples dbs :) and all you should do is Select * rdb$keywords or select * from keywords Old thread is here http://firebird.1100200.n4.nabble.com/Question-regarding-reserved-keywords-in-2-5-td3022079.html -- WhatsUp Gold - Download Free Network Management Software The most intuitive, comprehensive, and cost-effective network management toolset available today. Delivers lowest initial acquisition cost and overall TCO of any competing solution. http://p.sf.net/sfu/whatsupgold-sd Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] merged the following patches from debian 2.5
I have merged the following patches sparc-no-m32.patch powerpc-no-mcpu.patch I review now the follwing that was needed for sh port atomic_ops_require_cas.patch From the list of patches http://git.debian.org/?p=pkg-firebird/2.5.git;a=tree;f=debian/patches;h=edad9438a0d331ca98e1c5fab9d5eaeae3722368;hb=experimental Some will not be merged like the fix_kfreebsd_amd64_miscompile.patch and others need more discussions (related to paths ...) -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ERROR firebird.msg not found, when build Firebird 2.1.3 or 2.1.4
On Wed, May 11, 2011 at 10:58 AM, Alex Peshkoff peshk...@mail.ru wrote: On 05/11/11 04:59, wuu wrote: here is build log http://firebird.1100200.n4.nabble.com/file/n3513424/build.log build.log If your CPU supports 64 bit instructions, please try to: export CFLAGS=-m64 export CXXFLAGS=-m64 export LDFLAGS=-m64 before running configure (or autogen.sh). If not - I'm not sure how to help with this bug. cpu seems to be 32 bit if i look at the specs gen/firebird/firebird.msg not found could be related to bison/yacc bug ? try to enable debug mode to see if it works ./autogen.sh --with-system-editline=yes --with-system-icu --enable-debug also you could check firebird 2.5 to see if you have the same results -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] ERROR firebird.msg not found, when build Firebird 2.1.3 or 2.1.4
On Wed, May 11, 2011 at 12:11 PM, wuu 0049000...@zte.com.cn wrote: thank you, I'll enable debug to get more info. And 2.5 also can't compile : http://firebird.1100200.n4.nabble.com/file/n3514200/build_2.5.log build_2.5.log error info : in src/common/classes/fb_atomic.h, line 518, #error AtomicCounter: implement appropriate code for your platform! That is easy solvable by using this patch http://patch-tracker.debian.org/patch/series/view/firebird2.5/2.5.0.26074-0.ds4-4/atomic_ops_require_cas.patch in the firebird dir patch -p1 atomic_ops_require_cas.patch you also need to install libatomic_ops see the related thread http://firebird.1100200.n4.nabble.com/2-5-RHEL-PPC64-td3055188.html So I can only use 2.1.4. -- View this message in context: http://firebird.1100200.n4.nabble.com/ERROR-firebird-msg-not-found-when-build-Firebird-2-1-3-or-2-1-4-tp3510915p3514200.html Sent from the firebird-devel mailing list archive at Nabble.com. -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [pkg-firebird-general] Bug#626931: Bug#626931: Bug#626931: FTBFS on GNU/Hurd
On Tue, May 17, 2011 at 7:11 AM, Damyan Ivanov d...@debian.org wrote: [Full CC for debiandevel] -=| Damyan Ivanov, Mon, May 16, 2011 at 09:12:27PM +0300 |=- -=| Ondřej Surý, Mon, May 16, 2011 at 05:27:53PM +0200 |=- Hi Marius, On Mon, May 16, 2011 at 16:39, marius adrian popa map...@gmail.com wrote: 2011/5/16 Ondřej Surý ond...@debian.org: Package: firebird2.5 Version: 2.5.0.26074-0.ds4 Severity: normal Tags: patch Firebird FTBFS on GNU/Hurd because MAXPATHLEN is not defined on that platform. Attached is a patch which fixes that. Please apply, it is a simple fix and it blocks php5 build on GNU/Hurd. I have commited to svn 2.5 release branch please test if is ok That was quick! :) Unfortunatelly I am not able to test it as I don't use hurd myself. I asked the admin of strauss.debian.net (hurd porterbox) to install the needed build dependencies for firebird2.5 and will try building it there. But generally speaking (from my experience of fixing cyrus-imapd-2.x) it should work. I am Ccing debian-hurd list, maybe somebody there could help us with testing. If not I would suggest you go ahead and upload if you have other stuff to release... I seem to remember a Hurd porter said that there would be problems with semaphores or something like that, but I can't find it. Anyway, we'll see how the build goes on the porterbox. In the worst case php would have to omit the firebird dependency/support for Hurd. The build fails with the following error: g++ -ggdb -O3 -DNDEBUG -DLINUX -pipe -MMD -fPIC -DFB_SEND_FLAGS=MSG_NOSIGNAL -I. ./src/include/gen -I../src/include -I../src/vulcan -DNAMESPACE=Vulcan -pthread - g -O2 -DBOOT_BUILD -fno-rtti -c ../src/jrd/gds.cpp -o ../temp/boot/jrd/gds.o In file included from ../src/jrd/../jrd/../jrd/ThreadData.h:35, from ../src/jrd/../jrd/jrd.h:74, from ../src/jrd/gds.cpp:148: ../src/jrd/../jrd/../jrd/../common/classes/rwlock.h: In member function 'void Fi rebird::RWLock::init()': ../src/jrd/../jrd/../jrd/../common/classes/rwlock.h:199: error: 'PTHREAD_RWLOCK_ PREFER_WRITER_NONRECURSIVE_NP' was not declared in this scope ../src/jrd/../jrd/../jrd/../common/classes/rwlock.h:199: error: 'pthread_rwlocka ttr_setkind_np' was not declared in this scope make[5]: *** [../temp/boot/jrd/gds.o] Error 1 Sending a copy to firebird-devel for oppinion. We need a new define for hurd afther we undefine LINUX that part compiles but i hit another issues that i found it to be in haikuos too g++ -I../src/include/gen -I../src/include -I../src/vulcan -DNAMESPACE=Vulcan -gg db -p -Wall -Wno-switch -DLINUX -pipe -MMD -fPIC -DFB_SEND_FLAGS=MSG_NOSIGNAL -D DEV_BUILD -pthread -DBOOT_BUILD -pthread -fno-rtti -c ../src/jrd/os/posix/isc_ip c.cpp -o ../temp/boot/jrd/isc_ipc.o ../src/jrd/os/posix/isc_ipc.cpp: In function 'bool isc_signal2(int, FPTR_VOID, v oid*, ULONG)': ../src/jrd/os/posix/isc_ipc.cpp:187:31: error: 'SA_SIGINFO' was not declared in this scope ../src/jrd/os/posix/isc_ipc.cpp: In function 'void ISC_signal_cancel(int, FPTR_V OID_PTR, void*)': http://mapopa.blogspot.com/2010/06/firebird-database-porting-progress-on.html ps here is one kvm-linux, qemu image that can be used wget http://people.debian.org/~sthibault/hurd-i386/debian-hurd.img.tar.gz tar -xz debian-hurd.img.tar.gz kvm -net nic,model=rtl8139 -net user debian-hurd-*.img in my case i didn't had x so kvm -curses -net nic,model=rtl8139 -net user debian-hurd-20110323.img apt-get update apt-get dist-upgrade apt-buildep firebird2.5 then checkout from svn/debian or git http://mapopa.blogspot.com/2010/09/howto-checkout-firebird-25-release.html tip add --enable-system-icu --enable-debug by default is detected as i686-unknown-gnu0.3 i have exeperimented with some platform defaults but i still need some work and research to do ___ pkg-firebird-general mailing list pkg-firebird-gene...@lists.alioth.debian.org http://lists.alioth.debian.org/mailman/listinfo/pkg-firebird-general ___ pkg-firebird-general mailing list pkg-firebird-gene...@lists.alioth.debian.org http://lists.alioth.debian.org/mailman/listinfo/pkg-firebird-general -- Achieve unprecedented app performance and reliability What every C/C++ and Fortran developer should know. Learn how Intel has extended the reach of its next-generation tools to help boost performance applications - inlcuding clusters. http://p.sf.net/sfu/intel-dev2devmay
Re: [Firebird-devel] Changes to API since Interbase 6
On Thu, Jun 16, 2011 at 9:23 AM, Russell Rose russ...@passfield.co.uk wrote: I have been looking at the Interbase 6 API and see the service function which allows for the gfix options of full, mend and validate. Have there been any additions to the API since this time to allow for the sweep option? I have not managed to find anything in the documentation Well you need to pass the parameter to isc_action_svc_repair function isc_spb_rpr_mend_db isc_spb_rpr_sweep_db It's described in this doc http://www.ibphoenix.com/resources/documents/design/doc_181 Cool example we have in lua http://fbclient.googlecode.com/hg/lua/fbclient/service_class.lua?r=a257d7ec89a8a185e035eb8baaa5c490a3c9bd0d -- EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Interesting article about scalability of MySQL in Amazon (?) RDS
On Wed, Jun 22, 2011 at 12:19 PM, Alex Peshkoff peshk...@mail.ru wrote: On 06/22/11 11:13, Roman Rokytskyy wrote: Would be interesting to check how does Firebird behaves. Roman, we have some implementation of tpc-c, which works with firebird. I often use it to check firebird stability under load. But telling true it seems that it measures using some other tpmC. I think so because with one of the latest tests with trunk I've got TPC-C Throughput: 199378.00 tpmC on 2 years old box (5 warehouse / 5 client, embedded connection). And when the result differs 2 orders of magnitude (compared with 7000 in that article), it looks like something different is measured. Could you publish the sources in github/sourceforge for tpc we need the tool to do some benchmarks Also related to the article , on amazon rds is using EBS http://invalidlogic.com/2011/02/16/our-pain-points-with-ec2/ and as i measured (both on Firebird and mysql) it's quite horridly slow for IO and that could be the limit that is hit by rds , in fact you are always better with bare Real hardware and dedicated resources and no virtualization on it ps:I didn't tested yet the local drive that is atached to the instances in /mnt -- Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] FreePascal as an embedded language in Firebird: possible and desirable?
On Wed, Jul 27, 2011 at 2:55 PM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: On 27/07/2011 08:40, Alex Peshkoff wrote: On 07/27/11 15:11, Tony Whyman wrote: 6. Just in time compilation of the embedded procedure on first use (after create/alter) into a shared library/DLL which is then effectively a dynamically generated UDF library. A JIT approach is important because the database can be moved between processor architectures/platforms and it is important to be able to recompile automatically for the new platform. Before doing JIT, we must think about related security issues. How can we prevent pascal procedure from doing bad things with firebird runuser access rights? I believe it should be done as Chrome(ium)'s nativecliente technology is built, using a sandbox. +1 this is what i wanted to reply with :) http://blog.chromium.org/2008/10/new-approach-to-browser-security-google.html this is how flash plugin is run in an external process and if it crashes it crashes only the external process not the chrome process http://www.chromium.org/developers/design-documents/plugin-architecture Adriano -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] url from headers
url from headers should be changed from http://www.Inprise.com/IPL.html to http://www.firebirdsql.org/en/interbase-public-license -- uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Choosing a distributed version control system for firebird project
This page may help the project in choosing a better DVCS PHP uses Subversion (SVN) as its version control system of choice at the moment. This has a few drawbacks. A decentralized version control system can solve some of these drawbacks. This RFC aims to provide information helpful in choosing one of the proposed decentralized version control systems (DVCS). https://wiki.php.net/rfc/dvcs ps: I have casted my vote for git (for php project) https://wiki.php.net/rfc/dvcs/vote -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] control pannel bug windows7
Is this bug still present with 2.5 ? http://twitter.com/#!/ermsitgirl/status/107052676784721920 My guess is not , i will try it on a machine to see the status -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Performance of FW databases on ext4 filesystem
On Mon, Aug 29, 2011 at 1:14 AM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: All, After I bought a new machine, I reinstalled Ubuntu in new HDD with ext4 filesystem. While the new machine has much better CPU than the old one, I noticed the build being very slow where Firebird was creating databases. I found that mounting the ext4 partition with barrier=0 parameter decreased the performance from more than 2 minutes to less than 50s in the build. But changing this parameter seems to not make ext4 at least safe as ext3. So I reverted it and adjust the build to turn FW=off for the internal databases. That didn't become fast as barrier=0, but was acceptable (around 1 minute). Now I tried to run tcs and saw it's completely unpractical. So I started to test just create database performance. The numbers are around this: ntfs: 0.2s ext3 default (barrier=0): 0.1s ext3 (barrier=1): 0.8s ext4 default (barrier=1): 2.8s I removed the O_SYNC flag in posix.cpp and it makes ext4 similar to ext3. So I have some questions: Are we doing something wrong? Does ext4 just f*ks? Is ext3 good just until you need what it markets, i.e., you should pray for no hardware crashes or power loss? What about some new parameter to ignore FW=on for who just don't care? (tests, development, etc) you are not the only one that observed db/vm performance issues with ext4 maybe you need to mount it with data=writeback http://blog.smartlogicsolutions.com/2009/06/04/mount-options-to-improve-ext4-file-system-performance/ -- EMC VNX: the world's simplest storage, starting under $10K The only unified storage solution that offers unified management Up to 160% more powerful than alternatives and 25% more efficient. Guaranteed. http://p.sf.net/sfu/emc-vnx-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] 68K port
On Thu, Oct 20, 2011 at 3:40 PM, Alex Peshkoff peshk...@mail.ru wrote: Hi, Dam! Can you comment something about this issue: http://tracker.firebirdsql.org/browse/CORE-3637 Telling true I'm surprised. Why is that port needed at all? May be there is a real park of old 68k machines? Wikipedia mentions that 68k-based architecture based CPUs are used in embedded systems, but apache+php+firebird - is not it too much for embedded device? We had that port in FB1, but later cleaned it up. And I see no reasons to return to it. Did not drop as Won't fix only because it came from Debian :) I follow the bugs and fixes for debian and seems that port got in a compilable/bootable state at last :) http://lists.debian.org/debian-68k/2011/10/msg2.html I saw that ColdFire is still produced so this is what is the target for the real world (debian embeded) http://en.wikipedia.org/wiki/Freescale_ColdFire I will try to start the emulator and see how firebird works on it -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Ciosco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] news from kernel 3.1
if you feel slow downs with database access (inserts) with the new kernel 3.1 and ext3 Filesystem barriers enabled by default in Ext3 http://kernelnewbies.org/Linux_3.1 Hard disks have a memory buffer were they temporally store the instructions and data issued from the OS while the disk processes it. The internal software of modern disks changes the order of the instructions to improve performance, which means that instructions may or may not be committed to the disk in the same order the OS issued them. This breaks many of the assumptions that filesystems need to reliably implement things like journaling or COW, so disks provide a cache flush instruction that the OS uses when it needs it. In the Linux world, when a filesystem issues that instruction, it is called a barrier. Filesystems such as XFS, Btrfs and Ext4 already use and enable barriers by default; Ext3 supports them but until this release it did not enable them by default: while the data safety guarantees are higher, their performance impact in Ext3 is noticeable in many common workloads, and it considered that it was an unnaceptable performance regression to enable them by default. However, Linux distros like Red Hat have enabled barriers by default in Ext3 for a long time, and now the default for mainline has been changed aswell. In other words: if you use Ext3 and you note performance regressions with this release, try disabling barriers (barriers=0 mount option). -- The demand for IT networking professionals continues to grow, and the demand for specialized networking skills is growing even more rapidly. Take a complimentary Learning@Cisco Self-Assessment and learn about Cisco certifications, training, and career opportunities. http://p.sf.net/sfu/cisco-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Running Firebird on KVM
On Wed, Nov 23, 2011 at 12:37 PM, Pawel Sawicki wa...@poczta.onet.pl wrote: Hi All, We are running Firebird-2.5.1 on virtual machine with RHEL6.0. Our hypervisor is KVM. From time to time we get Firebird unresponsive and we need to restart it. This situation occurs on heavy loaded system, strace shows that the problem is related with the fragment of code which contains invocation of pthread_cond_timedwait sytem call (file /src/jrd/isc_sync.cpp). It looks like all threads lost completely synchronization and block each other. We use your standard distribution package. There is small chance that this problem can be attributed to different environment used during build, thus we are going to recompile Firebird from scratch. Hovewer more viable explanation is that we encountered bug which becomes visible in virtual environment. We have some experiances with timekeeping in virtual machines which is not very accurate and could possibly lead to this effect. If pthread_cond_timedwait sytem is not working correctly can it be simply replaced by other system call which could be more reliable ? Could you show what is the time source , it is possible to have a unstable clock source cat /sys/devices/system/clocksource/clocksource0/current_clocksource kvm-clock dmesg | grep kvm-clock [0.00] kvm-clock: cpu 0, msr 0:7a8381, boot clock [0.00] kvm-clock: cpu 0, msr 0:101d381, primary cpu clock [0.004000] kvm-clock: cpu 1, msr 0:102d381, secondary cpu clock ntp should be disabled on the guest but enabled on the host Best regards Pawel -- View this message in context: http://firebird.1100200.n4.nabble.com/Running-Firebird-on-KVM-tp4099137p4099137.html Sent from the firebird-devel mailing list archive at Nabble.com. -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-novd2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Remote protocol backward compatibility
On Wed, Jan 4, 2012 at 2:23 AM, W O sistemas2000profesio...@gmail.com wrote: I agree. I just use FB 2.5 Greetings. Walter. I would go to accept only protocol from 2.0 1.5.x is not supported anymore anyway http://www.firebirdsql.org/en/roadmap/ On Tue, Jan 3, 2012 at 5:39 PM, Mark Rotteveel m...@lawinegevaar.nl wrote: On 3-1-2012 17:04, Dmitry Yemanov wrote: All, Would there be any objections if we remove the support for protocol versions less than 10? It means that fbclient would not connect to pre-v6 versions of InterBase and fbserver would not accept connections from pre-v6 versions of gds32. All Firebird versions would still be supported, as well as InterBase 6.0 and above. This is about Firebird 3.0, of course. Such a cleanup would allow to simplify the code and make some future enhancements a bit easier. No objections from me: remove the old cruft :) -- Mark Rotteveel -- Write once. Port to many. Get the SDK and tools to simplify cross-platform app development. Create new or port existing apps to sell to consumers worldwide. Explore the Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join http://p.sf.net/sfu/intel-appdev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Remote protocol backward compatibility
On Wed, Jan 4, 2012 at 11:46 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On 4-1-2012 8:30, marius adrian popa wrote: On Wed, Jan 4, 2012 at 2:23 AM, W Osistemas2000profesio...@gmail.com wrote: I agree. I just use FB 2.5 Greetings. Walter. I would go to accept only protocol from 2.0 1.5.x is not supported anymore anyway http://www.firebirdsql.org/en/roadmap/ If you look at Jaybird it currently only supports protocol version 10, and as long as the newer protocol versions are not implemented, removing support for protocol version 10 would cut off all Java users from connecting to Firebird 3.0 (except when using a native client library, but that has its own downsides). I am planning on adding the newer protocol versions in Jaybird 2.3, but it will take time to get familiar with the wire protocol and its current implementation in Jaybird. What I have seen right now will probably mean that I will need to rewrite the implementation to better/easier accommodate multiple protocol versions. Then it will take more time to test the new implementation and to have users migrate to Jaybird 2.3. So they answer is less than 1.0 and you have my vote :) -- Ridiculously easy VDI. With Citrix VDI-in-a-Box, you don't need a complex infrastructure or vast IT resources to deliver seamless, secure access to virtual desktops. With this all-in-one solution, easily deploy virtual desktops for less than the cost of PCs and save 60% on VDI infrastructure costs. Try it free! http://p.sf.net/sfu/Citrix-VDIinabox Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Cpu affinity on Linux Super Server
On linux there is taskset to put the super server on the prefered cpu http://forums.devshed.com/firebird-sql-development-61/how-to-configure-cpu-affinity-on-superserver-linux-873311.html In theory we can unify the cpu affinity flags on Windows and Linux http://www.kernel.org/doc/man-pages/online/pages/man3/pthread_setaffinity_np.3.html http://www.kernel.org/doc/man-pages/online/pages/man2/sched_setaffinity.2.html I don't know if is worth it implemented but it could be useful to let 4 cores from 8 to work on firebird and the rest to be left to the webserver for example -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] JSON as a core type.
I saw it today on reddit , that postgre added json as core type http://people.planetpostgresql.org/andrew/index.php?/archives/244-Under-the-wire.html -- Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] JSON as a core type.
On Fri, Jan 20, 2012 at 6:25 PM, Mark Rotteveel m...@lawinegevaar.nl wrote: On Fri, 20 Jan 2012 17:42:55 +0200, marius adrian popa map...@gmail.com wrote: I saw it today on reddit , that postgre added json as core type http://people.planetpostgresql.org/andrew/index.php?/archives/244-Under-the-wire.html I don't really see the added benefit of having this as part of a database itself. IMHO, it is a database, not a 'do-everything-I-want-with-my-data'-base. I do understand it can be easy for some users, but easy should not always be the prime motivator. Is this BTW a switch from the saying 'Eventually all programs will evolve to also send mail (or be replaced by programs that do)' by a similar saying that has 'send mail' replaced by 'process JSON' (as also happened with XML in the end of 90s start of 00s)? Well json won and it event not tried to beat the xml vs json wars http://www.json.org/xml.html From a practical perspective i'm on the fourth json based api service (rails/django) that i'm working on Twitter switched to json only api (that would be the fifth project ) http://blog.programmableweb.com/2010/11/10/twitter-goes-json-only-with-one-api-more-to-come/ And if you wonder why is that well in ajax it's a lot easier to use json directly and faster (java script native type) http://www.json.org/js.html So i'm thinkig that making things easier for webdevel would be cool but of course all the formatting can be done externally from php,python,javascript -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] The new XFS: the filesystem of the future?
From what i understood from the presentation , the new XFS scales better than BTRFS/ext4 under higher workloads (more than 8 threads ) and delivers more iops compared with the mentioned filesystems http://lwn.net/SubscriberLink/476263/e9eab3b5a22a1f09/ via reddit discussion http://www.reddit.com/r/linux/comments/p1wpk/xfs_the_filesystem_of_the_future_lwnnet/ -- Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird License Incompatibilities
On Fri, Jan 27, 2012 at 2:03 PM, Pierre Arnaud arn...@epsitec.ch wrote: Hi, the original author of Colobot has also developed a derived game, called CeeBot, for which he has already prepared a ZIP file with the whole content: www.epsitec.ch/download/ceebot/ceebot.zip Does it use firebird ? or i don't see the relevance with the thread -- Virtualization Cloud Management Using Capacity Planning Cloud computing makes use of virtualization - but cloud computing also focuses on allowing computing to be delivered as a service. http://www.accelacomm.com/jaw/sfnl/114/51521223/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Generic thoughts about the Firebird network performance
On Sat, Mar 17, 2012 at 4:40 PM, Dmitry Yemanov firebi...@yandex.ru wrote: 17.03.2012 17:52, marius adrian popa wrote: Dmitry Yemanov wrote a series of articles related to Firebird network performance I suppose he would announce it himself if he would think it really belongs here ;-) Our lists are for development, not speculations. I have announced here for the comments, Maybe Adriano or others can share their comments about the core improvements :) Dmitry -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Lock manager memory 2 GB
On Fri, Mar 23, 2012 at 9:13 AM, Alex Peshkoff peshk...@mail.ru wrote: On 03/23/12 00:24, Nikolay Samofatov wrote: Hello, All! We completed (conditional) implementation of lock manager buffer 2 GB and put it into production. The production system tends to be 100% CPU bound now (as there is a few days back-log of work). All 24 cores are busy, 450 GB RAM utilized for one database. Roughly ~50% of CPU time is spent in Linux kernel Interesting, where is the time spent when changing rings is counted - user or kernel time? on average and lock manager mutex wait hovers around 40-50%. Afraid it's as expected for 24 cores system. Live kernel profiler output of loaded system is as follows (generated with OProfile): 7073900 3.6298 vmlinux vmlinux copy_user_generic_string 5554648 2.8502 vmlinux vmlinux __wake_up 4695015 2.4091 vmlinux vmlinux prepare_to_wait_exclusive 4670651 2.3966 vmlinux vmlinux futex_wait_setup 3988807 2.0468 vmlinux vmlinux futex_wake 2006843 1.0298 vmlinux vmlinux intel_idle 1321253 0.6780 vmlinux vmlinux schedule 1022927 0.5249 vmlinux vmlinux put_page 1001815 0.5141 vmlinux vmlinux finish_wait 735902 0.3776 vmlinux vmlinux try_to_wake_up 716559 0.3677 vmlinux vmlinux _atomic_dec_and_lock 674752 0.3462 vmlinux vmlinux get_page 646537 0.3318 vmlinux vmlinux tick_nohz_stop_sched_tick 628516 0.3225 vmlinux vmlinux task_rq_lock 594621 0.3051 vmlinux vmlinux update_curr 583779 0.2996 vmlinux vmlinux native_write_msr_safe 527673 0.2708 vmlinux vmlinux select_nohz_load_balancer 504132 0.2587 vmlinux vmlinux get_futex_key 460908 0.2365 vmlinux vmlinux __audit_syscall_exit 447328 0.2295 vmlinux vmlinux enqueue_hrtimer 443841 0.2277 vmlinux vmlinux __wake_up_bit 429380 0.2203 vmlinux vmlinux thread_return 401287 0.2059 vmlinux vmlinux __switch_to 397639 0.2040 vmlinux vmlinux update_cfs_shares 381845 0.1959 vmlinux vmlinux rb_get_reader_page 377837 0.1939 vmlinux vmlinux ktime_get 371547 0.1907 vmlinux vmlinux native_read_tsc 369331 0.1895 vmlinux vmlinux radix_tree_lookup_slot This demonstrates that to scale effectively past 24-40 cores per node, Firebird needs to implement shared buffer cache. Luckily it's implemented in trunk. And it's superserver - i.e. latches instead locks in lock manager. Lock manager mutex operations and copying from file system cache to userspace emerge as hard bottleneck. With lock manager change to 64-bit one 24 core node handles ~10 million user transactions daily. Is it going to reach 2**31 limit soon? 200 days if I'm not mistaken. reliably, at times having 1500 concurrent INSERT/UPDATE requests. Shall we merge lock manager changes? In trunk - definitely. What about 2.5 - not sure. May be having patch for high-end systems is better approach than commit in svn? Another option is On github you can fork the firebird 2.5 branch https://github.com/asfernandes/firebird/tree/B2_5_Release and keep the set of patches for high-end systems in your fork if you want -- This SF email is sponsosred by: Try Windows Azure free for 90 days Click Here http://p.sf.net/sfu/sfd2d-msazure Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Lock manager memory 2 GB
On Thu, Mar 22, 2012 at 10:24 PM, Nikolay Samofatov nikolay.samofa...@red-soft.biz wrote: Hello, All! We completed (conditional) implementation of lock manager buffer 2 GB and put it into production. The production system tends to be 100% CPU bound now (as there is a few days back-log of work). All 24 cores are busy, 450 GB RAM utilized for one database. Roughly ~50% of CPU time is spent in Linux kernel on average and lock manager mutex wait hovers around 40-50%. Live kernel profiler output of loaded system is as follows (generated with OProfile): 7073900 3.6298 vmlinux vmlinux copy_user_generic_string 5554648 2.8502 vmlinux vmlinux __wake_up 4695015 2.4091 vmlinux vmlinux prepare_to_wait_exclusive 4670651 2.3966 vmlinux vmlinux futex_wait_setup 3988807 2.0468 vmlinux vmlinux futex_wake 2006843 1.0298 vmlinux vmlinux intel_idle 1321253 0.6780 vmlinux vmlinux schedule 1022927 0.5249 vmlinux vmlinux put_page 1001815 0.5141 vmlinux vmlinux finish_wait 735902 0.3776 vmlinux vmlinux try_to_wake_up 716559 0.3677 vmlinux vmlinux _atomic_dec_and_lock 674752 0.3462 vmlinux vmlinux get_page 646537 0.3318 vmlinux vmlinux tick_nohz_stop_sched_tick 628516 0.3225 vmlinux vmlinux task_rq_lock 594621 0.3051 vmlinux vmlinux update_curr 583779 0.2996 vmlinux vmlinux native_write_msr_safe 527673 0.2708 vmlinux vmlinux select_nohz_load_balancer 504132 0.2587 vmlinux vmlinux get_futex_key 460908 0.2365 vmlinux vmlinux __audit_syscall_exit 447328 0.2295 vmlinux vmlinux enqueue_hrtimer 443841 0.2277 vmlinux vmlinux __wake_up_bit 429380 0.2203 vmlinux vmlinux thread_return 401287 0.2059 vmlinux vmlinux __switch_to 397639 0.2040 vmlinux vmlinux update_cfs_shares 381845 0.1959 vmlinux vmlinux rb_get_reader_page 377837 0.1939 vmlinux vmlinux ktime_get 371547 0.1907 vmlinux vmlinux native_read_tsc 369331 0.1895 vmlinux vmlinux radix_tree_lookup_slot This demonstrates that to scale effectively past 24-40 cores per node, Firebird needs to implement shared buffer cache. Lock manager mutex operations and copying from file system cache to userspace emerge as hard bottleneck. With lock manager change to 64-bit one 24 core node handles ~10 million user transactions daily. reliably, at times having 1500 concurrent INSERT/UPDATE requests. Shall we merge lock manager changes? Another thing to try is to use a kernel 3.2 if possible Some of the write locking and scalability issues were solved in kernel 3.2 http://news.ycombinator.com/item?id=3793973 http://www.reddit.com/r/Database/comments/rruh1/postgresql_did_i_say_32_cores_how_about_64/ -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Pipelining
On Fri, Apr 13, 2012 at 3:44 PM, Henri Gourvest hgourv...@gmail.com wrote: Le 12/04/2012 13:43, Alex Peshkoff a écrit : This will require serious redesign of network protocol. Certainly doable. Will require symmetric changes not only in client library, but in network server too. Must say that starting with 2.5 posix superclassic server and all arcs in 3.0 firebird architecture is very well adapted for such change - network server behaves like any other firebird client, calling same API as client tasks do. I.e. you can easily replace that part of SQL server even not recompiling the rest of DB engine. Thank you very much for this information, I hope it will be available in future versions of firebird. In Firebird 3.x you can write your own protocol , this is what i understand from the pluggable architecture http://www.slideshare.net/mindthebird/firebird-3-providerbased-architecture-plugins-and-oo-approach-to-api I'm thinking that you can write some kind of bson protocol http://www.mongodb.org/pages/viewpage.action?pageId=16646453 to your own plugin Client-bson/json/redis protocol- your own v8 node js plugin - firebird 3.x engine https://github.com/xdenser/node-firebird-libfbclient -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] interesting suse patches for gcc47 and firebird 2.1.x branch
I don't know if 2.1 is compiled with gcc 4.7 yet http://article.gmane.org/gmane.linux.suse.opensuse.scm/20834/ -- For Developers, A Lot Can Happen In A Second. Boundary is the first to Know...and Tell You. Monitor Your Applications in Ultra-Fine Resolution. Try it FREE! http://p.sf.net/sfu/Boundary-d2dvs2 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] doxygenated source code for firebird 2.5
It might be useful for people browsing studying firebird 2.5.x source code http://fossies.org/dox/Firebird-2.5.1.26351-0/dir_88a51956a2144fcc1c2646c7da10c1f4.html -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] extern/SfIO/include/stdio.h license problem - Email found in subject
On Wed, May 23, 2012 at 7:12 PM, Michal Kubecek m...@mk-sys.cz wrote: On Tue, May 22, 2012 at 05:24:27PM -0400, Leyne, Sean wrote: while reviewing Firebird 2.5 packages for OpenSuSE Factory, our legal team noticed that copyright notice on top of extern/SfIO/include/stdio.h claims that it contains certain software code or other information proprietary to ATT Corp. What is the problem with the FB packages having this file? I'm not sure it really is a problem but given the text on top of the file, I can't be sure it is OK either, especially when our legal team considers it to be bad enough to exclude it from OpenSuSE. This is why I wanted to discuss it in the list. (Yes, I too would prefer to live in a world where a developer doesn't need law school more then computer science.) The problem I see is that the source tarball contains a file claiming it contains a code proprietary to ATT and not referring to any license. For anyone who gets the tarball it means they don't now what they can or cannot do with it - and therefore with the source tree as a whole. There is no restriction on the distribution of the file. Which is not clear from the file itself. The page referenced in extern/SfIO/read.me indicates SfIO is distributed under EPL but 1. The version from the page is different so strictly speaking there is no source saying the file we include is covered by EPL as well. 2. Nowhere in the downloaded tarball any license is mentioned, only the comment about containing code proprietary to ATT is there 3. Actually, the page doesn't even say SfIO is distributed under EPL, it just requests you to confirm you agree with EPL to allow you to download it. This is quite unfortunate as e.g. the version embedded in ksh sources explicitly mentions EPL and refers to URL where it can be found (and there is no mention of proprietary code, just a simple copyright notice). In debian/ubuntu the files are removed https://launchpad.net/ubuntu/precise/+source/firebird2.5/+copyright * Removed sources with non-free/missing licensing The following files are removed as they contain only copyright information without any license allowing their distribution. Luckily, they are not needed when building on Debiian. - builds/install/arch-specific/solaris/ - src/install/arch-specific/solx86gcc/CS/postinstall.in - src/install/arch-specific/solx86gcc/CS/postremove.in - src/install/arch-specific/solx86gcc/CS/preinstall.in - src/msgs/templates.sql - extern/SfIO/ -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Jira
On Wed, Jun 27, 2012 at 7:35 PM, Leyne, Sean s...@broadviewsoftware.comwrote: Actually, I just opened the TIMESTAMP Keyword case with Atlassian IMHO, you did a little mistake in this ticket - you mentioned Firebird. If you simply had written what kind of idiot must be DB developer to choose reserved word as a field's name, they wouldn't have had chance to reject it this way. SL Actually, I suspect that their reply, in that case, would have been: What does it matter? This is not an issue for the database engines which we support. Please migrate to a supported engine. Maybe is time to evaluate redmine and to create a firebird driver for it http://www.redmine.org/boards/1/topics/18986?r=23588 Any sponsors ? :) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Trusted auth like on Linux/Mac
I wonder if the trusted auth should be enabled on linux too for embedded mode for example I didn't checked yet but the linux embedded library should use the current user if you open a database in the home folder and you provided no password As soon as I tested it on a Mac I discovered that I could not connect to the database: wrong username or password. It happens that it is possible to set up an embedded server under Linux and Mac, as I described in older posts, but these servers will still use security2.fdb to authenticate the user /home/mariuz/employee.fdb should be open under mariuz credentials (pam) for example with no need for a security database at all http://accountingplusplus.blogspot.fr/2012/06/firebird-connecting-to-embedded-server.html -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] (no subject)
On Thu, Jul 19, 2012 at 11:57 AM, J-L M so4h2...@hotmail.com wrote: Hello, We are trying to compile Firebird 2.1 for Android in order to use the embedded version in our mobile device of our software. But for the moment it seems impossible for some reasons : Android uses his own Libc called Bionic. And the problem is that there is a lot of missing features in. There is no implementation of the POSIX IPC or System V IPC inside, Android drop this to avoid denial-of-service. So, use of semaphore, shared memory, etc, is not possible. We have written a more complet document of this porterage which describes the problems in detail. please post it to google docs Somebody have already attempt to compile or to make an Android version of Firebird ? I see there is some work on the firebird 3.x branch What would be the good way to do that ? Otherwise, how to interest Firebird developpers to make this Android version ? (Maybe I can create a topic in the tracker ) Please use the list for conversations Thanks in advance. Jean-Louis Meuriot -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Building Firebird for Android
On Mon, Jul 23, 2012 at 11:21 AM, JLM so4h2...@hotmail.com wrote: On 23/07/2012 04:03, Adriano dos Santos Fernandes wrote: I tried it, with official NDK but got error compiling common/CharSet.cpp which needs ICU. So not even the client compiled. --- asfernandes:~/fb/dev/trunk.git$ echo $NDK /home/asfernandes/android/android-ndk-r8 asfernandes:~/fb/dev/trunk.git$ ./autogen.sh --with-cross-build=android.arme /home/asfernandes/android/android-ndk-r8/toolchains/arm-linux-androideabi-4.4.3/prebuilt/linux-x86/bin/arm-linux-androideabi-g++ -ggdb -DFB_SEND_FLAGS=MSG_NOSIGNAL -DLINUX -DANDROID -DARM -pipe -MMD -fPIC -fmessage-length=0 -I/home/asfernandes/fb/dev/trunk.git/extern/libtommath --sysroot=/home/asfernandes/android/android-ndk-r8/platforms/android-9/arch-arm -I/home/asfernandes/fb/dev/trunk.git/extern/icu/source/common -I/home/asfernandes/fb/dev/trunk.git/extern/icu/source/i18n -O3 -fno-omit-frame-pointer -I/home/asfernandes/fb/dev/trunk.git/src/include/gen -I/home/asfernandes/fb/dev/trunk.git/src/include -pthread -fno-rtti -c /home/asfernandes/fb/dev/trunk.git/src/common/CharSet.cpp -o /home/asfernandes/fb/dev/trunk.git/temp/Release/common/CharSet.o In file included from /home/asfernandes/fb/dev/trunk.git/extern/icu/source/common/unicode/utypes.h:36, from /home/asfernandes/fb/dev/trunk.git/extern/icu/source/common/unicode/ucnv.h:56, from /home/asfernandes/fb/dev/trunk.git/src/common/../jrd/../common/unicode_util.h:33, from /home/asfernandes/fb/dev/trunk.git/src/common/../jrd/intl_classes.h:35, from /home/asfernandes/fb/dev/trunk.git/src/common/CharSet.cpp:95: /home/asfernandes/fb/dev/trunk.git/extern/icu/source/common/unicode/umachine.h:52:33: error: unicode/platform.h: No such file or directory --- Since I tried to compile Firebird2.1, I add inch by inch libraries wich were missing in the NDK to compile. I take them from a debian ARM virtual machine. And I carry out the libfbclient.so successfully. Now, I will test this library. With Java, it's seems impossible because it can't communicate with Firebird for the moment. So I will try to use Qt Necessitas. Do you think Necessitas can runs with Firebird ? qt does have support for firebird , so if you compile the ibase driver it should in theory load the ibfbclient.so that you compiled and then comunicate with another server from internet (for example) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Design issue
This is not a bug in DBD::FIrebird, but a feature of the Firebird API. When fetching values after SELECT, the sqllen member of the SQLDA contains the maximum length in bytes. For CHAR(20) column, when using UTF8 connection charset, sqllen is 80, and there is no way for DBD::Firebird to determine that the column is really CHAR(20). My advise would be to use VARCHAR columns when the data is not guaranteed to fill the whole width. For VARCHAR the SQLDA contains the actual data length. My guess is that we need to close this bug https://rt.cpan.org/Ticket/Display.html?id=76506 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Can someone add info how to backtrace core-3740
http://tracker.firebirdsql.org/browse/CORE-3740 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Can someone add info how to backtrace core-3740
The question was when it will be increased the stack and if he can have a patch/build to try it http://firebird.1100200.n4.nabble.com/Firebird-bug-on-Mac-crashes-when-using-quot-IN-quot-lists-with-417-or-more-elements-td3001784.html On Wed, Aug 8, 2012 at 7:58 AM, marius adrian popa map...@gmail.com wrote: http://tracker.firebirdsql.org/browse/CORE-3740 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] FB/Java plugin is included in 3.0 ?
I have seen this firebird web bug related to the missing file for download http://tracker.firebirdsql.org/browse/WEB-66 http://web.firebirdsql.org/index.php?op=develsub=pluginsid=external_java It would be cool to be integrated and documentation updated -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Fwd: Re: [sqlalchemy] #2504: alternative driver for firebird
On Mon, Sep 24, 2012 at 11:07 AM, Treeve Jelbert tre...@scarlet.be wrote: ** help requested! some time ago I submitted a request to add fbd support to sqlalchemy That is now being implemented, but they have encountered a problem on OSX. I know nothing about OSX, but it looks as if that version misses an entrypoint, BLOB_open. I am not sure which version of Firebird they are using. seems to be fixed in 2.5.2 http://tracker.firebirdsql.org/browse/CORE-3911 -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] nanoseconds added to timestamp format
We have some issues in django driver and one test is failing with 6 digits microseconds http://tech.groups.yahoo.com/group/firebird-python/message/574 http://wiki.ispirer.com/sqlways/postgresql/data-types/timestamp I have opened on bug http://tracker.firebirdsql.org/browse/CORE-3939 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://ad.doubleclick.net/clk;258768047;13503038;j? http://info.appdynamics.com/FreeJavaPerformanceDownload.htmlFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Database dialect and BIGINT in metadata
On Wed, Oct 31, 2012 at 2:51 AM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: Hi! RDB$TRIGGERS.RDB$TRIGGER_TYPE was extended to BIGINT in v3, to support DDL triggers. It was difficult to found what was going wrong with CORE-3964, but then I found it. First, INI_init checks DBB_DB_SQL_dialect_3 which works on database creation, but on opening, it's set only in PAG_header (called after INI_init). But, anyway, I don't think treating a metadata field created with a type on a dialect is going to work after that dialect is changed and the type is interpreted as another one. Also, in no way that field could be interpreted as a double, as it has bits who changes (on conversion from/to SINT64) dues to double imprecision. I have no idea what to do (well, actually I have a very easy and good one, you know, it's to wipe dialect 1/2). I'd hate to split a single field in two to support something which should be removed +10 years ago. Dialect 1/2 logic was for supporting migration of interbase 5 to firebird 1.0 I hope that clients had the time to migrate -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Database dialect and BIGINT in metadata
On Wed, Oct 31, 2012 at 2:18 PM, Adriano dos Santos Fernandes adrian...@gmail.com wrote: On 31/10/2012 10:12, Mark Rotteveel wrote: Databases and applications still using dialect 1 should simply take the effort now to switch, or remain left behind on Firebird 2.5 max. It is the consequence of a decision to continue to use a legacy option. Continuing support for dialect 1 in Firebird and creating workarounds to that end just because we don't want to leave anyone behind is - IMHO - a waste of effort and time that the Firebird project could better spend on other things. I agree. I hate to need to adapt to new software versions, and some libraries I use requires a lot of changes as they evolve. But in many of Firebird tickets I have assigned to me, I just can't do anything. There is just no way to fix them without any form of incompatibility. I see that 3.0 is in feature freeze mode . maybe is time for 3.5 branch or the next-gen branch where you can solve some of the agresive changes and bugs -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Database dialect and BIGINT in metadata
On Wed, Oct 31, 2012 at 8:37 PM, Ann Harrison a...@qbeast.net wrote: Dmitry, Can we conclude that no client app existing these days should be able to deal with blr_quad / dtype_quad? Unless somebody is running a 20 year old app on a Vax ... This sounds as a good cleanup possibility. I guess. Since it wasn't used for the new 64 bit integers... And the quad is gone https://github.com/asfernandes/firebird/commit/eba82bb71e3fdafc7029eccd473dfe405526cb62 -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Database dialect and BIGINT in metadata
On Thu, Nov 1, 2012 at 3:03 PM, Carlos H. Cantu lis...@warmboot.com.br wrote: DY The proper solution is far not trivial to implement. Ok, but I understand that even not being trivial, it can be implemented :) DY An easier one will break existing applications as they will start DY calculating different numbers for the same queries. I think his is a relative point of view... I mean, people using numeric/decimal with dialect 3 is already using workarounds due to the currently existing problems/limitations (ie: using intermediate casts, etc). So, if the change would cause different results but with greater precision, I doubt anyone would get mad. Does any study was already made to check how different the results would become? A result of 1.04 becoming a more precise one (ie: 1.049) can be acceptable, while 1.04 becoming 1.10 may not. Of course, any change of this type would need to be very well documented and announced. Maybe is time for Dialect 4 with all the Dialect 3+1 fixes -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] To be removed in trunk
I have seen that old_prefixes in is not used anymore trunk/builds/old_prefixes/ http://firebird.svn.sourceforge.net/viewvc/firebird/firebird/trunk/builds/old_prefixes/ This is the old makefile area, left over from the InterBase unix build procedures. They have been replaced in src/make.new with an autoconfig version. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_sfd2d_oct Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] C api cleanup for api2.c
Thanks seems to compile now cc -Wall -L/usr/lib -lfbclient -I/usr/share/doc/firebird2.5-common-doc/examples/include/ api2.c ISC_USER=SYSDBA ISC_PASSWORD=masterkey ./a.out /var/lib/firebird/2.5/data/employee.fdb Dynamic SQL Error -SQL error code = -206 -Column unknown -BUDGET -Client SQL dialect 1 does not support reference to BIGINT datatype On Thu, Nov 8, 2012 at 8:11 AM, Alex Peshkoff peshk...@mail.ru wrote: On 11/08/12 00:01, marius adrian popa wrote: I try to compile the examples on debian testing on arm (raspberry) gcc -L/usr/lib -lfbclient -I/usr/share/doc/firebird2.5-common-doc/examples/include/ api2.c api2.c:38:5: error: conflicting types for ‘getline’ /usr/include/stdio.h:671:20: note: previous declaration of ‘getline’ was here api2.c:140:5: error: conflicting types for ‘getline’ /usr/include/stdio.h:671:20: note: previous declaration of ‘getline’ was here Thanks - fixed. (that samles were really written FAR before year 2008) -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] ODS changes for 2.5.2
There are other ODS changes in 2.5.1 vs 2.5.2? http://www.linkedin.com/groupItem?view=gid=1467097item=183106276type=membercommentID=103490293 At least what bugs were related to the changes -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Ubuntu builds
Damyan started to sync the package , there is a already in git , i wait the final build and it will be pushed to ppa after that for the supported ubuntu releases On Mon, Nov 12, 2012 at 6:31 PM, Alex Peshkoff peshk...@mail.ru wrote: On 11/12/12 20:13, Jorge Andrés Brugger wrote: El 12/11/2012 12:50 p.m., Mark Rotteveel escribió: On Mon, 12 Nov 2012 13:47:10 -0200, Pablo Sánchezpab...@adinet.com.uy wrote: Mark, maybe what Jorge is asking for, is to add to the tar.bz and rpm packages, a deb package on the firebirdsql site. But how would that be better, than simply getting it through apt-get as you do now? Mark Actually, there is rpm for 2.5.2 but there isn't deb for 2.5.2 final (and I´m grateful to Mariuz that he does what he does, but obviously the release cycle is not sync'ed) Supporting rpm is also not planned starting with FB3. The main reason is that rpm for (as an example) fedora core is not exactly same rpm as needed for (again example) suse. We obviously can't support rpms for all kinds of distro. And an attempt to have 'universal' package like now leads instead to 'hardly working' one. Suppose same issues are present in deb format too, therefore I do not like idea of adding debian package to SF releases. Writing good explanantion 'why' is certainly good thing. PS. A lot of projects provide themself nothing except src tarball. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Ubuntu builds
Here is the status for the next Debian stable Release 7.0 and unstable http://lists.alioth.debian.org/pipermail/pkg-firebird-general/2012q4/002315.html I will check how we can backport to ubuntu official repository for the LTS 12.04 and 12.10 https://wiki.ubuntu.com/StableReleaseUpdates ps: we wil have 2.5.2 in the ubuntu stable firebird ppa On Mon, Nov 12, 2012 at 7:49 PM, Jorge Andrés Brugger lis...@dasu.com.ar wrote: El 12/11/2012 02:04 p.m., Philippe Makowski escribió: Jorge Andrés Brugger [2012-11-12 17:11] : I know abot official repos, but if I go to http://www.firebirdsql.org/en/firebird-2-5-2/#Linux_AMD64 and if I'm a newcomer to Firebird, maybe I could think there is not a Debian/Ubuntu build ... (deb package) Shouldn't be at least an explanation at the download page? could be yes please fill a request in the tracker http://tracker.firebirdsql.org/browse/WEB Done: http://tracker.firebirdsql.org/browse/WEB-103 Thanks. -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Jorge Andrés Brugger Informática DASU - Obra Social del Personal de la Universidad Nacional de la Patagonia Comodoro Rivadavia, Chubut, Argentina Teléfono (0297) 446- int. 103 Correo electrónico: jbrug...@dasu.com.ar Website: www.dasu.com.ar -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3, time to rename conflict names ?
I agree with the longer names , is also better for readability and firebird manual seo On Fri, Nov 16, 2012 at 9:38 PM, Leyne, Sean s...@broadviewsoftware.com wrote: may be Firebird 3 is the good time frame to rename our binaries ? for example : fb_sql, fb_bak, fb_sec, fb_fix, fb_stat, fb_nbackup, fb_qli, fb_pre, fb_split, fb_qli I would suggest: fb_backup, fb_security, fb_fixup, fb_stats and fb_precompile I realize that the names are longer than the original, but they are much more meaningful (long gone are the days of 8.3 filenames). To mitigate the new names, perhaps we can problem soft-links/shortcuts for the original names. Sean -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3, time to rename conflict names ?
I agree on ubuntu i have isql-fb and is a lot faster to type than isql_fb On Sat, Nov 17, 2012 at 8:58 AM, Roman Simakov roman.sima...@gmail.com wrote: I like long names and do not like underlines. It's more faster to type a name without underline. 2012/11/17 Doug Chamberlin chamberlin.d...@gmail.com: Why not use underlines? On 11/16/12 6:34 PM, Adriano dos Santos Fernandes wrote: Why do use underlines when fb alone is a good prefix (that don't mess with the next word)? -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Roman Simakov -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3, time to rename conflict names ?
Redirects and FAQs can be refreshed , Memory can be refreshed Documentation can be updated , we can't live in the ib 1.0 - 4.0 era forever symlinks can be created at install times for oldtimers Times changed from the Vax years and people request up to date documentation and majority use a gui usually flamerobin , ibexpert ... even the core devels On Sat, Nov 17, 2012 at 10:37 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On 16-11-2012 20:23, Philippe Makowski wrote: Hi all, we have some binaries that have conflict name with other products : isql (UNIX-ODBC) and gstat (Ganglia) may be Firebird 3 is the good time frame to rename our binaries ? for example : fb_sql, fb_bak, fb_sec, fb_fix, fb_stat, fb_nbackup, fb_qli, fb_pre, fb_split, fb_qli On of the downsides of doing this is of course that all existing documentation, FAQs, webpages with info, and 30 years of knowledge on Firebird maintenance becomes instantly obsolete (or at least a bit stale). Mark -- Mark Rotteveel -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Fwd: SourceForge Repo Clone Complete
Maybe is time to migrate to git :) postgresql is on git now http://wiki.postgresql.org/wiki/Working_with_Git On Mon, Dec 17, 2012 at 11:21 AM, Jiri Cincura disk...@cincura.net wrote: Question maybe unrelated, maybe not. But why we are even using SVN from SF? We have enough HW (and let's face it, SVN doesn't need huge box) and we can run it ourselves. I do it, it's close to nothing administration. Then we can have whatever we want and maybe more. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- LogMeIn Rescue: Anywhere, Anytime Remote support for IT. Free Trial Remotely access PCs and mobile devices and provide instant support Improve your efficiency, and focus on delivering more value-add services Discover what IT Professionals Know. Rescue delivers http://p.sf.net/sfu/logmein_12329d2d Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird SQL's backup/restore uses magic words for stdin and stdout
I will post more info from now on , i guess i'm used to the short messages on twitter On Fri, Jan 11, 2013 at 10:18 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On Fri, 11 Jan 2013 10:01:40 +0200, marius adrian popa map...@gmail.com wrote: http://blog.unixwiz.net/2013/01/unhappy-surprise-firebird-sqls-backuprestore-uses-magic-words-for-stdin-and-stdout.html Why are you just posting URLs? I find it slightly confusing and mildly annoying to get a message with just an URL in it and no further information, especially as that is also the way some spam messages work. Could you please include some additional info when sending these kinds of things to the lists? Mark -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Master HTML5, CSS3, ASP.NET, MVC, AJAX, Knockout.js, Web API and much more. Get web development skills now with LearnDevNow - 350+ hours of step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122812 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird and Qt
I will check the driver i think is better if we contribute to the qt 5 tree also now you can send them patches directly to the gerrit There are articles about firebird embedded and qt but i guess you ask if we can put an firebird embedded plugin in the qt 5 tree right ? ps: some people used ibpp with qt but seems that fedora found it with some legal restrictions but if you agree with the lincense and want to bundle ibpp with your app then that is great https://sourceforge.net/mailarchive/message.php?msg_id=29716631 from what i understand you can't make a separate ibpp lib for you app and put in the fedora repository you can bundle like in flamerobin case On Sun, Feb 10, 2013 at 5:06 PM, christian.waldm...@rte-ag.ch wrote: Hello Firebird team I am using Firebird since many years, and since some time also in combination with the Qt Framework. Today I have encountered, that the QIBASE driver has only a minimalistic implementation. Has someone tried to upgrade/rework the QIBASE driver to support the Firebird 2.5 functions? The QIBASE plug in QT 4 uses the isc_ functions to access the fbclient. Is this still the suggested way? A stand alone implementation of Firebird embedded in the Qt development environment could boost the Firebird user base. Has someone already tried to do this? Happy greetings Chris -- Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Free Next-Gen Firewall Hardware Offer Buy your Sophos next-gen firewall before the end March 2013 and get the hardware for free! Learn more. http://p.sf.net/sfu/sophos-d2d-feb Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Google Summer of Code 2013
Are there some tasks in or around Firebird that could be submitted? I believe there are many students out there who would love to join in the DBMS project and learn about DB internals. http://www.google-melange.com/gsoc/homepage/google/gsoc2013 Some of the ideas : Port Firebird to IOS Port Firebird to Android Cleanup warnings from Clang build Push ActiveRecord Firebird Adapter to Rails master git repository (test with 4.0) Push Django Firebird Adapter to Django master git repository -- The Go Parallel Website, sponsored by Intel - in partnership with Geeknet, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials, tech docs, whitepapers, evaluation guides, and opinion stories. Check out the most recent posts - join the conversation now. http://goparallel.sourceforge.net/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Firebird 3 api c++ examples
can it be merged in the trunk https://github.com/asfernandes/fbstuff Also some examples and docs would be great ps: one more question when there will be a Release Tag for 3.0 alpha1 ? -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_feb Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] autoconf/automake/libtool warnings
rename is done , please test for any breakings On Mon, Mar 11, 2013 at 12:49 PM, Treeve Jelbert tre...@scarlet.be wrote: recent version of autoconf/automake/libtool complain about the firebird scripts aclocal: warning: autoconf input should be named 'configure.ac', not 'configure.in' libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR, `builds/make.new/config'. libtoolize: linking file `builds/make.new/config/ltmain.sh' libtoolize: putting macros in AC_CONFIG_MACRO_DIR, `m4'. libtoolize: linking file `m4/libtool.m4' libtoolize: linking file `m4/ltoptions.m4' libtoolize: linking file `m4/ltsugar.m4' libtoolize: linking file `m4/ltversion.m4' libtoolize: linking file `m4/lt~obsolete.m4' libtoolize: Consider adding `-I m4' to ACLOCAL_AMFLAGS in Makefile.am. -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Everyone hates slow websites. So do we. Make your web apps faster with AppDynamics Download AppDynamics Lite for free today: http://p.sf.net/sfu/appdyn_d2d_mar Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] aliases.conf - databases.conf rename
Question from twitter https://twitter.com/shtue/status/321510432458289152 What’s the point of the rename? It seems to only break existing code and documentation. -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Is Firebird 3 ready?
This kind of discussioons should be done on Firebird arhitect also if you can create a RFC in wiki or google docs it would be great http://tech.dir.groups.yahoo.com/group/Firebird-Architect/ On Wed, Apr 10, 2013 at 2:30 AM, Tom Coleman tcole...@autowares.com wrote: How about some discussion about strategic features - like the lack of straight-forward support for clustering? On Apr 6, 2013, at 6:22 AM, Dmitry Yemanov wrote: 06.04.2013 13:32, supp...@ibknowledgebase.com wrote: I see that core developers started to discuss ruche features - hidden fields, readable db_key. Discussion is far from implementation. These threads are collecting opinions, nothing more. -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Precog is a next-generation analytics platform capable of advanced analytics on semi-structured data. The platform includes APIs for building apps and a phenomenal toolset for data science. Developers can use our toolset for easy data analysis visualization. Get a free account! http://www2.precog.com/precogplatform/slashdotnewsletter Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Buildling Firebird 2.1.5 with clang++ and libc++ on MacOSX
I compile with clang++ and indeed there are many warning in 2.5/3.0 export CXX=clang++ ./autogen.sh I propose to solve them in 3.0 trunk branch , so we don't introduce any new bugs in the stable 2.5 branch So if you have patches please send them to this list with current clang on debian jessie i have this error In file included from src/jrd/../jrd/Function.h:28: src/jrd/../dsql/Nodes.h:508:23: error: use 'template' keyword to treat 'as' as a dependent template name return node ? node-asT() : NULL; ^ template On Thu, Jun 20, 2013 at 9:26 AM, Alex Peshkoff peshk...@mail.ru wrote: On 06/19/13 20:40, Lee Graber wrote: I am hoping I got the correct discussion alias. I am trying to figure out if I am going down a hole that I will not be happy with. My team uses Firebird's embedded engine for a couple of things and we are currently on the 2.1.x line. We are attempting to build embedded for Mac OSX using clang++ and libc++ but as I have started this I am finding myself fixing a lot of syntactical errors. There are lots of issues from c++11-narrowing checks among others. I can see on some threads that there are developers building using clang but from what I can glean that must only be happening on the 3.0 branch (I tried 2.5.x and it also had issues building so I stuck with 2.1.x to try and fix things since we are not looking to bump versions right now). If 3.0 is building with clang++ and libc++ in 3.0 branch, then someone must have done some work. As far as I know people used to build at least 2.5 using clang but it was more than a year ago. And you know that sometimes warnings in compilers tend to become errors in next versions. Therefore 2.5 can be not buildable with fresh clang. What about 3.0 - may be it was also tried with clang that time, but there were so many changes since that time... We use VC on windows and gcc on other systems (there are 2.5 ports to native compilers for most of widely used unixes). But what about Mac - we always used gcc. Does anyone know if this is an achievable goal by just fixing the missing casts, template compilation issues, string concat issues, ... Definitely yes, but 2.1 is bad choice. That code is about 6 years old (when branch was created) and therefore has more suspicious places than fresher versions. The rest of our product is built using clang and libc++ and we want this embedded component to be built with the same tools. I also have not been able to locate the 3.0 code base (if that is even something that is public domain) Certainly - license remains the same. svn checkout svn://svn.code.sf.net/p/firebird/code/firebird/trunk as I was going to compare my changes to those in 3.0 (if the files still exist) just to sanity check my changes. Such comparison is far not simple. Code was reworked in a lot of places. Alex. -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Buildling Firebird 2.1.5 with clang++ and libc++ on MacOSX
I have eliminated the error: use 'template' keyword to treat 'as' as a dependent template name using this solution http://stackoverflow.com/a/3786481/66242 g++ compilation went ok no crashes for database creation clang++ compilation went ok but with one crash in help db restoring (I will retest) On Thu, Jun 20, 2013 at 9:58 AM, marius adrian popa map...@gmail.com wrote: I compile with clang++ and indeed there are many warning in 2.5/3.0 export CXX=clang++ ./autogen.sh I propose to solve them in 3.0 trunk branch , so we don't introduce any new bugs in the stable 2.5 branch So if you have patches please send them to this list with current clang on debian jessie i have this error In file included from src/jrd/../jrd/Function.h:28: src/jrd/../dsql/Nodes.h:508:23: error: use 'template' keyword to treat 'as' as a dependent template name return node ? node-asT() : NULL; ^ template On Thu, Jun 20, 2013 at 9:26 AM, Alex Peshkoff peshk...@mail.ru wrote: On 06/19/13 20:40, Lee Graber wrote: I am hoping I got the correct discussion alias. I am trying to figure out if I am going down a hole that I will not be happy with. My team uses Firebird's embedded engine for a couple of things and we are currently on the 2.1.x line. We are attempting to build embedded for Mac OSX using clang++ and libc++ but as I have started this I am finding myself fixing a lot of syntactical errors. There are lots of issues from c++11-narrowing checks among others. I can see on some threads that there are developers building using clang but from what I can glean that must only be happening on the 3.0 branch (I tried 2.5.x and it also had issues building so I stuck with 2.1.x to try and fix things since we are not looking to bump versions right now). If 3.0 is building with clang++ and libc++ in 3.0 branch, then someone must have done some work. As far as I know people used to build at least 2.5 using clang but it was more than a year ago. And you know that sometimes warnings in compilers tend to become errors in next versions. Therefore 2.5 can be not buildable with fresh clang. What about 3.0 - may be it was also tried with clang that time, but there were so many changes since that time... We use VC on windows and gcc on other systems (there are 2.5 ports to native compilers for most of widely used unixes). But what about Mac - we always used gcc. Does anyone know if this is an achievable goal by just fixing the missing casts, template compilation issues, string concat issues, ... Definitely yes, but 2.1 is bad choice. That code is about 6 years old (when branch was created) and therefore has more suspicious places than fresher versions. The rest of our product is built using clang and libc++ and we want this embedded component to be built with the same tools. I also have not been able to locate the 3.0 code base (if that is even something that is public domain) Certainly - license remains the same. svn checkout svn://svn.code.sf.net/p/firebird/code/firebird/trunk as I was going to compare my changes to those in 3.0 (if the files still exist) just to sanity check my changes. Such comparison is far not simple. Code was reworked in a lot of places. Alex. -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbintl.conf
I think that was solved already in svn right ? http://sourceforge.net/p/firebird/code/57236/ and the related bug https://bugzilla.redhat.com/show_bug.cgi?id=905069 also the intl configure paths on freebsd changed in march from exec dir to confdir --with-fbintl=${CONFDIR}/intl \ that might be an issue http://svnweb.freebsd.org/ports/head/databases/firebird25-server/Makefile?revision=315591view=markup I would try a clean compile install from the 2.5 svn release branch On Sat, Jun 29, 2013 at 3:32 PM, Leonardo M. Ramé martinr...@yahoo.com wrote: From: philippe makowski pmakow...@ibphoenix.fr To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Saturday, June 29, 2013 4:50 AM Subject: Re: [Firebird-devel] fbintl.conf Leonardo M. Ramé [2013-06-28 20:57] : Thanks Adriano, but, where should the file be copied. And, is there a .log that I can look for some errors related to this file?. under Fedora I simply have : ls -la /usr/lib64/firebird/intl/ total 872 drwxr-xr-x. 2 root root 4096 23 mars 10:21 . drwxr-xr-x. 6 root root 4096 10 mars 19:59 .. -rwxr-xr-x. 1 root root 880864 10 mars 19:59 fbintl lrwxrwxrwx. 1 root root 25 23 mars 10:21 fbintl.conf - /etc/firebird/fbintl.conf and it is ok then Thanks Philippe, I've tried that also. It seems to be some incompatibility with libicu 50, that my FreeBsd 9.1 is using. -- Leonardo M. Ramé http://leonardorame.blogspot.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbintl.conf
Also i saw that there are issues with libfbtrace.so loading Trace plugin libfbtrace.so returned error on call trace_create. Error details: cannot initialize UNICODE collation to use in trace plugin http://www.freebsd.org/cgi/query-pr.cgi?pr=175485#reply1 On Sun, Jun 30, 2013 at 2:09 PM, marius adrian popa map...@gmail.com wrote: I think that was solved already in svn right ? http://sourceforge.net/p/firebird/code/57236/ and the related bug https://bugzilla.redhat.com/show_bug.cgi?id=905069 also the intl configure paths on freebsd changed in march from exec dir to confdir --with-fbintl=${CONFDIR}/intl \ that might be an issue http://svnweb.freebsd.org/ports/head/databases/firebird25-server/Makefile?revision=315591view=markup I would try a clean compile install from the 2.5 svn release branch On Sat, Jun 29, 2013 at 3:32 PM, Leonardo M. Ramé martinr...@yahoo.com wrote: From: philippe makowski pmakow...@ibphoenix.fr To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Saturday, June 29, 2013 4:50 AM Subject: Re: [Firebird-devel] fbintl.conf Leonardo M. Ramé [2013-06-28 20:57] : Thanks Adriano, but, where should the file be copied. And, is there a .log that I can look for some errors related to this file?. under Fedora I simply have : ls -la /usr/lib64/firebird/intl/ total 872 drwxr-xr-x. 2 root root 4096 23 mars 10:21 . drwxr-xr-x. 6 root root 4096 10 mars 19:59 .. -rwxr-xr-x. 1 root root 880864 10 mars 19:59 fbintl lrwxrwxrwx. 1 root root 25 23 mars 10:21 fbintl.conf - /etc/firebird/fbintl.conf and it is ok then Thanks Philippe, I've tried that also. It seems to be some incompatibility with libicu 50, that my FreeBsd 9.1 is using. -- Leonardo M. Ramé http://leonardorame.blogspot.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbintl.conf
confirmed the ICU_NEW_VERSION_MEANING patch http://sourceforge.net/p/firebird/code/57236/ is not included in the last official tar.bz2 for 2.5.2 (grep -R ICU_NEW_VERSION_MEANING *) http://sourceforge.net/projects/firebird/files/firebird/2.5.2-Release/Firebird-2.5.2.26540-0.tar.bz2/download so this is the issue On Sun, Jun 30, 2013 at 5:24 PM, Leonardo M. Ramé martinr...@yahoo.com wrote: - Original Message - From: marius adrian popa map...@gmail.com To: Leonardo M. Ramé martinr...@yahoo.com; For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Cc: Sent: Sunday, June 30, 2013 8:09 AM Subject: Re: [Firebird-devel] fbintl.conf I think that was solved already in svn right ? http://sourceforge.net/p/firebird/code/57236/ and the related bug https://bugzilla.redhat.com/show_bug.cgi?id=905069 also the intl configure paths on freebsd changed in march from exec dir to confdir --with-fbintl=${CONFDIR}/intl \ that might be an issue http://svnweb.freebsd.org/ports/head/databases/firebird25-server/Makefile?revision=315591view=markup I would try a clean compile install from the 2.5 svn release branch On Sat, Jun 29, 2013 at 3:32 PM, Leonardo M. Ramé martinr...@yahoo.com wrote: From: philippe makowski pmakow...@ibphoenix.fr To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Sent: Saturday, June 29, 2013 4:50 AM Subject: Re: [Firebird-devel] fbintl.conf Leonardo M. Ramé [2013-06-28 20:57] : Thanks Adriano, but, where should the file be copied. And, is there a .log that I can look for some errors related to this file?. under Fedora I simply have : ls -la /usr/lib64/firebird/intl/ total 872 drwxr-xr-x. 2 root root 4096 23 mars 10:21 . drwxr-xr-x. 6 root root 4096 10 mars 19:59 .. -rwxr-xr-x. 1 root root 880864 10 mars 19:59 fbintl lrwxrwxrwx. 1 root root 25 23 mars 10:21 fbintl.conf - /etc/firebird/fbintl.conf and it is ok then Thanks Philippe, I've tried that also. It seems to be some incompatibility with libicu 50, that my FreeBsd 9.1 is using. -- I have exactly the same versions of:http://www.freebsd.org/cgi/query-pr.cgi?pr=175485#reply1 Leonardo M. Ramé http://leonardorame.blogspot.com -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] fbintl.conf
automake is installed ? On Sun, Jun 30, 2013 at 11:07 PM, Leonardo M. Ramé martinr...@yahoo.com wrote: - Original Message - From: Leonardo M. Ramé martinr...@yahoo.com To: For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Cc: Sent: Sunday, June 30, 2013 4:32 PM Subject: Re: [Firebird-devel] fbintl.conf - Original Message - From: Leonardo M. Ramé martinr...@yahoo.com To: marius adrian popa map...@gmail.com; For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Cc: Sent: Sunday, June 30, 2013 4:21 PM Subject: Re: [Firebird-devel] fbintl.conf - Original Message - From: marius adrian popa map...@gmail.com To: Leonardo M. Ramé martinr...@yahoo.com; For discussion among Firebird Developers firebird-devel@lists.sourceforge.net Cc: Sent: Sunday, June 30, 2013 2:33 PM Subject: Re: [Firebird-devel] fbintl.conf confirmed the ICU_NEW_VERSION_MEANING patch http://sourceforge.net/p/firebird/code/57236/ is not included in the last official tar.bz2 for 2.5.2 (grep -R ICU_NEW_VERSION_MEANING *) http://sourceforge.net/projects/firebird/files/firebird/2.5.2-Release/Firebird-2.5.2.26540-0.tar.bz2/download so this is the issue Great Marius, thank you. Now I think I should build it from svn. The problem is which one to compile. There are Tags, Branches and Trunk, I'll go for branches/B_2_5_Release. When trying to ./autogen.sh --with-system-icu --with-system-editline, I've got this: AUTORECONF=autoreconf Running autoreconf ... autoreconf-2.69: Entering directory `.' autoreconf-2.69: configure.in: not using Gettext autoreconf-2.69: running: aclocal -I . --force autoreconf-2.69: configure.in: tracing autoreconf-2.69: running: libtoolize --copy --force libtoolize: putting auxiliary files in AC_CONFIG_AUX_DIR, `builds/make.new/config'. libtoolize: copying file `builds/make.new/config/ltmain.sh' libtoolize: putting macros in AC_CONFIG_MACRO_DIR, `m4'. libtoolize: copying file `m4/libtool.m4' libtoolize: copying file `m4/ltoptions.m4' libtoolize: copying file `m4/ltsugar.m4' libtoolize: copying file `m4/ltversion.m4' libtoolize: copying file `m4/lt~obsolete.m4' libtoolize: Consider adding `-I m4' to ACLOCAL_AMFLAGS in Makefile.am. autoreconf-2.69: running: /usr/local/bin/autoconf-2.69 --force autoreconf-2.69: running: /usr/local/bin/autoheader-2.69 --force autoreconf-2.69: configure.in: not using Automake autoreconf-2.69: Leaving directory `.' cp: 1.11.1*/install-sh: No such file or directory cp: automake): No such file or directory cp: (GNU: No such file or directory cp: /usr/share/automake-automake: No such file or directory Can't continue. What should I do?. -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- This SF.net email is sponsored by Windows: Build for Windows Store. http://p.sf.net/sfu/windows-dev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] pkg-config and firebird
This was submitted to debian but i guess we need also for the generic packages for Linux firebird-dev: ships neither fb_config nor fbembed.pc http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=717098 -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Partial patch for C++11 compilation of the Firebird 2.5 code
http://cgit.freedesktop.org/libreoffice/core/commit/?id=9fe159ef7cb7cfe5c1c91a6fbf1aa02fe79fec69 -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] firebird driver merged into libreoffice core
Changes to libreoffice and firebird driver can be seen in the git log http://cgit.freedesktop.org/libreoffice/core/log/?ofs=50 -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] license for examples wrong links
some links are wrong in the headers of examples https://github.com/asfernandes/firebird/tree/master/examples/interfaces link should be http://www.ibphoenix.com/about/firebird/idpl one example does have an old license header Interbase 1.0 license https://github.com/asfernandes/firebird/blob/master/examples/interfaces/02.update.cpp -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Partial patch for C++11 compilation of the Firebird 2.5 code
i will check the warnings and patch them if they are not already in 2.5 branch also there is an interesting small issue on macosx http://cgit.freedesktop.org/libreoffice/core/commit/?id=9ae13870b7779daac1dea0dc50fe6418c80cc48f I check the libo firebird related driver changes this way http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=firebird but seems that last ones are related mostly to the wrapper and sdbc driver On Sat, Jul 20, 2013 at 11:38 AM, Mark Rotteveel m...@lawinegevaar.nl wrote: On 17-7-2013 13:49, marius adrian popa wrote: http://cgit.freedesktop.org/libreoffice/core/commit/?id=9fe159ef7cb7cfe5c1c91a6fbf1aa02fe79fec69 Is there anything being done to integrate things like this back? Mark -- Mark Rotteveel -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] pkg-config and firebird
fb_config is now shiped in debian packages http://anonscm.debian.org/gitweb/?p=pkg-firebird/2.5.git;a=commitdiff;h=3082683b8241dd303d11491602d9781a8c0ad7da On Wed, Jul 17, 2013 at 10:26 AM, Alex Peshkoff peshk...@mail.ru wrote: On 07/17/13 11:10, marius adrian popa wrote: This was submitted to debian but i guess we need also for the generic packages for Linux firebird-dev: ships neither fb_config nor fbembed.pc http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=717098 Our package does contain fb_config: fbs bin # ./fb_config Usage ./fb_config [Options] Where Options are: --cflags --libs --embedlibs --bindir --udfdir --sbindir --confdir --docdir --sampledir --sampledbdir --helpdir --intldir --miscdir --securedbdir --msgdir --logdir --glockdir --pluginsdir --version fbs bin # I.e. this is sooner of all debian-specific issue. -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] LibreOffice status update
Seems that LibreOffice + Firebird driver is progressing and now driver is using dialect 3 as default http://www.ahunt.org/2013/07/firebirds-dialects/ and Developer hit some blob issues http://thread.gmane.org/gmane.comp.documentfoundation.libreoffice.devel/52120 Firebird driver related git changelog http://cgit.freedesktop.org/libreoffice/core/log/?qt=grepq=firebird -- See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] RFC - FB 3.0 IPv6 support (rebased)
ipv6 support was merged in 3.0 ? On Fri, Sep 21, 2012 at 9:38 PM, Michal Kubecek m...@mk-sys.cz wrote: On Tue, Sep 04, 2012 at 04:32:48PM +0200, Michal Kubecek wrote: Attached is a patch series implementing IPv6 support for current HEAD. Rebased version of the patches to current HEAD (after recent changes to src/remote/inet.cpp). Michal Kubecek -- Got visibility? Most devs has no idea what their production app looks like. Find out how fast your code is with AppDynamics Lite. http://ad.doubleclick.net/clk;262219671;13503038;y? http://info.appdynamics.com/FreeJavaPerformanceDownload.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Get your SQL database under version control now! Version control is standard for application code, but databases havent caught up. So what steps can you take to put your SQL databases under version control? Why should you start doing it? Read more to find out. http://pubads.g.doubleclick.net/gampad/clk?id=49501711iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] libedit update for 2.5.x
libedit will be updated and patched for 2.5.x branch also ? I ask this because in debian libedit2 i s already updated and it would be nice if also in the 2.5.x branch would be done so http://packages.debian.org/sid/libedit2 -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] root runuser in fb3
Seems the right way , so less privileges = is better On Fri, Aug 30, 2013 at 2:46 PM, Alex Peshkoff peshk...@mail.ru wrote: Hello all! In posix builds since FB2.0 we use 'firebird' runuser as default, but support (at least on linux) scripts to switch between 'firebird' and 'root' runusers. It's clear that using root as runuser is potential security hole for any system. On the other hand no problems with running firebird server in non-root mode were found during that years. Therefore I suggest to drop support of switching firebird to 'root' runuser since FB3. (Certainly it does not prevent user to switch runuser to 'root' manually, but this is not our issue.) Any problems with this suggestion? A. -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] building fbclient for android arm
I have an error error: 'PTHREAD_PRIO_INHERIT' was not declared in this scope /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp: In constructor 'Firebird::SharedMemoryBase::SharedMemoryBase(const TEXT*, ULONG, Firebird::IpcObject*)': /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp:1989:61: error: 'PTHREAD_PRIO_INHERIT' was not declared in this scope /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp:1989:81: error: 'pthread_mutexattr_setprotocol' was not declared in this scope -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] building fbclient for android arm
Thanks all worked with export NDK=/home/mariuz/android-ndk-r9 ./configure --with-system-editline --enable-binreloc --with-cross-build=android.arme On Thu, Sep 26, 2013 at 11:07 AM, Alex Peshkoff peshk...@mail.ru wrote: On 09/25/13 19:42, marius adrian popa wrote: I have an error error: 'PTHREAD_PRIO_INHERIT' was not declared in this scope /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp: In constructor 'Firebird::SharedMemoryBase::SharedMemoryBase(const TEXT*, ULONG, Firebird::IpcObject*)': /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp:1989:61: error: 'PTHREAD_PRIO_INHERIT' was not declared in this scope /home/mariuz/work/firebird-trunk/src/common/isc_sync.cpp:1989:81: error: 'pthread_mutexattr_setprotocol' was not declared in this scope Try with current trunk. But must say that isc_sync.cpp requires serious rework to make engine run on Android. -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] --with-system-icu is gone in trunk ?
when i try to compile from trunk i get this error WARNING: unrecognized options:--with-system-icu -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60133471iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] linux build requirements
You can check the Firebird spec files that is used for Fedora and epel versions http://pkgs.fedoraproject.org/cgit/firebird.git/tree/firebird.spec Watch for BuildRequires lines On Thu, Oct 3, 2013 at 6:15 PM, Nick Upson n...@telensa.com wrote: Hi, I need to build a customized version of 2.1.5 in order to restrict the possible ports used by events as our system now has a requirement to have the db on one server and the software on another with a firewall in the middle. I'm trying to build on centos 5.9, where it all runs fine but I haven't tried to build this before. Is there somewhere that gives all the required packages to do a sucessfull build? so far I've got autoconf but I'm sure there are more. -- Nick Upson, Telensa Ltd -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60134791iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Compatibility FB3.0 boolean and Interbase
Short answer no . Well this is a Interbase Express issue (ibx supports officialy only interbase) and i think emabarcadero is recommending FireDac these days (supports also Firebird) to access other databases For alternatives try IBObjects If you have the source for ibx you can also define the new type On Tue, Nov 12, 2013 at 11:54 AM, liviuslivius liviusliv...@poczta.onet.pl wrote: Hi, I know that Firebird go in self direcrion and Interbase is only start point for it but i need to know if is possible to have compatibile descriptor (field type) of Firebird Boolean data type as is in Interbase? Now we got Unknown SQL data type (32764) in IBX when we use FB3.0 database for boolean fields regards, Karol Bieniaszewski -- November Webinars for C, C++, Fortran Developers Accelerate application performance with scalable programming models. Explore techniques for threading, error checking, porting, and tuning. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60136231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- November Webinars for C, C++, Fortran Developers Accelerate application performance with scalable programming models. Explore techniques for threading, error checking, porting, and tuning. Get the most from the latest Intel processors and coprocessors. See abstracts and register http://pubads.g.doubleclick.net/gampad/clk?id=60136231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Which are the requeriments for to be a Firebird's core developer?
I guess you can start with first task compiling and onother task would be document new firebird 3 api with examples https://github.com/asfernandes/fbstuff/commits/master If i had time i would create new firebird 3 c++ examples from old c based api https://github.com/asfernandes/firebird/tree/master/examples/interfaces To understand the firebird 3 architecture there are a few presentations from previous conferences http://www.slideshare.net/mindthebird/firebird-3-providerbased-architecture-plugins-and-oo-approach-to-api On Wed, Dec 4, 2013 at 5:24 AM, W O sistemas2000profesio...@gmail.com wrote: Hello everybody. Since some months ago I read each post in this list. I'm fluent with C++ which I use since the year 1991 with Borland C++ 3.0, before that I used to use the C language. And I want to collaborate with the development of Firebird so new or improved features can be made faster. Which are the requeriments and steps to follow? (if such thing is possible, of course). Greetings. Walter. -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Which are the requeriments for to be a Firebird's core developer?
For building and contributing there is a Geting Involved page http://www.firebirdsql.org/en/building-the-code/ Conceptual papers that is worth to read http://www.ibphoenix.com/resources/documents/design also for Conceptual Architecture for Firebird I have updated the html paper to firebird 2.5 and added some links https://gitorious.org/conceptual-architecture-for-firebird-paper There is more on the firebird channel on youtube http://www.youtube.com/user/SQLFirebird or various Firebird conference papers On Wed, Dec 4, 2013 at 11:15 AM, marius adrian popa map...@gmail.com wrote: I guess you can start with first task compiling and onother task would be document new firebird 3 api with examples https://github.com/asfernandes/fbstuff/commits/master If i had time i would create new firebird 3 c++ examples from old c based api https://github.com/asfernandes/firebird/tree/master/examples/interfaces To understand the firebird 3 architecture there are a few presentations from previous conferences http://www.slideshare.net/mindthebird/firebird-3-providerbased-architecture-plugins-and-oo-approach-to-api On Wed, Dec 4, 2013 at 5:24 AM, W O sistemas2000profesio...@gmail.com wrote: Hello everybody. Since some months ago I read each post in this list. I'm fluent with C++ which I use since the year 1991 with Borland C++ 3.0, before that I used to use the C language. And I want to collaborate with the development of Firebird so new or improved features can be made faster. Which are the requeriments and steps to follow? (if such thing is possible, of course). Greetings. Walter. -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] firebird fails to build if -Werror=format-security flag is used.
could you apply the debian patch for 2.5 branch ? On Thu, Dec 5, 2013 at 10:20 AM, Alex Peshkoff peshk...@mail.ru wrote: On 12/05/13 00:25, Damyan Ivanov wrote: -=| Philippe Makowski, 04.12.2013 19:32:30 +0100 |=- From Fedora : https://bugzilla.redhat.com/show_bug.cgi?id=1037062 In fact is is true, Mageia use -Werror=format-security since a long time and to build Firebird package for Mageia I had to disable this (by chance I can using %define Werror_cflags %{nil} in the rpm spec file) but it is bad from the distro point of view. and now the same problem arise for Fedora Any volunteer to work on a patch ? Already done. See http://patch-tracker.debian.org/patch/series/view/firebird2.5/2.5.2.26540.ds4-8/out/hardening.patch In trunk we currently have no format-security warning. -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Sponsored by Intel(R) XDK Develop, test and display web and hybrid apps with a single code base. Download it for free now! http://pubads.g.doubleclick.net/gampad/clk?id=111408631iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] A PostgreSQL foreign data wrapper (FDW) for Firebird
This is an experimental foreign data wrapper (FDW) to connect PostgreSQL to Firebird. http://sql-info.de/postgresql/notes/firebird-foreign-data-wrapper-fdw.html -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Firebird Interbase Database engine hacks or rtfm
Notes on database security assesment http://www.slideshare.net/qqlan/firebird-interbase-database-engine-hacks-or-rtfm -- Rapidly troubleshoot problems before they affect your business. Most IT organizations don't have a clear picture of how application performance affects their revenue. With AppDynamics, you get 100% visibility into your Java,.NET, PHP application. Start your 15-day FREE TRIAL of AppDynamics Pro! http://pubads.g.doubleclick.net/gampad/clk?id=84349831iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
The related bug https://bugs.freedesktop.org/show_bug.cgi?id=72987 and in Embeeded there is need for security2.fdb for backup api ? (discussion at the end the bug) -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird db integration big-endian LibreOffice unable to open little-endian embedded firebird db
The related chage Use firebird backup format for .odb https://gerrit.libreoffice.org/gitweb?p=core.git;a=commitdiff;h=2540c23314d12b94c9ecb9e278969652bfb56c81 On Thu, Jan 9, 2014 at 11:23 AM, marius adrian popa map...@gmail.com wrote: The related bug https://bugs.freedesktop.org/show_bug.cgi?id=72987 and in Embeeded there is need for security2.fdb for backup api ? (discussion at the end the bug) -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] BuildRequires: libstdc++-static on epel7
I observed that libstdc++-static is required in epel7 firebird build Maybe is a good idea to enable g++ -static-libstdc++ for the tar.gz installers for firebird (so it will use the static libstdc++ instead of a shared library) http://pkgs.fedoraproject.org/cgit/firebird.git/tree/firebird.spec?h=epel7 -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] BuildRequires: libstdc++-static on epel7
Ok i understand so static libstdc++.so.6 is not needed anymore On Thu, Jan 23, 2014 at 11:17 AM, Alex Peshkoff peshk...@mail.ru wrote: On 01/23/14 13:06, marius adrian popa wrote: For example ldd for fbserver in tar.gz opt firebird bin $ ldd ./fbserver ... libstdc++.so.6 = /usr/lib/x86_64-linux-gnu/libstdc++.so.6 (0x7f0e4bf08000) This is dynamic library. And yes, all our binaries except libfbclient are using dynamic c++ support. libfbclient is a historical exception. When linux was changing from libstdc++.so.5 to libstdc++.so.6 it was very hard to provide single client library working in all distros - some requied .5, other .6. Therefore as a compromise static c++ support was used. In FB3 libfbclient is using dynamic c++ cause it's not standalone library any more - it's loading various plugins, and keeping static c++ support in it makes absolutely no sense any more. -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] LibreOffice 4.2 released with New Preview Feature : Firebird SQL backend
New feature preview feature in LibreOffice 4.2 : Firebird SQL connector for LibreOffice Base (Andrzej Hunt). When creating a new Database, select Firebird Embedded in the drop down menu (you have to first enable the Experimental features in Tools ▸Options ▸ LibreOffice ▸ Advanced). This allows creation of databases that performmany times faster than the previous built-in HSQLDB 1.8, avoiding the C++-to-Java overhead inherent in using HSQLDB. We plan to phase HSQLDB out over the next few releases, and provide a smooth migration path to Firebird. https://www.libreoffice.org/download/4-2-new-features-and-fixes/ -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available for testing
No builds for macosx ? On Sat, Feb 1, 2014 at 10:55 AM, Dmitry Yemanov firebi...@yandex.ru wrote: Firebird Project announces the second Alpha release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker. Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release. Please read the Release Notes carefully before installing and testing this Alpha release. Download page: http://www.firebirdsql.org/en/firebird-3-0-0-alpha2/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Alpha2-ReleaseNotes.pdf -- Dmitry Yemanov -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available for testing
With fresh Firebird 3.0 install i have with flamerobin (even if i enable legacy auth and flamerobin is loading the new fbclient) Context: Database::Connect Message: isc_attach_database failed SQL Message : -923 Connection not established Engine Code: 335544421 Engine Message : connection rejected by remote interface On Sat, Feb 1, 2014 at 10:55 AM, Dmitry Yemanov firebi...@yandex.ru wrote: Firebird Project announces the second Alpha release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker. Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release. Please read the Release Notes carefully before installing and testing this Alpha release. Download page: http://www.firebirdsql.org/en/firebird-3-0-0-alpha2/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Alpha2-ReleaseNotes.pdf -- Dmitry Yemanov -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available for testing
This is on Ubuntu 13.10 and x64 On Mon, Feb 3, 2014 at 7:21 PM, marius adrian popa map...@gmail.com wrote: With fresh Firebird 3.0 install i have with flamerobin (even if i enable legacy auth and flamerobin is loading the new fbclient) Context: Database::Connect Message: isc_attach_database failed SQL Message : -923 Connection not established Engine Code: 335544421 Engine Message : connection rejected by remote interface On Sat, Feb 1, 2014 at 10:55 AM, Dmitry Yemanov firebi...@yandex.ru wrote: Firebird Project announces the second Alpha release of Firebird 3.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker. Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release. Please read the Release Notes carefully before installing and testing this Alpha release. Download page: http://www.firebirdsql.org/en/firebird-3-0-0-alpha2/ Release Notes: http://web.firebirdsql.org/download/prerelease/rlsnotes/Firebird-3.0.0_Alpha2-ReleaseNotes.pdf -- Dmitry Yemanov -- WatchGuard Dimension instantly turns raw network data into actionable security intelligence. It gives you real-time visual feedback on key security issues and trends. Skip the complicated setup - simply import a virtual appliance and go from zero to informed in seconds. http://pubads.g.doubleclick.net/gampad/clk?id=123612991iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 3.0 Alpha 2 release is available for testing
sorry seems that was loading the old fbclient from /usr/lib/x86_64-linux-gnu/ ldd /opt/flamerobin/bin/flamerobin | grep libfb libfbclient.so.2 = /usr/lib/x86_64-linux-gnu/libfbclient.so.2 (0x7f1e8dfec000) cat /etc/ld.so.conf.d/x86_64-linux-gnu.conf /lib/x86_64-linux-gnu /usr/lib/x86_64-linux-gnu now is fixed and is loading the lib from /opt/firebird (symlinked) ldd /opt/flamerobin/bin/flamerobin | grep libfb libfbclient.so.2 = /usr/lib/libfbclient.so.2 (0x7fdba0a4e000) ls -lah /usr/lib/libfbclient.so.2 lrwxrwxrwx 1 root root 32 Feb 3 19:09 /usr/lib/libfbclient.so.2 - /opt/firebird/lib/libfbclient.so Now i get another issue seems that fb 3.0 can't open old on-disk structure from 2.5.x Engine Code: 335544379 Engine Message : unsupported on-disk structure for file /var/lib/firebird/2.5/data/django_postman.fdb; found 11.2, support 12.0 On Mon, Feb 3, 2014 at 7:38 PM, Dmitry Yemanov firebi...@yandex.ru wrote: 03.02.2014 21:21, marius adrian popa wrote: With fresh Firebird 3.0 install i have with flamerobin (even if i enable legacy auth and flamerobin is loading the new fbclient) Why do you need legacy auth if you use the new client? And how exactly did you enable it? Dmitry -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)
http://permalink.gmane.org/gmane.comp.db.firebird.python/360 -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)
Double checked , I can connect with flamerobin but not with the pure python firebird driver sudo pip install --upgrade firebirdsql ls -lah /tmp/test.fdb3 -rw-rw 1 firebird firebird 800K Feb 6 11:27 /tmp/test.fdb3 cat /tmp/connect_srp.py import firebirdsql conn = firebirdsql.connect( host='localhost', database='/tmp/test.fdb3', user='SYSDBA', password='masterkey', connect_version=3, use_srp=True, wire_crypt=True) On Thu, Feb 6, 2014 at 11:02 AM, Alex Peshkoff peshk...@mail.ru wrote: On 02/06/14 12:26, marius adrian popa wrote: http://permalink.gmane.org/gmane.comp.db.firebird.python/360 First of all make sure you can connect using native isql. Next check is there are something in firebird.log. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)
No issues in firebird log Lorkstation64 Thu Feb 6 10:05:03 2014 /opt/firebird/bin/fbguard: guardian starting /opt/firebird/bin/firebird On Thu, Feb 6, 2014 at 11:58 AM, Alex Peshkoff peshk...@mail.ru wrote: Next check is there are something in firebird.log. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] pyfirebirdsql can't authenticate with Firebird 3.0 (SRP issues)
implements network protocol directly On Thu, Feb 6, 2014 at 12:28 PM, Dimitry Sibiryakov s...@ibphoenix.com wrote: Does this pyfirebirdsql uses fbclient.dll at all or implement network protocol directly? -- WBR, SD. -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- Managing the Performance of Cloud-Based Applications Take advantage of what the Cloud has to offer - Avoid Common Pitfalls. Read the Whitepaper. http://pubads.g.doubleclick.net/gampad/clk?id=121051231iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel