Re: [firebird-support] Re: Firebird for a web application

2015-11-25 Thread Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] 
Hi,
i don't know what you want to monitor. There are MON$ tables for monitoring 
FB.We are using IBExpert for handling databases, which also has monitoring 
options (it actually requests data from MON$ tables).There also is performance 
analysis function and a lot more.
What we really do is: create the domains/tables. We write Stored Procedures 
(SP) for every single action (list, edit, delete, ...) and we never let direct 
acces to tables. Communiaction is all done through SPs.After the project is 
finished we analyse every SP (with IBExpert) to see they are performing well 
(there is a nice graph in IBExpert for this).Then we launch it in production.
If new features are developed later, we do them on the development server and 
after testing we synchronize database structure to production server (IBExpert 
can also do this)
About monitoring, we only monitor database health by an automatic 
backup-restore procedure (run from cron script)
As troubleshooting, if something goes wrong usually the daily backup is the key 
point...but we had database corruption only once. Then i bought a IBSurgeon's 
FBfirstAID license for 200 EUR and problem was solved easily.

That's all in short.




 


On Wednesday, November 25, 2015 12:34 PM, "mirco.malag...@ingeniaonline.it 
[firebird-support]"  wrote:
 

     Hello Szilveszter,what is your experience about monitoring, analysis and 
troubleshooting?
Thanks a lot,Mirco
  #yiv9798980123 #yiv9798980123 -- #yiv9798980123ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv9798980123 
