Re: [firebird-support] General: connect firebird server from local network

2016-04-21 Thread InField.au infield...@outlook.com [firebird-support]
Dear Helen,


Thanks for your answer.
I will read through Quick Start again.




Best regards,


James


Original Message
Sender:Helen Borrie hele...@iinet.net.au 
[firebird-support]firebird-support@yahoogroups.com
Recipient:firebird-supportfirebird-supp...@yahoogroups.com
Date:Friday, Apr 22, 2016 04:13
Subject:Re: [firebird-support] General: connect firebird server from local 
network



Friday, April 22, 2016, 12:57:31 AM, InField.au wrote:
 
  I know my question is very naive, but I spent long time to search
  through internet and can’t get answer.
 
 Why search the internet when you can get the information from the docs
 that ship in the download kits? Look in the \docs subdirectory of
 your installation for the Quick Start Guide. If you want the html
 version of the docs on-line, they are all in Documentation area of the
 Firebird website.
 
  1. Firebird Server runs at PC-A (eg. IP: 192.168.0.10). And
  Database file is copied in this PC.
 
 Yes; although if you are working with a new release of Firebird, the
 database should be backed up with gbak -backup on the old server
 version and that backup restored with gbak -create on the new.
 
  2. DB-application will run at PC-B. Both are linked to same network.
 
  3. Modified aliases.conf to configure Database file for Firebird Server.
 
 Yes.
  Tested aliases.conf by running DB-application in PC-A, it can access Database 
file properly.
 
  4. Copied fbclient.dll  firebird.conf into same folder as DB-application in 
PC-B.
 
 fbclient.dll yes. Firebird.conf no.
 
  As my understand, my application should work like this:
 
  DB-Application @ PC-B
 - fbclient.dll
 - Pickup Firebird Server IP/Name from firebird.conf
 
 No. Firebird.conf and aliases.conf are components of the server host,
 not of the client. Fbclient.dll is a component of the client
 application layer. It contains the parameters for the API functions
 and does not read firebird.conf or aliases.conf itself.
 
 A subsystem of the server, known as "y-valve", handles the connection
 request and processes the attachment based on the parameters supplied
 by the client application via fbclient.dll. Those parameters include
 the host name or IP address of the server and either the path to the
 database file AS SEEN BY BY THE HOST or, optionally (and better) the
 alias configured for it in aliases.conf. See the Quick Start Guide
 for the proper info about the connection string format for the network
 protocol you want to use.
 
  My question is:
 
  How to configure firebird.conf (or another config file?) to let
  fbclinet.dll know where Firebird Server is?
 
 You'll now realise that this is not what you do. Clients connect to
 the server: the server does not reach out and connect to a client.
 One Firebird server can manage multiple databases and hundreds of
 clients from all kinds of environments.
 
 The client application must be able to find the correct fbclient.dll
 locally. On a Windows client, the library needs to be located either
 in the same directory as the application's executables or in the
 system path in a location that is visible to the application.
 
 --HB
 



[firebird-support] Re: Database Corrupt ?

2016-04-21 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com,  wrote :
 
 Your glibc seems ok (a bit outdated, but not critical)

 > 4. MemTotal: 7911216 kB (8 GB)
 
  I mean - could you run memory test to ensure your RAM is ok ? 
Random corruptions of different databases could be sign of hardware problem 
(not necessary, but
possible)

 > 5. Here is a part of my less /proc/cpuinfo - Is it weird that I have 4 GHz 
 > but the cpu MHz just 800 Mhz ?

  It is OK, while CPU is not 100% buzy

Regards,
Vlad




Re: [firebird-support] General: connect firebird server from local network

2016-04-21 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Friday, April 22, 2016, 12:57:31 AM, InField.au wrote:

> I know my question is very naive, but I spent long time to search
> through internet and can’t get answer.

Why search the internet when you can get the information from the docs
that ship in the download kits?  Look in the \docs subdirectory of
your installation for the Quick Start Guide.  If you want the html
version of the docs on-line, they are all in Documentation area of the
Firebird website.

> 1. Firebird Server runs at PC-A (eg. IP: 192.168.0.10). And
> Database file is copied in this PC.

Yes;  although if you are working with a new release of Firebird, the
database should be backed up with gbak -backup on the old server
version and that backup restored with gbak -create on the new.

> 2. DB-application will run at PC-B. Both are linked to same network.

> 3. Modified aliases.conf to configure Database file for Firebird Server.

Yes.
> Tested aliases.conf by running DB-application in PC-A, it can access 
> Database file properly.

> 4. Copied fbclient.dll & firebird.conf into same folder as DB-application in 
> PC-B.

fbclient.dll yes.  Firebird.conf no.


> As my understand, my application should work like this:


>  DB-Application @ PC-B
->> fbclient.dll
->> Pickup Firebird Server IP/Name from firebird.conf

No. Firebird.conf and aliases.conf are components of the server host,
not of the client. Fbclient.dll is a component of the client
application layer.  It contains the parameters for the API functions
and does not read firebird.conf or aliases.conf itself.

A subsystem of the server, known as "y-valve", handles the connection
request and processes the attachment based on the parameters supplied
by the client application via fbclient.dll.  Those parameters include
the host name or IP address of the server and either the path to the
database file AS SEEN BY BY THE HOST or, optionally (and better) the
alias configured for it in aliases.conf.  See the Quick Start Guide
for the proper info about the connection string format for the network
protocol you want to use.

> My question is:

> How to configure firebird.conf (or another config file?) to let
> fbclinet.dll know where Firebird Server is?

You'll now realise that this is not what you do.  Clients connect to
the server:  the server does not reach out and connect to a client.
One Firebird server can manage multiple databases and hundreds of
clients from all kinds of environments.

The client application must be able to find the correct fbclient.dll
locally.  On a Windows client, the library needs to be located either
in the same directory as the application's executables or in the
system path in a location that is visible to the application.

--HB



Re: [firebird-support] General: connect firebird server from local network

2016-04-21 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
21.04.2016 14:57, InField.au infield...@outlook.com [firebird-support] wrote:
> As my understand, my application should work like this:

   No. Read Quick Start Guide about connection strings.

-- 
   WBR, SD.






++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ 

++


Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/



[firebird-support] General: connect firebird server from local network

2016-04-21 Thread InField.au infield...@outlook.com [firebird-support]
Dear Madam/Gentleman,


I know my question is very naive, but I spent long time to search through 
internet and can’t get answer.


1. Firebird Server runs at PC-A (eg. IP: 192.168.0.10). And Database file is 
copied in this PC.
2. DB-application will run at PC-B. Both are linked to same network.
3. Modifiedaliases.conf to configure Database file for Firebird Server.
  Tested aliases.conf by running DB-application in PC-A, it can access Database 
file properly.
4. Copied fbclient.dll  firebird.conf into same folder as DB-application in 
PC-B.


As my understand, my application should work like this:


  DB-Application @ PC-B
- fbclient.dll
- Pickup Firebird Server IP/Name from firebird.conf
- Firebird Server @ PC-A
- Pickup Database file alias from aliases.conf
- Databasefile.fdb


My question is:
How to configure firebird.conf (or another config file?) to let fbclinet.dll 
know where Firebird Server is?


Thanks.




Best regards,


James