Re: [firebird-support] Implicit path for Database
On 9/2/2017 11:49 AM, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] wrote: > 01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: >> Will be good also a way to specify the path where the databses are store >> if I not specify a path in connect string. > In firebird.conf set DatabaseAccess to Restrict. Databases will be > created in the first > directory in list. > > That really works. Thanks. --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus ++ 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/
Re: [firebird-support] Implicit path for Database
01.09.2017 23:35, Neagu nea...@gmail.com [firebird-support] wrote: > Will be good also a way to specify the path where the databses are store > if I not specify a path in connect string. In firebird.conf set DatabaseAccess to Restrict. Databases will be created in the first directory in list. -- 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/
Re: [firebird-support] Implicit path for Database
Saturday, September 2, 2017, 9:35:20 AM, Neagu wrote: > In databases.conf I can put the lists of alias of Known databases, but I > look for a way to specify only the alias of path where the databases are > store. > Now, If I not specify a path in connect string, the databases is search > in C:\Windows\System32 And, on POSIX, it will search in the current working directory (cwd). You can (and should) configure which directories the server is allowed to search for databases to connect to. The parameter for this, in firebird.conf, is DatabaseAccess. By default, it is set to 'Full', meaning the server can accept connections to databases anywhere. The alternative settings are: None. This takes no arguments. The server can connect only to databases whose full paths are specified in databases.conf. Restrict. This takes a list of one or more filesystem paths where the server may connect to databases located there. If you have databases in sub-directories of that path, you must list each path separately. Use semicolons to separate multiple paths. > Will be good also a way to specify the path where the databses are store > if I not specify a path in connect string. Something like this is possible, as long as you want to store the database in Firebird's root directory *AND* that path is specified as a parameter of DatabaseAccess Restrict (or DatabaseAccess FULL is the current setting). In general, though, storing a database amongst the software components is not a brilliant idea. Read the built-in documentation for DatabaseAccess in firebird.conf. Did you know that you can create an alias for a database that does not yet exist? For example. myNewDB = d:\databases\development.fdb After that is saved, you can create a new database named 'development.fdb' in d:\databases by passing the alias as the database name parameter in your CREATE DATABASE statement. In this case, your DatabaseAccess configuration can be NONE (because the database is known through databases.conf) or FULL (server does not care where a database is located). RESTRICT will work, too, if d:\databases is included in the list of allowed directories. Don't forget that any changes you do in firebird.conf will take effect only after restarting the Firebird service. Helen
[firebird-support] Implicit path for Database
Hello, In databases.conf I can put the lists of alias of Known databases, but I look for a way to specify only the alias of path where the databases are store. Will be good also a way to specify the path where the databses are store if I not specify a path in connect string. Now, If I not specify a path in connect string, the databases is search in C:\Windows\System32 Thanks, Neagu --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus