[xwiki-users] How to enable admin rights (was: Re: xwiki mysql plugin problem) - xwiki-users@xwiki.org

27 Nov 2009

...
  You was right, I have no programming rights. But I
dont know where to set
 them. Because I dont have no administration button in my xwiki. I import
 XAR
 file with templates etc, and when I log as new user I have any rights to
 do
 something.

 You can import xwiki-manager.xar to receive administration UI.

But this theme is specific to you wiki installation (I don't know what
wiki you installed and how) and are xwiki-specific.

So, I will redirect this to xwiki mail list.

...
  2009/11/27 Ruslan Shevchenko
&lt;rssh(a)gradsoft.com.ua&gt;

 1. are user, which do changes, have programming rights ?
 (add logEnabled to config, to check this)
 [ see

http://redmine.gradsoft.ua/repositories/entry/jungleplatform/platform/web/x…
 ] line 31

 2. Otherwise, on debug enabled you must see messages.
 (see

http://redmine.gradsoft.ua/repositories/entry/jungleplatform/platform/web/x…
 line 85)

  So I made some changes:

 context.xml

 <Context>

      <Resource name="jdbc/hw" auth="Container" 
type="javax.sql.DataSource"
                 maxActive="100"
maxIdle="30" maxWait="10000"
                username="root" password="polop"
 driverClassName="com.mysql.jdbc.Driver"
                url="jdbc:mysql://localhost:3306/hw"/>
     <WatchedResource>WEB-INF/web.xml</WatchedResource>
 </Context>

 web.xml in xwiki inside <web-app>

   <resource-ref>
       <description>DB Connection</description>
       <res-ref-name>jdbc/hw</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
   </resource-ref>

 log4j was added

 in catalina.log there are just informations about start or stop

 I add this line to xwiki.cfg
 xwikisql.initialContextPrefix=jdbc

 this code was used in velocity:

 #set($plugin = $xwiki.sql) plugin is $plugin #set($db =
 $plugin.getDatabase('hw')) db is $db

 and result is:

 plugin is ua.gradsoft.xwikisql.SqlPluginApi@802ed1

 db is $db