Re: [firebird-support] conect flamerobin with Firebird3
>- Original Message - >From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] >To: firebird-support@yahoogroups.com >Sent: Tuesday, April 26, 2016 9:38 AM >Subject: Re: [firebird-support] conect flamerobin with Firebird3 > >On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu >[firebird-support] wrote: >> Create a firebird 3 bd in another user who is not sysdba >> and create a role called sysdba without permission > >Creating a role called SYSDBA will disallow the user SYSDBA to connect >to Firebird. > precisely that. >> and when I try to connect from flamerobin you give me the following >> error message >What user? Given the error below I suspect you are connecting with >SYSDBA. the user who creates the database, which is the same with which I am trying to connect, but also comes with other users who have permissions to other roles created through >> *** IBPP::SQLException *** >> Context: Database::Connect >> Message: isc_attach_database failed >> >> SQL Message : -902 >> Unsuccessful execution caused by a system error that precludes >> successful execution of subsequent statements >> >> Engine Code : 335544745 >> Engine Message : >> Your login SYSDBA is same as one of the SQL role name. Ask your >> database administrator to set up a valid Firebird login. >> unknown ISC error 335545081 >> >> As I can overcome this error? > >Dont create / drop the role SYSDBA. > >Mark > >Posted by: Mark Rotteveel m...@lawinegevaar.nl This problem does not occur in firebird 2.5.x there any way to solve this error, or an issue introduced in firebird3? Best Regards | ISMAEL |
Re: [firebird-support] conect flamerobin with Firebird3
No I have not registered the dabtabase with the sysdba user. Even as I say connect and put the user who believes the database and gives me the same error as if flamerobin not respect the user with which I want to connect. This error does not occur in version 2.5.5 because the db is a restored from a dabtabase running perfectly firebird 2.5.5 with the sysdba role created and another user as the owner of the dabtabase. Regards.. | ISMAEL | - Original Message - From: Mark Rotteveel m...@lawinegevaar.nl [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, April 26, 2016 9:38 AM Subject: Re: [firebird-support] conect flamerobin with Firebird3 On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission Creating a role called SYSDBA will disallow the user SYSDBA to connect to Firebird. > and when I try to connect from flamerobin you give me the following > error message What user? Given the error below I suspect you are connecting with SYSDBA. > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes > successful execution of subsequent statements > > Engine Code : 335544745 > Engine Message : > Your login SYSDBA is same as one of the SQL role name. Ask your > database administrator to set up a valid Firebird login. > unknown ISC error 335545081 > > As I can overcome this error? Dont create / drop the role SYSDBA. Mark Posted by: Mark Rotteveel <m...@lawinegevaar.nl> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (4)
Re: [firebird-support] conect flamerobin with Firebird3
On 2016-04-26 14:10, 'Ismael L. Donis Garcia' sli...@citricos.co.cu [firebird-support] wrote: > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission Creating a role called SYSDBA will disallow the user SYSDBA to connect to Firebird. > and when I try to connect from flamerobin you give me the following > error message What user? Given the error below I suspect you are connecting with SYSDBA. > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes > successful execution of subsequent statements > > Engine Code : 335544745 > Engine Message : > Your login SYSDBA is same as one of the SQL role name. Ask your > database administrator to set up a valid Firebird login. > unknown ISC error 335545081 > > As I can overcome this error? Dont create / drop the role SYSDBA. Mark
Re: [firebird-support] conect flamerobin with Firebird3
He does not work with the library version 2.5, but already configured to work with her. If I delete the SYSDBA role if I connect to the database, but do not want to eliminate that role. If I remove the role SYSDBA when connected and once connected beyond the role I think again you still connect, but when I turn off the PC and turn again and I no longer connect. I'm trying to connect to the user who creates the BD Regards.. | ISMAEL | - Original Message - From: 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] To: firebird-support@yahoogroups.com Sent: Tuesday, April 26, 2016 8:41 AM Subject: Re: [firebird-support] conect flamerobin with Firebird3 > Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission > and when I try to connect from flamerobin you give me the following error > message > > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements > > Engine Code : 335544745 > Engine Message : > Your login SYSDBA is same as one of the SQL role name. Ask your database > administrator to set up a valid Firebird login. > unknown ISC error 335545081 > > As I can overcome this error? Are you sure that FlameRobin picks up the FB 3 client library? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc. Posted by: "Thomas Steinmaurer" <t...@iblogmanager.com> Reply via web post . Reply to sender . Reply to group . Start a New Topic . Messages in this topic (2)
Re: [firebird-support] conect flamerobin with Firebird3
> Create a firebird 3 bd in another user who is not sysdba > and create a role called sysdba without permission > and when I try to connect from flamerobin you give me the following error > message > > *** IBPP::SQLException *** > Context: Database::Connect > Message: isc_attach_database failed > > SQL Message : -902 > Unsuccessful execution caused by a system error that precludes successful > execution of subsequent statements > > Engine Code: 335544745 > Engine Message : > Your login SYSDBA is same as one of the SQL role name. Ask your database > administrator to set up a valid Firebird login. > unknown ISC error 335545081 > > As I can overcome this error? Are you sure that FlameRobin picks up the FB 3 client library? -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.