DeskNow Knowledge Base
 
      
Home Installation and initial setup How do I tell which database is used by DeskNow?

How do I tell which database is used by DeskNow?

To find out which database you're using: open the C:\desknowdata\cfg\Database.cfg (/var/desknowdata/cfg/Database.cfg) file, and look at the Url parameter (NB if you find a line preceded by a #, it is commented out, and should be ignored. The file will contain only one line beginning with 'Url').

  • If the value of the Url parameter contains the word 'postgresql' , then you're using the PostgreSQL database.
  • If the value of the Url parameter contains the word 'mysql' then you're using the MySQL database. 
  • If the value of the Url parameter contains the word 'microsoft', then you're using MS SQL Server (2000 or 2005).
  • If the value of the Url parameter contains the word 'mckoi', then you're using the old embedded database. We recommend migrating data to another database, that will offer much better performance. See this article: /kb/idx/9/132/article/

If you do not have access to the Database.cfg file

Simply open the log.Init file from the day that DeskNow was last started.

You will see a line like 'Database driver: ' and the name of the database driver.

This will confirm you which db driver (and so database) DeskNow is using.

 

 

Email Article Email
Print Article Print


How helpful was this article to you?
Related Articles
article How do I make the DeskNow service start after the database server?
This article applies to Windows environments...

  May 27, 2004    Views: 63917   
article DeskNow and the new default database
Starting with the 3.1 release, DeskNow for...

  May 25, 2006    Views: 21889   
article How do I migrate from the old McKoi database to an external database?
Please note: depending on the amount of data...

  May 25, 2006    Views: 21455   



Powered by Lore :: (c)2003 Pineapple Technologies.