Subject Re: [firebird-support] Strange Firebird error "unsupported on-disk structure for file"
Author Helen Borrie
At 04:35 PM 18/03/2006, you wrote:
>I do not understand this error. Any ideas? Its from a firebird 1.5
>database on windows i am trying to open it in linux:
>
>
>
>matt@rr4linux /etc/init.d $ /opt/firebird/bin/isql -user sysdba
>-password ******
>Use CONNECT or CREATE DATABASE to specify a database
>SQL> connect /home/matt/opsim/branches/sysdata.fdb;
>Statement failed, SQLCODE = -820
>
>unsupported on-disk structure for file
>/home/matt/opsim/branches/sysdata.fdb; found 32779, support 10
>SQL>

1. How did you transport the database? (Intel to Intel should be OK,
otherwise you'd need to restore a Windows gbak on the Linux server).

2. Are you by any chance running Superserver on Linux? If so,
you've got the wrong connect string (though this should cause the
"Unavailable database", as far as I know..) Anyway, if is fbserver
and not fb_inet_server then use the local loopback server:

SQL> connect localhost:/home/matt/opsim/branches/sysdata.fdb;

And make sure that the firebird:firebird user:group has rwx rights to
the directory chain AND rw for the database file.

./heLen