Issue installing Clipperz Community Edition

[jaminto]

hi everyone.
let me first say how awesome the clipperz project is. carrying around
a usb key with all your passwords is such a pain. and being able to
install this on your own server makes this the perfect password
storage solution.

so, i'm psyched to get it set up and working.

however, after a late night fighting to get PHP5 and mysql installed
on my windows box with IIS7, Clipperz at least looks like it's
working. However during the setup, POG spit out a bunch of errors.
the POG output is at the end of this message.

I can then create an account on clipperz, login, and add cards.
However when I view the cards, I get this error:
Error while downloading the card
missing ) in parenthetical

Any ideas how to fix? I'm using x64 versions of mysql and PHP5.
could that be the issue?

***PHP/SERVER INFO ****
* PHP 5.2.5 x64
* Microsoft-IIS/7.0
* MySQL client version: 5.0.19
* PHP extension: mysql

*** MYSQL INFO ***
* Server: localhost via TCP/IP
* Server version: 5.0.67-community-nt
* Protocol version: 10
* User: jason@localhost
* MySQL charset: UTF-8 Unicode (utf8)

***POG OUTPUT******

Initializing POG Setup....OK!
File Structure....OK!
Configuration Info....OK!

Storage Status
Aligning [onetimepassword] with table 'onetimepassword'....OK!
Aligning [onetimepasswordstatus] with table
'onetimepasswordstatus'....OK!
Aligning [record] with table 'record'....OK!
Aligning [recordversion] with table 'recordversion'....OK!
Aligning [user] with table 'user'....OK!

POG Essentials
[onetimepassword]
Save() failed
SaveNew() ignored
Delete() ignored
GetList()
GetList() ignored
DeleteList() ignored
Optimizing....OK!
***
[onetimepasswordstatus]
Save()....OK!
SaveNew()....OK!
Delete()....OK!
GetList()
Limit....OK!
Sorting....OK!
DeleteList()....OK!
Optimizing....OK!
***
[record]
Save() failed
SaveNew() ignored
Delete() ignored
GetList()
GetList() ignored
DeleteList() ignored
Optimizing....OK!
***
[recordversion]
Save() failed
SaveNew() ignored
Delete() ignored
GetList()
GetList() ignored
DeleteList() ignored
Optimizing....OK!
***
[user]
Save()....OK!
SaveNew()....OK!
Delete()....OK!
GetList()
Limit....OK!
Sorting....OK!
DeleteList()....OK!
Optimizing....OK!

