ssis-support — SSiS email-based support

Re: [SSiS-Support] trouble with ssis-address

[bfdi533 <bf...@cb...>]

> In order to get them back you need to do one of two things:
> 
> 2) Run a manual coldsync using the restore mode. Check the man page for 
> coldsync for the full command line options. You will need to turn off 
> any coldsync daemons that are running on that port first (I often use a 
> second port and just swap the cradle over).

Worked beautifully; I realized about 2 hours after I sent this email and
after trying for 3 hours to get this sync to work that I there was a
restore option.  I did get this to work; thanks.

> One way of "importing" the data from an existing palm pilot is to remove 
> the "fetch," from the conduit entry in .coldsyncrc

Ok; so I did that and it worked.  All of my contacts are now in the
database.  I will try to add fetch back and and make sure that they sync
correctly.

I noticed in your documentation that you do not have dump on the todo,
datebook and memo.  Is that because that method is not available on
these items?  Or is it because you normally only use fetch for your
business needs but dump is actually coded?

--------------------------
Ed Davison

[SSiS-Support] trouble with ssis-address

[Ed D. <bf...@cb...>]

Whenever I run this conduit through coldsync my entire AddressDB is
wiped clean.  My .coldsyncrc entry for this is:

conduit fetch,dump {
	path: "/opt/ssis/coldsync/conduits/ssis-address";
	type: addr/DATA;
}

Now I have 2 problems: 

