Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS) [SOLVED]

['Bryan Cole' bryan.c...@teraview.com [firebird-support]]

On Tue, 2018-12-18 at 20:04 +0100, Dimitry Sibiryakov s...@ibphoenix.com 
[firebird-support] wrote:

18.12.2018 19:17, 'Bryan  Cole' 
bryan.c...@teraview.com [firebird-support] 
wrote:

[root@bryan  bin]# ./isql -user test -pass test -role 
RDB$ADMIN

localhost:employee


   Didn't you forget about a special meaning of $ in bash command line?


YES! That's it!  -> 


OGM I'm an idiot. That bash would mangle the role-name hadn't cross my mind.


Thank you Dimitry. Also Thank You to everyone else who who took the time to 
respond to my pleas for help.

I really appreciate it.


Have a great Xmas/New Year.

Bryan

Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

[Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]]

On 19.12.2018 at 17:33, Mark Rotteveel m...@lawinegevaar.nl 
[firebird-support] wrote:
> Although I haven't read it myself, consider buying "Migration Guide to
> Firebird 3" by Carlos Cantu, see
> https://www.firebirdnews.org/migration-guide-to-firebird-3/

Just taking the occasion of this topic being discussed, I'd like to 
mention one thing that might get overlooked but may as well become a 
real issue in some cases.
There's a short note on the firebirdnews.org site
https://www.firebirdnews.org/how-to-migrate-existing-users-from-firebird-2-x-to-firebird-3/
saying, that upgrading existing users from 2.x to 3.x will generate a 
new random password for each user.
Is that really the only option? With a few dozens of systems deployed, a 
few dozens to a few hundreds users each (real FB users), notifying a 
couple of thousand employees of our customers about new passwords might 
be a real no-go.
That's one of the main reasons we're delaying the upgrade from 2.5 to 3 
at our customers' sites.

Any suggestions much appreciated.

thanks
Tomasz

-- 
__--==--__
__--== Tomasz Tyrakowski==--__
__--==SOL-SYSTEM==--__
__--== http://www.sol-system.pl ==--__
__--==--__

Re: [firebird-support] Problems with creating new users (no permission for INSERT access to TABLE PLG$VIEW_USERS)

['Bryan Cole' bryan.c...@teraview.com [firebird-support]]

On Wed, 2018-12-19 at 13:46 +1300, Helen Borrie hele...@iinet.net.au 
[firebird-support] wrote:


Bryan,

Maybe something in here will provide that ah-haa moment. ;-)



In Fb 3 and Fb 4-alpha, you must have *both* and perform your login with
the role. In Fb 4 beta 1, a user with the GRANT ADMIN ROLE (SEC$ADMIN TRUE)
does not need to log in with the RDB$ADMIN role. I don't know whether this
is going to be backported to Fb 3.0.5.

Helen


Thanks for the informative post. Turns out my problem was my linux shell 
mangling the role-name.
I've learned a lot about the Firebird security database in process of tracing 
this though. Have also aged about 5 years in the last 2 days.

Bryan

RE: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

['Paul Beach' pbe...@mail.ibphoenix.com [firebird-support]]

<>

http://www.ibphoenix.com/files/conf2016/upgrading-Cisar-2016.pdf

Regards
Paul

[firebird-support] Preparing for upgrade from 1.56 to 3 or 4

[my...@techsol.org [firebird-support]]

I have a few older FB databases that will need upgrading to later versions.  
They are pretty large, and most have between 500-1,000 stored procedures.  Some 
contain many tables with millions of rows of data.  This is not likely to be a 
small undertaking.  Although I realize there are services out there that I can 
pay to do this, I'd like to do it myself simply because I have to manage these 
databases going forward.
 

 Is there any documentation regarding doing upgrades like this available for 
review?  This is all on Linux and I realize that this process will take some 
time, so I may need interim support for DBs on upgraded Linux OS versions as I 
progress through this, but I'd like to be able to plan out the migration.
 

 If anyone can point me to any slides, papers, presentations, etc. that might 
help with this, it would be greatly appreciated.
 

 Thanks
 Myles

Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

[Mark Rotteveel m...@lawinegevaar.nl [firebird-support]]

On 19-12-2018 17:01, my...@techsol.org [firebird-support] wrote:
> I have a few older FB databases that will need upgrading to later 
> versions.  They are pretty large, and most have between 500-1,000 stored 
> procedures.  Some contain many tables with millions of rows of data.  
> This is not likely to be a small undertaking.  Although I realize there 
> are services out there that I can pay to do this, I'd like to do it 
> myself simply because I have to manage these databases going forward.
> 
> Is there any documentation regarding doing upgrades like this available 
> for review?  This is all on Linux and I realize that this process will 
> take some time, so I may need interim support for DBs on upgraded Linux 
> OS versions as I progress through this, but I'd like to be able to plan 
> out the migration.
> 
> If anyone can point me to any slides, papers, presentations, etc. that 
> might help with this, it would be greatly appreciated.

I suggest to read all release notes since 1.5 on 
https://www.firebirdsql.org/en/release-notes/

Also read the "Firebird 2 Migration & Installation".

Although I haven't read it myself, consider buying "Migration Guide to 
Firebird 3" by Carlos Cantu, see 
https://www.firebirdnews.org/migration-guide-to-firebird-3/

Mark
-- 
Mark Rotteveel

[firebird-support] Firebird 2.5 ppa repository for Ubuntu 18.04

[my...@techsol.org [firebird-support]]

There is reference to installing Firebird 2.5.x on Ubuntu on the website at 
https://firebirdsql.org/manual/ubusetup.html 
https://firebirdsql.org/manual/ubusetup.html  but this information is very old. 
 The repository that is referenced does not seem to work with Ubuntu 18.04.  
When I attempt to add it to my sources and then update, I get the following 
error:
 

 E: The repository 'http://ppa.launchpad.net/mapopa/ppa/ubuntu bionic Release' 
does not have a Release file.
 
 N: Updating from such a repository can't be done securely, and is therefore 
disabled by default.
 

 Is there a more up to date repository for Firebird 2.5 for Ubuntu 18.04 LTS 
that any one can point me to?  I can install from the install.sh script, but it 
doesn't support inetd, etc. and I'm going to have to manually set all that up.  
I'm sure that a DEB package for this will do all of that automatically.  I am 
unable to use FB 3 yet, so I need this for FB 2.5.
 

 Thanks
 Myles

Re: [firebird-support] Preparing for upgrade from 1.56 to 3 or 4

[my...@techsol.org [firebird-support]]

Thank you so much for this information.  Priceless!