Re: [xwiki-users] monitoring tools?

2012-05-14 Thread Sergiu Dumitriu

On 05/14/2012 11:54 AM, Paul Libbrecht wrote:

Is there really no-one using any monitoring tools?
How is the myxwiki.org farm monitored?



Yep, we're doing monitoring, but the sysadmins are the only ones that 
can answer that question. They probably haven't notice this thread yet.


Did you see https://github.com/xwiki-contrib/xwiki-glimpse ?



Paul


Le 9 mai 2012 à 13:05, Paul Libbrecht a écrit :



Hello XWiki users,

I'd like to know what the users of XWiki use as monitoring tools.

Does anyone have experience with Nagios? Zabbix? AlertSite?
Another?
A hand-made solution?
(I haven't met one that is java based, that'd be cute!)

Here's my answer:
- with i2geo.net, we used Nagios, it was relatively faithful at warning of downtime and 
even at warning "failed restart" (which remain a mystery to me but happen, from 
time to time)

- with curriki.org, we use AlertSite, it works very well to warn about the 
downtime and plot performance changes. Internally, also, we use a script to 
detect too long response times and restart (which happens when queries start to 
lock too many other queries) and a hand-made monitoring tool which displays a 
synchronized overview of the top, page loading time, apache and appservlogs, 
and mysql queries; it's a youngish but can help diagnose.





--
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] monitoring tools?

2012-05-14 Thread Roman Muntyanu
We use Nagios + http://www.pnp4nagios.org/ to monitor status of our XWiki 
server (single instance).
It provides us with history records and charts on vast set of parameters (CPU 
load, Disk IO, Memory used, Number of threads, TCP Connections, Uptime and more)

Don't ask me how it's configured - I'm just a happy user :)

-Original Message-
From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of 
Paul Libbrecht
Sent: Monday, May 14, 2012 18:54 PM
To: XWiki Users
Subject: Re: [xwiki-users] monitoring tools?

Is there really no-one using any monitoring tools?
How is the myxwiki.org farm monitored?

thanks in advance

Paul


Le 9 mai 2012 à 13:05, Paul Libbrecht a écrit :

> 
> Hello XWiki users,
> 
> I'd like to know what the users of XWiki use as monitoring tools.
> 
> Does anyone have experience with Nagios? Zabbix? AlertSite?
> Another?
> A hand-made solution?
> (I haven't met one that is java based, that'd be cute!)
> 
> Here's my answer: 
> - with i2geo.net, we used Nagios, it was relatively faithful at warning of 
> downtime and even at warning "failed restart" (which remain a mystery to me 
> but happen, from time to time)
> 
> - with curriki.org, we use AlertSite, it works very well to warn about the 
> downtime and plot performance changes. Internally, also, we use a script to 
> detect too long response times and restart (which happens when queries start 
> to lock too many other queries) and a hand-made monitoring tool which 
> displays a synchronized overview of the top, page loading time, apache and 
> appservlogs, and mysql queries; it's a youngish but can help diagnose.

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] monitoring tools?

2012-05-14 Thread Paul Libbrecht
Is there really no-one using any monitoring tools?
How is the myxwiki.org farm monitored?

thanks in advance

Paul


Le 9 mai 2012 à 13:05, Paul Libbrecht a écrit :

> 
> Hello XWiki users,
> 
> I'd like to know what the users of XWiki use as monitoring tools.
> 
> Does anyone have experience with Nagios? Zabbix? AlertSite?
> Another?
> A hand-made solution?
> (I haven't met one that is java based, that'd be cute!)
> 
> Here's my answer: 
> - with i2geo.net, we used Nagios, it was relatively faithful at warning of 
> downtime and even at warning "failed restart" (which remain a mystery to me 
> but happen, from time to time)
> 
> - with curriki.org, we use AlertSite, it works very well to warn about the 
> downtime and plot performance changes. Internally, also, we use a script to 
> detect too long response times and restart (which happens when queries start 
> to lock too many other queries) and a hand-made monitoring tool which 
> displays a synchronized overview of the top, page loading time, apache and 
> appservlogs, and mysql queries; it's a youngish but can help diagnose.

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] pb in UsedSpace document in Admin Tools Application

