WebInterface

[Wikke]

Hi,

I installed loginventory 5.0.2.0. build 3103 and also the webinterface 5.1 Build 3127 on a windows server 2003 r2 32bit. IIS 6 is enable. When I test de webinterface with the local administrator account i get the following error.

Testing program directory privileges

Checking execute permissions ...
alert("Error: System.Exception\nMessage: An error occured: Description: Operation is not allowed when the object is closed. Source: !ExecuteSQL:507\nSource: Login.Ventory.GcBridge.5.0\n at ViewGenerator..ctor()\n\nDate/Time: 3/03/2010 11:42\nCulture: nl-BE\n\nUnable to create GlobalContext in HandleError");_CMDTYPESEPERATOR_No execute privileges for LOGINventory program folder. User SERVER06\Administrator needs execute privileges.
Test not passed!

Error:
Thread was being aborted.

Can anyone help me?

Kind regards,

Wikke

[MarcoM]

Hi,

What happens if you call the webinterface with
http://localhost/liwi/default.aspx?

[Wikke]

Hi,

When I go to http://localhost/liwi5/default.aspx I get a message from webpage telling me "unterminated string constant" then i click ok and get the following message:

alert("Error: System.Exception\nMessage: An error occured:
Description: Operation is not allowed when the object is closed.
Source: !ExecuteSQL:507\nSource: Login.Ventory.GcBridge.5.0\n at ViewGenerator..ctor()\n\nDate/Time: 3/03/2010 16:57\nCulture: nl-BE\n\nUnable to create GlobalContext in HandleError");

kind regards,

Wikke

[MarcoM]

Hi,

Which DB do you use?
Is the db server located at the same machine as the webinterface and ...
what is the authentication type (Integrated Windows or SQL Authentication) set in LOGINventory Configuration.

[Wikke]

Hi,

I'm using Mysql server 5.1 with an odbc 3.51.11 so i can select don't optimize column width and return matching rows.
DB and webinterface are on the same server but where can i find authentication type in loginventory configuration?
In IIS authentication is default integrated windows.

thanks

Wikke

[Franky]

This configurations is NOT supported
Please use at minimum: MySQL 5.1.32 and ODBC 5.1.6
All requiremens: http://www.loginventory.com/loginventor ... quirements

[Wikke]

Hi,

Oké i changed the odbc back to 5.1.6 but still I get the same error! I used odbc 3.51.11 because when you test the connection in the configuration you get "Please check that MySQL ODBC options "Don't Optimize Column Width" and Return Maching Rows" are enabled!" Is there another way to solve that error? I don't find those options in odbc 5.1.6!

kind regards,

Wikke

[MarcoM]

Hi there seems to be a problem establishing a database connection in some cases.
Please give us some (days ... hours) to evaluate the problem ... we will come back to you soon.

[MarcoM]

Hi,

It seems to be just a missleading error message. LOGINvetory Webinterface is not able to connect to your db.

Please Notice:

MS-SQL Server:
If the Webinterface installation is not placed on the Database Server use SQL Authentication instead of
NT-Authentication (can be changed in the LOGINventory Configuration -> Select Database dialog).

MS-Access:
Read and Write Privileges for the user executing the webinterface as well as Network-Service Account for the
Directory containing the .mdb and the .mdb file itself.

ODBC Connection:
Use System, not User DSN

Detailed How-To's about webinterface configuration may be found here
How To use SQL Server, SQL Server 2005 Express
How To set up file system security on Access denied
How To allow ASP.Net 2.0 on IIS 6 (Windows 2003 Server)


Of course we will improve error handling ...

[Wikke]

Problem solved, I used a user DSN for my odbc connection.

Thanks

Wikke