RE: [Phpgroupware-developers] phpgroupware and coldsync

[Brian Johnson]

You're getting ahead of me ... I need to install the latest P5 modules
installed

I get about 2 hours max per day to work on this and last night I was
installing coldsync and phpgw on my laptop ... so I don't have a working
transfer test station set up quite yet (probably get it done tonight)

As you noted, one of the problems that came up was the realization that the
P5 palm modules didn't handle null values in fields very well

The log messages make this look like two different problems
line 156 is:
          $counter = $counter + 1;

but above that I have the required initialization:
  my $counter = 0;
hmmm ... I'll have to check into that one

In the meantime, compare your categories on the palm against the categories
of the records in phpgw just to make sure things match up.



> -----Original Message-----
> From: address@hidden
> [mailto:address@hidden Behalf Of Adam Hull
> Sent: Wednesday, July 10, 2002 1:20 AM
> To: address@hidden
> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
>
>
> Progress!
>
> Not sure all that did but my ultimate problem was table permissions.
> Despite having
>
> local        all                                           trust
> host         all         127.0.0.1     255.255.255.255     trust
>
> in /var/lib/pgsql/data/pg_hba.conf, I had to set individual
> permissions for
> each table. I am knew to pgsql so I didn't realize this was necessary.
>
> Anyway, I have successfully transfered calendar, addressbook,
> and notes data
> from phpgw into palm. However, todo did not work and nothing
> has moved from
> palm to phpgw. I am now getting this error in the log:
>
> cond_readstatus: <<< "301 Use of uninitialized value in
> addition (+) at
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 156."
> Use of uninitialized value in addition (+) at
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 156.
> run_conduit: got status 301
> Child has printed to stdout.
> cond_readline: About to select()
> cond_readline: select() returned 1
> cond_readstatus: <<< "301 Use of uninitialized value in string ne at
> /usr/lib/perl5/site_perl/5.6.1/Palm/Address.pm line 598."
> Use of uninitialized value in string ne at
> /usr/lib/perl5/site_perl/5.6.1/Palm/Address.pm line 598.
>
> Brian, I saw you discussed this on the coldsync mailing list
> and ultimately
> changes were made to Address.pm? Well I am running p5-palm
> version 1.2.4. I
> think that is that latest. Do you know what might be causing this?
>
> Thanks!
>
> Brian Johnson (address@hidden) wrote*:
> >
> >In the perl program, the HEADERS (phpid in braces) is a pointer to an
> >array
> >
> >The array's name is HEADERS and phpid is one of the values
> in that array -
> >it is defined in the conf file and it also defined at the
> top of the conduit
> >in case it is ommitted from the conf file - that shouldn't
> be the sync
> >problem you're experiencing - it's something else
> >
> >I need to play with it to double check what's happening - in
> the meantime,
> >try the memo conduit - it's the first one I did and spent
> the most time on
> >since it is the easiest (has the fewest fields) - therefore it is the
> >easiest to debug as well
> >
> >
> >> -----Original Message-----
> >> From: address@hidden
> >> [mailto:address@hidden Behalf Of
> Adam Hull
> >> Sent: Tuesday, July 09, 2002 2:12 PM
> >> To: address@hidden
> >> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
> >>
> >>
> >> Hey!
> >> It worked! using the phpgw userid successfully returned
> data like so:
> >> SELECT e.*, p.palm_rec_id, u.cat_name FROM (palm_addressbook
> >> p RIGHT JOIN
> >> phpgw_addressbook e ON p.cal_id = e.id) LEFT JOIN
> >> phpgw_categories u ON e.id =
> >> u.cat_id WHERE e.owner = 4
> >>
> >> so can we replace the question mark with a proper variable?
> >> could we replace it with  ? (those are braces around phpid)
> >>
> >> Brian Johnson (address@hidden) wrote*:
> >> >
> >> >Try replacing the question mark with your phpid - the
> >> results should still
> >> >be the same - I just wanted to make sure you didn't get any
> >> errors to prove
> >> >that the database tables were setup correctly
> >> >
> >> >I'll be a couple of days - I'm setting up my laptop with
> coldsync and
> >> >phpgroupware so that I can trouble shoot when not at the office
> >> >
> >> >I hope I can get my Palm to sync via IR - I got it to work
> >> under Windows
> >> >
> >> >
> >> >
> >> >> -----Original Message-----
> >> >> From: address@hidden
> >> >> [mailto:address@hidden Behalf Of
> >> Adam Hull
> >> >> Sent: Monday, July 08, 2002 7:33 PM
> >> >> To: address@hidden
> >> >> Subject: RE: [Phpgroupware-developers] phpgroupware and coldsync
> >> >>
> >> >>
> >> >> I just ran this query:
> >> >>
> >> >> SELECT e.*, p.palm_rec_id, u.cat_name FROM (palm_addressbook
> >> >> p RIGHT JOIN
> >> >> phpgw_addressbook e ON p.cal_id = e.id) LEFT JOIN
> >> >> phpgw_categories u ON e.id =
> >> >> u.cat_id WHERE e.owner = ?
> >> >>
> >> >> and it returned nothing. is it because the palm_addressbook
> >> >> table is empty?
> >> >> But I would think that palm_addressbook requires no initial
> >> >> data, right?
> >> >>
> >> >>
> >> >> Brian Johnson (address@hidden) wrote*:
> >> >> >
> >> >> >Try connecting to the database with a database tool and
> >> >> perform the query
> >> >> >there
> >> >> >
> >> >> >> -----Original Message-----
> >> >> >> From: address@hidden
> >> >> >> [mailto:address@hidden Behalf Of
> >> >> Adam Hull
> >> >> >> Sent: Wednesday, July 03, 2002 4:51 PM
> >> >> >> To: address@hidden;
> address@hidden
> >> >> >> Cc: address@hidden
> >> >> >> Subject: [Phpgroupware-developers] phpgroupware and coldsync
> >> >> >>
> >> >> >>
> >> >> >> Greetings all, I am cross posting this message to the
> >> >> >> coldsync-hackers and
> >> >> >> phpgroupware-developers mailing lists because I am unsure
> >> >> >> where my issue stems
> >> >> >> from so I apologize in advance to anyone who receives
> >> this twice.
> >> >> >>
> >> >> >> I am continuing Brian Johnson's excellent work on
> >> phpgroupware palm
> >> >> >> synchronization. He has successfully tested the conduits with
> >> >> >> phpgw 0.9.13.018
> >> >> >> (R14 release candidate 3).
> >> >> >>
> >> >> >> Here is my setup:
> >> >> >> Mandrake 8.1
> >> >> >> perl 5.6.1
> >> >> >> postgres 7.1.2
> >> >> >> coldsync 2.2.5
> >> >> >> phpgroupware 0.9.15.002
> >> >> >>
> >> >> >> I am pretty sure I have installed all the necessary perl
> >> >> >> modules and other
> >> >> >> dependencies. I am now getting the following coldsync error
> >> >> >> when I attempt
> >> >> >> synching via netsync.
> >> >> >>
> >> >> >> 401 Error executing sql DBI::db=HASH(0x8200d88)->errstr at
> >> >> >>
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware l07
> >> >> >>
> >> >> >> The above error is followed by:
> >> >> >> cond_readstatus: <<< "301 DBD::Pg::st execute failed:
> >> >> ERROR: Relation
> >> >> >> 'palm_addressbook' does not exist at
> >> >> >>
> >> >>
> >>
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107
> >> >> >> DBD::Pg::st execute failed: ERROR: Relation
> >> >> >> 'palm_addressbook' does not exist
> >> >> >> at
> >> >> >>
> >> >>
> >>
> /usr/share/coldsync-2.2.5/conduits/addressbook-phpgroupware line 107.
> >> >> >>
> >> >> >> The above I believe may just be a chain reaction from the
> >> >> >> failed SQL execution
> >> >> >> but I am not sure.
> >> >> >>
> >> >> >> The line it is failing on in addressbook-phpgroupware is:
> >> >> >> $sth_select_all->execute($HEADERS)
> >> >> >> or die "$err_exec_sql $dbh->errstr";
> >> >> >>
> >> >> >> which might be failing due to this SQL statement:
> >> >> >> my $sth_select_all = $dbh->prepare(
> >> >> >>  "SELECT e.*, p.palm_rec_id, u.cat_name".
> >> >> >>  " FROM (palm_addressbook p RIGHT JOIN phpgw_addressbook e ON
> >> >> >> p.cal_id=e.id)".
> >> >> >>  " LEFT JOIN phpgw_categories u ON e.id = u.cat_id".
> >> >> >>  " WHERE e.owner = ?"
> >> >> >> ) or die $err_prep_sql;
> >> >> >>
> >> >> >> But I compared the above against the phpgw tables and it
> >> >> >> checks out. There
> >> >> >> does not appear to be any table changes between 0.9.13 and
> >> >> >> 0.9.15. And it
> >> >> >> appears as though coldsync is making a connection to pgsql
> >> >> >> because after
> >> >> >> running coldsync and the palm finishes the sync process I do
> >> >> >> a "ps aux" and I
> >> >> >> can see an open postgres connection process still running.
> >> >> >> So, I have no idea
> >> >> >> where this is failing. Any help from anyone would be most
> >> >> appreciated.
> >> >> >>
> >> >> >> Thanks a lot,
> >> >> >> Adam Hull
> >> >> >> http://axisgroupware.org
> >> >> >>
> >> >> >>
> >> >> >> _______________________________________________
> >> >> >> Phpgroupware-developers mailing list
> >> >> >> address@hidden
> >> >> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >> >> >
> >> >> >
> >> >> >_______________________________________________
> >> >> >Phpgroupware-developers mailing list
> >> >> >address@hidden
> >> >> >http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >> >> >
> >> >>
> >> >>
> >> >> _______________________________________________
> >> >> Phpgroupware-developers mailing list
> >> >> address@hidden
> >> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >> >
> >> >
> >> >_______________________________________________
> >> >Phpgroupware-developers mailing list
> >> >address@hidden
> >> >http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >> >
> >>
> >>
> >> _______________________________________________
> >> Phpgroupware-developers mailing list
> >> address@hidden
> >> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >
> >
> >_______________________________________________
> >Phpgroupware-developers mailing list
> >address@hidden
> >http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
> >
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers