[OGo-Users] URLs Accessible from ZideStore
Kianha x
users@opengroupware.org
Wed, 23 Apr 2008 17:36:25 +0200
------=_Part_22989_11894602.1208964985595
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi,
2008/4/23, Adam Tauno Williams <adam@morrison-ind.com>:
>
> > I can't access the tasks via ZideStore's WebDAV neither with the
> > client webdav (Bitkinex) nor with webdav standard. I think that the
> > url is correct (http://myserver/zidestore/dav/myuser/Tasks). I don't
> > know if I need to do something in special in the Tasks.... if I have
> > the locked access,...
>
>
> No, it looks like it might be a bug. If I use cadaver to
> access /zidestore/dav/adam/Tasks/ and do an ls I see an error in the log
> -
> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: BEGIN
> TRANSACTION
> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: SELECT
> t1.accounting_info, t1.actual_work, t1.associated_companies,
> t1.associated_contacts, t1.category, t1.job_comment, t1.completion_date,
> t1.creator_id, t1.db_status, t1.end_date, t1.executant_id,
> t1.is_control_job, t1.is_team_job, t1.job_id, t1.job_status,
> t1.keywords, t1.kilometers, t1.kind, t1.last_modified, t1.name,
> t1.notify_x, t1.object_version, t1.parent_job_id, t1.percent_complete,
> t1.priority, t1.project_id, t1.sensitivity, t1.source_url,
> t1.start_date, t1.timer_date, t1.total_work FROM job t1 WHERE
> ((t1.job_status <> '30_archived') AND (t1.executant_id IN (10100))
> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: ROLLBACK
> TRANSACTION
> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: <0x0x8b2debc[SxTaskManager]>
> FAILED: (Exception name:PostgreSQL72FatalError
> class:PostgreSQL72Exception reason:fatal pgsql error
> (channel=<0x0x84511b4[PostgreSQL72Channel]:
> connection=<0x0x8488964[PGConnection]: connection=0x0x84a7238>>):
> ERROR: syntax error at end of input
> LINE 1: ...ob_status <> '30_archived') AND (t1.executant_id IN (10100))
>
> I'll check into this.
If you discover what is the problem, you say me it, please.
> 2008/4/22, Adam Tauno Williams <adam@morrison-ind.com>:
> > > I believe the Tasks folder should work for reading, but Tasks via
> > ZideStore's WebDAV/GroupDAV access are read-only.
> > By the other hand, I am trying to upload files (only appoinments and
> > contacts)to OpenGroupware, using two options :Bitkinex and the next
> > code but without successfull:
>
> > HttpURL hrl = new
> > HttpURL("http://myserver/zidestore/dav/myuser/Overview");
> > hrl.setUserinfo("myuser", "mypassword");
> > wdr = new WebdavResource(hrl);
> > File file = new File("C:/Temp/10440.ics");
> > wdr = new WebdavResource(hrl);
> > wdr.putMethod(file); --> return false
> > System.out.println(wdr.getStatusMessage()); --> Method Not Allowed
> > (405)
>
> > Am I using the correct code?
>
>
> I've never used Java to access zidestore, but I've got two questions -
>
> 1.) Try just doing an HTTP PUT.
> 2.) Is the file in the correct format? The "10440.ics" contains a
> single vEvent?
I have uploaded appointments (.ics) but contacts not. Also I have deleted
appointments and contacts.
> When I obtain the appointments, for example , the downloading of files
> > is slow, how can I optimize this? or in general Is slow the manage the
> > files via ZideStore's WEBDAV access ?
>
>
> It isn't the fastest thing in the world, but isn't terrible. Enabling
> profiling and seeing where the time goes would be useful (see WMOGAG).
> Often it is people having never performed a "VACUUM ANALYZE;" on their
> database. There is also a [undocumented] bulk get method which helps
> allot; with it you can retrieve multiple objects in a single request.
I am going to review wmogag, Do you know what is the method?
Thanks you very much,
------=_Part_22989_11894602.1208964985595
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi,<br><br><div><span class="gmail_quote">2008/4/23, Adam Tauno Williams <<a href="mailto:adam@morrison-ind.com">adam@morrison-ind.com</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> I can't access the tasks via ZideStore's WebDAV neither with the<br> > client webdav (Bitkinex) nor with webdav standard. I think that the<br> > url is correct (<a href="http://myserver/zidestore/dav/myuser/Tasks">http://myserver/zidestore/dav/myuser/Tasks</a>). I don't<br>
> know if I need to do something in special in the Tasks.... if I have<br> > the locked access,...<br> <br> <br>No, it looks like it might be a bug. If I use cadaver to<br> access /zidestore/dav/adam/Tasks/ and do an ls I see an error in the log<br>
-<br> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: BEGIN<br> TRANSACTION<br> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: SELECT<br> t1.accounting_info, t1.actual_work, t1.associated_companies,<br>
t1.associated_contacts, t1.category, t1.job_comment, t1.completion_date,<br> t1.creator_id, t1.db_status, t1.end_date, t1.executant_id,<br> t1.is_control_job, t1.is_team_job, t1.job_id, t1.job_status,<br> t1.keywords, t1.kilometers, t1.kind, t1.last_modified, <a href="http://t1.name">t1.name</a>,<br>
t1.notify_x, t1.object_version, t1.parent_job_id, t1.percent_complete,<br> t1.priority, t1.project_id, t1.sensitivity, t1.source_url,<br> t1.start_date, t1.timer_date, t1.total_work FROM job t1 WHERE<br> ((t1.job_status <> '30_archived') AND (t1.executant_id IN (10100))<br>
Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: PG0x0x84511b4 SQL: ROLLBACK<br> TRANSACTION<br> Apr 23 12:21:57 ogo-zidestore-1.5 [6309]: <0x0x8b2debc[SxTaskManager]><br> FAILED: (Exception name:PostgreSQL72FatalError<br>
class:PostgreSQL72Exception reason:fatal pgsql error<br> (channel=<0x0x84511b4[PostgreSQL72Channel]:<br> connection=<0x0x8488964[PGConnection]: connection=0x0x84a7238>>):<br> ERROR: syntax error at end of input<br>
LINE 1: ...ob_status <> '30_archived') AND (t1.executant_id IN (10100))<br> <br> I'll check into this.</blockquote><br><br>If you discover what is the problem, you say me it, please.<br><br><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> 2008/4/22, Adam Tauno Williams <<a href="mailto:adam@morrison-ind.com">adam@morrison-ind.com</a>>:<br> > > I believe the Tasks folder should work for reading, but Tasks via<br> > ZideStore's WebDAV/GroupDAV access are read-only.<br>
> By the other hand, I am trying to upload files (only appoinments and<br> > contacts)to OpenGroupware, using two options :Bitkinex and the next<br> > code but without successfull:<br> <br> > HttpURL hrl = new<br>
> HttpURL("<a href="http://myserver/zidestore/dav/myuser/Overview">http://myserver/zidestore/dav/myuser/Overview</a>");<br> > hrl.setUserinfo("myuser", "mypassword");<br> > wdr = new WebdavResource(hrl);<br>
> File file = new File("C:/Temp/10440.ics");<br> > wdr = new WebdavResource(hrl);<br> > wdr.putMethod(file); --> return false<br> > System.out.println(wdr.getStatusMessage()); --> Method Not Allowed<br>
> (405)<br> <br> > Am I using the correct code?<br> <br> <br>I've never used Java to access zidestore, but I've got two questions -<br> <br> 1.) Try just doing an HTTP PUT.<br> 2.) Is the file in the correct format? The "10440.ics" contains a<br>
single vEvent?</blockquote><div><br>I have uploaded appointments (.ics) but contacts not. Also I have deleted appointments and contacts.<br></div><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
> When I obtain the appointments, for example , the downloading of files<br> > is slow, how can I optimize this? or in general Is slow the manage the<br> > files via ZideStore's WEBDAV access ?<br> <br> <br>
It isn't the fastest thing in the world, but isn't terrible. Enabling<br> profiling and seeing where the time goes would be useful (see WMOGAG).<br> Often it is people having never performed a "VACUUM ANALYZE;" on their<br>
database. There is also a [undocumented] bulk get method which helps<br> allot; with it you can retrieve multiple objects in a single request.</blockquote><div><br><br>I am going to review wmogag, Do you know what is the method?<br>
</div><br></div>Thanks you very much,<br>
------=_Part_22989_11894602.1208964985595--