Tomas Kuliavas said: >>>> I dumped the SM database, adjusted the table creation statements. I >>>> can import the address information to the new version, but I get >>>> unserialized errors when I try to move the user preferences over. >>>> Does anyone have a conversion program or at leaste a list of what >>>> the old names were and what they are now called. >>>> >>>> 1.2.2 : uw imapd >>>> 1. squirrelspell >>>> 2. vlogin >>>> 3. listcommands >>>> 4. procfilter >>>> 5. delete_move_next >>>> 6. view_as_html >>>> 7. newmail >>>> 8. calendar >>>> >>>> >>>> 1.4.4 : dovecot impad >>>> >>>> >>>> Plugins >>>> Installed Plugins >>>> 1. debugger >>>> 2. compatibility >>>> 3. delete_move_next >>>> 4. serversidefilter >>>> 5. fortune >>>> 6. listcommands >>>> >>>> >>>> BTW: serversidefilter is from CSV with one of the @unlink commands >>>> commented out. >>>> >>>> Configtest output: >>>> This script will try to check some aspects of your SquirrelMail >>>> configuration and point you to errors wherever it can find them. You >>>> need to go run conf.pl in the config/ directory first before you run >>>> this script. >>>> >>>> SquirrelMail version: 1.4.4 >>>> Config file version: 1.4.0 >>>> Config file last modified: 13 January 2006 14:36:06 >>>> Checking PHP configuration... >>>> PHP version 4.3.10-16 OK. >>>> PHP extensions OK. >>>> Checking paths... >>>> Data dir OK. >>>> Attachment dir OK. >>>> Plugins OK. >>>> Themes OK. >>>> Default language OK. >>>> Base URL detected as: http://test.micek.csz.com/squirrelmail/src >>>> Checking outgoing mail service.... >>>> SMTP server OK (220 cyber7.csz.com ESMTP Sendmail >>>> 8.13.4/8.13.4/Debian-3; Fri, 13 Jan 2006 15:47:44 -0800; (No >>>> UCE/UBE) logging access from: localhost(OK)[EMAIL PROTECTED] >>>> [127.0.0.1]) Checking IMAP service.... >>>> IMAP server ready (* OK dovecot ready.) >>>> Capabilities: * CAPABILITY IMAP4rev1 SORT THREAD=REFERENCES >>>> MULTIAPPEND UNSELECT LITERAL+ IDLE CHILDREN LISTEXT LIST-SUBSCRIBED >>>> NAMESPACE >>>> Checking internationalization (i18n) settings... >>>> gettext - Gettext functions are available. You must have appropriate >>>> system locales compiled. mbstring - Mbstring functions are >>>> available. recode - Recode functions are unavailable. >>>> iconv - Iconv functions are available. timezone - Webmail users can >>>> change their time zone settings. Checking database functions... PHP >>>> Pear DB support is present. >>>> >>>> >>>> ERROR: database support not present! >>>> ?!! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ >>>> Well its writing to the database fine and reading from it AFAIKT. >>> >>> Could you update configtest.php to latest version? >>> >>> Or at least fix line 375 in your script. >>> >>> You have 'do_err($db.' database support not present!');' >>> >>> Correct line is 'do_err($dbtype.' database support not present!');' >>> >>> -- >>> Tomas >> Ok, BTW: the userprefs table updates fine so the problem is that the >> version of configtest.php has issues... >> >> Went to www.squirrelmail.org .. downloads .. tired to follow the >> instructions for accessing 1.4.x CSV to get latest version of >> configtest >> >> received the following error: >> cvs login: warning: failed to open /home/staff/mussatto/.cvspass for >> reading: No such file or directory >> >> If I touched .cvspass into existance it just returns to the local >> shell prompt. Of course...Found browse cvs ... ok frap its not >> compatiable with stock config.pl >> >> Ok got config.pl from cvs --> >> Parse error: parse error, unexpected T_CONSTANT_ENCAPSED_STRING in >> /etc/squirrelmail/config.php on line 32 > > You confused HEAD with SM-1_4-STABLE > > http://cvs.sf.net/viewcvs.py/*checkout*/squirrelmail/squirrelmail/src/configtest.php?rev=1.9.2.15 > >> Reverting config.pl to debian stock. Hardcoded cvs version of >> configtest.php to default to remote configtest = true.. ok it runs.. >> results still show >> Checking database functions... >> PHP Pear DB support is present. >> ERROR: mysql database support not present! >> Installed mysql module via pear its listed but I'm still getting the >> error. >> I'll recheck the login but SM is changing user preferences. It just >> won't import them via dump and load. Addresses come across find. > > apt-get install php4-mysql > > make sure that extension=mysql.so is present in php.ini > > restart apache and make sure that error logs don't have mysql.so loading > errors. > > check configtest.php one more time. > > -- > Tomas Thanks for the link. Got that version of configtest.phh and received the same error. However if I comment out line 385 (and the corresponding else section) I get: mysql database support present. preferences database connect successful. mysql database support present. addressbook database connect successful.
If remove "isset($db_functions[$dbtype]) &&" from line 385 it also works. I think I may have found out what is blowing up things: I have message highlighting turned on and the insert for it is many lines long (hey its my crude way of separating wheat from chaff. Looks like we have a bug... If I try to put in more than three it blows up. mySql table for usrprefs was wrong (thougth I copied it from http://www.squirrelmail.org/wiki/MySQL. "prefval text NOT NULL," not prefval varchar(255) NOT NULL, FRAP!! my error. Sorry. the site is correct, thoguht I cut and pasted that bit. Thanks ------- William R. Mussatto, Senior Systems Engineer http://www.csz.com Ph. 909-920-9154 ext. 27 FAX. 909-608-7061 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 -- squirrelmail-users mailing list Posting Guidelines: http://www.squirrelmail.org/wiki/MailingListPostingGuidelines List Address: squirrelmail-users@lists.sourceforge.net List Archives: http://news.gmane.org/thread.php?group=gmane.mail.squirrelmail.user List Archives: http://sourceforge.net/mailarchive/forum.php?forum_id=2995 List Info: https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
