UseBB Community

Hi ! I have this error:

An error was encountered. We apologize for any inconvenience.

In file db_mysql.php on line 86:

E_WARNING - mysql_connect() [function.mysql-connect.html]: Client does not support authentication protocol requested by server; consider upgrading MySQL client
This error should probably not have occured, so please report it to the webmaster. Thank you for your help.

If you are the webmaster of this board and you believe this is a bug, please send a bug report.

Why ?

My configuration server:

Apache 1.3
PHP 4.3.11
MySQL 4.1 (latest)

http://localhost/usebb/

------------------------------------------------------------

$dbs['type'] = 'mysql';
$dbs['server'] = 'localhost';
$dbs['username'] = 'root';
$dbs['passwd'] = 'hidden';
$dbs['dbname'] = 'usebb';
$dbs['prefix'] = 'usebb_';

//
// Initialize a new configuration holder array
//
$conf = array();

//
// Define configuration
//
$conf['activation_mode'] = 1;
$conf['active_topics_count'] = 25;
$conf['admin_email'] = 'example@example.net';
$conf['allow_multi_sess'] = 1;
$conf['allow_duplicate_emails'] = 0;
$conf['avatars_force_width'] = 65;
$conf['avatars_force_height'] = 65;
$conf['board_closed'] = 0;
$conf['board_closed_reason'] = 'Just closed...';
$conf['board_descr'] = 'My board\'s description';
$conf['board_keywords'] = 'forum,board,community,usebb';
$conf['board_name'] = 'My Community';
$conf['board_url'] = '';
$conf['cookie_domain'] = '';
$conf['cookie_path'] = '';
$conf['cookie_secure'] = 0;
$conf['date_format'] = 'D M d, Y g:i a';
$conf['debug'] = 0;
$conf['disable_registrations'] = 0;
$conf['disable_registrations_reason'] = 'No new users allowed at this time.';
$conf['dst'] = 0;
$conf['email_view_level'] = 1;
$conf['enable_acp_modules'] = 1;
$conf['enable_contactadmin'] = 1;
$conf['enable_detailed_online_list'] = 1;
$conf['enable_forum_stats_box'] = 1;
$conf['enable_memberlist'] = 1;
$conf['enable_quickreply'] = 1;
$conf['enable_rss'] = 1;
$conf['enable_stafflist'] = 1;
$conf['enable_stats'] = 1;
$conf['exclude_forums_active_topics'] = array ();
$conf['exclude_forums_rss'] = array ();
$conf['exclude_forums_stats'] = array ();
$conf['flood_interval'] = 30;
$conf['friendly_urls'] = 0;
$conf['guests_can_access_board'] = 1;
$conf['guests_can_view_profiles'] = 1;
$conf['hide_avatars'] = 0;
$conf['hide_signatures'] = 0;
$conf['hide_undefined_config_setting_warnings'] = 1;
$conf['hide_undefined_template_setting_warnings'] = 0;
$conf['hide_undefined_template_warnings'] = 0;
$conf['hide_userinfo'] = 0;
$conf['language'] = 'English';
$conf['members_per_page'] = 25;
$conf['online_min_updated'] = 30;
$conf['output_compression'] = 2;
$conf['passwd_min_length'] = 5;
$conf['posts_per_page'] = 25;
$conf['rel_nofollow'] = 0;
$conf['return_to_topic_after_posting'] = 1;
$conf['rss_items_count'] = 25;
$conf['search_limit_results'] = 1000;
$conf['search_nonindex_words_min_length'] = 3;
$conf['session_max_lifetime'] = 60;
$conf['session_name'] = 'usebb';
$conf['session_save_path'] = '';
$conf['show_edited_message_timeout'] = 60;
$conf['sig_allow_bbcode'] = 1;
$conf['sig_allow_smilies'] = 1;
$conf['sig_max_length'] = 500;
$conf['single_forum_mode'] = 0;
$conf['target_blank'] = 0;
$conf['template'] = 'default';
$conf['timezone'] = 0;
$conf['topicreview_posts'] = 5;
$conf['topics_per_page'] = 25;
$conf['view_detailed_online_list_min_level'] = 0;
$conf['view_forum_stats_box_min_level'] = 0;
$conf['view_hidden_email_addresses_min_level'] = 3;
$conf['view_memberlist_min_level'] = 0;
$conf['view_stafflist_min_level'] = 0;
$conf['view_stats_min_level'] = 0;
$conf['view_contactadmin_min_level'] = 0;

---------------------------------------------------------------


Bye !

This is a misconfiguration on your SQL server. If you use PHP 4, it is recommended to use MySQL 4.0. If you are using MySQL 4.1/5, you have to configure MySQL to accept the old way of authentication (short passwords). Or use PHP 5 using the mysqli driver.

Dietrich wrote

This is a misconfiguration on your SQL server. If you use PHP 4, it is recommended to use MySQL 4.0. If you are using MySQL 4.1/5, you have to configure MySQL to accept the old way of authentication (short passwords). Or use PHP 5 using the mysqli driver.

I installed the version 4.0.26 of MySQL and I have this error now:

An error was encountered. We apologize for any inconvenience.

In file db_mysql.php on line 86:

E_WARNING - mysql_connect() [function.mysql-connect.html]: Can't connect to MySQL server on 'localhost' (10061)
This error should probably not have occured, so please report it to the webmaster. Thank you for your help.

If you are the webmaster of this board and you believe this is a bug, please send a bug report.

Why Usebb cannot work with MySQL 4.1 ?

Bye

There's something wrong with your set-up. Is MySQL running on that socket 10061? I suggest you check the config of your SQL daemon.

UseBB works with MySQL 4.1. The problem is PHP 4 only has a mysql driver that works with MySQL up to version 4.0. If you want to use 4.1 you will have to enable short passwords or use PHP 5 with the mysqli driver.

Dietrich wrote

There's something wrong with your set-up. Is MySQL running on that socket 10061? I suggest you check the config of your SQL daemon.

UseBB works with MySQL 4.1. The problem is PHP 4 only has a mysql driver that works with MySQL up to version 4.0. If you want to use 4.1 you will have to enable short passwords or use PHP 5 with the mysqli driver.

How to enable short password ?