Re: [firebird-support] Strange behaviour on Linux
On 08/12/17 04:48, dam...@wxs.nl [firebird-support] wrote: Hello, When I have the following directory structure on a Linux server: /a/b/c and I want to create a database /a/b/c/test.fdb with gbak, the access rights of directory "c" must be rwx (readable, writeable, executable). Also the access rights to directory "a" and "b" must be r_x (readable, executable). The same with use of isql. My question is why? There might be some (unknown to me) reason that directory "c" must be executable, but why also directory "a" and "b"? Can somebody explain this to me? I don't understand it. That is normal UNIX directory permission behaviour. You must have execute permission to make any access to the directory. You generally don't need read access (which is only required to list the files, not to access them). It is not specific to Linux or Firebird. Try it with less and a text file... Hamish
[firebird-support] Strange behaviour on Linux
Hi Roy, the x flag is needed for file execution and directory access. While r says you can read the directory x says you can access it. Regards, Martin
Re: [firebird-support] Problem with CONTAINING and COLLATE
07.12.2017 18:46, Gabor Boros mlngl...@bgss.hu [firebird-support] wrote: > Why does the connection charset count? Because you are sending queries in connection charset. And string literals in them are in connection charset. Because of that your 'x' cannot have COLLATE PXW_HUNDC. -- 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] Strange behaviour on Linux
Hello, When I have the following directory structure on a Linux server: /a/b/c and I want to create a database /a/b/c/test.fdb with gbak, the access rights of directory "c" must be rwx (readable, writeable, executable). Also the access rights to directory "a" and "b" must be r_x (readable, executable). The same with use of isql. My question is why? There might be some (unknown to me) reason that directory "c" must be executable, but why also directory "a" and "b"? Can somebody explain this to me? I don't understand it. With kind regards, Roy Damman This applies to 2.5.x but I think also to 3.x.
[firebird-support] Problem with CONTAINING and COLLATE
Hi All, I have a database with DEFAULT CHARACTER SET WIN1250 COLLATION PXW_HUN and a table in it: CREATE TABLE TABLE_1 (NEV VARCHAR(60) CHARACTER SET WIN1250 COLLATE PXW_HUN); Connect with ISQL: isql 1.2.3.4:MYDB -charset UTF8 -user myadmin -password mypasswd Execute this: SELECT * FROM TABLE_1 WHERE NAME CONTAINING 'x' COLLATE PXW_HUNDC; Got this error: Statement failed, SQLSTATE = 22021 Dynamic SQL Error -SQL error code = -204 -COLLATION PXW_HUNDC for CHARACTER SET UTF8 is not defined If connect with isql 1.2.3.4:MYDB -user myadmin -password mypasswd got this: Statement failed, SQLSTATE = 22021 Dynamic SQL Error -SQL error code = -204 -COLLATION PXW_HUNDC for CHARACTER SET NONE is not defined Why does the connection charset count? I tried with 3.0(.3.32850 snapshot). Gabor ++ 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] Mapping
I have a database which is its own security database. I now want users in the default security database to have access. So I created a mapping: create global mapping TrustedUsers using plugin Srp in "security.db" from any user to user This is based on the example the example in the release notes. But users in the default database are unable to connect. Is there another step? Have I misunderstood something? Dave