1. How do I get my AddressDB back from a backup (I have tried copying it
to the backup directory and it never restores the info.
2. How do I get this to work properly?  What additional info is needed
for this to be debugged?

-- 

--------------------------
Ed Davison
Sr. Systems Analyst
McCombs School of Business
512-232-6620 voice

Re: [SSiS-Support] use conduits

[Marco v. B. <ma...@84...>]

Karsten Hillmann wrote:

> Hi Marco,
> 
> No I looked a little more ....
> 
> It seems not to work that I update or insert something on the Linux side
> that it ends up on teh palm. I tried it with entries of the Date Book. The
> update and the insert go perfetctly into the DB, but not on the palm.
> 
> There is still something wrong with my setup ... so I looked again into
> /opt/ssis/includes/ssis-defaults.php
>         # HTTP subdirectory
>         # Trying to standardise on ApacheRoot
>         $ApacheRoot = "$HTTP_HOST/$ApacheDir";
>         $ServerRoot = "$HTTP_HOST/$ApacheDir";
> 
> $HTTP_HOST is not set in that file and not in a normal shell in my case.
> 
> In another line (in the part before where Users should/could chage) you say
> $ApacheDir  = "/ssis";
> So, is there a "/" too mutch?

Looks like a mistake there somewhere. I know there was a bug with the 
"index button" (see my previous email), but I can't remember what I did 
to fix it as I am not yet running CVS. I would have to run a diff on the 
two config files to be sure.


> 
> Another thing I just see. (I am not so experienced, so please bi kind if it
> should be visable, that the anserws to my questions should be clear or if my
> questions are stupd.)
> When I go to the admin-site and klick the only user there (ID=1, Palm User
> Name="hillmann), I get t view-users.php. I get the entries except the Name.
> in the .php file is see at $result4 that you query the table "Users" and
> seem to expect a collum "FirstName" and "LastName". In my Users table, these
> collums are missing.

The FirstName and LastName are a leftover from a previous version where 
I linked to the address database using the Address ID. As the Palm 
changes this whenever you edit the record, it was impossible to use, so 
I dropped it and used a text search on the company name instead. I am 
not sure how well that works. I need to rewrite that bit before we get 
to the final beta, as I want to use .htauth with the username and 
password in the MySQL database.

So at the moment, FirstName and LastName are not used.

> 
> 
> And a last thing, to change the DB password for ssis, would it be anough to
> tell ssis-defaults.php the new password?

Yes, it should be. As I have mentioned elsewhere, there is a new config 
file system in the next release.

> 
> 
> Just some questions... hope they are not too anoying or stupide.
> Nothing serius so I really don't want to stop you going into a pub only
> because auf these.
> Acutally, I don't think you would go late into pub because of such emails
> :-)
> 

I am at the stage of life where you remember the headache rather than 
the drink !!

Best regards,

Marco.

Re: [SSiS-Support] use conduits

[Marco v. B. <ma...@84...>]

> Hi Marco,
> 
> Great, ist seems to work now.
> 
> I changed something in /opt/ssis/includes/ssis-defaults.php.
> 
> $ColdSyncLogFile = "$coldsyncData";
> (there was $ssisDirectory extra in the variable)

The next version will use the Perl Log::Lite function, and is much 
neater. I have combined all the config data into a single text based 
config file that both PHP and Perl can read.

> 
> 
> When I use the admin-site and follow the link "ceate/update config-File", it
> also updates /opt/ssis/coldsync/palms
> It changes the unix username to ssis. That is not so nice I think.

It needs to be writable by apache and readable by the coldsync daemon 
(usually started by root). I think I decided th

> 
> The Informataions are now in the DB. Great!!!
> 
> One strage thing with the links.
> My Starting page is: https://192.168.42.254/ssis/
> I already get some informations. (my sceduled things).
> I can follow the link "Address Book" from the menue on the left. I geht the
> first addresses.
> I klick on one of the names and I get the details.
> The strage thing is, when I klick the "INDEX" Button at hte bottom, it says:
> "The requested URL /ssis/address/index.php was not found on this server. "
> Does that tell me, that I have a wront entry in my
> "/opt/ssis/includes/ssis-defaults.php"?

I think you have asked this question in your next email. There is a 
small bug I fixed for the new version. Have a look in the attached file, 
at the code for the index button in the same file on your system. If I 
remember correctly, it is a simple fix.

> 
> Now I have  /opt/ssis/coldsync/users/hillmann/.coldsyncrc and within hillman
> a dir named .palm where the files are.
> Those are the locations that asre expected by ssis?

Yes, that looks right.

> 
> Thanks for your great job to build such a great tool. Now I will have an eye
> if any information gets lost. But I don't expect it.

I have been doing quite a lot of re-writting, especially on logging. It 
   is taking longer than I expected, but I still hope to have v0.1.9 out 
soon.

Thanks for trying it. I started writting it less than a year ago, simple 
because I got tired of not being able to properly share data with the 
other staff at Supporting Role. All the existing solutions (at least the 
ones I found) were either very expensive, or would only run on Windows, 
or both.

Regards,

Marco.

Re: [SSiS-Support] use conduits

[Marco v. B. <ma...@84...>]

Karsten Hillmann wrote:
> Hi,
> 
> I have a machine running Debian as a server and a XP Notebook for normal
> work.
> I unpacked your ssis-tar (0.1.8).
> I used the .sql-scripts to create the MySQL Stuff. (Now there is a
> ssis-database with several tables)
> I installed coldsync.
> The sync itself seems to work. In the directory /home/hillmann/.palm arrived
> the addresses and all the stuff from my clié.
> But when I look at my internal ssis-website, there are still no date from my
> pda.
> 
> I think I missed the part where I should tell coldsync whitch and when to
> use the conduits.

Hi,

SSiS was written to use "virtual" users, so the user data, and the 
.coldsyncrc files are all in a subdirectory os 
ssis/coldsync/users/{username}

If you create a "PDA" user  (which I have just realised has a bug), and 
update the coldsync details, as well as making sure that the 'palms' 
file is linked from /etc to ssis/coldsync, it should work.

To get around the bug, go into MYSQL, (mysql ssis -u ssis -p ) and enter 
"INSERT INTO Users(PalmUserName) VALUES ('Palm User Name');" where Plan 
User Name is the name you have registered on your Palm. As soon as that 
is in place, you should be able to edit all of the values through the 
"System Admin" page. You can get the correct values for this by looking 
at the coldsync log after an unsucessful sync (as it can't find a proper 
match).

Once the user is edited and saved, you can then click on "create/update 
coldsync config files", and that will create the .coldsyncrc files in 
the virtual user subdirectory.

Hope this helps,

Regards,

Marco.



> Do I have to put in the /home/hillmann/.coldsyncrc some lines like:
> 
>  conduit fetch {
>                    path: /opt/ssis/coldsync/conduits/ssis-address
>                        type: addr/DATA;
>                        }
> 
> 
> 
> Same with dump? I hope that I miss only very few thing to get it :-).
> 
> 
> 
> And one thing I don't quite understand in
> /opt/ssis/includes/ssis-defaults.php
> 
> 
> 
>         # Where are the coldsync config and data files going to end up
>         $coldsyncConf = $ssisDirectory ."/coldsync";
>         $coldsyncData = $ssisDirectory ."/coldsync/users";
> 
> could that be in my case
> /home/hillmann/ (for there is the users .coldsyncrc) and
> /home/hillmann/.palm (for the users archive, backup and install directories
> are there)
> 
> But what to do, if there would be another user willing to sync to that
> machine?
> I think I got this wrong ...
> 
> 
> Any case, enjoy the weekend and greetings from Frankfurt / Germany.
> 
> 
> Karsten
> 
> 
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by EclipseCon 2004
> Premiere Conference on Open Tools Development and Integration
> See the breadth of Eclipse activity. February 3-5 in Anaheim, CA.
> http://www.eclipsecon.org/osdn
> _______________________________________________
> ssis-support mailing list
> ssi...@li...
> https://lists.sourceforge.net/lists/listinfo/ssis-support
> 

