Install on linux

[tsoloane]

looks like that's it. Unable to run the sql as entered here is a transcript of my session.

mysql> select * from qx_permission;
Empty set (0.00 sec)

mysql> insert into QX_PERMISSION(PERMISSION_ID, ROLE_ID, ACCESS_LEVEL, PERMISSION_OBJECT_TYPE, OBJECT_ID) values(0, 0, 3, 0, 0);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`qwoss/qx_permission`, CONSTRAINT `FK_QX_PERMISSION_TO_QX_VIEW_OBJECTS` FOREIGN KEY (`object_id`) REFERENCES `qx_view_objects` (`pkey`))
mysql>


would it be a good idea to drop the constraint?

[tsoloane]

Dropping the constraint was not helpful. The error in the javascript is:

_focusesMeta[0] has no properties

This is the line that says:

_$activateFocus3(_this$static, _focusesMeta[0]._index);

in the _$SubFocusesPanel function...

Aieee, I'm going bald...

[azudin]

I see. So most likely it is still with MySQL case sensitivity.

Anyways we are preparing a package for Solaris and MySQL now so I am hoping to have a tested version of case sensitive MySQL SQL installation scripts by the end of the day. Once ready I will attach them under the thread...

Thanks,
Andrei.

[tsoloane]

thanks. Look forward to it

[azudin]

Here we go. Please find attached. You will need to run them in the file name order.
Probably you can skeep the 0.database-qwoss-login_v001.sql one which creates a new user and then
0.database-qwoss_v001.sql
...
8.application-data_v055.sql
dashboard_data.sql

next please run installation tools (http://server.name:8080/tools)
and finally

add-access-rights.sql - this one simply adds permissions for all screens to the admin user.

Let us know how it goes.

Thanks,
Andrei.

[stevebrooks000]

Hi I am getting the exact same client side JS error as tsoloane, namely:

=====================================

_focusesMeta[0] has no properties

This is the line that says:

_$activateFocus3(_this$static, _focusesMeta[0]._index);

in the _$SubFocusesPanel function...

=====================================

The login page doesn't popup any error instead it just sits there with the loading ani spining around forever.

I am running on WinXP with MS SQL 2000.

I encountered every other problem he had to and resolved them but this one has me stumped. I doubt it has anything todo with DB permissions as the JS code seems to be trying to set and show labels on buttons and add them to the display deck. The full JS method with error line marked is:

======================================

function _$SubFocusesPanel(_this$static, _appMetaData){
var _focusesMeta, _i, _subfocuses, _j, _m, _sfm, _event, _data;
_$ButtonSet(_this$static);
_$$init75(_this$static);
_focusesMeta = _appMetaData._focuses;
_this$static._labelButtonSets = _initDims('[Lcom.queplix.core.client.common.ui.LabelButtonSet; ', [831], [48], [_focusesMeta._length], null);
_$initActivatedSubFocuses(_this$static, _focusesMeta._length);
for (_i = 0; _i < _focusesMeta._length; _i++) {
_setCheck(_this$static._labelButtonSets, _i, _$LabelButtonSet0(new _LabelButtonSet(), true));
_subfocuses = _focusesMeta[_i]._subFocuses;
for (_j = 0 , _m = _subfocuses._length; _j < _m; _j++) {
_sfm = _subfocuses[_j];
_event = _$Event(new _Event0(), _sfm._index);
_data = _$ButtonData5(new _ButtonData(), _sfm._caption);
_$setCaptionSelectedStyle(_data, 'subFocus_labelSelected');
_$setCaptionHoverStyle(_data, 'subFocus_labelHighlighted');
_$addButton1(_this$static._labelButtonSets[_i], _event, _data);
}
_$subscribeEvents8(_this$static, _this$static._labelButtonSets[_i]);
_$add4(_this$static._deckPanel, _this$static._labelButtonSets[_i]);
}
if (_focusesMeta._length > 0) {
_this$static._deckPanel._showWidget0(0);
}
_this$static._deckPanel._setHeight0(_pixelToSize(2 2));
_this$static._initWidget0(_this$static._deckPanel) ;
_$activateFocus3(_this$static, _focusesMeta[0]._index); <<< ERROR!!!
return _this$static;
}

======================================

Here is the full error from the JS Error Console:

======================================

Error: _focusesMeta[0] has no properties
Source File: http://localhost:8080/com.queplix.qw...9.cache.html?0
Line: 55289
======================================

There are no errors in the server log and it reported that the login was successful i.e.

======================================

2007-05-30 20:39:23,359 DEBUG [com.queplix.core.modules.eql.parser.generic.EQLInt Mediator] addSubOp() class com.queplix.core.modules.eql.ops.NoneOp
2007-05-30 20:39:23,359 DEBUG [com.queplix.core.modules.eql.parser.generic.EQLInt Mediator] addSubWhereCondition(): -1
2007-05-30 20:39:23,359 INFO [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl]
SELECT
A373.HIS_TABLE_ID AS FIELD0,
A373.HIS_FIELD_ID AS FIELD1,
A168.NAME AS FIELD2,
A213.NAME AS FIELD3
FROM
QX_HIS_TBLFIELD A373
LEFT OUTER JOIN QX_HIS_TABLE A168 ON A373.HIS_TABLE_ID = A168.HIS_TABLE_ID
LEFT OUTER JOIN QX_HIS_FIELD A213 ON A373.HIS_FIELD_ID = A213.HIS_FIELD_ID
WHERE
lower(A168.NAME) = lower(?)
PARAM [0]: QX_USER_LOG CLASS=com.queplix.core.modules.eql.EQLStringObject

2007-05-30 20:39:23,375 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] page=null
2007-05-30 20:39:23,375 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] pageSize=null
2007-05-30 20:39:23,375 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] datasets=0
2007-05-30 20:39:23,375 DEBUG [com.queplix.core.utils.sql.vendor.mssql.SqlWrapper MSSQLImpl] Data source 'java:comp/env/jdbc/QxDataSource' loaded. Class: org.jboss.resource.adapter.jdbc.WrapperDataSource
2007-05-30 20:39:23,375 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Set parameter 'QX_USER_LOG' in position #0 of statement
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Select completed: rows=0 more?=false
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.generic.EQLAge ntGenericImpl] ...execute EQL request completed
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.ejb.HistoryEJB] Entity 'user_log' (table 'QX_USER_LOG') doesn't have the fields to log history for.
2007-05-30 20:39:23,390 INFO [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl]
INSERT INTO
QX_USER_LOG
(USER_LOG_ID,USER_ID,USER_TYPE_ID,SESSION_ID,FULLN AME,HOST,REMOTE_ADDRESS,LOGIN_TIME,LOGOUT_TIME)
VALUES
(20,0,0,?,?,?,?,CONVERT(DATETIME,'30/05/2007 08:39:23', 103),NULL)
PARAM [0]: 42380A4C768F8D79AB2B5477828B9AF8 CLASS=com.queplix.core.modules.eql.EQLStringObject
PARAM [1]: Administrator CLASS=com.queplix.core.modules.eql.EQLStringObject
PARAM [2]: 127.0.0.1 CLASS=com.queplix.core.modules.eql.EQLStringObject
PARAM [3]: 127.0.0.1 CLASS=com.queplix.core.modules.eql.EQLStringObject

