Hi, Very happy user of community edition. I'm moving to a new server. I copied over the web root for clipperz. The web page comes up fine. I then did this: 1) created a clipperz database 2) did a typical backup and restore copy to the new server.
It looks like I did this ok... mysql> show tables; +-----------------------+ | Tables_in_clipperz | +-----------------------+ | base64_data | | onetimepassword | | onetimepasswordstatus | | record | | recordversion | | user | +-----------------------+ 6 rows in set (0.00 sec)
On Wed, May 23, 2012 at 1:20 AM, eric <emill...@gmail.com> wrote:
> Hi, Very happy user of community edition.
> I'm moving to a new server.
> I copied over the web root for clipperz.
> The web page comes up fine.
> I then did this:
> 1) created a clipperz database
> 2) did a typical backup and restore copy to the new server.
> It looks like I did this ok...
> mysql> show tables;
> +-----------------------+
> | Tables_in_clipperz |
> +-----------------------+
> | base64_data |
> | onetimepassword |
> | onetimepasswordstatus |
> | record |
> | recordversion |
> | user |
> +-----------------------+
> 6 rows in set (0.00 sec)
> However, I cannot login...
> Thanks!
> --
> You received this message because you are subscribed to the Google Groups
> "Clipperz" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/clipperz/-/bvLSeQ-oqWYJ.
> To post to this group, send email to clipperz@googlegroups.com.
> To unsubscribe from this group, send email to
> clipperz+unsubscribe@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/clipperz?hl=en.
On Wednesday, May 23, 2012 1:49:06 AM UTC-6, Alrik wrote:
> Did you enter the correct db details in the configuration of clipperz?
> Regards, > Alrik
> On Wed, May 23, 2012 at 1:20 AM, eric <emill...@gmail.com> wrote:
>> Hi, Very happy user of community edition. >> I'm moving to a new server. >> I copied over the web root for clipperz. >> The web page comes up fine. >> I then did this: >> 1) created a clipperz database >> 2) did a typical backup and restore copy to the new server.
>> It looks like I did this ok... >> mysql> show tables; >> +-----------------------+ >> | Tables_in_clipperz | >> +-----------------------+ >> | base64_data | >> | onetimepassword | >> | onetimepasswordstatus | >> | record | >> | recordversion | >> | user | >> +-----------------------+ >> 6 rows in set (0.00 sec)
>> However, I cannot login...
>> Thanks!
>> -- >> You received this message because you are subscribed to the Google Groups >> "Clipperz" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/clipperz/-/bvLSeQ-oqWYJ. >> To post to this group, send email to clipperz@googlegroups.com. >> To unsubscribe from this group, send email to >> clipperz+unsubscribe@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/clipperz?hl=en.
On Friday, June 8, 2012 10:25:14 AM UTC-6, eric wrote:
> i believe I entered the correct db details. > It all seems to work fine. Just will not accept my pw.
> On Wednesday, May 23, 2012 1:49:06 AM UTC-6, Alrik wrote:
>> Did you enter the correct db details in the configuration of clipperz?
>> Regards, >> Alrik
>> On Wed, May 23, 2012 at 1:20 AM, eric <emill...@gmail.com> wrote:
>>> Hi, Very happy user of community edition. >>> I'm moving to a new server. >>> I copied over the web root for clipperz. >>> The web page comes up fine. >>> I then did this: >>> 1) created a clipperz database >>> 2) did a typical backup and restore copy to the new server.
>>> It looks like I did this ok... >>> mysql> show tables; >>> +-----------------------+ >>> | Tables_in_clipperz | >>> +-----------------------+ >>> | base64_data | >>> | onetimepassword | >>> | onetimepasswordstatus | >>> | record | >>> | recordversion | >>> | user | >>> +-----------------------+ >>> 6 rows in set (0.00 sec)
>>> However, I cannot login...
>>> Thanks!
>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Clipperz" group. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msg/clipperz/-/bvLSeQ-oqWYJ. >>> To post to this group, send email to clipperz@googlegroups.com. >>> To unsubscribe from this group, send email to >>> clipperz+unsubscribe@googlegroups.com. >>> For more options, visit this group at >>> http://groups.google.com/group/clipperz?hl=en.
Wow, sorry for all these posts. Ok, I corrected the configuration.php file to provide the root password. The mysql connect error is now gone but login still fails.
This is all that's in the log:
[Fri Jun 08 11:34:06 2012] [error] [client 127.0.0.1] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/clipperz/php/objects/class.database.php on line 52, referer: http://htpc2/clipperz/index.html
On Tuesday, May 22, 2012 5:20:10 PM UTC-6, eric wrote:
> Hi, Very happy user of community edition. > I'm moving to a new server. > I copied over the web root for clipperz. > The web page comes up fine. > I then did this: > 1) created a clipperz database > 2) did a typical backup and restore copy to the new server.
> It looks like I did this ok... > mysql> show tables; > +-----------------------+ > | Tables_in_clipperz | > +-----------------------+ > | base64_data | > | onetimepassword | > | onetimepasswordstatus | > | record | > | recordversion | > | user | > +-----------------------+ > 6 rows in set (0.00 sec)
Ok, figured it out. It was really all just mistakes on my part...
Here is what worked for me: 1) Copy over your database (mysqldump) 2) Make sure the configuration.php file for clipperz has the correct root pw if you have mysql set up this way. On my old server root could login without a pw and that was not the case on the new mysql install. 3) Turn off db encoding in the configuration file: $configuration['db_encoding'] = 0; 4) run the setup php, do the align tables bit and then go to modules an enable base_64 5) Set db encoding back to on $configuration['db_encoding'] = 1;
On Friday, June 8, 2012 11:37:19 AM UTC-6, eric wrote:
> Wow, sorry for all these posts. Ok, I corrected the configuration.php file > to provide the root password. > The mysql connect error is now gone but login still fails.
> This is all that's in the log:
> [Fri Jun 08 11:34:06 2012] [error] [client 127.0.0.1] PHP Warning: > mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in > /var/www/clipperz/php/objects/class.database.php on line 52, referer: > http://htpc2/clipperz/index.html
> On Tuesday, May 22, 2012 5:20:10 PM UTC-6, eric wrote:
>> Hi, Very happy user of community edition. >> I'm moving to a new server. >> I copied over the web root for clipperz. >> The web page comes up fine. >> I then did this: >> 1) created a clipperz database >> 2) did a typical backup and restore copy to the new server.
>> It looks like I did this ok... >> mysql> show tables; >> +-----------------------+ >> | Tables_in_clipperz | >> +-----------------------+ >> | base64_data | >> | onetimepassword | >> | onetimepasswordstatus | >> | record | >> | recordversion | >> | user | >> +-----------------------+ >> 6 rows in set (0.00 sec)
