Topic: phproject on sme and outlook sync

[ralph]

Hi all,

has anybody any expierience with phproject and phpsync on sme and - on top - any idea where to get phpsync ( www.ds-services.de/phpsync is broken ).

In case one can get that stuff and it really works - whow !

TIA,
Ralph

[Andy Parkinson]

I have just managed to download the files from http://www.ds-services.de/portal/    . You will need to create a free account with them to do the download. If you get stuck let me know and I will put the files on my site for you to download.
I haven't actually tried it out yet . I will try it out and let you know the results

[ralph]

Hi Andy,

thanks for your offer.

I've downloaded the stuff and gonna install it right away.
I'll tell you about it being worth or not - in case it is, it would be a more than interesting solution,

Hold on, ciao,

Ralph

[ralph]

Hi Andy,

got the stuff installed and tried to have a connect - unfortunately no way.

It's in the settings. Hmmm, do you have any idea about the password of the user "root" used in config.inc.php for phproject ?

BR, TIA,

Ralph

[Dan Brown]

For more information on the mysql root password, see http://www.familybrown.org/howtos/mysql-password-howto.html.

[ralph]

Hi Dan,

thanks a lot for your answer and the link to the how-to. Maybe preventet me from crashing something ;->>

As you can imaginge following this track, I'm trying to sync outlook with phproject using sandros phpsync. Connection is done using mysql driver installed on my xp box. When ever I try to connect, I get the errormsg "user@ip-of-my-xp-box" not permitted to log in.

I unfortunately got no idea of dbs at all, so any suggestion would - again - be very welcome.

cheerio,

Ralph

[Guck Puppy]

The problem here is of "grants" in the mysql table on the mysql server.

Your xp machine is not in the "these hosts / ips are allowed to connect to this mysql server" for the database you are trying to access. How do you add it?

Well, phpmyadmin is probably the best bet to use (it is in the contribs list) or you should see if phpprojekt has the ability to change the access details for your database.

Suffice it to say that with phpmyadmin you can easily allow access from your ip address using its built in functions.

Hey, and when you say "Connection is done using mysql driver installed on my xp box" you're talking about the odbc driver for mysql right?

G

[ralph]

Hi Guck Puppy,

thanks for the hint - sounds logical somehow.

gonna give that a try these days and - yes, I'm talking about odbc driver ....

I'll tell you the results right here, cheerio,

Ralph

[Dean Mumby]

Hi

I have been battling with this synctool for a couple days.
Basically they say you need to use the version of myobdc from their site as well as install the mdac_typ.exe from microsoft which is linked from their site. The next problem is the use of unencrypted paswords which can be overcome by deleting the config.inc.php file and the databse then creaing a new database, and running the setup.php script. Personally I dont like using the root account in mysql for anything so I would recomend creating a new user and giving that user rights to the mysql database.

mysql> create database project
mysql> grant all on project.* to projectadmin identified by "projectpass";

this should be sufficient for the user to connect from any internal machine and access the database. I confirmed this using the latest myobdc drivers and running the connection test. As I said though the sync tool only supports the version on their site, and the problem is there is no connection test in that version.

I am using xp pro and I cant find anything saying it will work with xp pro. If any one interested in a possible exchange replacement is running win2k I would be interested to hear if it works for you. I will probably set up a w2k vmware session and give it a go but that may take time.

Good luck