Jump to content

delete and setup a new database


rene
 Share

Recommended Posts

  • 3 weeks later...

Hey Murat I tried again to completly reinstall daminion, but while installing I get the error message, that the user account postgres already exists and I need to enter the password. if I enter postgres I get the error that the password is wrong.

 

I deleted everything else. I searched the computer for "postgres" and deleted everything, restarted the computer, But I still get this error message.

 

Any Idea what do do

 

 

thanks rene

Link to comment
Share on other sites

  • 4 months later...

I've recorded a sample video explaining how to delete the shared (PostgreSQL) database and create a new one.

 

Video_2013-04-28_170249.wmv

 

 

Hi Murat,

 

Sorry if I'm repeating a previous post (I cannot recall if I wrote about it or not).

 

It seems this process to create a new catalog in Daminion Server is not working anymore :sorry2:

 

I tried it back in May and it worked perfectly, then, I think around August I tried it again and it didn't work but I guess I was able to find what I was looking for. Am I probably missing something?

 

Thanks!

Link to comment
Share on other sites

Do you see any error messages?

 

Please try 902 build.

 

No error messages.

 

I tried it with build 902 and what worked is to only rename the current NetCatalog database and don't manually create a new one. After starting Daminion Server it creates the NetCatalog database and populate it with the data structure which is even better (it saves a step :))

 

Thanks!

Link to comment
Share on other sites

  • 8 months later...

No error messages.

 

I tried it with build 902 and what worked is to only rename the current NetCatalog database and don't manually create a new one. After starting Daminion Server it creates the NetCatalog database and populate it with the data structure which is even better (it saves a step :))

 

Thanks!

 

Hi there, just an update, I'm on build 1045 and tried this process to create a new catalog but it seems it doesn't work anymore:

 

- if I rename the existing NetCatalog db and start Daminion Server, I get this errors logged:

 

