>
> >
> > >So, has anyone ever created a database when alias restrictions are
> > >turned on?

I wrote:

> >Yes - but I confirm that it is broken in v.1.5.1. Sorry, can't say
> >whether
> >this is intentional or not.
> >

At 10:45 AM 13/09/2004 -0400, Someone wrote:

> >Argh. Thanks. Can you point me to the bug reporting mechanism for FB?
>
>It's not a bug yet. It may have been intentional. I've posted a query
>about it in Firebird-devel.

OK, it's not a bug at all. The secret is that you can access the alias for
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
exist yet:

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;
SQL>

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.

./heLen