2012-05-14 Thread CHENEAU-GREHALLE Nicolas
Hi,

 

I think there's a problem in UsedSpace for Admin Tools Application.

If we change the default values for "xwiki.db" and "xwiki.db.prefix"
parameters (in xwiki.cfg), the code of "showSpaceUsed" procedure doesn't
work :

 

def showSpaceUsed(message, table, wiki) {

 def mwikiquery = (wiki=="") ? "" : "AND TABLE_SCHEMA = '${wiki}'"

 def query = (table=="") ? "SELECT SUM(DATA_LENGTH)/1024/1024 as 'space'
FROM INFORMATION_SCHEMA.TABLES  WHERE 1=1 ${mwikiquery}" : "SELECT
SUM(DATA_LENGTH)/1024/1024 as 'space' FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_NAME='${table}' ${mwikiquery}"

 

For example with "xwiki.db=manager" and "xwiki.db.prefix=xwiki_" :

 

My table is "xwiki_manager" and not "xwiki".

 

As result :

 

Wiki xwiki

oTotal Space used:  ? (No signature of method: static
java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oAttachment Space used:  ? (No signature of method: static
java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oAttachment History Space used:  ? (No signature of method: static
java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oAttachment Recycle bin Space used:  ? (No signature of method:
static java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oHistory Space used:  ? (No signature of method: static
java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oRecycle bin Space used:  ? (No signature of method: static
java.lang.Math.floor() is applicable for argument types:
(java.lang.String) values: []
Possible solutions: floor(double), log(double), find(), acos(double),
cos(double), cosh(double)

oOther Space used 0.0MB

 

 

Best regards,

 

Nicolas

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Java api/method th get the text content of xwiki page?

2012-05-14 Thread Eduard Moraru
Hi,

Why are you trying to use the scripting (wrapping) API when you are in Java
and not use directly the core API?

DocumentReference docRef = new DocumentReference("xwiki", "MySpace1",
"WebHome");
XWiki xwiki = context.getWiki();
XWikiDocument document = xwiki.getDocument(docRef, context);
String documentContent = document.getContent();

Thanks,
Eduard

On Mon, May 14, 2012 at 12:52 PM, mohit gupta  wrote:

> Hi All,
>
> i created a space i.e MySpace1. On WebHome, i put the some content i.e
> "This is my latest content". Now in my java class, i want to get the
> content
> of MySpace1.WebHome page . Here  is the code snippet i tried to get the
> content of page but i get the document1 as null though the page exists.
>
>   com.xpn.xwiki.api.XWiki xwikiApi= new
> com.xpn.xwiki.api.XWiki(context.getWiki(),context);
>  Document document1=null;
>  try {
>  document1 = xwikiApi.getDocument("MySpace1.WebHome");//
> getting document1  as null
>  } catch (XWikiException e) {
>log.info("did not find OrgDataCreation.WebHome page");
>
>  }
>  String contentStr="";
>  if(document1!=null)
>  {
>  contentStr=document1.getContent();
>
>  }
>
>  I am not sure what i am missing here?
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] XWQL issue

2012-05-14 Thread Vincent Massol

On May 14, 2012, at 12:25 PM, Jeremie BOUSQUET wrote:

> If, like me, you want to keep your xwql readable, you can also add this
> after assigning the xwql string :
> 
> #set($xwql = "
>  select ...
> 
> ")
> #set($Q="\n")
> #set($xwql = $xwql.replaceAll("$Q", " "))

Personally I find this less readable but that's just me ;)

Thanks
-Vincent

> It will just remove the carriage-return so XWQL parser does not complain,
> 
> BR,
> Jeremie
> 
> 2012/5/14 Jeremie BOUSQUET 
> 
>> I think I just found the problem ...
>> Instead of :
>> 
>> 
>> #set($findWQL = "
>> from doc.object($classname) as qat
>> ")
>> 
>> ... Write this :
>> 
>> #set($findWQL = " from doc.object($classname) as qat ")
>> 
>> It seems the XWQL parser does not like carriage-return in queries at all
>> ... :)
>> 
>> Best regards,
>> Jeremie
>> 
>> 
>> 2012/5/10 Eugen Colesnicov 
>> 
>>> try
>>> ...
>>> where qat.language like 'en'
>>> ...
>>> 
>>> :) I don't know why
>>> 
>>> --
>>> Best regards
>>> Eugen Colesnicov
>>> 
>>> --
>>> View this message in context:
>>> http://xwiki.475771.n2.nabble.com/XWQL-issue-tp7532124p7546601.html
>>> Sent from the XWiki- Users mailing list archive at Nabble.com.
>>> ___
>>> users mailing list
>>> users@xwiki.org
>>> http://lists.xwiki.org/mailman/listinfo/users
>>> 
>> 
>> 
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] XWQL issue

2012-05-14 Thread Jeremie BOUSQUET
If, like me, you want to keep your xwql readable, you can also add this
after assigning the xwql string :

#set($xwql = "
  select ...

")
#set($Q="\n")
#set($xwql = $xwql.replaceAll("$Q", " "))

It will just remove the carriage-return so XWQL parser does not complain,

BR,
Jeremie

2012/5/14 Jeremie BOUSQUET 

> I think I just found the problem ...
> Instead of :
>
>
> #set($findWQL = "
>  from doc.object($classname) as qat
>  ")
>
> ... Write this :
>
> #set($findWQL = " from doc.object($classname) as qat ")
>
> It seems the XWQL parser does not like carriage-return in queries at all
> ... :)
>
> Best regards,
> Jeremie
>
>
> 2012/5/10 Eugen Colesnicov 
>
>> try
>> ...
>>  where qat.language like 'en'
>> ...
>>
>> :) I don't know why
>>
>> --
>> Best regards
>> Eugen Colesnicov
>>
>> --
>> View this message in context:
>> http://xwiki.475771.n2.nabble.com/XWQL-issue-tp7532124p7546601.html
>> Sent from the XWiki- Users mailing list archive at Nabble.com.
>> ___
>> users mailing list
>> users@xwiki.org
>> http://lists.xwiki.org/mailman/listinfo/users
>>
>
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] XWQL issue

