I have been using UBB Classic for almost 10 years now. I have a "gold" support plan.

I am having difficulty with the Threads installation.
I have installed MySQL. PHP is already on the server as we use it for UBBClassic. (According to the info.php file, MySQL is enabled.)
I can login to the MySQL command prompt. I have created a database named "ubbthreads", a user named "ubbserver", and assigned a password to the user.

In Step 2, the install utility asks for MySQl server info. Currently, the fields are populated as follows...
Database Server: localhost
Database Name: ubbthreads
Database User: ubbserver
Database Password: *******
Tablename prefix: ubbt_

When I click on "Check Database Settings", Page 3 is displayed.

This page tells me that..

Connecting to Server: Failed
Connecting to Database: Failed

The installation documentation that came with the download is sparse. I needs assistance.

Thanks in advance.

Wayne Harris

From install doc:

Any good?

Also, your Database Name might be your server name + database name.

eg: Database Name: myserver_ubbthreads

Thanks for the quick response. I have my own servers. I have created the information and accounts being used.

I have tried various permutations on the server name and database name with no success.

I just examined the PHP.INI file. The default values for the MySQL section are listed below...

[MySQL]
; Allow or prevent persistent links.
mysql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
mysql.max_persistent = -1

; Maximum number of links (persistent + non-persistent). -1 means no limit.
mysql.max_links = -1

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
mysql.default_port =

; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

; Default host for mysql_connect() (doesn't apply in safe mode).
mysql.default_host =

; Default user for mysql_connect() (doesn't apply in safe mode).
mysql.default_user =

; Default password for mysql_connect() (doesn't apply in safe mode).
; Note that this is generally a *bad* idea to store passwords in this file.
; *Any* user with PHP access can run 'echo get_cfg_var("mysql.default_password")
; and reveal this password! And of course, any users with read access to this
; file will be able to reveal the password as well.
mysql.default_password =

; Maximum time (in secondes) for connect timeout. -1 means no limimt
mysql.connect_timeout = 60

; Trace mode. When trace_mode is active (=On), warnings for table/index scans and
; SQL-Erros will be displayed.
mysql.trace_mode = Off

[mSQL]
; Allow or prevent persistent links.
msql.allow_persistent = On

; Maximum number of persistent links. -1 means no limit.
msql.max_persistent = -1

; Maximum number of links (persistent+non persistent). -1 means no limit.
msql.max_links = -1

Have you tried Database Name: ubbserver_ubbthreads

As it is your own server, I assume you set up the database and database user / password yourself.

Are you confident that you have entered those correct details in the config - making sure that it is case sensitive?

The name of the server is SERVER2. I changed the database name to server2_ubbthreads without success.

I also changed the Database Server from localhost to SERVER2 without success.

I have tried the following names for Database Server without success...

localhost
127.0.0.1
65.90.218.142

Thanks in advance for your assistance.

Wayne

Yes. I have created and deleted several users from the MySQL command prompt. When I use "select user, host, password from mysql.user;" I get the following...

USER HOST PASSWORD
root localhost *******...
ubbserver localhost *******...

When I use "show databases;" I see the following...

DATABASE
information-schema
mysql
ubbthreads

Connection to server failed? NOT permission denied?

Find out where mysql.sock is located.

edit this in your php.ini to match
; Default socket name for local MySQL connects. If empty, uses the built-in
; MySQL defaults.
mysql.default_socket =

Restart Apache or IIS or whatever you're using.

If it's permission denied on the other hands, you probably have mysql using new passwords and php using old passwords. Mysql is newer than 4.1 and php is a version 4 something?