Blogxter Install Unavailable

Poster Content
nk4um User
Posts: 31
July 13, 2007 13: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...
Like · Post Reply
nk4um Moderator
Posts: 899
July 13, 2007 13: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.
Like · Post Reply
nk4um User
Posts: 31
July 13, 2007 13:38mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)
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
Like · Post Reply
nk4um Moderator
Posts: 899
July 13, 2007 12:56MySQL Version?
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.
Like · Post Reply
nk4um User
Posts: 31
July 13, 2007 12:29Internal Server Error
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>
Like · Post Reply
nk4um Moderator
Posts: 899
July 13, 2007 12: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.
Like · Post Reply
nk4um User
Posts: 31
July 13, 2007 12:19it starts to work!
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
Like · Post Reply
nk4um Moderator
Posts: 899
July 13, 2007 09:58/etc/RDBMSConfig.xml
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&amp;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

Like · Post Reply
nk4um User
Posts: 31
July 10, 2007 21: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.
Like · Post Reply
nk4um User
Posts: 31
July 10, 2007 17:11setupDB.xml seems to have passed
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
Like · Post Reply
nk4um User
Posts: 31
July 5, 2007 19: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
Like · Post Reply
nk4um Moderator
Posts: 599
July 5, 2007 06:15MySQL config
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
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 19:53and this is the last System Log Report
   
<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>
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 19:47the rather lengthy stacktrace
<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>
Like · Post Reply
nk4um Moderator
Posts: 599
July 4, 2007 19:28Error getting masked
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
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 19:10
ooouch ... how embarrassing! sorry, tony! hi tony, thanks for coming in :-D
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 18: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.
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 18: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...
Like · Post Reply
nk4um Moderator
Posts: 599
July 4, 2007 17:07I suspect the module needs to be expanded
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
Like · Post Reply
nk4um User
Posts: 31
July 4, 2007 14:16stuck in the database installation
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 
Like · Post Reply
nk4um User
Posts: 31
May 8, 2007 18: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.
Like · Post Reply
nk4um Administrator
Posts: 158
May 8, 2007 17: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
Like · Post Reply
nk4um User
Posts: 31
May 8, 2007 17:293.2 rc2, chiba 2
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
Like · Post Reply
nk4um Administrator
Posts: 158
May 7, 2007 23: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
Like · Post Reply
nk4um User
Posts: 31
May 7, 2007 22:54Thanks a lot!
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... ;-)
Like · Post Reply
nk4um Moderator
Posts: 899
May 5, 2007 12:47Blogxter Download
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
Like · Post Reply
nk4um User
Posts: 31
May 5, 2007 10:10bloxter download
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
Like · Post Reply
nk4um Moderator
Posts: 899
April 14, 2006 12:17Blogxter Install Unavailable
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.
Like · Post Reply