Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10

[marcus mar...@antiphasis.net [firebird-support]]

stevef...@yahoo.com [firebird-support] wrote:
> I've successfully installed Firebird on FreeBSD 10 but can't seem to
> find documentation on the proper way to configure it to run at system
> startup.
>
>
> Somewhere on the www, I found that you should add the following line
> to/etc/rc.conf:
>
>
> firebird_enable="YES"
>
>
> I did this and it seems to work.
>
>
> I also want SuperServer so I added to the same file:
>
>
> firebird_mode = "superserver"
>
>
> This seems to work too.
>
>
> What about the default database directory, permissions etc. What
> commands are required for this?
>
>
> Would be glad if an experienced FreeBSD admin could post a reply.TIA.
Short answer:
default database directory is configured in firebird.conf.

chown -R firebird: /where/your/default/database/folder/points/tp

common knowledge.


>
> 



[Non-text portions of this message have been removed]

Re: [firebird-support] Proper way to configure Firebird startup on FreeBSD 10

[map...@gmail.com [firebird-support]]

database access is not restricted to a dir  

 but it can be configured to be done so with DatabaseAccess 
 

 http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security 
http://www.firebirdsql.org/manual/qsg2-config.html#qsg2-config-security
 

 also firebird runs under firebird user so it needs rw access to that 
user/group 
  


 

[firebird-support] Re: Proper way to configure Firebird startup on FreeBSD 10

[stevef...@yahoo.com [firebird-support]]

Maybe I should re-phrase my original question: 

Is there any recommended documentation somewhere about the "secure & 
recommended" way to start Firebird service and all configuration after 
installation?

Re: [firebird-support] Configuring Firebird for high transaction through put

[Alexey Kovyazin a...@ib-aid.com [firebird-support]]

Hi Russel,

Good starting point could be our optimized configuration files:
http://ib-aid.com/en/optimized-firebird-configuration/

Regards,
Alexey Kovyazin
IBSurgeon


What type of access (read vs. write mix) are you expecting? Mainly write

What mix of small vs. large queries are you expecting? the queries are 
based on single order ids (primary keys) and about 4 tables involved


How many simultaneous connections are you expecting? that's the big 
question we are looking at a range of 1400 - 13000 orders per hour


What page cache number and page size have you tested with? page 
buffers: 2048; page size: 4096


What type of HDD config and how much RAM will the server have? all on 
virtual. 2 HDD and 4GB ram - can increase to 16GB


What OS? Windows server 2012

*Russell Weetch
*SMXi – /the heartbeat of your business/

*T: *+44 (0)20 7100 6010 *M:*+44 (0)7879 816084 *W:*http://smxi.com 
 *E:*russ...@smxi.com 


Linked In  
 
 
 



Systematic Marketing, 429-433 Pinner Road, Harrow HA1 4HN, United Kingdom

SMX, SMXi, Masque® and Masque Arts are trading names and trade marks 
of Systematic Marketing Ltd


Registration No. 2472380 England / VAT 541 2972 49

This email and any files transmitted with it are confidential and 
intended solely for the use of the individual or entity to whom they 
are addressed. If you have received this email in error, please notify 
me immediately. If you are not the intended recipient of this email, 
you should not copy it for any purpose, or disclose its contents to 
any other person.



On 11 September 2014 16:35, 'Leyne, Sean' s...@broadviewsoftware.com 
[firebird-support] > wrote:




> We are having to gear up one of our web apps for a potential
spike in access
> next month and have been running some load testing. Overall it
seems not
> to bad but the database is a bit of a bottleneck or so it seems.
>
> Without turning off forced rights what else should we look at?
We have
> increased core utilisation. Does page size have an impact? Any
ideas would
> be welcomed. Are there any documents anywhere that cover this?

What type of access (read vs. write mix) are you expecting?

What mix of small vs. large queries are you expecting?

How many simultaneous connections are you expecting?

What page cache number and page size have you tested with?

What type of HDD config and how much RAM will the server have?

What OS?


Sean

[firebird-support] Re: Configuring Firebird for high transaction throughput

[Aage Frank Johansen aagjo...@online.no [firebird-support]]

<<
How many simultaneous connections are you expecting? that's the big 
question we are looking at a range of 1400 - 13000 orders per hour
 >>
This does not look like much of a challenge - but I don't know the 
nature of your orders processing!
Checking your SQL could be a good thing - I'm thinking of indexes.

<<
What page cache number and page size have you tested with? page 
buffers: 2048; page size: 4096
 >>
