Hi!

Sorry for "constant" asks but I'm in a big project and I wanna move fast to finishing it.

So: in DBISAM philosophy the Server use one Config Database that containing all
publishable databases, their users/paths/datas.

In the EDB tutorial example I see only one DataBase using.

So I wanna ask that how can I use more databases in the server?
How can I register all databases, and where I can see them all (as in dbisam dbmgr)?
How can I protect them? How to I get these infos quickly?

And the most important question: where I can get the ODBC driver for access EDB databases?
(I need to use it from web, from python).

Thanks for your help:
 dd

Durumdara <durumdara@gmail.com> wrote:
>>>
So: in DBISAM philosophy the Server use one Config Database that containing all
publishable databases, their users/paths/datas.
So I wanna ask that how can I use more databases in the server?
How can I register all databases, and where I can see them all (as in dbisam dbmgr)?
>>>

So, my main question is this:
I have 3 applications.
Every applications have local version (to test, develop it). And every of them have remote
version (the published version).
Every application have EDBConfig file (for local and remote using).
This config file placed near to exe.

But if I wanna publish these db-s in a DataBase server, I need to transfer all settings
from the local EDbConfig files to global remote EDBConfig file.
The "databases" are easily transfer with "create database xxx path yyy".
But local users/roles I must transfer by hand! And possible the users or roles overlapped
by others!!!

And possible in one case I use another file extension in a database, and other in another.
Or other setting are not same as in another application.

So I don't understand how to I realize these things with one global EDBConfig file. This
is hard, not user/developer friendly.

Or I something understand wrong in the EBD's philosophy??? Is existing another way to
registrate the DB-s I wanna publish with dbsrv? How?

Dear Tim! Please help me a little to I understand the working method of the EDB! Please
help me in the publishing my three databases!

(For example: in IBExpert (a manager of FireBird/IB databases) I can register some
databases with I wanna using/working. But these databases are not dependent from these
registrations. In the edbmgr I can use only one EDBConfig file. But if I use this file for
my ALL databases, I waste my disk place, and I enable security holes, because all database
infos, users, etc. I stored in this file (and installed to everywhere), and not in
separate config files (by app).
But working with databases is better when I see them all in one place - like in IBExpert.
This is different thing: the IBExpert is only registrate the databases - so it is user
friendly).

Thanks for your help:
 dd

Durumdara,

<< So: in DBISAM philosophy the Server use one Config Database that
containing all publishable databases, their users/paths/datas.

In the EDB tutorial example I see only one DataBase using. >>

EDB is the exact same design as DBISAM in terms of the server.

<< So I wanna ask that how can I use more databases in the server? >>

CREATE DATABASE:

http://www.elevatesoft.com/edb1sql_create_database.htm

<< How can I register all databases, and where I can see them all (as in
dbisam dbmgr)? >>

The EDB Manager allows you to perform the administration against the EDB
Server without a separate admin utility or admin connection.

<< How can I protect them? How to I get these infos quickly? >>

What do you mean by protect them ?  Do you mean user security ?  If so, then
see here:

http://www.elevatesoft.com/edb1sql_user_security.htm

<< And the most important question: where I can get the ODBC driver for
access EDB databases? (I need to use it from web, from python). >>

You can purchase it here:

http://www.elevatesoft.com/scripts/order.dll?action=viewcatprod&product=edb

You'll probably only need the EDB-DAC-STD product.

--
Tim Young
Elevate Software
www.elevatesoft.com

Durumdara,

<< Every applications have local version (to test, develop it). And every of
them have remote version (the published version).  Every application have
EDBConfig file (for local and remote using). This config file placed near to
exe.

But if I wanna publish these db-s in a DataBase server, I need to transfer
all settings from the local EDbConfig files to global remote EDBConfig file.
The "databases" are easily transfer with "create database xxx path yyy". But
local users/roles I must transfer by hand! And possible the users or roles
overlapped by others!!! >>

Just copy the configuration file and database files (catalog file and table
files) over to the server machine, and then follow these instructions to
modify the database paths as necessary:

http://www.elevatesoft.com/edb_faqt_2.htm

I would suspect that you aren't changing large portions of the database in
this manner very often, and this type of operation would only be required a
few times, if that.

<< And possible in one case I use another file extension in a database, and
other in another. Or other setting are not same as in another application.
>>

File extension settings are not stored in the configuration file.  The only
thing stored in the configuration file is covered here in the manual:

http://www.elevatesoft.com/edb1sql_configuration_database.htm

<< So I don't understand how to I realize these things with one global
EDBConfig file. This is hard, not user/developer friendly. >>

Frankly, I don't think you quite understand the EDB architecture yet, so it
seems hard when it really isn't.   The only difference between EDB and
DBISAM is the use of the configuration file for local sessions in addition
to the EDB Server.   That's it.  So, my question to you at this point is,
how did you accomplish what you're trying to accomplish in DBISAM ?  If you
start from that point, you will find that nothing really changed in terms of
remote sessions using the EDB Server.   The only difference is that you use
SQL instead of code for administering databases, users, etc.

<< (For example: in IBExpert (a manager of FireBird/IB databases) I can
register some databases with I wanna using/working. But these databases are
not dependent from these registrations. >>

Neither are the databases in EDB.  They are not dependent upon the contents
of the configuration file.   However, you do want to be careful with respect
to how you modify users and/or roles, especially if they have been granted
privileges in an existing database.   The privileges are stored in the
database catalog files, but the users/roles are stored in the configuration
file.  But, this is not unique to EDB, and any database server that uses
external authentication can run into the same problem.  MS SQL Server can
have this issue, for example.

<< In the edbmgr I can use only one EDBConfig file. But if I use this file
for my ALL databases, I waste my disk place, and I enable security holes,
because all database infos, users, etc. I stored in this file (and installed
to everywhere), and not in separate config files (by app). >>

1.06 will have the ability to use separate configuration files per local
session:

http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=16&msg=2723&page=1#msg2723

However, your issue is not that the EDB Manager can't use separate
configuration files per session since you're using remote sessions for your
published databases, correct ?  What type of session are you using for your
test sessions ?  Are they local or remote ?

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
>>>
However, your issue is not that the EDB Manager can't use separate
configuration files per session since you're using remote sessions for your
published databases, correct ?  What type of session are you using for your
test sessions ?  Are they local or remote ?
>>>

Hi!

Sorry for Myst in my Brain, but I don't understand this...
I write to you what I want to do, please tell me, how can I realize... Thanks for it!

I have two projects.
1.) DVD auction house.
2.) Book store.

These projects have two parts: Delphi + web (Python).
The Delphi part is an application that used by the customer to administrating the web
database (prices, products, etc.).
These apps are installed in the client's machine somewhere.

The Python (web) part installed in my webserver, and this is the published content.
In this server I use DBISAM server to provide the infos to the client (Delphi part) and I
use local session to get these datas for web (ODBC driver + Python).

Scheme:
The client -> Application -> DBISAM server -> local database (in server) <- ODBC <- Python
<- Web.

The Delphi parts are developed locally with local session using, with local databases.
Later I developed them with remote session to check speed and test other things in it.

So...
In the developer machine I used INI files to provide database access infos. I simply
change it (local/remote) as I need.

In the server I used dbsrvmgr to registrate the databases, the database users, and to
publish these databases for clients.

THIS IS I WANT TO BUILD WITH EDB TOO.
As I saw we bougth wrong product because this is not containing the ODBC driver. Ok, this
is later needed, in the python section.
But I finished with client app, so I want to set the application to remote mode.
But before I do this I need to set up the server.

This is the point where I "lost in configs". Because I copied the two databases (separate
products!) to the server and I need to say the server to "these dbs I need to publish with
these params..." as I do in DBISAM too.
But I don't found a way to register these databases as in dbsrvmgr.

Please help me a little: how can I do this thing?
If you don't want to use this forum (because it is lama question) please write to me email
address.

Thanks for your help!!!

dd

Durumdara,

