firebird2.5 - Firebird Error while trying to create file, Permission denied -


i'm trying create firebird database in home directory through flamerobin get

*** ibpp::sqlexception *** context: database::create message: isc_dsql_execute_immediate failed  sql message : -902 unsuccessful execution caused system error precludes successful execution of subsequent statements  engine code    : 335544344 engine message : i/o error during "open o_creat" operation file "/home/user/test.fdb" error while trying create file permission denied

even though file chmod 777, file /etc/firebird/2.5/firebird.conf has been modified that:

databaseaccess = full

is set allow access files. service running:

$ ps ax | grep fireb  3909 ?        s      0:00 /usr/sbin/fbguard -daemon -forever -pidfile /var/run/firebird/2.5/fbserver.pid

even though strangely netstat doesn't find connection port:

netstat | grep 3050

and returns empty list.

if connect existing database works, instance connecting 

/var/lib/firebird/2.5/system/help.fdb

correctly shows tables.

i see 2 possible causes:

  1. you mention file chmod 777, implies file exists, creating new database fail.

  2. you trying create (or connect) file in user folder (i assume yours), through firebird server (although fact no server running might indicate isn't case).

i assume firebird server isn't running under account (but under firebird user), , therefore isn't allowed access files in folder.

you need create (or access) database in location firebird user has sufficient access rights, or use local (embedded) connection (although not sure if supported flamerobin.


Comments

Post a Comment

Popular posts from this blog

php - failed to open stream: HTTP request failed! HTTP/1.0 400 Bad Request -

this code i'm using find latitude , longitude of place: function coords($address){ echo $url="http://maps.googleapis.com/maps/api/geocode/json?address=".$address; $json = file_get_contents(urlencode($url)); $data = json_decode($json, true); print_r($data['results'][0]['geometry']['location']['lat']); print_r($data['results'][0]['geometry']['location']['lng']); } however returns warning: failed open stream: http request failed! http/1.0 400 bad request if use above code in simple procedure works fine not in function. note: have tried curl_init()... method produced same result? instead of encoding whole url encode address part. following code work fine $add='jamshoro phase 2'; $url="http://maps.googleapis.com/maps/api/geocode/json?address=".urlencode($add); $json = file_get_contents($url); $data = json_decode($json, true); print_r($data['r...
Read more

command line - Use qwinsta in PowerShell ISE -

i trying use qwinsta , rwinsta powershell code. when try run error "the term 'qwinsta' not recognized name of cmdlet, function, script file, or operable program." need able remotely on several machines without having add .dll's or modules other machines. tried terminal services powershell module, need able put on remote machines , not able that. within powershell ise how run qwinsta? not looking parse information gather it. following code have tried (which had found on site also): function get-tssessions { param( $computername = "localhost" ) qwinsta /server:$computername | #parse output foreach-object { $_.trim() -replace "\s+","," } | #convert objects convertfrom-csv } get-tssessions -computername "localhost" | ft -autosize best have running powershell ise (x86). when run command qwinsta there same error you. of course assuming have 64-bit os. th...
Read more

java - Incorrect order of records in M-M relationship in hibernate -

Image
i have 4 records in bridge table in mysql database. using @manytomany in hibernate, accurate order of employees incorrect incorrect of projects. following required material figure out doing mistake. this source. @entity @table(name="project") public class projectbean { @id @generatedvalue @column(name="project_id") private int projectid; @column(name="title") private string projecttitle; @manytomany(mappedby="projects") private collection<employeebean> employees; public projectbean() { employees = new arraylist<employeebean>(); } //getters & setters } @entity @table(name="employee") public class employeebean { @id @generatedvalue @column(name="employee_id") private int employee_id; @column(name="first_name") private string ...
Read more