|
nk4um User
Posts: 31
|
2007-07-13T14:59:27.000ZJuly 13, 2007 14:59
|
You need to put your jdbc driver in [path-install]/modules/mod-db/lib/
|
that''s where it was all the time
|
To clean up do... delete from blogxter.users where id>2;
|
at least that helped hm...
|
|
nk4um Moderator
Posts: 755
|
2007-07-13T14:43:09.000ZJuly 13, 2007 14:43
You should be ok with 4.1.11 - I think blogxter started out on 3.x.x.
You need to put your jdbc driver in [path-install]/modules/mod-db/lib/
The installer script must have created the super user each time you tried to install. To clean up do...
delete from blogxter.users where id>2;
P.
|
|
nk4um User
Posts: 31
|
MySQL-version 4.1.11: Looks like my version of MySQL is slightly older than yours. I''ll try to initiate an update (although I''m not sure if I''m
allowed to do so). When i tried this on my MacBook with MySQL 5.x I had the same problems but i''ll have to retry with the
proper RDBMSconfig.xml in place (just can''t do that right now). JDBC-driver: I tried 2 JDBC-drivers on the server, mysql-connector-java-3.1.14-bin.jar and mysql-connector-java-5.0.6-bin.jar, which didn''t
make a difference. Just one question here: do I have to register them explicitly anywhere or is <jdbcDriver>com.mysql.jdbc.Driver</jdbcDriver>
in /etc/RDBMSConfig.xml all that''s needed? SQL-statement: Issuing SELECT @userid:=id FROM blogxter.users WHERE userid=''super''; directly returns quite a lot of users. In case this
gives a hint here''s the complete content of blogxter.users (passwords deleted):
mysql> SELECT * FROM blogxter.users; +----+--------+-----------+----------+----------------+------+-----------------+-+----------+--------+--------+ | id | userid | firstname | lastname | email | web | biog | | reminder | answer | status | +----+--------+-----------+----------+----------------+------+-----------------+-+----------+--------+--------+ | 1 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 2 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 3 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 4 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 5 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 6 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 7 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 8 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 9 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 10 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 11 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 12 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 13 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 14 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 15 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 16 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 17 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 18 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 19 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 20 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 21 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 22 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 23 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 24 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 25 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 26 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 27 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 28 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 29 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 30 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 31 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 32 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | | 33 | super | super | super | root@localhost | NULL | super user biog | | NULL | NULL | active | | 34 | guest | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | active | +----+--------+-----------+----------+----------------+------+-----------------+-+----------+--------+--------+
|
Ciao, Thomas
|
|
nk4um Moderator
Posts: 755
|
Hi Thomas, Huh. Weird. After login their is a batch query made...
<batch> <!--Get userid--> <sql> SELECT @userid:=id FROM users WHERE userid=''<xsl:value-of select="$param/nvp/userid"/>''; </sql> <!--Delete any old session for this user--> <sql> DELETE FROM sessions WHERE userid=@userid; </sql> <!--Create new session with guid value as token--> <sql> INSERT INTO sessions VALUES (''<xsl:value-of select="."/>'' , @userid, NOW(),NOW() ); </sql> </batch>
|
As you can see the first statement is a select assignment to a mysql variable. I can only suggest that this is a problem with the mysql version you are using or maybe the JDBC drivers? We are running
on 4.1.20 with JDBC driver mysql-connector-java-3.1.8-bin.jar P.
|
|
nk4um User
Posts: 31
|
Sorry, but logging in as ''super'' returns an Internal Server Error. Complete stacktrace below (obviously ;-). Ciao, thomas <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:dpml+operand@ffcpl%3A/www/control/sysadmin/access/processLogin.idoc+session@session%3A62BCF757C8A51645575BE751AA77A62D+param@var%3Aparam
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:115</level> <level>org.ten60.docxter2.XRLMapper.processRequest() line:85</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:107</level> </stack> <ex> <id>Unhandled exception in DPML</id> <message> INSTR: requestWithArgs uri=ffcpl:/blog-security-login-super param=param</message> <requestid>ffcpl:/www/control/sysadmin/access/processLogin.idoc</requestid> <stack> <level>org.ten60.netkernel.dpml.DPMLAccessor.stateException() line:159</level> <level>org.ten60.netkernel.dpml.DPMLAccessor.receiveAsyncException() line:131</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateReturnResult() line:621</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:266</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:requestWithArgs+uri@ffcpl%3A/blog-security-login-super+param@var%3Aparam in urn:org:ten60:netkernel:ext:dpml
as java.lang.Object]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.ura.sys.RequestWithArgsAccessor.requestAsync() line:75</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>com.ten60.netkernel.util.NetKernelException</id> <message>Problem in RequestWithArgs</message> <stack> <level>org.ten60.ura.sys.RequestWithArgsAccessor.requestAsync() line:70</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:227</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE ffcpl:/blog-security-login-super+param@var%3Aparam in urn:org:ten60:netkernel:ext:sys as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:118</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>Unhandled Exception in Accessor</id> <message>org.ten60.docxter2.XRLMapper</message> <requestid>[SOURCE active:mapper+operand@ffcpl:/blog-security-login-super+param@var%3Aparam+operator@ffcpl:/links.xml
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:115</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.innerRequestAsynch() line:153</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:dpml+operand@ffcpl%3A/blogxter/security/superlogin.idoc+param@var%3Aparam+operator@ffcpl%3A/links.xml
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:115</level> <level>org.ten60.docxter2.XRLMapper.processRequest() line:85</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:107</level> </stack> <ex> <id>Unhandled exception in DPML</id> <message> INSTR: sqlBatch operand=sql</message> <requestid>ffcpl:/blogxter/security/superlogin.idoc</requestid> <stack> <level>org.ten60.netkernel.dpml.DPMLAccessor.stateException() line:159</level> <level>org.ten60.netkernel.dpml.DPMLAccessor.receiveAsyncException() line:131</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateReturnResult() line:621</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:266</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:sqlBatch+operand@var%3Asql in urn:org:ten60:netkernel:ext:dpml as java.lang.Object]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:118</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>Unhandled Exception in Accessor</id> <message>org.ten60.rdbms.accessor.RDBMSAccessorImpl2</message> <requestid>[SOURCE active:sqlBatch+operand@var%3Asql in urn:org:ten60:netkernel:mod:db as java.lang.Object]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:115</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:227</level> </stack> <ex> <id>java.sql.BatchUpdateException</id> <message>Can not issue SELECT via executeUpdate().</message> <stack> <level>com.mysql.jdbc.Statement.executeBatch() line:941</level> <level>org.ten60.rdbms.accessor.RDBMSAccessorImpl2.sqlBatch() line:268</level> <level>org.ten60.rdbms.accessor.RDBMSAccessorImpl2.execute() line:140</level> <level>org.ten60.rdbms.accessor.RDBMSAccessorImpl2.processRequest() line:101</level> </stack> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex>
|
|
nk4um Moderator
Posts: 755
|
2007-07-13T13:21:18.000ZJuly 13, 2007 13:21super
Glad that we''re making progress. You now need to sign into the admin page using username ''super'' and whatever you used
for the admin password.
Cheers,
P.
|
|
nk4um User
Posts: 31
|
Hi Peter,
thanks a lot for having a look! As you suspected /etc didn''t contain ConfigRDBMS.xml. I copied it over from the install-directory
and changed it along the lines of the example you posted. I can now enter the startpage of the blog - yeah! :-)
But i can''t sign in nor log in into the admin area as super user ''blogxter''. (I didn''t try to register as a new user since
i figured that i would need an admin account to activate new users).
No luck in scratch: there''s a directory named modules_blogxter_services_1_0_7 and another one named modules_blogxter_services,
but they are both empty (the same goes for blogyter-web).
Ciao Thomas
|
|
nk4um Moderator
Posts: 755
|
Hi Thomas, Sorry for the slow response to this thread. I didn''t have any internet access in France. First some diagnostics. Can you look in your [nkse-install-path]/scratch/ and find the scratch directory for blogxter_services.
In my system it is file__home_dexter_apps_blogxter_services_1_0_7. If the installation worked then the RDBMS config will be found in: /etc/RDBMSConfig.xml It should look like...
<config> <rdbms> <jdbcDriver>com.mysql.jdbc.Driver</jdbcDriver> <jdbcConnection>jdbc:mysql://localhost:3306/blogxter?user=blogxter&password=xxxxxx</jdbcConnection> <poolSize>100</poolSize> </rdbms> </config>
|
My guess is if you put this file there then it will start working! Fingers crossed. Let me know what your system looks like. Cheers, Peter
|
|
nk4um User
Posts: 31
|
2007-07-10T22:35:36.000ZJuly 10, 2007 22:35
i have to correct myself: the user ''super'' and its password are entered correctly into the blogxter database. db user name
and password are entered correctly into the mysql.user table.
|
|
nk4um User
Posts: 31
|
As far as I can see, setupDB.xml seems to have run through without problems. All the tables are there, including the entries
"Welcome" and "License". The only possible hint that I can find is that the table ''blogxter.users'' doesn''t contain the
DB Admin Username that I provided through the form on http://host.name:1060/ep+name@app_blogxter_installer_start. Instead
the user ''super'' carries that password. Maybe this gives soemone an idea of what went wrong? Maybe there''s a simple workaround?
I still hesitate to tinker with the database but the users table would be the my starting point.
Ciao Thomas
|
|
nk4um User
Posts: 31
|
2007-07-05T20:14:11.000ZJuly 5, 2007 20:14maybe
thanks for your time, tony! maybe peter can shed some light on this when he''s in the office again next week. maybe i''ll
try the database installation by foot until then, although that looks like a rather tedious undertaking. thanks again! thomas
|
|
nk4um Moderator
Posts: 485
|
Hi Tom, I think you original error message is the key to this:
|
Error Can not issue SELECT via executeUpdate(). Please check your database permissions. The DB Admin account you use must have remote access and GRANT permissions. Also make
sure you have a MySQL JDBC driver installed in mod_db/lib/.
|
I think the installer script is failing early and hence the subsequent usage errors. There must be some extra detail needed
in setting up the database or database administrator. Unfortunately I have zero experience of mysql configuration :-( Tony
|
|
nk4um User
Posts: 31
|
<ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:throw+operand@ffcpl%3A/installer/start.idoc%23xpointer(/idoc/seq/if/then/if/else/instr/operand/ex)
in urn:org:ten60:netkernel:ext:dpml as java.lang.Object]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException()
line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.netkernel.xml.xahelper.XAccessor.requestAsync()
line:93</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex>
<id>Unhandled Exception</id> <message>in org.ten60.ura.sys.ThrowExceptionAccessor</message> <requestid>[SOURCE active:throw+operand@ffcpl%3A/installer/start.idoc%23xpointer(/idoc/seq/if/then/if/else/instr/operand/ex)
in urn:org:ten60:netkernel:ext:sys as java.lang.Object]</requestid> <stack> <level>org.ten60.netkernel.xml.xahelper.XAccessor.requestAsync()
line:90</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest()
line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:227</level> </stack> <ex> <id>Error</id>
<message>Unable to connect to database - please check DBA user and password</message> <stack> <level>org.ten60.ura.sys.ThrowExceptionAccessor.buildException()
line:77</level> <level>org.ten60.ura.sys.ThrowExceptionAccessor.source() line:57</level> <level>org.ten60.netkernel.xml.xahelper.XAccessor.requestAsync()
line:82</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> </ex>
</ex> </ex>
|
|
nk4um User
Posts: 31
|
<ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:xrl-html-tolerant+template@xrl%3Atemplate_master+content@xrl%3Ahome_page+operator@ffcpl%3A/links.xml
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:115</level> <level>org.ten60.docxter2.XRLMapper.processRequest() line:85</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:107</level> </stack> <ex> <id>Unhandled Exception in Accessor</id> <message>org.ten60.docxter2.XRLLinker</message> <requestid>[SOURCE active:xrl-html-tolerant+template@xrl%3Atemplate_master+content@xrl%3Ahome_page+operator@ffcpl%3A/links.xml
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:115</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.innerRequestAsynch() line:153</level> </stack> <ex> <id>XRL Failure</id> <message>failed to process xrl:include href=xrl:blog_toc</message> <requestid>xrl:template_master xrl:home_page</requestid> <stack> <level>org.ten60.docxter2.XRLLinker.recurse() line:266</level> <level>org.ten60.docxter2.XRLLinker.recurse() line:373</level> <level>org.ten60.docxter2.XRLLinker.recurse() line:373</level> <level>org.ten60.docxter2.XRLLinker.recurse() line:373</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:dpml+operand@ffcpl:/www/control/home/blog_toc.idoc in urn:org:ten60:netkernel:ext:xrl as
org.ten60.netkernel.xml.representation.IXAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:115</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:60</level> <level>org.ten60.docxter2.XRLLinker.recurse() line:249</level> </stack> <ex> <id>Unhandled exception in DPML</id> <message> INSTR: source uri=ffcpl:/blog-getTOCPublic</message> <requestid>ffcpl:/www/control/home/blog_toc.idoc</requestid> <stack> <level>org.ten60.netkernel.dpml.DPMLAccessor.stateException() line:159</level> <level>org.ten60.netkernel.dpml.DPMLAccessor.receiveAsyncException() line:131</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateReturnResult() line:621</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:266</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:source+uri@ffcpl%3A/blog-getTOCPublic in urn:org:ten60:netkernel:ext:dpml as java.lang.Object]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.ura.sys.RequestWithArgsAccessor.requestAsync() line:75</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>com.ten60.netkernel.util.NetKernelException</id> <message>Problem in RequestWithArgs</message> <stack> <level>org.ten60.ura.sys.RequestWithArgsAccessor.requestAsync() line:70</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.requestSynch() line:111</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE ffcpl:/blog-getTOCPublic in urn:org:ten60:netkernel:ext:sys as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:118</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>Unhandled Exception in Accessor</id> <message>org.ten60.docxter2.XRLMapper</message> <requestid>[SOURCE active:mapper+operand@ffcpl:/blog-getTOCPublic+operator@ffcpl:/links.xml in urn:org:ten60:netkernel:ext:xrl
as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:115</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.innerRequestAsynch() line:153</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:dpml+operand@ffcpl%3A/blogxter/blog/getTOCPublic.idoc+operator@ffcpl%3A/links.xml
in urn:org:ten60:netkernel:ext:xrl as com.ten60.netkernel.urii.IURAspect]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.docxter2.GTPUtils.resolveLink() line:115</level> <level>org.ten60.docxter2.XRLMapper.processRequest() line:85</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:107</level> </stack> <ex> <id>Unhandled exception in DPML</id> <message> INSTR: sqlQuery operand=sql</message> <requestid>ffcpl:/blogxter/blog/getTOCPublic.idoc</requestid> <stack> <level>org.ten60.netkernel.dpml.DPMLAccessor.stateException() line:159</level> <level>org.ten60.netkernel.dpml.DPMLAccessor.receiveAsyncException() line:131</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateReturnResult() line:621</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:266</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE active:sqlQuery+operand@var%3Asql in urn:org:ten60:netkernel:ext:dpml as java.lang.Object]</requestid> <stack> <level>com.ten60.netkernel.scheduler.RequestState.setException() line:126</level> <level>com.ten60.netkernel.scheduler.Scheduler.receiveAsyncException() line:336</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:118</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> </stack> <ex> <id>Unhandled Exception in Accessor</id> <message>org.ten60.rdbms.accessor.RDBMSAccessorImpl2</message> <requestid>[SOURCE active:sqlQuery+operand@var%3Asql in urn:org:ten60:netkernel:mod:db as java.lang.Object]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:115</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> <level>com.ten60.netkernel.scheduler.Scheduler.requestSynch() line:111</level> </stack> <ex> <id>Exception during request processing</id> <message>whilst waiting for result...</message> <requestid>[SOURCE ffcpl:/etc/ConfigRDBMS.xml in urn:org:ten60:netkernel:mod:db as org.ten60.rdbms.representation.IAspectDBConnectionPool]</requestid> <stack> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.issueSubRequest() line:273</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFHelperImpl.sourceAspect() line:362</level> <level>org.ten60.rdbms.accessor.RDBMSAccessorImpl2.processRequest() line:98</level> <level>org.ten60.netkernel.layer1.nkf.impl.NKFAccessorImpl.requestAsync() line:107</level> </stack> <ex> <id>Error sourcing resource</id> <message>resource ffcpl:/etc/ConfigRDBMS.xml not found in module urn:org:ten60:netkernel:mod:blogxter</message> <requestid>ffcpl:/etc/ConfigRDBMS.xml</requestid> <stack> <level>com.ten60.netkernel.module.accessor.ModuleResourceAccessor.source() line:108</level> <level>com.ten60.netkernel.module.accessor.ModuleResourceAccessor.requestAsync() line:70</level> <level>com.ten60.netkernel.scheduler.Scheduler.stateRequestRepresentation() line:429</level> <level>com.ten60.netkernel.scheduler.Scheduler.processRequest() line:251</level> </stack> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex> </ex>
|
|
nk4um Moderator
Posts: 485
|
Hi Tom,
yes Peter is on vacation this week. He wrote Blogxter. Unfortunately the error reporting is minimal. Now that you have the
module expanded try commenting out the error screen to let the real raw error through unmasked. To do this comment out the
"500" link in the links.xml XRL file in the root directory of mod_blogxter_web. Just looking at the source though it looks
as though any error should written to the log. Not sure why you are not seeing it.
Do you see any hint as to what failed?
Cheers, Tony
|
|
nk4um User
Posts: 31
|
2007-07-04T20:10:02.000ZJuly 4, 2007 20:10
ooouch ... how embarrassing! sorry, tony! hi tony, thanks for coming in :-D
|
|
nk4um User
Posts: 31
|
2007-07-04T19:44:39.000ZJuly 4, 2007 19:44
i forgot to say that the install script _did_ install a database named ''blogxter'' in the mysql-db, although it quitted with
the above mentioned error.
|
|
nk4um User
Posts: 31
|
2007-07-04T19:42:34.000ZJuly 4, 2007 19:42
hi peter, thanks for coming in!
|
Try expanding the module and modifying deployedModules.xml to point to the expanded dir and then try the db install again.
|
did that
|
Is anything written to the log to indicate why the install failed?
|
i couldn''t find any usefull information
|
Or do the release notes for blogxter shed any more light.
|
sorry to say so but there aren''t any. you uploaded just the two jar-files.
|
It could also be that the version of mysql has some different administrator privileges to the version blogxter was originally
written too.
|
i tried it on the production server too, where mysql is of version 4.1.11. i even replaced the newish jdbc-5.0-driver by
a 3.1-version, but no luck. the result: also the stack trace ends at the same point. on the server the response to the install script is even worse than on the mac at home. it says:
|
Error Unable to connect to database - please check DBA user and password Please check your database permissions. The DB Admin account you use must have remote access and GRANT permissions. Also make
sure you have a MySQL JDBC driver installed in mod_db/lib/.
|
sorry to bother you with an application you didn''t want to support anymore! it''s just so tempting because it has some functionalities
that the forum hasn''t, like threaded discussions, trackback and the like, binary-upload, db-support (har har ;-). well, maybe you have still another trick up your sleeves...
|
|
nk4um Moderator
Posts: 485
|
Try expanding the module and modifying deployedModules.xml to point to the expanded dir and then try the db install again.
I''m afraid the error handling in this old app isn''t too hot. Is anything written to the log to indicate why the install
failed? Or do the release notes for blogxter shed any more light. It could also be that the version of mysql has some different
administrator privileges to the version blogxer was originally written too.
Cheers, Tony
|
|
nk4um User
Posts: 31
|
hi, installing the database poses some problems. perhaps someone has a quick idea. system is an intel mac with mac os x 10.4.10, java version "1.5.0_07", mysql Ver 14.12 Distrib 5.0.41, for apple-darwin8.5.1
(i686) using readline 5.0, mysql-connector-java-5.0.6-bin.jar (copied into modules/mod-db/lib, cold restart thereafter) i created a user and granted him all privileges i could think of like this:
GRANT ALL PRIVILEGES ON *.* TO ''foo''@''%'' IDENTIFIED BY ''bar'' WITH GRANT OPTION ;
|
then i ran the install form at https://localhost:1060/ep+name@app_blogxter_installer_start with the following settings:
hostname localhost mysql port 3306 db admin user foo db admin pass bar
|
the page returns with the following warning:
|
Error Can not issue SELECT via executeUpdate(). Please check your database permissions. The DB Admin account you use must have remote access and GRANT permissions. Also make
sure you have a MySQL JDBC driver installed in mod_db/lib/.
|
https://localhost:1060/blogxter/ (it''s https in my case, see the other thread http://www.1060.org/forum/topic/265/1 for details)
returns an Internal Server Error which is so long that i hesitate to post it here. but a database named ''blogxter'' was created as well as two users named ''blogxter'' and one user named ''foo''. so the script
apperently did something - but failed somewhere else? or does the problem lie within the blogxter application? thanks in advance for any help! thomas
|
|
nk4um User
Posts: 31
|
2007-05-08T19:06:35.000ZMay 8, 2007 19:06chiba
no, i wouldn''t call that critical, but "(very) nice to have". since pjr above mentioned the lack of snapiness in the chiba-xforms-implementation
that the old blogxter application uses, and since an ajax-ified chiba promises a much better user experience, i just thought
that maybe ... ;-) well, i''m on my first project and other things are certainly more critical to me right now (eg barely getting the whole thing
on track) but in the perspective ajax-supported xforms are definitely important.
|
|
nk4um Administrator
Posts: 158
|
2007-05-08T18:37:03.000ZMay 8, 2007 18:37
Thomas,
Good to be cautious!
NetKernel 3.2 is ready for use. We are very careful about our releases - each one is thoroughly tested and checked for memory
leaks, performance, etc. We have already switched our production servers over to this release and we see no issues.
The new Chiba release you mention is not included in NetKernel 3.2. Is this a critical feature that you need?
Randy
|
|
nk4um User
Posts: 31
|
i saw the new release when i looked for the download but wasn''t sure if it''s already mature. as a newbie the last thing
you want is getting caught by a bug when you have to act on the assumption that it''s all your own fault. but i take your
advice as a hint that you consider it stable. btw: it seem to me like nk 3.2 does not use the new chiba 2.0 library with ajax support. is that right? do you have plans
to do so?
thanks, thomas
|
|
nk4um Administrator
Posts: 158
|
2007-05-08T00:10:18.000ZMay 8, 2007 00:10
Thomas,
Sounds like a great project!
We are here to help, please post any additional questions to the forum.
You might want to download and install NetKernel 3.2. Although we have not posted the announcement yet, it is available on
the download page.
Randy
|
|
nk4um User
Posts: 31
|
i''m just building my very first rdbms-backed project. it has to have a blog, a forum, a media-archive and a website with
some cms - and, of course, has to be finished soon... i hope to get quite far with the modules you provide. thanks a lot for
the fast response! (and stay tuned for more emergency calls... ;-)
|
|
nk4um Moderator
Posts: 755
|
Hi Thomas,
Sorry. Blogxter has been a low priority for us since we now ship this forum application as an in-depth example of a web application.
We still haven''t had time to do a refresh on blogxter - a bit embarrassing since it would only take a couple of days to update.
The reason the front-end is a bit long in the tooth is that it uses XForms quite a lot and we''ve never been too happy with
the need to have a stateful application for the server-side XForm engine - the Chiba library is also relatively slow so the
forms are not as snappy as an AJAX front-end would be. The services module is still fine.
Anyway apart from the age it still works perfectly and has been our production blogging app for many years. I''ve posted
the current modules here...
http://1060.org/upload/blogxter/blogxter-services-1.0.7.jar http://1060.org/upload/blogxter/blogxter-web-1.1.0.jar
You will need MySQL installed and will need to add a mysql jdbc driver to the modules/mod-db/lib directory.
If you install the modules with the module install wizard then after the cold restart you will get a link to the blogxter
installer application in the services module - just fill in the DB settings and you''re all set. You can also get to this
as an entrypoint when you view the services module (control-panel->Module Deployment Report->Blogters-Services).
If you need any help with it just ask.
Cheers,
Peter
|
|
nk4um User
Posts: 31
|
hi, looks like bloxter didn''t make it into the 3.0 release. i happen to need a blog software and i wonder if bloxter is incompatible
with netkernel 3.1 or if you just took it offline because it''s not a good example of a "modern" use of netkernel (eg: "doesn''t
use XRL, so let''s dump it!"). in the latter case i would be very thankfull if you could make the download available to me.
btw, the download is still linked frome here: http://www.1060.org/blogxter/publish/6
thanks, thomas
|
|
nk4um Moderator
Posts: 755
|
Blogxter is now quite an old application - it was developed on NetKernel 1.0. We are currently updating and modernised it
to use the latest and greatest features of NetKernel 3.0. Whilst this work is in progress Blogxter has been temporarily removed
from the list of installable applications.
Watch this space for the updated version.
|