<< This is the point where I "lost in configs". Because I copied the two
databases (separate products!) to the server and I need to say the server to
"these dbs I need to publish with these params..." as I do in DBISAM too.
But I don't found a way to register these databases as in dbsrvmgr. >>

Just make sure that the EDB Manager is pointing to the same configuration
file that the web application and EDB Server are both using (or use a remote
session to connect to the EDB Server, which should be using the same
configuration file as the web application), and then use the CREATE DATABASE
statement in the SQL tab for the system-defined Configuration database to
create the database.  The steps to do so are outlined here:

http://www.elevatesoft.com/edb1d7_loc_creating_tutorial_database.htm

The general architecture of your application will look like this:

Web App             EDB Server
       |                           |
       ---- Config File ----
                   |
                   |
      Database Definitions
                   |
              Tables

--
Tim Young
Elevate Software
www.elevatesoft.com

Dear Tim!

Sorry Tim, but I need the answer to how can I register these TWO databases...

>>>>>>>>
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
<< This is the point where I "lost in configs". Because I copied the two
databases (separate products!) to the server and I need to say the server to
"these dbs I need to publish with these params..." as I do in DBISAM too.
But I don't found a way to register these databases as in dbsrvmgr. >>

Just make sure that the EDB Manager is pointing to the same configuration
file that the web application and EDB Server are both using (or use a remote
session to connect to the EDB Server, which should be using the same
configuration file as the web application), and then use the CREATE DATABASE
statement in the SQL tab for the system-defined Configuration database to
create the database.  The steps to do so are outlined here:

http://www.elevatesoft.com/edb1d7_loc_creating_tutorial_database.htm

The general architecture of your application will look like this:

Web App             EDB Server
       |                           |
       ---- Config File ----
                   |
                   |
      Database Definitions
                   |
              Tables


>>>>>>>>

So I understand it IF I HAVE ONE APPLICATION.
But here is TWO (or later MORE) APPLICATIONS, TWO SEPARATED DATABASES.
How to I say to EDBServer: "Hey guy, this database is here, in this directory - and you
must publish it with these users/roles; and here is the another database in another way -
and you must publish it with these (another) users/roles".

As in DBISAM servermanager?
In this program (dbsrvmgr) I can register the databases, I can link the users to the
databases, I can check what databases are published, etc.

This is what I searching in EDBServer. How can I do it? I cannot point to the ONE OF THE
DATABASES, because I wanna point to all I want to publish!

This is my LAMA question and this is what I want to do as soon as possible - in correct way.

Thanks for your help, and sorry for disturbing!

 dd

Durumdara,

<< So I understand it IF I HAVE ONE APPLICATION.
But here is TWO (or later MORE) APPLICATIONS, TWO SEPARATED DATABASES.  How
to I say to EDBServer: "Hey guy, this database is here, in this directory -
and you must publish it with these users/roles; and here is the another
database in another way - and you must publish it with these (another)
users/roles". >>

The users and roles are not tied to a specific database, they are tied to
the system-defined Configuration database, which is stored in the
configuration file.  Simply set up the users and roles in the Configuration
database using the CREATE USER/ROLE statements, and then set up the
privileges for the database(s) using the GRANT statements:

http://www.elevatesoft.com/edb1sql_grant_privileges.htm
http://www.elevatesoft.com/edb1sql_grant_roles.htm

<< In this program (dbsrvmgr) I can register the databases, I can link the
users to the databases, I can check what databases are published, etc. >>

In the EDB Manager, just connect to the EDB Server using a remote session
and issue the appropriate SQL statements.  As I stated before, there isn't a
separate admin port and administration utility with EDB.  You use the same
connection as with other operations, and you simply need to have
Administrative privileges (be granted the system-defined Administrators
role) to execute the appropriate statements.

<< This is what I searching in EDBServer. How can I do it? I cannot point to
the ONE OF THE DATABASES, because I wanna point to all I want to publish! >>

In EDB you're going to need to set up the privileges for the various
users/roles for each database.   The privileges that are assigned for a
given object or objects is stored in the database catalog for each database.

--
Tim Young
Elevate Software
www.elevatesoft.com