2007-05-30 20:39:23,390 DEBUG [com.queplix.core.utils.sql.vendor.mssql.SqlWrapper MSSQLImpl] Data source 'java:comp/env/jdbc/QxDataSource' loaded. Class: org.jboss.resource.adapter.jdbc.WrapperDataSource
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Set parameter '42380A4C768F8D79AB2B5477828B9AF8' in position #0 of statement
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Set parameter 'Administrator' in position #1 of statement
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Set parameter '127.0.0.1' in position #2 of statement
2007-05-30 20:39:23,390 DEBUG [com.queplix.core.modules.eql.parser.mssql.SQLExecu torMssqlImpl] Set parameter '127.0.0.1' in position #3 of statement
2007-05-30 20:39:23,406 DEBUG [com.queplix.core.modules.eql.parser.generic.EQLAge ntGenericImpl] ...updated 1 rows
2007-05-30 20:39:23,406 INFO [com.queplix.core.modules.eql.ejb.EQLManagerEJB] EQL UPDATE completed. Time (ms) = 78
2007-05-30 20:39:23,406 DEBUG [com.queplix.core.modules.jeo.gen.UserLogObjectHand ler] Object updated, entity - 'user_log'
2007-05-30 20:39:23,406 INFO [com.queplix.core.integrator.IntegratorLogin] Login for user:admin, finished in: 4.578s

=====================================

Any help would be greatly appreciated.

Thanks

[tsoloane]

Steve, had a look at it again. The sql scripts posted by Azudin fix the issue on my side. Am busy configuring the app now.

[stevebrooks000]

OK Thanks,

Any idea which aspect of the scripts, as they are in mysql syntax and the chances of making the DB worse by doing the nessesary syntax changes to run them on ms sql 2000 makes me reluctant to go down that path. I will have a look at my permissions again but I'm pretty sure the qwoss user can do everything.

BTW, I'm pleased you got it going congratulations I've been on this for 4 evenings straight also. It looks like a funky app so can't wait to have a play also.

Cheers

[stevebrooks000]

Nice, got it going by just running the insert permissions in the add access rights script manually and woolaaa.

Thanks heaps

[Sultan]

Originally Posted by azudin

By the way, what browser are you using? On Linux the only option for now is Firefox.

Not really, I successfully ran queweb client in IE 6 with Wine on Linux