Wednesday, October 18, 2017, 9:52:36 AM, [email protected] wrote: > I am a newbie, like a total newbie just exploring databases for the > first time. I am using Lazarus and they all seem to prefer Firebird > and lot of the documentation is geared that way. I have > successfully downloaded and installed Firebird onto ElementaryOS > Loki. I am trying to use DB Scema but can't connect to firebird > from there. I can connect to sqlite from dbscema and I can > connect to firebird from Flamerobin. I get the error:
> ncompatible wire encryption levels requested on client and server > Incompatible wire encryption levels requested on client and server > [SQLState:28000, ISC error code:335545064] > You CAN or you cannot connect from FlameRobin? > I then followed these instruction and changed my firebird.conf file > to "Wirecrypte = Enabled" as seen here: Hopefully you didn't add that extraneous letter 'e' to the parameter name. And you removed the '#' character from that line. > - https://www.firebirdsql.org/ file/documentation/drivers_ > documentation/java/3.0.2/ release_notes.html#notes-on- firebird-3-support If you want to enable wire encryption, you will need to have two things in addition to enabling it in firebird.conf: 1. the fbclient.so that comes with Firebird 3. Older Firebird versions do not support wire encryption. 2. a language interface layer that knows about Fb3 wire encryption so that the application can pass it in the API. For FlameRobin, you need fbclient.so: the 64-bit version if you are using 64-bit FR; otherwise, you need the 32-bit version. You match the bitness of the client to the bitness of your application, not the bitness of the Firebird server. Unfortunately, if you have installed the 64-bit Firebird server and need the 32-bit client, you'll have to grab the x86 kit from the download area and extract the client from it. For some reason that totally escapes me, we still do not provide any client-only kits in the download area. > But I still can't connect. I also tested with DBerver but have the > same problem. I downloaded and installed the java driver to version > 3.0.2. But still no success at all. I have no idea what t o do. > All the programs I have tried to use to connect to Firebird don't > work and they all tell me to come here. You've named some applications I've never heard of. Are you sure they actually support Firebird? If they claim to do so, check what driver they need, e.g., ODBC, Python, etc. In the case of Jaybird, you have both the client and the language interface rolled into one. Jaybird supports the API natively. However, it appears Jaybird does not support wire encryption yet. To ask about that, subscribe to the firebird-java support list, see https://www.firebirdsql.org/en/mailing-lists/ > I would attach the firebird.conf but there doesn't seem to be a way > to do that. the firebird conf that I found was in > /etc/firebird/firebird3.0 The Firebird 3 installer script didn't put it there but possibly FlameRobin or Jaybird did. Some client interfaces need to read firebird.conf. It won't conflict with the server's firebird.conf, per se, but it would pay to keep the one used by the client app consistent with the one used by the server. > I also found an other firebird.conf in /opt/firebird/. That's the one the installer put there. > I h ave no idea why there would be two of them. I > have only ever installed FB once. I have tried changed the > Wirecrypt on both, then on one then the other. If you change a configuration setting you have to restart the Firebird server, unless you are running Classic. (But, if you didn't change the ServerMode parameter, then you are running Superserver and you DO need that restart.) If FR or another app is depending on the settings in its own firebird.conf file then you;d probably need to restart that app after changing that file, too. Another possibility is that the FlameRobin package you installed is pre-Firebird 3.0 and has installed an old fbclient.so in its WD. So check that as well. I strongly recommend that you study the two PDF books in /opt/firebird/doc. There you have the Quick Start Guide and the release notes. Our release notes are very detailed. Helen