If you are using SuperServer: You are using about 8MB (out of your 
4GB RAM) if there is just one database.  Increase the 2K page buffers 
to 8K (or maybe even more).  The 4KB page size may be ok, but test 
with 8KB as well.  Maybe you could benefit from even higher numbers.
If you are using ClassicServer you will have to think about number of 
users (each with their own cache).

And, think twice before turning ForcedWrites OFF.


-- 
Aage J.

[firebird-support] Ran "successful" install on Mac, but nothing is installed.

[a...@melvin.com [firebird-support]]

Please help. This is my first time downloading Firebird. I downloaded from
http://www.firebirdsql.org/en/firebird-2-5/#MacOSX

and the version I got was 
FirebirdSS-2.5.3-26778-x86_64.pkg.zip

Twice I have run the installer, and each time the installation was 
"successful," yet nothing called "Firebird" is under Applications or anywhere 
else on my computer, other than the installer.

I am using Mac OSX 10.6 (Snow Leopard) on a Core 2 Duo (64-bit) Macbook from 
late 2007.

[firebird-support] SQL Error -104

[Johannes Grimm johannes.g...@gmail.com [firebird-support]]

Hi folks,


i just don't get it what the heck i'm doing wrong. I would like to have 
something like that:


select ba.artno
from mov_invoices mi, bas_articles ba
where mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00'
and case
when (ba.artno like '90__') then '9000'
when (ba.artno like '80__') then '8000'
when (ba.artno like '70__') then '7000'
when (ba.artno like '60__') then '6000'
when (ba.artno like '50__') then '5000'
when (ba.artno like '40__') then '4000'
when (ba.artno like '30__') then '3000'
when (ba.artno like '20__') then '2000'
when (ba.artno like '10__') then '1000'
end


any ideas somebody?


greets johannes

[firebird-support] Unhandled exception at 0x777B03B8 (kernel32.dll) in fsql.exe: 0xC0000005: Access violation writing location 0x00030FFC

[mwaqassha...@hotmail.com [firebird-support]]

Dear All,
 Facing this issue when fsql.exe is runing, Please help to resolve 
this issue.
 

 Unhandled exception at 0x777B03B8 (kernel32.dll) in fsql.exe: 0xC005: 
Access violation writing location 0x00030FFC.
 [8/26/2014 6:00:45 PM] Rehman Khaleel: 6.1.7601.17932 (win7sp1_gdr.120820-0419)
 [8/26/2014 6:03:07 PM] Rehman Khaleel: ---
 [8/26/2014 6:03:08 PM] Rehman Khaleel: Faulting application name: fsql.exe, 
version: 0.0.0.0, time stamp: 0x2a425e19
 Faulting module name: KERNELBASE.dll, version: 6.1.7601.17932, time stamp: 
0x503275ba
 Exception code: 0x0eedfade
 Fault offset: 0xd3cf
 Faulting process id: 0x19a0
 Faulting application start time: 0x01cfc12d53eb904d
 Faulting application path: C:\Program Files\Innovative Saudia\Quran\fsql.exe
 Faulting module path: C:\Windows\system32\KERNELBASE.dll
 Report Id: 9631320e-2d20-11e4-a64c-e06995251596
 [8/26/2014 6:04:29 PM] Rehman Khaleel: Failed to create restore point (Process 
= C:\Windows\system32\msiexec.exe /V; Description = Installed Quran; Error = 
0x80070422).
 
 

 

RE: [firebird-support] SQL Error -104

['Leyne, Sean' s...@broadviewsoftware.com [firebird-support]]

> i just don't get it what the heck i'm doing wrong. I would like to have
> something like that:
> 
> select ba.artno
> from mov_invoices mi, bas_articles ba
> where mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00'
> and case
> when (ba.artno like '90__') then '9000'
> when (ba.artno like '80__') then '8000'
> when (ba.artno like '70__') then '7000'
> when (ba.artno like '60__') then '6000'
> when (ba.artno like '50__') then '5000'
> when (ba.artno like '40__') then '4000'
> when (ba.artno like '30__') then '3000'
> when (ba.artno like '20__') then '2000'
> when (ba.artno like '10__') then '1000'
> end

Try

select 
  case
  when (ba.artno like '90%') then '9000'
  when (ba.artno like '80%') then '8000'
  when (ba.artno like '70%') then '7000'
  when (ba.artno like '60%') then '6000'
  when (ba.artno like '50%') then '5000'
  when (ba.artno like '40%') then '4000'
  when (ba.artno like '30%') then '3000'
  when (ba.artno like '20%') then '2000'
  when (ba.artno like '10%') then '1000'
end
  as ba.artno
from mov_invoices mi, bas_articles ba
where 
  mi.invdate between '2014-05-01 00:00:00' and '2014-08-01 00:00:00'


Sean