rene Posted April 24, 2013 Report Share Posted April 24, 2013 Hello folks, my database is so messed up, because of all the renaming, how can I delete the database and setup a new one? Thanks winam! Quote Link to comment Share on other sites More sharing options...
Murat Posted April 28, 2013 Report Share Posted April 28, 2013 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 Quote Link to comment Share on other sites More sharing options...
rene Posted April 28, 2013 Author Report Share Posted April 28, 2013 hey Murat, thanks! Just figuered I forgot my password. I figuere I have to completly uninstall everything and reinstall it again right? winam Quote Link to comment Share on other sites More sharing options...
Murat Posted April 28, 2013 Report Share Posted April 28, 2013 thanks! Just figuered I forgot my password. I figuere I have to completly uninstall everything and reinstall it again right? Please use the "postgres" password without quotes Quote Link to comment Share on other sites More sharing options...
rene Posted April 30, 2013 Author Report Share Posted April 30, 2013 Thanks murat Quote Link to comment Share on other sites More sharing options...
rene Posted May 18, 2013 Author Report Share Posted May 18, 2013 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 Quote Link to comment Share on other sites More sharing options...
lintujuh Posted May 18, 2013 Report Share Posted May 18, 2013 Hi Rene, Have you looked at the Postgres forum? Easiest way is to use the uninstall script that is in the Postgres directory but in the post there are also manual instructions. -Juha Quote Link to comment Share on other sites More sharing options...
Murat Posted May 18, 2013 Report Share Posted May 18, 2013 Delete the "postgres" user from the Administration Tools > Users and try again. Quote Link to comment Share on other sites More sharing options...
exterminador Posted October 17, 2013 Report Share Posted October 17, 2013 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 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! Quote Link to comment Share on other sites More sharing options...
Murat Posted October 17, 2013 Report Share Posted October 17, 2013 Do you see any error messages? Please try 902 build. Quote Link to comment Share on other sites More sharing options...
exterminador Posted October 17, 2013 Report Share Posted October 17, 2013 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! Quote Link to comment Share on other sites More sharing options...
rene Posted October 17, 2013 Author Report Share Posted October 17, 2013 btw. can one rename the "netcatalog" or do I need to create a new one? Quote Link to comment Share on other sites More sharing options...
exterminador Posted October 17, 2013 Report Share Posted October 17, 2013 btw. can one rename the "netcatalog" or do I need to create a new one? Hi Rene, You can rename your existing NetCatalog database to something else and start Daminion server to create a new (empty) catalog, just keep in mind I did it just for testing purposes and will rename my original db back to NetCatalog. Regards Quote Link to comment Share on other sites More sharing options...
rene Posted October 18, 2013 Author Report Share Posted October 18, 2013 ok thanks Quote Link to comment Share on other sites More sharing options...
exterminador Posted July 5, 2014 Report Share Posted July 5, 2014 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! Quote Link to comment Share on other sites More sharing options...
Murat Posted July 8, 2014 Report Share Posted July 8, 2014 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 Quote Link to comment Share on other sites More sharing options...
montonero Posted July 13, 2014 Report Share Posted July 13, 2014 (edited) 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 July 13, 2014 by montonero Quote Link to comment Share on other sites More sharing options...
Alexius Posted July 14, 2014 Report Share Posted July 14, 2014 Can I just remove it in PGAdmin? Yes, It should be renamed by the PgAdmin. Quote Link to comment Share on other sites More sharing options...
exterminador Posted July 18, 2014 Report Share Posted July 18, 2014 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! Quote Link to comment Share on other sites More sharing options...
montonero Posted October 5, 2014 Report Share Posted October 5, 2014 Looks like this method isn't working with last builds (tried 1084). Launch of Daminion.Server.exe doesn't recreate default NetCatalog. Quote Link to comment Share on other sites More sharing options...
rene Posted October 5, 2014 Author Report Share Posted October 5, 2014 Hey Murat, I guess deleting old databses etc can be done throu the daminion admin panel meanwhile right? Quote Link to comment Share on other sites More sharing options...
Murat Posted October 6, 2014 Report Share Posted October 6, 2014 This will work for catalogs that were created via the admin panel only. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.