#yiv9798980123ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv9798980123 
#yiv9798980123ygrp-mkp #yiv9798980123hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv9798980123 #yiv9798980123ygrp-mkp #yiv9798980123ads 
{margin-bottom:10px;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad 
{padding:0 0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad p 
{margin:0;}#yiv9798980123 #yiv9798980123ygrp-mkp .yiv9798980123ad a 
{color:#ff;text-decoration:none;}#yiv9798980123 #yiv9798980123ygrp-sponsor 
#yiv9798980123ygrp-lc {font-family:Arial;}#yiv9798980123 
#yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc #yiv9798980123hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv9798980123 
#yiv9798980123ygrp-sponsor #yiv9798980123ygrp-lc .yiv9798980123ad 
{margin-bottom:10px;padding:0 0;}#yiv9798980123 #yiv9798980123actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv9798980123 
#yiv9798980123activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv9798980123
 #yiv9798980123activity span {font-weight:700;}#yiv9798980123 
#yiv9798980123activity span:first-child 
{text-transform:uppercase;}#yiv9798980123 #yiv9798980123activity span a 
{color:#5085b6;text-decoration:none;}#yiv9798980123 #yiv9798980123activity span 
span {color:#ff7900;}#yiv9798980123 #yiv9798980123activity span 
.yiv9798980123underline {text-decoration:underline;}#yiv9798980123 
.yiv9798980123attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv9798980123 .yiv9798980123attach div a 
{text-decoration:none;}#yiv9798980123 .yiv9798980123attach img 
{border:none;padding-right:5px;}#yiv9798980123 .yiv9798980123attach label 
{display:block;margin-bottom:5px;}#yiv9798980123 .yiv9798980123attach label a 
{text-decoration:none;}#yiv9798980123 blockquote {margin:0 0 0 
4px;}#yiv9798980123 .yiv9798980123bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv9798980123 
.yiv9798980123bold a {text-decoration:none;}#yiv9798980123 dd.yiv9798980123last 
p a {font-family:Verdana;font-weight:700;}#yiv9798980123 dd.yiv9798980123last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv9798980123 
dd.yiv9798980123last p span.yiv9798980123yshortcuts 
{margin-right:0;}#yiv9798980123 div.yiv9798980123attach-table div div a 
{text-decoration:none;}#yiv9798980123 div.yiv9798980123attach-table 
{width:400px;}#yiv9798980123 div.yiv9798980123file-title a, #yiv9798980123 
div.yiv9798980123file-title a:active, #yiv9798980123 
div.yiv9798980123file-title a:hover, #yiv9798980123 div.yiv9798980123file-title 
a:visited {text-decoration:none;}#yiv9798980123 div.yiv9798980123photo-title a, 
#yiv9798980123 div.yiv9798980123photo-title a:active, #yiv9798980123 
div.yiv9798980123photo-title a:hover, #yiv9798980123 
div.yiv9798980123photo-title a:visited {text-decoration:none;}#yiv9798980123 
div#yiv9798980123ygrp-mlmsg #yiv9798980123ygrp-msg p a 
span.yiv9798980123yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv9798980123 
.yiv9798980123green {color:#628c2a;}#yiv9798980123 .yiv9798980123MsoNormal 
{margin:0 0 0 0;}#yiv9798980123 o {font-size:0;}#yiv9798980123 
#yiv9798980123photos div {float:left;width:72px;}#yiv9798980123 
#yiv9798980123photos div div {border:1px solid

Re: [firebird-support] Cannot Connect to FireBird Database from network workstation

2015-11-25 Thread Nagy Szilveszter nagy_szilvesz...@yahoo.com [firebird-support] 
And also see if selinux is not blocking you.
 


On Monday, November 23, 2015 4:52 PM, "Steve Wiser 
st...@specializedbusinesssoftware.com [firebird-support]" 
 wrote:
 

     Run netstat -an from the command line on the server and make sure port 
3050 is listening (you should see something like 0.0.0.0:3050 as the local 
address and 0.0.0.0:* as the foreign address).

-steve


On Sun, Nov 22, 2015 at 12:11 PM, Jesse McCarty linuxphotographe...@gmail.com 
[firebird-support]  wrote:

     Is that setting changed in the /etc/firebird/firebird.conf file or a 
different configuration file? I have not made any changes to the xinetd 
configuration.JesseOn Nov 22, 2015 12:32 AM, "Mark Rotteveel 
m...@lawinegevaar.nl [firebird-support]"  
wrote:

     On 21-11-2015 20:07, Jesse McCarty linuxphotographe...@gmail.com 
[firebird-support] wrote:
> Production system running Ubuntu 14.04 (64Bit) and Firebird Classic 2.5
> has the database setup and also has two samba file shares setup. The
> Windows 7 machine can see the shares (including the location of the
> database) but the program test connection is always unable to connect to
> the database. I also cannot connect to the Database from a remote
> machine using FlameRobin.

Have you checked that Firebird is listening on the external IP address 
of the server (192.168.254.42 according to the screenshot)? As far as I 
recall the default xinetd config of Firebird Classic on Ubuntu only 
listens on 127.0.0.1 (localhost).

Mark

-- 
Mark Rotteveel
   
   

  #yiv1370204836 #yiv1370204836 -- #yiv1370204836ygrp-mkp {border:1px solid 
#d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv1370204836 
#yiv1370204836ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv1370204836 
#yiv1370204836ygrp-mkp #yiv1370204836hd 
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 
0;}#yiv1370204836 #yiv1370204836ygrp-mkp #yiv1370204836ads 
{margin-bottom:10px;}#yiv1370204836 #yiv1370204836ygrp-mkp .yiv1370204836ad 
{padding:0 0;}#yiv1370204836 #yiv1370204836ygrp-mkp .yiv1370204836ad p 
{margin:0;}#yiv1370204836 #yiv1370204836ygrp-mkp .yiv1370204836ad a 
{color:#ff;text-decoration:none;}#yiv1370204836 #yiv1370204836ygrp-sponsor 
#yiv1370204836ygrp-lc {font-family:Arial;}#yiv1370204836 
#yiv1370204836ygrp-sponsor #yiv1370204836ygrp-lc #yiv1370204836hd {margin:10px 
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv1370204836 
#yiv1370204836ygrp-sponsor #yiv1370204836ygrp-lc .yiv1370204836ad 
{margin-bottom:10px;padding:0 0;}#yiv1370204836 #yiv1370204836actions 
{font-family:Verdana;font-size:11px;padding:10px 0;}#yiv1370204836 
#yiv1370204836activity 
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv1370204836
 #yiv1370204836activity span {font-weight:700;}#yiv1370204836 
#yiv1370204836activity span:first-child 
{text-transform:uppercase;}#yiv1370204836 #yiv1370204836activity span a 
{color:#5085b6;text-decoration:none;}#yiv1370204836 #yiv1370204836activity span 
span {color:#ff7900;}#yiv1370204836 #yiv1370204836activity span 
.yiv1370204836underline {text-decoration:underline;}#yiv1370204836 
.yiv1370204836attach 
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 
0;width:400px;}#yiv1370204836 .yiv1370204836attach div a 
{text-decoration:none;}#yiv1370204836 .yiv1370204836attach img 
{border:none;padding-right:5px;}#yiv1370204836 .yiv1370204836attach label 
{display:block;margin-bottom:5px;}#yiv1370204836 .yiv1370204836attach label a 
{text-decoration:none;}#yiv1370204836 blockquote {margin:0 0 0 
4px;}#yiv1370204836 .yiv1370204836bold 
{font-family:Arial;font-size:13px;font-weight:700;}#yiv1370204836 
.yiv1370204836bold a {text-decoration:none;}#yiv1370204836 dd.yiv1370204836last 
p a {font-family:Verdana;font-weight:700;}#yiv1370204836 dd.yiv1370204836last p 
span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv1370204836 
dd.yiv1370204836last p span.yiv1370204836yshortcuts 
{margin-right:0;}#yiv1370204836 div.yiv1370204836attach-table div div a 
{text-decoration:none;}#yiv1370204836 div.yiv1370204836attach-table 
{width:400px;}#yiv1370204836 div.yiv1370204836file-title a, #yiv1370204836 
div.yiv1370204836file-title a:active, #yiv1370204836 
div.yiv1370204836file-title a:hover, #yiv1370204836 div.yiv1370204836file-title 
a:visited {text-decoration:none;}#yiv1370204836 div.yiv1370204836photo-title a, 
#yiv1370204836 div.yiv1370204836photo-title a:active, #yiv1370204836 
div.yiv1370204836photo-title a:hover, #yiv1370204836 
div.yiv1370204836photo-title a:visited {text-decoration:none;}#yiv1370204836 
div#yiv1370204836ygrp-mlmsg #yiv1370204836ygrp-msg p a 
span.yiv1370204836yshortcuts 
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv1370204836 
.yiv1370204836green {color:#628c2a;}#yiv1370204836 .yiv1370204836MsoNormal 
{margin:0 0 0 0;}#yiv1370204836 o

[firebird-support] Replication SW experience

2015-11-25 Thread Slavomir Skopalik skopa...@elektlabs.cz [firebird-support] 
Hi all,
we are preparing new project with bidirectional replication.

Customer idea is to have master database in head quoter
and slave databases on production plant (to solve network performance 
and availability issues).

Witch replication SW you can recommend for this bidirectional replication?
What is typical issues and weakness of this SW.

Thank you.

Slavek

-- 
Ing. Slavomir Skopalik
Executive Head
Elekt Labs s.r.o.
Collection and evaluation of data from machines and laboratories
by means of system MASA (http://www.elektlabs.cz/m2demo)
-
Address:
Elekt Labs s.r.o.
Chaloupky 158
783 72 Velky Tynec
Czech Republic
---
Mobile: +420 724 207 851
icq:199 118 333
skype:skopaliks
e-mail:skopa...@elektlabs.cz
http://www.elektlabs.cz

Re: [firebird-support] How much percentage of a database space is a table contents taking.

2015-11-25 Thread Alan J Davies alan.dav...@aldis-systems.co.uk [firebird-support] 
Hi Robert, you can do this easily with a tool such as IBExpert. Just run 
Services / Database Statistics and this is the result:

TableName   SizeUsage%
CUSTOMER11,960,320  0.295
PARAMFIL16,384  1   0.000
POSTCODES   3,903,012,864   96.335
POSTCODE_MISSING16,384  1   3.000

I've removed a lot more detail such as number of records, pages, fill 
size etc.

Alan J Davies
Aldis


On 26/11/2015 05:38, rgilland1...@gmail.com [firebird-support] wrote:
> I have a large database.
>
> I have some tables that I believe are unnecessary and are taking up too
> much space.
>
> I need to prove this to the boss. to be allowed to change the system.
>
>
> How can I generate a report that gives me a list of table names and
> percentage of overall database the table is holding.
>
>
> Kind Regards,
>
>
> Robert.
>
>
>

[firebird-support] Re: Firebird for a web application

2015-11-25 Thread mirco.malag...@ingeniaonline.it [firebird-support] 
Hello Szilveszter, what is your experience about monitoring, analysis and 
troubleshooting?
 

 Thanks a lot,
 Mirco

[firebird-support] How much percentage of a database space is a table contents taking.

2015-11-25 Thread rgilland1...@gmail.com [firebird-support] 
I have a large database.
 I have some tables that I believe are unnecessary and are taking up too much 
space.
 I need to prove this to the boss. to be allowed to change the system.
 

 How can I generate a report that gives me a list of table names and percentage 
of overall database the table is holding.
 

 Kind Regards,
 

 Robert.