Login - after sql migration between servers

[bones]

Hi

I'm working off-line on my Linux box at home (our marvellous Telkom still has a huge monopoly meaning that ADSL etc is still too expensive). Installed phpWCMS there, all working fine.
Also installed phpWCMS on the server through Fantastico (don't shoot me).
Then I used phpMyAdmin to export the db via sql. Uploaded to the on-line server by dropping tables and running sql script.
I can see the pages, no problem, but I can't login.

i have looked at the conf file but it doesn't make sense to me to change it.

Any ideas

Roland

[Pappnase]

hello bones

please check wich version run at fantastico and wich version did you work offline!? also if you can post your conf.inc.php without passwords and login data

[Oliver Georgi]

Try to update the password on your remote system using phpMyAdmin - and update to current release.

The update is a MD5 value - select this in the select menu in phpMyAdmin and insert the new password.

Oliver

[bones]

Hi

Thanks Pappnase, Oliver.

Both versions are v1.1 RC2

Below are config files;
Server
<?

// database values
$phpwcms["db_host"] = "localhost";
$phpwcms["db_user"] = "xxxxxx";
$phpwcms["db_pass"] = "xxxxxx";
$phpwcms["db_table"] = "edenvale_wcms1";
$phpwcms["db_prepend"] = "";
$phpwcms["db_pers"] = 0;

// site values
$phpwcms["site"] = "http://edenvalescouts.za.net/";
$phpwcms["admin_email"] = "roland.magg@kwela.biz";

// paths
$phpwcms["root"] = "cms"; //default: ""
$phpwcms["file_path"] = "phpwcms_filestorage"; //default: "phpwcms_filestorage"
$phpwcms["file_tmp"] = "phpwcms_tmp"; //default: "phpwcms_tmp"
$phpwcms["templates"] = "phpwcms_template"; //default: "phpwcms_template"
$phpwcms["dir_thlist"] = "thumb_list"; //default: "thumb_list"
$phpwcms["dir_preview"] = "thumb_preview"; //default: "thumb_preview"
$phpwcms["content_path"] = "content"; //default: "content"
$phpwcms["cimage_path"] = "images"; //default: "images"
$phpwcms["ftp_path"] = "phpwcms_ftp"; //default: "phpwcms_ftp"

// content values
$phpwcms["file_maxsize"] = 2097152; //Bytes (50 x 1024 x 1024)
$phpwcms["content_width"] = 538; //max width of the article content column - important for rendering multi column images
$phpwcms["img_list_width"] = 100; //max with of the list thumbnail image
$phpwcms["img_list_height"] = 75; //max height of the list thumbnail image
$phpwcms["img_prev_width"] = 538; //max width of the large preview image
$phpwcms["img_prev_height"] = 400; //max height of the large preview image
$phpwcms["max_time"] = 1800; //logout after max_time/60 seconds

// other stuff
$phpwcms["compress_page"] = 0; //if 1 = page compression, 0 = no compression

// debugging timer
$phpwcms["timer"] = 0; //is for displaying a how long it needs to create

$phpwcms["imagick"] = 0; //0 = GD, 1 = ImageMagick convert
$phpwcms["imagick_path"] = ""; //Path to ImageMagick (default="" - none)
$phpwcms["use_gd2"] = 1; //0 = GD1, 1 = GD2
$phpwcms["rewrite_url"] = 0; //whether URL should be rewritable
$phpwcms["wysiwyg_editor"] = 3; //0 = no wysiwyg editor, 1 = HTMLarea, 2 = FCKeditor, 3 = browser based
$phpwcms["phpmyadmin"] = 1; //enable/disable phpMyAdmin in Backend
$phpwcms["default_lang"] = "en"; //default language
$phpwcms["charset"] = "iso-8859-1"; //default charset 'iso-8859-1'

// dynamic ssl encryption engine
$phpwcms["site_ssl_mode"] = '0'; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms["site_ssl_url"] = ''; //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. "https://www.yourdomainhere.tld"
$phpwcms["site_ssl_port"] = '443'; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'


?>

Local
<?

// database values
$phpwcms["db_host"] = "localhost";
$phpwcms["db_user"] = "yyy";
$phpwcms["db_pass"] = "yyy";
$phpwcms["db_table"] = "scoutcms";
$phpwcms["db_prepend"] = "";
$phpwcms["db_pers"] = 0;

// site values
$phpwcms["site"] = "http://linux.local/";
$phpwcms["admin_email"] = "roland.magg@kwela.biz";

// paths
$phpwcms["root"] = "scoutcms"; //default: ""
$phpwcms["file_path"] = "phpwcms_filestorage"; //default: "phpwcms_filestorage"
$phpwcms["file_tmp"] = "phpwcms_tmp"; //default: "phpwcms_tmp"
$phpwcms["templates"] = "phpwcms_template"; //default: "phpwcms_template"
$phpwcms["dir_thlist"] = "thumb_list"; //default: "thumb_list"
$phpwcms["dir_preview"] = "thumb_preview"; //default: "thumb_preview"
$phpwcms["content_path"] = "content"; //default: "content"
$phpwcms["cimage_path"] = "images"; //default: "images"
$phpwcms["ftp_path"] = "phpwcms_ftp"; //default: "phpwcms_ftp"

// content values
$phpwcms["file_maxsize"] = 2097152; //Bytes (50 x 1024 x 1024)
$phpwcms["content_width"] = 538; //max width of the article content column - important for rendering multi column images
$phpwcms["img_list_width"] = 100; //max with of the list thumbnail image
$phpwcms["img_list_height"] = 75; //max height of the list thumbnail image
$phpwcms["img_prev_width"] = 538; //max width of the large preview image
$phpwcms["img_prev_height"] = 400; //max height of the large preview image
$phpwcms["max_time"] = 1800; //logout after max_time/60 seconds

// other stuff
$phpwcms["compress_page"] = 0; //if 1 = page compression, 0 = no compression

// debugging timer
$phpwcms["timer"] = 0; //is for displaying a how long it needs to create

$phpwcms["imagick"] = 0; //0 = GD, 1 = ImageMagick convert
$phpwcms["imagick_path"] = ""; //Path to ImageMagick (default="" - none)
$phpwcms["use_gd2"] = 1; //0 = GD1, 1 = GD2
$phpwcms["rewrite_url"] = 0; //whether URL should be rewritable
$phpwcms["wysiwyg_editor"] = 3; //0 = no wysiwyg editor, 1 = HTMLarea, 2 = FCKeditor, 3 = browser based
$phpwcms["phpmyadmin"] = 1; //enable/disable phpMyAdmin in Backend
$phpwcms["default_lang"] = "en"; //default language
$phpwcms["charset"] = "iso-8859-1"; //default charset 'iso-8859-1'

// dynamic ssl encryption engine
$phpwcms["site_ssl_mode"] = '0'; // tuns the SSL Support of WCMS on(1) or off (0) DEFAULT '0'
$phpwcms["site_ssl_url"] = ''; //URL assigned to the SSL Certificate. DON'T add a slash at the End! Exp. "https://www.yourdomainhere.tld"
$phpwcms["site_ssl_port"] = '443'; //The Port on which you SSL Service serve the secure Sites. Servers DEFAULT is '443'


?>

[bones]

how do i change pwd in phpMyAdmin?

i can go and see the entry in the user table - but the password seems encrypted.

Sorry, i don't know what MD5 means.

(Hey, by the way, i dunno if i can help phpwcms, but i can was brought up talking German, but went to an English school (also lived in Germany and Switzerland for some years - so if you need some translating from German to English, let me know.)

Regards
Roland

[bones]

another strange thing. When copying between two remote servers, all worked fine, except that you now have to put in pwd twice.

Roland

[bones]

Hi Pappnase, Oliver

Thanks for the help.
I eventually found a workaroud - i created a new instance of PHPwcms and just sql'ed the user table to my local system, and then sql'ed the whole db back to where i wanted it. And seems to work.

Still puzzled as to why it would not accept the login. Suspect to do with timestamps?

Roland