<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Seriously, I can't understand. I'm sure is something silly I can't see, but.............</div><div><br></div><div><div>galilea:testfb glpunzi$ ls -all /Library/Frameworks/Firebird.framework/Versions/Current/Resources/examples/empbuild/</div><div>total 2120</div><div>drwxr-xr-x 3 firebird firebird 102 4 jun 2008 .</div><div>drwxr-xr-x 10 firebird firebird 340 4 jun 2008 ..</div><div>-rw-r--r-- 1 firebird firebird 1085440 2 abr 21:03 employee.fdb</div><div>galilea:testfb glpunzi$ </div><div><br></div><div>And I can open 'employee' from Flamerobin and from Lazarus without problems.</div><div><br></div><div><div>under a folder on my Documents User folder.</div><div><br></div><div><div>galilea:testfb glpunzi$ ls -all</div><div>total 1360</div><div>drwxr-xr-x 3 glpunzi staff 102 2 abr 20:48 .</div><div>drwx------+ 37 glpunzi staff 1258 2 abr 21:01 ..</div><div>-rw-rw---- 1 firebird firebird 696320 2 abr 20:55 test.fdb</div><div><br></div><div>I created this DB from isql with my user. once created, with some data (and after see I can't connect to it) I did:</div><div><div>sudo chown -R firebird:firebird test.fdb </div><div><br></div></div><div>And still without connection to it. From lazarus, flamerobin and isql, the same error.</div><div>From isql:</div><div><div>Statement failed, SQLCODE = -902</div><div>I/O error for file "test.fdb"</div><div>-Error while trying to open file</div><div>-Permission denied</div><div><br></div><div>from flamerobin: <span class="Apple-style-span" style="font-family: Tahoma; font-size: 11px; white-space: pre; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px; "><a href="http://img183.imageshack.us/img183/4519/flamerobinscreensnapz00.png">http://img183.imageshack.us/img183/4519/flamerobinscreensnapz00.png</a></span></div><div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 11px; white-space: pre; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><br></span></font></div><div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 11px; white-space: pre; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;">If I revert the chown to:</span></font></div><div><font class="Apple-style-span" face="Tahoma" size="3"><span class="Apple-style-span" style="font-size: 11px; white-space: pre; -webkit-border-horizontal-spacing: 2px; -webkit-border-vertical-spacing: 2px;"><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; white-space: normal; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; "><div>sudo chown -R glpunzi test.fdb </div><div><br></div></span></span></font></div></div><div>Then, isql works, but still without connceting flamerobin or Lazarus.</div><div><br></div><div>Some idea?</div><div><br></div><div>Cheers.</div><div><br></div></div></div></div><div><br></div><br><div><div>El 02/04/2009, a las 16:54, Graeme Geldenhuys escribió:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>On Thu, Apr 2, 2009 at 4:08 PM, Giuseppe Luigi Punzi<br><<a href="mailto:glpunzi@lordzealon.com">glpunzi@lordzealon.com</a>> wrote:<br><blockquote type="cite">I'm starting some projects, and I will develop them from OSX and<br></blockquote><blockquote type="cite">Windows. On windows, seems all ok, but from OSX I'm getting some<br></blockquote><blockquote type="cite">troubles thath stops me now.<br></blockquote><br>It's because Windows has crappy security. :-)<br><br><blockquote type="cite">Now, I can't open any database from Lazarus/SQLdb nor Flamerobin,<br></blockquote><blockquote type="cite">getting an error about 'Permission Denied'.<br></blockquote><br>In Firebird config file (/etc/firebird/2.0/firebird.conf under Linux)<br>you can setup what directories are allow do have database in. By<br>default I think not all directories are allowed. It's the<br>"DatabaseAccess" setting.<br><br>Also you need to be sure about your User and Group access writes to<br>the database file (*.fdb) itself and the write access to the directory<br>containing the *.fdb files.<br><br><blockquote type="cite">I'm missing something? Is better to install Classic Server instead<br></blockquote><blockquote type="cite">SuperServer? If so, is enough deleting Firebird.Framework directory?<br></blockquote><br>Your problem has nothing to do with Classic vs Super Server installs.<br>It's a permission issue - that's all.<br><br><br>Regards,<br> - Graeme -<br><br><br>_______________________________________________<br>fpGUI - a cross-platform Free Pascal GUI toolkit<br><a href="http://opensoft.homeip.net/fpgui/">http://opensoft.homeip.net/fpgui/</a><br>_______________________________________________<br>Lazarus mailing list<br>Lazarus@lazarus.freepascal.org<br>http://www.lazarus.freepascal.org/mailman/listinfo/lazarus<br></div></blockquote></div><br></body></html>