Dear Markus, first of all thank you very much for the prompt reply. As for your question below, the reason might be the following:
It is a strange "feature" of the isql-fb interpreter, namely, it cuts the longer lines of stdin. It is worse than a good old Fortran 77 compiler: I'm not sure but the limit is some 50 characters. But it happens only if it receives something from a pipe or file to stdin, if it comes from the keyboard interactively, everything is O.K. I found this from my experience while I was writing stored procedures and trying to feed the code to isql-fb from stdin. Moreover, the error message you receive does not reflect this issue, it simply acts as if you just had not written the rest of the command. Since you cannot even break the line within the path to the database, maybe you should use another directory to store the databases, or cd to the database and omit the path to eliminate the problem. Or maybe some \n-s in the echo might help. As for the segfault itself: unfortunately I didn't have the time to collect more experience yet, but as soon as I find out something, I'll let you know. Regards, Matyas On Fri, 3 Apr 2009 23:45:08 +0200 "Markus Hoenicka" <[email protected]> wrote: > Dr. Matyas Koniorczyk writes: > > Use CONNECT or CREATE DATABASE to specify a database > > CREATE DATABASE 'localhost:/var/databases/libdbitest'; > > I've tried to reproduce the firebird driver failures on a Debian 5.0 > box, but my firebird skills seem to be insufficient to get anywhere on > this platform. I've installed firebird 2.0 as a package and managed to > use gsec to change the SYSDBA password. I can use isql-fb > interactively and create databases when logged in as root. However, > what doesn't work is the non-interactive command that the > libdbi-drivers test program uses to set up the test database: > > echo "CREATE DATABASE > 'localhost:/usr/local/var/lib/libdbi/firebird/libdbitest';"|isql-fb > -user SYSDBA -password XXX -sql_dialect 3 > > Use CONNECT or CREATE DATABASE to specify a database > Expected end of statement, encountered EOF > > I have write access in the directory (as root), and I can "create" the > database file using touch. > > Can anyone please help me figure out why this fails on Debian? > > regards, > Markus > > -- > Markus Hoenicka > [email protected] > (Spam-protected email: replace the quadrupeds with "mhoenicka") > http://www.mhoenicka.de -- Dr. Matyas Koniorczyk http://rail.ttk.pte.hu/kmatyas ------------------------------------------------------------------------------ _______________________________________________ Libdbi-drivers-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
