|Subject||UPDATE RE: Creating databases w/ aliases|
> > >So, has anyone ever created a database when alias restrictions are
> > >turned on?
> >Yes - but I confirm that it is broken in v.1.5.1. Sorry, can't sayAt 10:45 AM 13/09/2004 -0400, Someone wrote:
> >this is intentional or not.
> >Argh. Thanks. Can you point me to the bug reporting mechanism for FB?OK, it's not a bug at all. The secret is that you can access the alias for
>It's not a bug yet. It may have been intentional. I've posted a query
>about it in Firebird-devel.
CREATE DATABASE on Windows SS via the IPServer local protocol.
So, say you have this alias in aliases.conf for a database that doesn't
ghastly = d:\data\horrible.fdb
and you have DatabaseAccess configured as NONE....
Use CONNECT or CREATE DATABASE to connect
SQL> CREATE DATABASE 'localhost:ghastly'
CON> USER 'sysdba' PASSWORD 'ravinmad'
CON> PAGE_SIZE 8192;
and you're there. look in the path and you'll find horrible.fdb.
The same is true for Classic on Windows, of course (which doesn't support
ipserver, in any case) and for SS on Linux (which doesn't support a local
connect under any conditions). In fact, Classic on Linux is alone in
supporting a no-host string for the alias in the CREATE DATABASE statement.
So---there ya go.