UBB.threads PHP Forum Software Community Forums UBB.threads 7 Installation and Upgrade Support Error in Step 3 of Installation - Connection to Server Failed

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?

Connection to server FAILED.
I am running IIS. Windows 2003 Server Enterprise.
I am new to MySQL (I use MSSQL server on my other machines.)
With regards to the "socket". Does this refer to the "port" number created?

I just re-ran the MySQL Server Instance Configuration Wizard.
I selected the following options...

Detailed Configuration
Server Machine
Multifunctional Database
Online Transaction Processing (OLTP)
Enable TCP/IP Networking on Port 3306
Enable Strict Mode
Standard Character Set
Installed as a service
No Anonymous Account

It could be that the install script is masking the true error. What you can do is create a test.php script and bring it up in your browser. For the contents of the script, you'll use this (replace username and password with the actual username you setup, and databasename with the databasename:

This is the error that was returned...

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:\inetpub\wwwroot\testconnect.php on line 3

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in c:\inetpub\wwwroot\testconnect.php on line 4

Here is what I had...

<?php

$dbh = mysql_connect("localhost","ubbserver","pw");
mysql_select_db("ubbthreads",$dbh);

?>

Except pw was the password for the account.
ubbserver is the user name for the account.
ubbthreads is the database.

Yup. Php and the MySQL server are not both using the same passwording schema.

http://dev.mysql.com/doc/refman/5.0/en/old-client.html
http://www.digitalpeer.com/id/mysql

That did it!

Man... a new installation manual is a must. I am making notes.

Now, I get an error in Step 6. When I click on "Creating Your Tables" I receive a generic web browser error message "Internet Explorer cannot disply the webpage".

Any suggestions?

Sounds like grants. Rick or someone will chime in I'm sure with a way to make that installer script pop out the right error messages.

Just as an aside, the instruction manual was written to handle the install of .threads, not the proper installation and setup of a server, MySQL, or PHP. They all have their own documentation, a lot of it, mostly really good. There is no need for Rick to replicate their work.

Do you get the error immediately, or does it take a bit before the error comes up?

I get it immediately. It is similar to what happens if you have an error in your ASP script. I have my browser set up to show detailed error messages but in this case, I just get the default error page.

Thanks for the quick reply. I want to migrate to threads. My current board is audioforum.termpro.com

Thanks again.

Now, I get the same error message when I click on http://server2.termpro.com/forums/install/install.php

This has been happening intermittently. Normally, I can link to install.html and then click on the PHP link and it will work. (When I click on the PHP link, my server asks me to login).

Do you have any error logs? It could be that it's just logging the error to the server error logs?

It almost looks like you might have some sort of php issue going on. I'm getting a blank (empty) page, even if I type a bogus URL that has a php extension:

http://server2.termpro.com/forums/booboo.php - results in a blank page

http://server2.termpro.com/forums/booboo.html - results in the proper page not found error