2012-05-14 Thread Jeremie BOUSQUET
I think I just found the problem ...
Instead of :

#set($findWQL = "
 from doc.object($classname) as qat
 ")

... Write this :
#set($findWQL = " from doc.object($classname) as qat ")

It seems the XWQL parser does not like carriage-return in queries at all
... :)

Best regards,
Jeremie

2012/5/10 Eugen Colesnicov 

> try
> ...
>  where qat.language like 'en'
> ...
>
> :) I don't know why
>
> --
> Best regards
> Eugen Colesnicov
>
> --
> View this message in context:
> http://xwiki.475771.n2.nabble.com/XWQL-issue-tp7532124p7546601.html
> Sent from the XWiki- Users mailing list archive at Nabble.com.
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
>
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


[xwiki-users] Java api/method th get the text content of xwiki page?

2012-05-14 Thread mohit gupta
Hi All,

i created a space i.e MySpace1. On WebHome, i put the some content i.e
"This is my latest content". Now in my java class, i want to get the content
of MySpace1.WebHome page . Here  is the code snippet i tried to get the
content of page but i get the document1 as null though the page exists.

   com.xpn.xwiki.api.XWiki xwikiApi= new
com.xpn.xwiki.api.XWiki(context.getWiki(),context);
 Document document1=null;
 try {
  document1 = xwikiApi.getDocument("MySpace1.WebHome");//
getting document1  as null
 } catch (XWikiException e) {
log.info("did not find OrgDataCreation.WebHome page");

 }
 String contentStr="";
 if(document1!=null)
 {
  contentStr=document1.getContent();

 }

 I am not sure what i am missing here?
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users