2014-07-05 03:11:15,750 [7] DEBUG PicaJet.Daminion.Service.WCF.CatalogServiceHost [(null)] - host_Opened
2014-07-05 03:11:15,800 [7] DEBUG PicaJet.Daminion.Service.WCF.FileTransferServiceHost [(null)] - host_Opening
2014-07-05 03:11:15,815 [7] DEBUG PicaJet.Daminion.Service.WCF.FileTransferServiceHost [(null)] - host_Opened
2014-07-05 03:11:15,815 [7] DEBUG Service.WCF.ServerService.DaminionService [(null)] - Done creating hosting: 07/05/2014 03:11:15
2014-07-05 03:11:16,536 [10] DEBUG PicaJet.Daminion.Service.Utils.UniversalCatalogService [(null)] - Program version: Daminion Server 3.0.0 (build 994) 
2014-07-05 03:11:16,586 [10] DEBUG PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand [(null)] - Start: (0)
2014-07-05 03:11:16,606 [10] ERROR PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand [(null)] - Error: (0)
Npgsql.NpgsqlException:
no existe la base de datos ?NetCatalog?
Severity: FATAL
Code: 3D000
  at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 693
  at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum) in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 326
  at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectedState.cs:line 52
  at Npgsql.NpgsqlConnector.Open() in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnector.cs:line 707
  at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 447
  at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 252
  at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 197
  at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 181
  at Npgsql.NpgsqlConnection.Open() in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnection.cs:line 536
  at PicaJet.Daminion.Service.DbFactory.CreateConnection(String connectionString) in c:\DaminionAuto\Code\Service.DB\DbFactory.cs:line 28
  at PicaJet.Daminion.Service.ConnectionManager.GetConnection(Int32 connectionTimeout) in c:\DaminionAuto\Code\Service.DB\ConnectionManager.cs:line 59
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 107
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 50
2014-07-05 03:11:16,631 [10] DEBUG PicaJet.Daminion.Service.Utils.InitWatchedFoldersManagerCommand [(null)] - Start: (1)
2014-07-05 03:11:16,646 [10] ERROR PicaJet.Daminion.Service.Utils.InitWatchedFoldersManagerCommand [(null)] - Error: (1)
Npgsql.NpgsqlException:
no existe la base de datos ?NetCatalog?
Severity: FATAL
Code: 3D000
  at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 693
  at Npgsql.NpgsqlState.IterateThroughAllResponses(IEnumerable`1 ienum) in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 326
  at Npgsql.NpgsqlConnectedState.Startup(NpgsqlConnector context) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectedState.cs:line 52
  at Npgsql.NpgsqlConnector.Open() in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnector.cs:line 707
  at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 447
  at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 252
  at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 197
  at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection) in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnectorPool.cs:line 181
  at Npgsql.NpgsqlConnection.Open() in C:\projects\Npgsql2\src\Npgsql\NpgsqlConnection.cs:line 536
  at PicaJet.Daminion.Service.DbFactory.CreateConnection(String connectionString) in c:\DaminionAuto\Code\Service.DB\DbFactory.cs:line 28
  at PicaJet.Daminion.Service.ConnectionManager.GetConnection() in c:\DaminionAuto\Code\Service.DB\ConnectionManager.cs:line 32
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 103
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 50

 

 

- if I create an empty NetCatalog database in postgre and start Daminion Server, I get this:

 

2014-07-05 03:29:30,604 [10] DEBUG PicaJet.Daminion.Service.Utils.UniversalCatalogService [(null)] - Program version: Daminion Server 3.0.0 (build 994) 
2014-07-05 03:29:30,649 [10] DEBUG PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand [(null)] - Start: (3)
2014-07-05 03:29:30,668 [10] DEBUG SQL [(null)] - select Ver from Settings ()
2014-07-05 03:29:30,673 [10] DEBUG SQL [(null)] - BEGIN TRANSACTION;
ALTER TABLE Settings ADD Ver TEXT;
UPDATE Settings SET Ver = @Version;
COMMIT; (@Version=0)
2014-07-05 03:29:30,678 [10] ERROR PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand [(null)] - Error: (3)
Npgsql.NpgsqlException:
no existe la relación «settings»
Severity: ERROR
Code: 42P01
  at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 850
  at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1173
  at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1191
  at Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1377
  at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1040
  at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 609
  at Npgsql.NpgsqlCommand.ExecuteNonQuery() in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 512
  at PicaJet.Daminion.Service.DbCommandWrapper.ExecuteNonQuery() in c:\DaminionAuto\Code\Service.DB\DbCommandWrapper.cs:line 41
  at PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand.UnknownVer(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\CheckValidateAndUpdateCommand.cs:line 485
  at PicaJet.Daminion.Service.Utils.CheckValidateAndUpdateCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Command\CheckValidateAndUpdateCommand.cs:line 51
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 109
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 50
2014-07-05 03:29:30,685 [10] DEBUG PicaJet.Daminion.Service.Utils.InitWatchedFoldersManagerCommand [(null)] - Start: (4)
2014-07-05 03:29:30,705 [10] DEBUG SQL [(null)] - select ID, Guid, ValuesTableName, FileValuesField, FileValuesTable, DataType, GuiType, Caption, Description, UniqueValue, AllowGroups, IsAllowChangeParent, ExcludeFromUI, PropertyInspectorTitleAlign, CanAssign, MappedInDatabaseAsMultipleValues, IsMultiplyValues, ReadOnly, MaxLevelHierarchy, Units, Multiplier, TagGroupGuid from IndexedTags ()
2014-07-05 03:29:30,708 [10] ERROR PicaJet.Daminion.Service.Utils.InitWatchedFoldersManagerCommand [(null)] - Error: (4)
Npgsql.NpgsqlException:
no existe la relación «indexedtags»
Severity: ERROR
Code: 42P01
  at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext() in C:\projects\Npgsql2\src\Npgsql\NpgsqlState.cs:line 850
  at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1173
  at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1191
  at Npgsql.ForwardsOnlyDataReader.NextResult() in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1377
  at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError) in C:\projects\Npgsql2\src\Npgsql\NpgsqlDataReader.cs:line 1040
  at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 609
  at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 588
  at Npgsql.NpgsqlCommand.ExecuteDbDataReader(CommandBehavior behavior) in C:\projects\Npgsql2\src\Npgsql\NpgsqlCommand.cs:line 538
  at System.Data.Common.DbCommand.ExecuteReader()
  at PicaJet.Daminion.Service.DbCommandWrapper.ExecuteReader() in c:\DaminionAuto\Code\Service.DB\DbCommandWrapper.cs:line 47
  at PicaJet.Daminion.Service.DbCommandHelper.GetList[T](IDbCommand command, SelectDelegate selectDelegate) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 29
  at PicaJet.Daminion.Service.DbCommandHelper.GetList[T](IDbCommand command, IMapper mapper) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 54
  at PicaJet.Daminion.Service.DbCommandHelper.GetList[T](DbConnection connection) in c:\DaminionAuto\Code\Service.DB\DbCommandHelper.cs:line 70
  at PicaJet.Daminion.Service.Utils.TagsWorkerDbHelper.GetIndexedTags(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\Helper\TagsWorkerDbHelper.cs:line 33
  at PicaJet.Daminion.Service.Utils.AnotherTagsWorker.GetIndexedTag(Guid guid, DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\AnotherTagsWorker.cs:line 133
  at PicaJet.Daminion.Service.Utils.InitWatchedFoldersManagerCommand.Start(DbConnection connection) in c:\DaminionAuto\Code\Service.Utils.Uni\SmartPool\InitWatchedFoldersManagerCommand.cs:line 17
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Start() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 109
  at PicaJet.Daminion.Service.Utils.DatabaseCommand.Process() in c:\DaminionAuto\Code\Service.Utils.Uni\DatabaseCommand.cs:line 50
2014-07-05 03:29:30,714 [8] DEBUG PicaJet.Daminion.Service.WCF.CatalogServiceHost [(null)] - host_Opened
2014-07-05 03:29:30,732 [8] DEBUG PicaJet.Daminion.Service.WCF.FileTransferServiceHost [(null)] - host_Opening
2014-07-05 03:29:30,742 [8] DEBUG PicaJet.Daminion.Service.WCF.FileTransferServiceHost [(null)] - host_Opened
2014-07-05 03:29:30,742 [8] DEBUG Service.WCF.ServerService.DaminionService [(null)] - Done creating hosting: 07/05/2014 03:29:30

 

In summary, I couldn't find a way to create an empty server catalog without doing it from install. Hopefully is something that could come back in the future, it is really useful when testing new builds.

 

Thanks!

Link to comment
Share on other sites

To create an empty Daminion Server catalog (NetCatalog) please follow the next steps:

 

- Launch the Daminion Server admin panel and stop the Daminion Service

- Launch the PgAdmin and rename the existing NetCatalog to ~NetCatalog

- Locate and launch the this console service:

c:\Program Files (x86)\Daminion Software\Daminion Server\Daminion.Server.exe

- Close the console

- Launch the Admin panel and press the Start button

Link to comment
Share on other sites

To create an empty Daminion Server catalog (NetCatalog) please follow the next steps:

As I understand, all the data of the old catalog (which was renamed to ~NetCatalog) will remain? Can I just remove it in PGAdmin?

 

Tried to remove and it works. Just to say.

Edited by montonero
Link to comment
Share on other sites

To create an empty Daminion Server catalog (NetCatalog) please follow the next steps:

 

- Launch the Daminion Server admin panel and stop the Daminion Service

- Launch the PgAdmin and rename the existing NetCatalog to ~NetCatalog

- Locate and launch the this console service:

c:\Program Files (x86)\Daminion Software\Daminion Server\Daminion.Server.exe

- Close the console

- Launch the Admin panel and press the Start button

 

 

Nice! Thanks Murat!

Link to comment
Share on other sites

  • 2 months later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...