How to move to new server

[eric]

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!

[Alrik Bronsema]

Did you enter the correct db details in the configuration of clipperz?

Regards,

Alrik

--
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 clip...@googlegroups.com.
To unsubscribe from this group, send email to clipperz+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/clipperz?hl=en.

[eric]

i believe I entered the correct db details.

It all seems to work fine. Just will not accept my pw.

Alrik

To unsubscribe from this group, send email to clipperz+unsubscribe@googlegroups.com.

[eric]

Alrik, actually, I'm not sure how I missed this before but I see this in the apache log:

PHP Warning:  mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) 

How can I provide the password? I would like to leave it password protected.

[eric]

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

[eric]

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;

I'm sure there is a better way..

Eric