|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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
|
|
|
|
Joined: Dec 2006
Posts: 1,235
veteran
|
veteran
Joined: Dec 2006
Posts: 1,235 |
From install doc: If the installation script tells you that connecting to the database with the information provided has "FAILED", use the "Verify Settings" button to return to the form. Check your settings, contacting your host if necessary, and try again. Any good?
|
|
|
|
Joined: Dec 2006
Posts: 1,235
veteran
|
veteran
Joined: Dec 2006
Posts: 1,235 |
Also, your Database Name might be your server name + database name.
eg: Database Name: myserver_ubbthreads
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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
|
|
|
|
Joined: Dec 2006
Posts: 1,235
veteran
|
veteran
Joined: Dec 2006
Posts: 1,235 |
Database Server: localhost Database Name: ubbthreads Database User: ubbserver Database Password: ******* Have you tried Database Name: ubbserver_ubbthreads
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
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?
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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? 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
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
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.
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
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?
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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. 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
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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:
<?php
$dbh = mysql_connect("localhost","username","password");
mysql_select_db("databasename",$dbh);
?>
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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:
<?php
$dbh = mysql_connect("localhost","username","password");
mysql_select_db("databasename",$dbh);
?>
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
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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.
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
Last edited by David Dreezer; 12/13/2007 6:33 PM.
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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?
|
|
|
|
Joined: Jul 2006
Posts: 2,143
Pooh-Bah
|
Pooh-Bah
Joined: Jul 2006
Posts: 2,143 |
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.
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
Do you get the error immediately, or does it take a bit before the error comes up?
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
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.
|
|
|
|
Joined: Dec 2007
Posts: 12
stranger
|
stranger
Joined: Dec 2007
Posts: 12 |
Now, I get the same error message when I click on http://server2.termpro.com/forums/install/install.phpThis 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).
|
|
|
|
Joined: Jun 2006
Posts: 9,242 Likes: 1
Former Developer
|
Former Developer
Joined: Jun 2006
Posts: 9,242 Likes: 1 |
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
|
|
|
|
|
|
Test
by Phun - 05/28/2024 7:31 PM
|
|
2 members (Baldeagle, Gizmo),
269
guests, and
178
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|