Hi Mark

Thanks for the tip, that was it: I had to configure the hostname, which I didn't do at the install. It is working now.

Roy

--- In ib-support@y..., Mark O'Donohue <mark.odonohue@l...> wrote:
>
> Hi Roy
>
> (Mark here :-).
>
> roy@w... wrote:
>
> >Hi
> >
> >This is what I get when trying to do as Sean did:
> >
> >[root@killroy interbase]# bin/isql -user sysdba -password xxxxx
> >Use CONNECT or CREATE DATABASE to specify a database
> >SQL> set sql dialect 3;
> >SQL> show sql dialect;
> > Client SQL dialect is set to: 3. No database has been connected.
> >SQL> create database '127.0.0.1:/home/interbase/test.gdb'
> >CON> ;
> >Internal error: Unexpected isc_info_value 0
> >
> >WARNING: Pre IB V6 database only speaks SQL dialect 1 and does not accept Client SQL dialect 3 . Client SQL dialect is reset to 1.
> >SQL>
> >
> >and the version is: LI-T1.0.0.368 Firebird Beta2
> >
>
>
> golem:~/src/interbase/build/interbase/jrd> /opt/interbase/bin/isql
> Use CONNECT or CREATE DATABASE to specify a database
> SQL> set sql dialect 3;
> SQL> create database '127.0.0.1:/tmp/z6.gdb';
> SQL> show sql dialect;
> Client SQL dialect is set to: 3 and database SQL dialect is: 3
> SQL>
>
> I don't think it's to do with dialect, I think you have a communication
> problem in the server, and your getting rubbish back.
>
> The internal error comes from an isc_database_info call, where it
> interogates the the database properties, including ODS version etc,
> It gets a 0, (which it complanins about), gets something else which it
> interprets as dialect and since ODS is set to default it reckons the
> server side is pretty lousy.
>
> Some things to try:
>
> Do you have localhost in /etc/hosts.equiv,
>
> Perhaps check the /opt/interbase/interbase.log to see if there is
> anything relevant.
>
> try telnet 127.0.0.1 3050 - see what happens.
>
> try create database 'localhost:/home/...";
>
> try adding a few things into your /etc/hosts.equv file
> "localhost.localdomain", "killroy" "killroy.com.au" that sort of thing
> (mainly you want hostname for the computer there).
>
> Also try running tcpdump in another window and see what packets get
> flown around, it may give a clue what the problem is.
>
> Is there anything like firewalls, or anything that could be comming into
> play here.
>
> Im assuming that a plain 'create database' with no dialect will also
> fail. If not a 'show version' would be good after create/connect as it
> should show both client and server dialect versions.
>
> Cheers
>
> Mark
>
>
> >
> >--- In ib-support@y..., Mark O'Donohue <mark.odonohue@l...> wrote:
> >
> >>roy@w... wrote:
> >>
> >>>Hi
> >>>
> >>>I tried to create a database with isql on the Linux box and get the message:
> >>>
> >>>Warning: Pre IB V6 database only speaks SQL dialect 1 and does not accept Client SQL dialect 3 . Client SQL dialect reset to 1.
> >>>
> >>Ok, well looks interesting :-), heres what I get for doing linux isql
> >>client to linux classic server.
> >>
> >>
> >>golem:~/src/interbase/build/release1.0.0a> /opt/interbase/bin/isql -user
> >>sysdba -password xxxxxx
> >>Use CONNECT or CREATE DATABASE to specify a database
> >>SQL> set sql dialect 3;
> >>SQL> create database 'localhost:/tmp/z1.gdb';
> >>SQL> show sql dialect;
> >> Client SQL dialect is set to: 3 and database SQL dialect is: 3
> >>SQL>
> >>
> >>SQL> show version;
> >>ISQL Version: LI-T1.0.0.368 Firebird Beta2
> >>InterBase/linux Intel (access method), version "LI-T1.0.0.368 Firebird
> >>Beta2"
> >>InterBase/linux Intel (remote server), version "LI-T1.0.0.368 Firebird
> >>Beta2/tcp (golem.ko-software.com)/P10"
> >>InterBase/linux Intel (remote interface), version "LI-T1.0.0.368
> >>Firebird Beta2/tcp (golem.ko-software.com)/P10"
> >>on disk structure version 10.0
> >>
> >>
> >>Reconnecting also seemed to work.
> >>
> >>golem:~/src/interbase/build/release1.0.0a> /opt/interbase/bin/isql -user
> >>sysdba -password xxxxxx
> >>Use CONNECT or CREATE DATABASE to specify a database
> >>SQL> connect 'localhost:/tmp/z1.gdb';
> >>Database: 'localhost:/tmp/z1.gdb', User: sysdba
> >>SQL> show sql dialect;
> >> Client SQL dialect is set to: 3 and database SQL dialect is: 3
> >>SQL> quit;
> >>
> >>
> >>So (from my reading of what Ive' got) that seemed to work and it has
> >>v1.0.0 on client and server sides (both on linux box currently).
> >>
> >>Is this similar to your test, or did you use the win32 as the client side?
> >>
> >>I'll try that, but Im also going to have a look for that error message
> >>in the source code, and see if I can find it somewhere.
> >>
> >>Cheers
> >>
> >>Mark
> >>
> >>--
> >>Your database needs YOU!
> >>http://www.firebirdSQL.org
> >>
> >
> >
> >
> >To unsubscribe from this group, send an email to:
> >ib-support-unsubscribe@egroups.com
> >
> >
> >
> >Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
> --
> Your database needs YOU!
> http://www.firebirdSQL.org