Tuesday, March 13, 2007

Sinergia Help Desk FAQ

This FAQ is a work in progress, if you have any question not answered here, email me.

What are the required permissions to install sinergia?
Does Sinergia log errors?
I want to install Sinergia using a different SQL Server 2005 instance than .\SQLEXPRESS What should I do?
I can't login with the admin user. What's wrong?
where exactly can I change the default password and user names?
What do I have to do to customize the users and passwords of the Sinergia setup?
the last check in the diagnose tool fails, reporting lack of priviliges, but I'm logged in with local administrator. What's wrong?
what does this code generation do?
What are the defined Roles designed for?
I can't start the Sinergia.Workflow service. Each time I cleared the Event Log the service started! What's the problem?
I'm trying to compile, and I can't. What do I need?


What are the required permissions to install sinergia?

The setup must be ran with local administration priviliges


Does Sinergia log errors?

Yes, they are logged in the Event Log. You can find it in:
Start>Administrative Tools>Event Viewer>Application


I want to install Sinergia using a different SQL Server 2005 instance than .\SQLEXPRESS What should I do?

To modify the SQL Server instance used by Sinergia you must:

1. Find and replace all the ocurrences of .\sqlexpress in the *.bat files of the installation folder (C:\Program Files\GLR\Sinergia)
2. Find and replace all the ocurrences of .\sqlexpress in the web.config file in the folder of the website C:\Inetpub\wwwroot\Sinergia\Web
3. Find and replace all the ocurrences of .\sqlexpress in the config file, C:\Program Files\GLR\Sinergia\workflow\Sinergia.WWF.Host.exe.config
4. Edit all enumerations, with data source type SQL, and modify the connection string defined updating it to the new SQL Server instance.


I can't login with the admin user. What's wrong?

This happens when running Sinergia from within Visual Studio. To be able to run Sinergia from Visual Studio do the following: Open the Sinergia_aspnet database, go to the aspnet_Membership table. Replace the cells with value /Sinergia/Web, with value /Web
where exactly can I change the default password and user names?

Users, and their passwords are added to the membership database through the Membership_Users.sql script in the resources folder of the Visual Studio solution. The product does not include user management features, the reason for this is that its based on the ASP.NET Website configuration tool provided out of the box by Membership asp.net. You can access it with the Website/ASP.NET Configuration menu option of the Visual Studio IDE, when the web project is selected. This is the tool provided to manage user, roles, and passwords. Unfortunately there is no way to open the web version witout a Visual Studio installation. Check out this article regarding this ( http://www.developer.com/net/asp/article.php/3569166)


What do I have to do to customize the users and passwords of the Sinergia setup?

If you want to change the password you have to do the following steps:

1 - Create a user with the ASP.NET Website configuration tool
2 - Open the Sinergia_aspnet database, go to the aspnet_Membership table. This table contains users, and their passwords data.
3 - Copy the password text of the row whose email matches the one you entered in 1
4 - Paste the password text in line 5 of the Membership_User.sql script
5 - Copy the password salt text of the row whose email matches the one you entered in 1
6 - Paste the password salt text in line 6 of the Membership_User.sql script

Basically this means, Membership uses some algorithm to hash the entered password, copying the hashed value into the create user script works. I think it Membership can be configured no to encrypt the user's password into the database, but that's not the default setup.


the last check in the diagnose tool fails, reporting lack of priviliges, but I'm logged in with local administrator. What's wrong?

This represents lack of priviliges to write in the sinergia/web/restricted/controls/generated, and sinergia/web/App_Code folders by the process running the website. This can be fixed assigning permissions to the IIS_WPG workgroup, and the Internet Guest Users account (at least in Win2k3).


what does this code generation do?

When a Case Type is set as default, by clicking the Make default link with a selected case type files are generated (also when clicking the generate files link). What's generated? A user control which is placed dynamically in the case form, along with a datatype class which is used to carry data to and from the database, to the form.


What are the defined Roles designed for?

Administrator, has priviliges to do everything.
Manager, can: open, edit, and update cases, as well as view reports.
Technician, has priviliges to: open, edit, and update cases'status.
Users without role have priviliges only to open cases, and edit them.


I can't start the Sinergia.Workflow service. Each time I cleared the Event Log the service started! What's the problem?

This may be due to the configuration of the Event Log logfile. You should make sure it's configured to overwrite events as needed.


I'm trying to compile, and I can't. What do I need?

The following refrences need fix before building

Testing ==> Tests ---> Nunit.framework
DataAcess ==> DataAcess ---->
a) Microsoft.Practice.EnterpriseLibrary.Common
b) """""""" . """""" . """"""""""""" . Data