mike chekal Posted November 20, 2013 Report Share Posted November 20, 2013 I am new to the world of PlasticSCM and I am installing a PlasticSCM server that is being linked to a different device hosting an MS SQL Instance. I have been through the knowledge base a few times and I still can not figure out where I am going wrong. This is my current db.conf, the path is local to the server hosting the Plastic server. <?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=db2\sqlplasticserver;User Id=sa;Pwd=|SoC|dQTP6GQroQ6R6zlK+WFEzvOIq1glANhz;DATABASE={0};</ConnectionString> <DatabasePath>d:\plasticscm</DatabasePath> <DatabaseSuffix /> <DatabasePrefix /></DbConfig> This is the error that is displaying in the Plastic.server log: 2013-11-20 10:28:47,259 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'sinklevel' compression mode set. all metadata will be serialized2013-11-20 10:28:47,321 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers2013-11-20 10:28:47,321 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are directly written into the response buffer2013-11-20 10:28:47,353 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Start listening2013-11-20 10:28:47,353 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'sinklevel' compression mode set. all metadata will be serialized2013-11-20 10:28:47,353 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers2013-11-20 10:28:47,353 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are directly written into the response buffer2013-11-20 10:28:47,353 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Using certificate file ssl-certificate.pfx2013-11-20 10:28:47,571 (null) NT AUTHORITY\SYSTEM at (null) ERROR DataManager - Error trying to create the database repositories: Directory lookup for the file "d:\plasticscm\repositories.plastic" failed with the operating system error 2(The system cannot find the file specified.).CREATE DATABASE failed. Some file names listed could not be created. Check related errors.2013-11-20 10:28:47,571 (null) NT AUTHORITY\SYSTEM at (null) ERROR Codice.CM.Server.RepositoryHandler - The database repositories can't be created. Check the server log (plastic.server.log). Error: Directory lookup for the file "d:\plasticscm\repositories.plastic" failed with the operating system error 2(The system cannot find the file specified.).CREATE DATABASE failed. Some file names listed could not be created. Check related errors. at Codice.CM.Data.BaseDataManager.ExecuteCreateDatabaseScript(String databaseName, String contentResourceName) at Codice.CM.Data.BaseDataManager.CreateRepositoriesData() at Codice.CM.Server.RepositoryHandler.InitService()2013-11-20 10:28:47,602 bd970dd0-4a10-4aaf-9da1-f3b516de4335 NT AUTHORITY\SYSTEM at Server:APP2 INFO Transaction - Transaction timeout -> 120000ms2013-11-20 10:28:47,618 bd970dd0-4a10-4aaf-9da1-f3b516de4335 NT AUTHORITY\SYSTEM at Server:APP2 ERROR DataConnection - There was a problem in OpenConnection. Cannot open database "repositories" requested by the login. The login failed.Login failed for user 'sa'. [repositories]2013-11-20 10:28:47,634 bd970dd0-4a10-4aaf-9da1-f3b516de4335 NT AUTHORITY\SYSTEM at Server:APP2 ERROR Trigger - There was an error loading the triggers. Error: Plastic SCM server APP2: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 'sa'.2013-11-20 10:28:48,226 (null) NT AUTHORITY\SYSTEM at (null) INFO Channel - Start listening I am currently trying to connect with the SQL's instance sa account I am sure that there is not an issue with rights for this user. I can connect to the db server from the hosting server through odbc using that account. anything else I should be checking? Link to comment Share on other sites More sharing options...
calbzam Posted November 20, 2013 Report Share Posted November 20, 2013 Hi, I think it could be the same issue as: http://www.plasticscm.net/index.php?/topic/308-plastic-fails-to-create-db-on-sql-server/?hl=%2Bdirectory+%2Blookup+%2Bfile Is the database path pointing to a location accessible by the cluster?? Regards, Carlos Link to comment Share on other sites More sharing options...
mike chekal Posted November 20, 2013 Author Report Share Posted November 20, 2013 No that is a location on the device hosting PlasticSCM, I will give it a try with a UNC first than I may need to map a drive I will let you know if this fixes the issue Link to comment Share on other sites More sharing options...
mike chekal Posted November 20, 2013 Author Report Share Posted November 20, 2013 I had to do a few more changes but it seems to be working, I had to make sure the user had share and security rights to the folder and change it from defined to trusted_connection and Plastic is working. Thank you and that should close this topic Link to comment Share on other sites More sharing options...
calbzam Posted November 21, 2013 Report Share Posted November 21, 2013 Great! Let us know if we can help you with more issues. Regards, Carlos Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.