phpbb no longer working?

[cragi]

I have a site that is protected from gaining forum access. I installed phpbb a couple of months ago and it was working fine, but now I get the following error when I try to access it:

Could not connect to the databasePHP Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied., SQL state 08001 in SQLConnect in E:\web\loansifterc\htdocs\forum\db\mssql-odbc.php on line 54 PHP Warning: odbc_error(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\forum\db\mssql-odbc.php on line 377 PHP Warning: odbc_errormsg(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\forum\db\mssql-odbc.php on line 378



I tried to reinstall the forum using the DSN, DB name, username & password, yet still get same error. I'm supposed to have given this site to production and they are holding based on this!

[bruce]

Do you mean you password protected the forum by removing IUSR permission from the control panel?

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[joelnet]

The error message makes me think your user/pass for the connection to mysql is bad.


This shouldn't have anything to do with password protection. It could be the application you are using as well.



Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

[bruce]

Not entirely,

PHP is kinda wierd. If you password protect a directory without giving the user with the right from the root down, PHP will crap out.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[cragi]

I have a SQL Server 2K account, and am trying to install phpbb2 or even the newer beta phpbb3. I have opened up permissions so the site and that directory is fully accessible in order to get it running. I use the same database, username, and password through many applications on the website, so that isnt an issue. I also looked up the proper ODBC connection in the panel.

Running phpbb3 actually gives pretty good error messages, so I'll go off this one. The link is at:
www.loansifter.com/phpbb3/ (http://www.loansifter.com/phpbb3/)

It requests the following:
connection type: ms sql odbc
dsn: DB_65955_sqlConn
port: [blank]
database: DB_65955
username:
password:

I know you've said that you were able to get phpbb running in earlier testing - are you still able to do so? I don't see any reason that I should be having this problem.

[cragi]

also, the specific error was:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This is the listed DSN in my admin panel

[bruce]

are you getting this error w/ phpbb2 or phpbb3?

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[mjp]

cragi said...
I know you've said that you were able to get phpbb running in earlier testing - are you still able to do so? I don't see any reason that I should be having this problem.

[/quote]Hmm, I tried an install of the 3 beta version from scratch on SQL 2000 and the install failed on the final step. The database connection was successful however, and the tables were created. But there may be issues with the install script:

install_install.php [ 1336 ]
SQL : SELECT * FROM phpbb_modules WHERE module_langname = 'ACP_MANAGE_USERS' AND module_class = 'acp' AND module_name <> '' LIMIT 1
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 5: Incorrect syntax near 'LIMIT'.

Ran through the installation using a MySQL database and it went without a hitch...










mjp
DiscountASP.NET
http://DiscountASP.NET

[cragi]

this was the message in phpbb3 - the error in phpbb2 was at the same point, but i seem to recall it being a generic error message

[cragi]

well I am failing this install on phpbb 2 and 3 without creating the tables in sql server. I have entered in the proper criteria as best as I can tell, trying it both the ODBC and straight routes. It is saying that it doesnt recognize the data source name. I was able to install phpbb 2 in access, but not SQL Server, which is what I need. I have looked through everything I can tell on this end with no success and the problem seems pretty clearly on the dasp side.

[bruce]

i suggest you create a test script to make sure php can talk to the DB.

<html>
<head><title>PHP SQL TEST</title></head>
[b]
<h2>MS SQL / DSN Test</h2>
<table border='1'>

<?php
$DSN='SQLDSN_sqlConn';
$DSN_User='sqlusername';
$DSN_Passwd='sqlpassword';
$QueryString='SELECT * from sysobjects';

$Connect = odbc_connect( $DSN, $DSN_User, $DSN_Passwd );
$Result = odbc_exec( $Connect, $QueryString );

odbc_free_result( $Result );
odbc_close( $Connect );
?>
</table>

If this doesn't produce any error, the DSN is working fine. If not, it's something in phpBB (probably something you input is invalid)

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

[cragi]

I have uploaded phpbb3 to another site I have hosted here with the exact same configuration sql server 2k. On that I was able to get down to the final step, as mentioned, where it errored out. This still doesnt solve the base problem on loansifter, where its not even getting past the dsn part. I have checked the entry a dozen times, copying and pasting them directly from the admin panel and even resetting any password just in case. Still no success getting past the DSN on that site, which explains why I wasnt even able to get phpbb 2 running

[cragi]

I set up / edited the file as suggested with the following error result:

PHP Warning: odbc_connect(): SQL error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied., SQL state 08001 in SQLConnect in E:\web\loansifterc\htdocs\test.php on line 13 PHP Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\test.php on line 14 PHP Warning: odbc_free_result(): supplied argument is not a valid ODBC result resource in E:\web\loansifterc\htdocs\test.php on line 16 PHP Warning: odbc_close(): supplied argument is not a valid ODBC-Link resource in E:\web\loansifterc\htdocs\test.php on line 17

is there a file that could have been deleted that could be causing this?

[bruce]

that's very weird!!

i think you need to create a support ticket. someone need to take a look inside the server to make sure the dsn exists.

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)