Thursday, March 29, 2007

Sinergia screencasts

Screencasts of some of Sinergia's help desk features are now published in the project's site. This is a work in progress, as soon as I create new screencasts I'll publish them.

So, please check them out and come back with feedback.

Wednesday, March 28, 2007

Sinergia 0.4.0 released

I'm happy to announce that Sinergia open source help desk version 0.4.0 has been released.

Its focus was:
- improving error logging support
- adding import/export case types feature. This feature will have a post on itself
- fixing windows service restart problem

As usual, you may download Sinergia's latest release from here.

cheers, gabo

Sunday, March 25, 2007

Known Sinergia Issue Opening existing workflow instance after restarting windows service

I've spotted some days ago a bug in Sinergia. If you create a new case, and then re start the Sinergia Workflow Window Service you will have problems editing the created case. But you'll be able to create new instances without problem. I'll be working this week on this bug, in the meantime I've already started a new thread in Windows Workflow Foundation's forum, here it is if you want to take a look a t it.

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

Sunday, March 04, 2007

Diagnose setup problems tool

After a long hiatus there's a new release of the Sinergia Help Desk project.

The 0.3.7 version improves error logging, and includes a new tool to diagnose if a setup is ok, trying the most important features independently.

So if you install this version you should see a new link in the Login page. Something like this:
Sinergia Help Desk Following this link should lead to this page, where you can test every feature needed for a correct execution of the Sinergia web application.

With this tool you know from scratch if something is going wrong, and maybe even a hint about how to fix it.

Sinergia Help Desk Diagnose tool I hope you find it helpful.