Hi All,
I am wondering about the level of support in Firebird's implementation of
Win_Sspi as I can not find specific documentation.
If anyone can point me to a source document I would greatly appreciate it.
The situation I have is a heterogeneous mixture of platforms within a
corporate en
the issues.
From: firebird-support@yahoogroups.com on
behalf of Dalton Calford dcalf...@distributel.ca [firebird-support]
Sent: December 11, 2017 2:37:39 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Select Distinct returning multiple rows
I have a weird problem.
An over-simplified description of the problem is as follows
select a.FOO, a.BAR from FOOBAR a
returns two rows.
a.FOO a.BAR
A 124
A 124
select distinct a.FOO, a.BAR from FOOBAR a
returns the same two rows
a.FOO a.BAR
A 124
A 124
BUT
I prefer more smaller triggers with a specified firing order, along with code
at the beginning of the trigger that checks to see if the trigger should fire
or not - this allows you to disable a trigger within the scope of a single
transaction ie.
(a) Update master table that trigger checks - t
Yes,
But the new domain is not created for every table, just for every column where
you are not using a pre-defined domain.
So,
Create table MYTABLE(mycolA integer, mycolB integer, mycolC integer); would
auto create three separate new domains.
I wish I knew more of what you are trying to
Every time you do not define a domain when creating a column in a table,
firebird creates a new domain.Unless they have changed something
fundamental, they never purge unused domains. So, you perform a backup and it
recreates all the prior domains first, then, proceeds to create new domain
Interesting, only one record.
The RDB$ domains are auto generated by the system - RDB$1297080260861 says that
it is the 1,297,080,260,861 domain created by the system.
If this is not the only auto-generating domain you have been using, it is
possible that you have hit the maximum auto-incremen
That type of error generally is caused by a utility or process that has changed
the definition of the column.
You have data in your column in that table that no longer fits in the new
definition.
When you manually change, or use a utility to smack the system tables, vs
creating a whole new c
I am having difficulties with the latest linux Firebird 64 bit ODBC drivers in
that they are not working with the latest UnixODBC versions.
When using the ODBC Administrator, (unixODBC-GUI-Qt4) it tells me it can not
load a property list for Firebird.
Does anyone have a setup guide for ODBC o
Hi Alain,
For roles and trusted authentication (which is what I am discussing here) you
use the "set trusted role" command.
With trusted authentication (when you use the OS/network to authenticate the
user) you are not passing role information and the dba needs to apply trusted
roles which w
You have a few choices in how to do this.
You can either upgrade your users to RDB$ADMIN role rights (not recommended) or
you can grant the user to have rights to a view that gets it's data from a
stored procedure that connects back to the database in a separate
connect/transaction as a user t
Hi Alain,
We use full user authentication at our company, so everyone logs into the
database using their own credentials. Currently, each user has an account in
the firebird security database. Each user also has a windows domain account.
This means each user has, at a minimum, two separat
Hi Everyone.
I have a linux machine (Ubuntu 16.04 64bit Server) with Firebird 3.01 64 bit
installed.
That machine is a member of our corporate domain and authenticates via
PAM/Samba4 for all user access.
I want to have Firebird client applications on remote windows machines to use
the linux
Hi,
I am testing Firebird 3 and one of the tests happens to be finding out if it
supports Active Directory.
I am assuming that trusted user authentication passes the user identity as per
the local machine to the server.
The question I have is how you would setup a linux box (already part of
Thanks,
I removed Firebird and tried the downloads from Sourceforge, all is working
fine now.
From: firebird-support@yahoogroups.com on
behalf of peshk...@mail.ru [firebird-support]
Sent: June 1, 2016 5:19:23 AM
To: firebird-support@yahoogroups.com
Subject: [
Hey All,
Does anyone have the latest install guides for Firebird 3 on systemd based
Ubuntu systems?
I installed firebird, gave it the password but the install had output as follows
Created default security3.fdb
Failed to start firebird3.0-server.service: Unit firebird3.0-server.service not
fo
I have an cluster of older database formats (32bit firebird 1.5) and I wish to
see about migrating them to a newer firebird 2.5 64 bit format.
We replicate using older custom C code on telco servers, so redesigning the
replication code and getting it certified for use is a non-starter.
So, we
I am attempting to setup FreeAdhocUDF on a standard (apt-get) install of
firebird 2.5
The server is a 64 bit machine/OS/firebird install.
I am having problems understanding some of the FreeAdhocUDF documentation
For example, the documentation assumes that firebird is installed under /opt/
and
Is there a method to remove the restriction on connecting to security2.fdb
until fb3 goes gold?
From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com]
Sent: 01 September 2015 11:01
To: firebird-support@yahoogroups.com
Subject: [firebird-s
With firebird 2.5 we received some wonderful tools that allowed us to create,
update and drop users without needlessly mucking about with smacking the
security database. Yea!
But, we also where locked out from reading the security database so we can no
longer see who is defined in the databas
Hi Everyone,
I am almost embarrassed to ask, but, I am having a great deal of difficulty
with setting this up.
I have a brand new installation of Ubuntu LTS Server 14.04
I have installed firebird superclassic.
I have used gbak to restore a database without any problems
I can connect to my newl
21 matches
Mail list logo