Yet another problem with the MB Strings Module... im seriously seriously stuck!

[samuel]

Hey guys, ive fummbled around for the past couple of hours trying to get the "Writable Session Save Path" working. after reading other stuff from the forum i figured it out and was able to fix it... but now i am stuck with another road block...

ok, preface, im trying to install SugarSuite-4.5.0c on Fedora Core 3 with Apache 2.0.53, SQL 4.1.21 and PHP 4.3.11.

PHP Version OK (ver 4.3.11 )
MySQL Database OK
MB Strings Module Not found: SugarCRM will not be able to process multi-byte characters. This will impact receiving emails in character sets other than UTF-8.
Yea, dun dun dun!! so i went searching for answers in the forum, but alas, no luck.
I edited the php.ini file and uncommented the mbstring module...

 ; MB String Module, implemented for sugarcrm
; Allows for me to process multi-byte characters,
; thus will make characters other than UTF-8 Readable.
[mbstring]
; language for internal character representation.
mbstring.language = English
 
; internal/script encoding.
; Some encoding cannot work as internal encoding.
; (e.g. SJIS, BIG5, ISO-2022-*)
mbstring.internal_encoding = UTF-8
 
; http input encoding.
mbstring.http_input = auto
 
; http output encoding. mb_output_handler must be
; registered as output buffer to function
mbstring.http_output = pass
 
; enable automatic encoding translation accoding to 
; mbstring.internal_encoding setting. Input chars are
; converted to internal encoding by setting this to On.
; Note: Do _not_ use automatic encoding translation for
;       portable libs/applications.
mbstring.encoding_translation = On
 
; automatic encoding detection order.
; auto means 
mbstring.detect_order = auto
 
; substitute_character used when character cannot be converted
; one from another
mbstring.substitute_character = none
 
; overload(replace) single byte functions by mbstring functions.
; mail(), ereg(), etc are overloaded by mb_send_mail(), mb_ereg(),
; etc. Possible values are 0,1,2,4 or combination of them.
; For example, 7 for overload everything.
; 0: No overload
; 1: Overload mail() function
; 2: Overload str*() functions
; 4: Overload ereg*() functions
mbstring.func_overload = 0 
  

After a couple of tries, i concluded that my mbstring must be broken, but putty proves otherwise as it seems that my mbstring works fine because my yum yum gave me this...

 [root@air030 ~]# yum info php-mbstring
Setting up Repos
legacy-updates            100% |=========================|  951 B    00:00
psa-7.5                   100% |=========================|  951 B    00:00
base                      100% |=========================| 1.1 kB    00:00
updates-released          100% |=========================|  951 B    00:00
legacy-utils              100% |=========================|  951 B    00:00
Reading repository metadata in from local files
legacy-upd: ################################################## 795/795
psa-7.5   : ################################################## 3/3
base      : ################################################## 2622/2622
updates-re: ################################################## 910/910
legacy-uti: ################################################## 1/1
Available Packages
Name   : php-mbstring
Arch   : i386
Version: 4.3.11
Release: 2.8.4.legacy
Size   : 920 k
Repo   : legacy-updates
Summary: A module for PHP applications which need multi-byte string handling
Description:
 The php-mbstring package contains a dynamic shared object that will add
support for multi-byte string handling to PHP. 
  

and just to make sure, i also ran the short script to see my php settings which can be viewed here...
www.illusions.com.au/php.php

I am out of ideas, as i am seriously stuck on this... i would greatly appreciate anyone whos willing to lend me a hand in getting off step 2 of the installation process! thanks in advance =D

[ruchida]

Hi
It seems the mbstring module is not yet installed and activated. Try to install it by running "yum install php-mbstring".
An example of settings is illustrated here

[samuel]

 [root@air030 ~]# yum install php-mbstring
