Re: [libdbi-users] firebird driver segfault

2013-02-18 Thread Markus Hoenicka

Christoph Kottke christoph.kot...@gmx.de 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

2013-02-18 Thread Christoph Kottke

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

2013-02-18 Thread markus . hoenicka
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