CHECKED 5 OBJECT(S). FOUND 3 ERROR(S):
---------------------------------------------------
Query failed: insert into `onetimepassword` (`userid`,
`onetimepasswordstatusid`, `reference`, `key`, `key_checksum`, `data`,
`version`, `creation_date`, `request_date`, `usage_date` ) values (
'',
'',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26' )

Object onetimepassword failed essential tests

Query failed: insert into `record` (`userid`, `reference`, `data`,
`version`, `creation_date`, `update_date`, `access_date` ) values (
'',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26' )

Object record failed essential tests

Query failed: insert into `recordversion` (`recordid`, `reference`,
`header`, `data`, `version`, `previous_version_key`,
`previous_version_id`, `creation_date`, `update_date`, `access_date` )
values (
'',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'Lorem Ipsum is simply dummy text of the printing and typesetting
industry',
'12345678',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26',
'1997-12-15 23:50:26' )

Object recordversion failed essential tests

[jaminto]

i reinstalled php and mysql with the 32bit versions and the problem
persists.

can someone say what exact version of PHP and mysql clipperz is tested
and verified to be working on? seems clipperz.com is working fine, so
maybe posting the versions of that installation would help.

i have bcmath installed and magic_quotes_gpc set On

this seems to be the same symptoms as this thread which seems to be
unresolved:
http://groups.google.com/group/clipperz/browse_thread/thread/79f841c46028edd1

this also may be the same issue posted in this bug:
http://sourceforge.net/tracker/index.php?func=detail&aid=1936791&group_id=223257&atid=1058390

separately, there are two versions of the same files with different
capitalization checked into the sourceforge.net SVN repository. i
don't think this was intentional. this is messing up tortoiseSVN when
you try to do a checkout. the files are Bookmarklet_IE.js <->
bookmarklet_ie.js and Bookmarklet.js <-> bookmarklet.js in the
javascript source directory:
http://clipperz.svn.sourceforge.net/viewvc/clipperz/trunk/community.edition/js/src/

still i think this bookmarklet code is unrelated to the operation of
the site, and running this latest version from svn i still have the
same issues.

thanks again for the help

[Giulio Cesare Solaroli]

Hello Jason,

I am sorry for your trouble, but my limited experience with PHP is not
very helpful here.

Clipperz Community Edition has some running installations, but its not
the same version used on the main Clipperz.com site; there we use a
completely different backend, base on Java + PostgreSQL.

It seems like POG is not able to completely configure the DB in
question; you may try to search on the POG resources if someone more
knowledgeable can help you.

We will check for the files with different capitalization on their
names and fix them, but they should not be the problem here.

Best regards,

Giulio Cesare

[jaminto]

is the author that created the community edition code base available
to work on this issue?

it would really be helpful to know what OS and versions of php and
mysql that Clipperz Community Edition has been successfully installed
on.

as it is right now, it seems clipperz community edition is unusable in
its current state.

thanks

On Nov 21, 2:51 pm, "Giulio Cesare Solaroli" <giulio.ces...@gmail.com>
wrote:

> Hello Jason,
>
> I am sorry for your trouble, but my limited experience with PHP is not
> very helpful here.
>
> Clipperz Community Edition has some running installations, but its not
> the same version used on the main Clipperz.com site; there we use a
> completely different backend, base on Java + PostgreSQL.
>
> It seems like POG is not able to completely configure the DB in
> question; you may try to search on the POG resources if someone more
> knowledgeable can help you.
>
> We will check for the files with different capitalization on their
> names and fix them, but they should not be the problem here.
>
> Best regards,
>
> Giulio Cesare
>

> On Fri, Nov 21, 2008 at 5:16 PM, jaminto <jason.ami...@gmail.com> wrote:
>
> > i reinstalled php and mysql with the 32bit versions and the problem
> > persists.
>
> > can someone say what exact version of PHP and mysql clipperz is tested
> > and verified to be working on?  seems clipperz.com is working fine, so
> > maybe posting the versions of that installation would help.
>
> > i have bcmath installed and magic_quotes_gpc set On
>
> > this seems to be the same symptoms as this thread which seems to be
> > unresolved:

> >http://groups.google.com/group/clipperz/browse_thread/thread/79f841c4...

>
> > this also may be the same issue posted in this bug:

> >http://sourceforge.net/tracker/index.php?func=detail&aid=1936791&grou...

>
> > separately, there are two versions of the same files with different
> > capitalization checked into the sourceforge.net SVN repository.  i
> > don't think this was intentional.  this is messing up tortoiseSVN when
> > you try to do a checkout.  the files are Bookmarklet_IE.js <->
> > bookmarklet_ie.js and Bookmarklet.js <-> bookmarklet.js in the
> > javascript source directory:

> >http://clipperz.svn.sourceforge.net/viewvc/clipperz/trunk/community.e...

[jaminto]

I posted this issue to the POG google group here:
http://groups.google.com/group/Php-Object-Generator/browse_thread/thread/c3375232174679bb

They suggested it may be an issue with the sql-mode in the mysql
configuration that apparently ONLY affects MySQL 5 running on Windows:
http://groups.google.com/group/Php-Object-Generator/browse_thread/thread/80977b3d1468cb4d/

unfortunately, i made the change to the my.ini file, restarted my
whole machine and still had issues.

[Giulio Cesare Solaroli]

Hello Jason,

sorry for the long time it took me to answer your questions; I am
actually the author of the community edition, but my experience with
PHP + MySQL is very limited.

We will try to assemble a stripped down VMWare virtual machine with
Clipperz Community Edition install, so that people interested may at
least have a working reference installation.

Not sure when we will be able to find the time to assemble it, but we
will do our best.

Regards,

Giulio Cesare

[jaminto]

Hi Giulio Cesare,
it turns out the previously mentioned strict setting in MySQL was the
issue and now Clipperz Community Edition is running fine on my Vista
machine (happy times!)

i was making the change to my.ini mentioned in my previous post
(commenting out the sql-mode entry), but User Account Control (UAC)
was somehow preventing the system from using my modified file. After
a system restart, the file was back to its original state.

i ended up disabling UAC and now with the sql-mode config entry set to
nothing (ie. sql-mode=""), the POG setup completed successfully.

if someone wants to keep UAC enabled and change the my.ini file, they
can try this more complicated solution:
http://remy.supertext.ch/2007/11/changing-the-mysql-myini-file-in-windows-vista/

To make sure your changes take effect, you can run this from the mysql
command line:
SELECT @@GLOBAL.sql_mode;

Here's the mysql documentation on the sql_mode setting:
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html

Thanks for your help Giulio Cesare. I'm excited to finally get it up
and running!

On Nov 30, 8:27 am, "Giulio Cesare Solaroli" <giulio.ces...@gmail.com>
wrote:

> Hello Jason,
>
> sorry for the long time it took me to answer your questions; I am
> actually the author of the community edition, but my experience with
> PHP + MySQL is very limited.
>
> We will try to assemble a stripped down VMWare virtual machine with
> Clipperz Community Edition install, so that people interested may at
> least have a working reference installation.
>
> Not sure when we will be able to find the time to assemble it, but we
> will do our best.
>
> Regards,
>
> Giulio Cesare
>

> On Sun, Nov 30, 2008 at 6:50 AM, jaminto <jason.ami...@gmail.com> wrote:
>
> > I posted this issue to the POG google group here:

> >http://groups.google.com/group/Php-Object-Generator/browse_thread/thr...

>
> > They suggested it may be an issue with the sql-mode in the mysql
> > configuration that apparently ONLY affects MySQL 5 running on Windows:

> >http://groups.google.com/group/Php-Object-Generator/browse_thread/thr...

[Giulio Cesare Solaroli]

Hello Jason,

thank you very much for the detailed report on how you have been able
to fix your setup.

Enjoy Clipperz, and keep us updated on your findings!

Regards,

Giulio Cesare