Setting up Install Process
Setting up Repos
legacy-updates            100% |=========================|  951 B    00:00
psa-7.5                   100% |=========================|  951 B    00:00
base                      100% |=========================| 1.1 kB    00:00
updates-released          100% |=========================|  951 B    00:00
legacy-utils              100% |=========================|  951 B    00:00
Reading repository metadata in from local files
legacy-upd: ################################################## 795/795
psa-7.5   : ################################################## 3/3
base      : ################################################## 2622/2622
updates-re: ################################################## 910/910
legacy-uti: ################################################## 1/1
Parsing package install arguments
Resolving Dependencies
--> Populating transaction set with selected packages. Please wait.
---> Downloading header for php-mbstring to pack into transaction set.
php-mbstring-4.3.11-2.8.4 100% |=========================|  17 kB    00:00
---> Package php-mbstring.i386 0:4.3.11-2.8.4.legacy set to be updated
--> Running transaction check
 
Dependencies Resolved
Transaction Listing:
  Install: php-mbstring.i386 0:4.3.11-2.8.4.legacy - legacy-updates
Total download size: 920 k
Is this ok [y/N]: y
Downloading Packages:
(1/1): php-mbstring-4.3.1 100% |=========================| 920 kB    00:00
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Installing: php-mbstring 100 % done 1/1
 
Installed: php-mbstring.i386 0:4.3.11-2.8.4.legacy
Complete! 
  

ok, then after restarting apache, it worked! yay!!

hai hai, arigato gozaimasu ^___^

now to finish the final steps of this sweet sweet installation

[samuel]

okaaay, yea.. next step -___-

 Please fix the following errors before proceeding:
SugarCRM database user name and/or password is invalid (Error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client).
Database admin user name and/or password is invalid (Error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client). 
  

=/ what does all this mean? someone please assist in explaining how to solve this, i am running SQL 4.1.21... it shouldn't come up with this.

EDIT -
I had a read around, and ended up here...

This is permanent solution. Instead of typing this "SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something');" in the command line client for every single user, do the following:

Find "my.ini" inside windows directory and insert the following lines (First line is just a comment, it can be ommited)

#Use old password encryption method (needed for 4.0 and older clients).
old_passwords

Restart the service for the changes to take place.

Where do i find the my.ini file?
I am running FC3.

[ruchida]

If you are using FC3, that file will be /etc/my.cnf. It should look like;

 [mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
     
[mysql.server]
user=mysql
basedir=/var/lib
 
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid 
  

[samuel]

Ive changed the my.cnf file and restarted apache for the 5th time...

 [mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql 
socket=/var/lib/mysql/mysql.sock
 
# Default to using old password format for compatibility with mysql 3.x 
# clients (those using the mysqlclient10 compatibility package). 
old_passwords=1
 
[mysql.server]
user=mysql
basedir=/var/lib
 
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid 
  

and it still gives me this.

Please fix the following errors before proceeding:
SugarCRM database user name and/or password is invalid (Error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client).
Database admin user name and/or password is invalid (Error 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client).

so much twiddling around with this.. =/
I am so damn close to getting this to work! would much appeciate the help!! thanks in advance.

[simple]

Ive changed the my.cnf file and restarted apache for the 5th time...

Did you restart mysql too?

[samuel]

yea, ive restarted it with the shell command -
/etc/init.d/mysqld restart

and also did a soft and hard reboot.. no good. any ideas?

[ruchida]

yea, ive restarted it with the shell command -
/etc/init.d/mysqld restart

and also did a soft and hard reboot.. no good. any ideas?

You need to set old_password to a right id. In MySQL, "peter" is not an id, but "peter@localhost" (name + @ + server name) is an id.

[samuel]

sorry, im kind of dense at this time of the day, but i dont follow what you mean..
what is it that i need to add to my.cnf for it to set the old_password to the right id?
ive created the database name, database user, and is it that i set old_password to the database user?
my database user is sugarcrm, and its localhost, so what should i add to the my.cnf file and where?

thanks for your help so far ruchida..