[SSiS-Support] use conduits

[Karsten H. <k.h...@gm...>]

Hi,

I have a machine running Debian as a server and a XP Notebook for normal
work.
I unpacked your ssis-tar (0.1.8).
I used the .sql-scripts to create the MySQL Stuff. (Now there is a
ssis-database with several tables)
I installed coldsync.
The sync itself seems to work. In the directory /home/hillmann/.palm arrived
the addresses and all the stuff from my clié.
But when I look at my internal ssis-website, there are still no date from my
pda.

I think I missed the part where I should tell coldsync whitch and when to
use the conduits.
Do I have to put in the /home/hillmann/.coldsyncrc some lines like:

 conduit fetch {
                   path: /opt/ssis/coldsync/conduits/ssis-address
                       type: addr/DATA;
                       }



Same with dump? I hope that I miss only very few thing to get it :-).



And one thing I don't quite understand in
/opt/ssis/includes/ssis-defaults.php



        # Where are the coldsync config and data files going to end up
        $coldsyncConf = $ssisDirectory ."/coldsync";
        $coldsyncData = $ssisDirectory ."/coldsync/users";

could that be in my case
/home/hillmann/ (for there is the users .coldsyncrc) and
/home/hillmann/.palm (for the users archive, backup and install directories
are there)

But what to do, if there would be another user willing to sync to that
machine?
I think I got this wrong ...


Any case, enjoy the weekend and greetings from Frankfurt / Germany.


Karsten

Re: [SSiS-Support] table structure

[Marco v. B. <ma...@84...>]

Hi Peer,

The only reason is that I started with Palmuser in the first table, and 
then realised it could be more generic. Since I have to change quite a 
bit of code, I decided to leave it alone as the current version is 
nearly stable. I have recently fixed a couple more bugs and it looks 
like I will post a new version to SourceForge in the next couple of 
weeks. I have been working on a Datebook export to Quickbooks Timer 
format that I am hoping to include before uploading 0.1.9.

Regards,

Marco.

Peer Oliver Schmidt wrote:

> Good day,
>
> I "stumbled" across SSIS today, and took a look at the table 
> structure. Is there a reason for having different fieldnames for the 
> same information? We have palmusers in todo, user in 
> memo,datebook,address and expense??
>
> Any kind of information is greatly appreciated.
>
> Best regards
>
> Peer Oliver Schmidt
> the internet company
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> ssis-support mailing list
> ssi...@li...
> https://lists.sourceforge.net/lists/listinfo/ssis-support
>

[SSiS-Support] table structure

[Peer O. S. <po...@th...>]

Good day,

I "stumbled" across SSIS today, and took a look at the table structure. 
Is there a reason for having different fieldnames for the same 
information? We have palmusers in todo, user in memo,datebook,address 
and expense??

Any kind of information is greatly appreciated.

Best regards

Peer Oliver Schmidt
the internet company

[SSiS-Support] LDIF export

[Marco v. B. <ma...@84...>]

Hi,

For those of you who may wish to get something going with LDAP, I have 
attached an export utility with would normally live in 
ssis/public_html/address. It creates an LDIF file that you can import 
into your OpenLDAP database with the following line:

ldapadd -h localhost -D "uid=ldapadmin,dc=supporting-role,dc=co,dc=uk" 
-W -v -x -c -f /opt/ssis/exports/ssis-address.ldif

(changing of course the bind DN to yours).

I am also looking into the option of running the SSiS database as an 
OpenLDAP back end rather than trying to replicate between the two 
systems. Although it would mean that an external LDAP server could not 
be used, it would remove considerable complexity in trying to determine 
which database entry was the newest, and what to do it both have 
changed. At the moment the only way I can see of doing it is to have a 
table with three fields: ID, MySQL timestamp, and LDAP timestamp, based 
on what the replication program found last time through.

Regards,

Marco

PS: I am away for a few days, hopefully getting some sun, so apologies 
if I do not respond to emails until late next week.

[SSiS-Support] Test

[Marco v. B. <ma...@84...>]

Test Message