MiguelAngel Posted February 3, 2016 Report Share Posted February 3, 2016 Hello. last week we had a server crash (plastic 4+ MSSQL) I have recovered most of the files from the server.This is my db.conf <?xml version="1.0"?> <DbConfig xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <ProviderName>sqlserver</ProviderName> <ConnectionString>Server=localhost;User Id=plastic;Pwd=XXXXXXXXXXXXXXXXXXX;DATABASE={0};</ConnectionString> <DatabasePath>E:\MS-SQL-Server\Plastic-SCM</DatabasePath> <DatabaseSuffix /> <DatabasePrefix /> </DbConfig>With this configuration.. where is the database (ldf/mdf files)? (don't know how the database was configured)what is DATABASE={0}? master.mdf??Can i rebuild database from E:\MS-SQL-Server\Plastic-SCM ?? in this location there are a lot of files "rep_X.plastic" and "rep_X.plastic.log"Thanks in advance. Link to comment Share on other sites More sharing options...
manu Posted February 3, 2016 Report Share Posted February 3, 2016 Hello! the MS SqlServer databases should be located here "E:\MS-SQL-Server\Plastic-SCM". You should be able to reinstall MS SQLServer and re-connect the databases. Once you can see the databases using the SQLServer Management studio you will be able to start the Plastic SCM server. Link to comment Share on other sites More sharing options...
MiguelAngel Posted February 3, 2016 Author Report Share Posted February 3, 2016 Muchas gracias por la respuesta!Entonces el procedimiento sería:-instalar sql server -instalar plastic server -cambiar la config para que apunte a E:\MS-SQL-Server\Plastic-SCM-parar el servicio plastic server-copiar los ficheros .plastic y .log a E:\MS-SQL-Server\Plastic-SCM (sólo hay .plastic y .log)-iniciar server plastices correcto??Muchas gracias por adelantado Link to comment Share on other sites More sharing options...
manu Posted February 3, 2016 Report Share Posted February 3, 2016 Nop, realmente sería: 1) Instalar SqlServer 2) Instalar Plastic SCM Server 3) Copiar las bases de datos a E:\MS-SQL-Server\Plastic-SCM (ficheros log y plastic) 4) Usando SqlServer management tool linkar/añadir las bases de datos que se han copiado. 5) Arrancar Plastic SCM server habiendo configurado el fichero "db.conf" para que use MS SqlServer. Saludos. Link to comment Share on other sites More sharing options...
MiguelAngel Posted February 3, 2016 Author Report Share Posted February 3, 2016 Nop, realmente sería: 1) Instalar SqlServer 2) Instalar Plastic SCM Server 3) Copiar las bases de datos a E:\MS-SQL-Server\Plastic-SCM (ficheros log y plastic) 4) Usando SqlServer management tool linkar/añadir las bases de datos que se han copiado. 5) Arrancar Plastic SCM server habiendo configurado el fichero "db.conf" para que use MS SqlServer. Saludos. Pues muchísimas gracias por la información!! Moviendo datos... Link to comment Share on other sites More sharing options...
manu Posted February 3, 2016 Report Share Posted February 3, 2016 Genial. Cualquier cosa aquí estamos para ayudar. Saludos. Link to comment Share on other sites More sharing options...
MiguelAngel Posted February 5, 2016 Author Report Share Posted February 5, 2016 Hola, -he logrado adjuntar todas las bases de datos. -con el management studio he creado un nuevo login (sqlserver autenticacion) con el usuario y la pass antiguas.-la base de datos para el usuario plastic es repositories -pero no autentica: 2016-02-05 09:27:00,089 Server:ALEANOVA-SRV01 ERROR DataConnection - There was a problem in OpenConnection. Cannot open database "repositories" requested by the login. The login failed. Login failed for user 'plastic'. [repositories] 2016-02-05 09:27:00,105 Server:ALEANOVA-SRV01 ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server ALEANOVA-SRV01:8087 wasn't able to open a connection to the database. Check the server log (plastic.server.log). Error: Cannot open database "repositories" requested by the login. The login failed. Login failed for user 'plastic'.Se os ocurre algo??Gracias por adelantado Link to comment Share on other sites More sharing options...
MiguelAngel Posted February 5, 2016 Author Report Share Posted February 5, 2016 mas trazas del error: 2016-02-05 09:38:17,653 (null) ERROR RepositoryStore - Error in CreateRepositoriesData. Cannot open database "repositories" requested by the login. The login failed. Login failed for user 'plastic'. 2016-02-05 09:38:17,653 (null) ERROR Codice.CM.Server.RepositoryHandler - Cannot open database "repositories" requested by the login. The login failed. Login failed for user 'plastic'. at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Codice.CM.Data.RepositoryStore.CreateRepositoriesData() at Codice.CM.Server.RepositoryHandler.j() at Codice.CM.Server.RepositoryHandler.a(String A_0) 2016-02-05 09:38:17,731 Server:ALEANOVA-SRV01 ERROR DataConnection - There was a problem in OpenConnection. Cannot open database "repositories" requested by the login. The login failed. Me surgen unas dudas:- Debo crear tantos sql server logins como bases de datos rep_X? - si en el server.conf indicamos create default repositories a true .. no sobreescribirá los repositorios restaurados?? -adjunto una captura del management studiohttp://prntscr.com/9z8uzv Link to comment Share on other sites More sharing options...
manu Posted February 8, 2016 Report Share Posted February 8, 2016 Just a fast update. This was solved using direct support. Fixing the right permissions and restoring the users.conf and groups.conf file was enough. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.