Re: [libdbi-users] firebird driver segfault
Christoph Kottke writes: > some more hits, > > if you use xinet.d you must enabled by hand in > /etc/xinet.d/firebird.conf and restart xinetd. > and new created db can only access by SYSDBA before the are activated... > Hi, one reboot later things have improved considerably. I tried to start the superserver process manually yesterday. There were no error messages, but the commands apparently did not succeed. After I booted the box tonight, the server was started correctly, and I was at least able to connect to the test database. I started to fiddle with tests/test_dbi in order to get some tests running. The test database is created ok using isql-fb, and I can connect to that (empty) database manually. I also found out the hard way that you have to run ./test_dbi as root to avoid error messages like: Can't access lock files' directory /tmp/firebird However, running the test as root results in error messages like (printed using printf using a modified debug firebird driver): Fatal lock manager error: invalid lock id (19892), errno: 11 --Resource temporarily unavailable I'll have to investigate which commands exactly cause this error messages, but at this time the test program does not run to completion using this driver. Did you ever succeed in running the new test kit? Or the old one shipped with 0.8.3 fwiw? regards, Markus -- Markus Hoenicka http://www.mhoenicka.de AQ score 38 -- 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/ ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
Re: [libdbi-users] firebird driver segfault
Am 18.02.2013 10:43, schrieb Christoph Kottke: > Am 18.02.2013 10:27, schrieb Markus Hoenicka: >>> Classic does not require this step, but it doesn't work either. I'm >>> sure that I miss some critical step in the procedure. What about >>> accounts: do you run your queries from a regular user account? root? >>> firebird? Also, where do you create databases? What are the >>> permissions of that directory, and who owns it? Do you use localhost >>> in the database specifier, do you use any other host information, or >>> none at all? > Hi again, > > the server is full funktional, i connect via network with normal user > accound. the used > table is public ownership. the directory of the database file must own > by firebird:firebird > and have rw pemissions. > > btw. i can setup an testserver for you! > > christoph some more hits, if you use xinet.d you must enabled by hand in /etc/xinet.d/firebird.conf and restart xinetd. and new created db can only access by SYSDBA before the are activated... christoph -- 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/ ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
Re: [libdbi-users] firebird driver segfault
Am 18.02.2013 10:27, schrieb Markus Hoenicka: >> Classic does not require this step, but it doesn't work either. I'm >> sure that I miss some critical step in the procedure. What about >> accounts: do you run your queries from a regular user account? root? >> firebird? Also, where do you create databases? What are the >> permissions of that directory, and who owns it? Do you use localhost >> in the database specifier, do you use any other host information, or >> none at all? Hi again, the server is full funktional, i connect via network with normal user accound. the used table is public ownership. the directory of the database file must own by firebird:firebird and have rw pemissions. btw. i can setup an testserver for you! christoph -- 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/ ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
Re: [libdbi-users] firebird driver segfault
Christoph Kottke was heard to say: > Hi, > > thanks for your investigating :) > > i've run an debian 6.0.6 on i386 and install the lastest firebird-1.5 > from http://firebirdsql.org/ > because libdbi-driver depends on old include files (gds.h, etc). but you > can use the tarball only > to compile and use the server from debian repository. > > i 've never had problems to install an firebird server on debian, it > works always out of the box. > > the server is: firebird2.5-classic > Hi, I've tried both classic and super. In order to get the latter up and running, you're supposed to configure the package like this (as root): dpkg-reconfigure firebird2.5-super Even that command fails, saying it cannot connect. As this is still part of the installation, I have to consider this package broken. Classic does not require this step, but it doesn't work either. I'm sure that I miss some critical step in the procedure. What about accounts: do you run your queries from a regular user account? root? firebird? Also, where do you create databases? What are the permissions of that directory, and who owns it? Do you use localhost in the database specifier, do you use any other host information, or none at all? I'll give it another try tonight, but of course there is no point in delaying libdbi-drivers 0.9 any further if I don't have a chance to fix the firebird driver anyway. We'd have to move that driver to the "code present but unsupported" vault. BTW I'm running Debian Wheezy i386 on the test box. I've installed it from scratch on Saturday, so it shouldn't be screwed up in any way that affects firebird. If I include Debian's weird non-standard library directories, I don't have any problems building the firebird driver from the headers and libraries provided by the Debian packages. regards, Markus -- Markus Hoenicka http://www.mhoenicka.de AQ score 38 -- 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/ ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
Re: [libdbi-users] firebird driver segfault
Am 18.02.2013 00:51, schrieb markus.hoeni...@mhoenicka.de: > Christoph Kottke writes: > > hi, > > > > i've installed the latest cvs revisions for libdbi and libdbi-driver and > > when ever i try to fetch more than > > 3 row from an firebird table it's end in an segfault. > > > > but when i revert the "bull patch" in dbi_result.c it works like a charm. > > > > Hi, > > I'd be happy to look at this issue. However, I haven't been able to > set up firebird on Debian either. I've followed the excellent Ubuntu > instructions which should work for Debian as well: > > https://help.ubuntu.com/community/Firebird2.5 > > However, no luck. isql-fb never manages to make a connection. I cannot > create database, and I can't access the example database either. This > database drives me nuts, I haven't seen it work on any platform here > in the past couple of years. > > In order to have a chance to debug the driver, would you please share > some information how you succeeded in running firebird at > all. Again, I'm not talking about libdbi or libdbi-drivers problems. I > just can't get the engine itself to work. > > regards, > Markus Hi, thanks for your investigating :) i've run an debian 6.0.6 on i386 and install the lastest firebird-1.5 from http://firebirdsql.org/ because libdbi-driver depends on old include files (gds.h, etc). but you can use the tarball only to compile and use the server from debian repository. i 've never had problems to install an firebird server on debian, it works always out of the box. the server is: firebird2.5-classic christoph -- 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/ ___ libdbi-users mailing list libdbi-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-users
