Re: cannot authenticate to MSSQL database from BASE

[tadios tefera <ttefera () gmail com>]

Thank you for your response Michael,

I have placed the connect.php file you attached in the "base" folder on the
IIS server.
I have adjusted the authencitation info (password, etc...) for our SQL
server:

$serverName = "SERVER-B";
$usr="snort";
$pwd="mypassword";
$db="snort";


And then I attempted to test by going to http://SERVER-C/base/connect.php ;
this is the reponse I got:

"*Fatal error*: Call to undefined function sqlsrv_connect() in *
C:\inetpub\wwwroot\base\connect.php* on line *11*"
In my scenario, SERVER-B is the MSSQL server and SERVER-C is the IIS server.
Am I using the connect.php DB connection test file as you anticipated?

Thanks,

Tad.
On Sun, Jan 22, 2012 at 10:19 AM, Michael Steele <michaels () winsnort com>wrote:

> You might be able to use the attached .php file to test the DB connection
> and users credentials to the remote MSSQL database.****
>
> ** **
>
> Kindest regards,****
>
> Michael...****
>
> ** **
>
> WINSNORT.com Management Team Member****
>
> --****
>
> ****************** Established ~ 2001 ***********************
>
> *          Visit Us @ http://www.winsnort.com           *****
>
> *      ~~ FREE WinIDS Snort installation guides ~~      *****
>
> *               ~~ FREE support forums ~~               *****
>
> * Snort: Open Source Network IDS - http://www.snort.org *****
>
> *************************************************************
>
> ** **
>
> *From:* tadios tefera [mailto:ttefera () gmail com]
> *Sent:* Tuesday, January 17, 2012 11:31 AM
> *To:* snort-users () lists sourceforge net
> *Subject:* [Snort-users] cannot authenticate to MSSQL database from BASE**
> **
>
> ** **
>
> Hi,****
>
>  ****
>
> I have managed to get Snort 2.9.2 working on Windows 2008 R2 Servers.****
>
> The generated data from Snort is being placed in an mssql database.****
>
>  ****
>
> My setup is as follows:****
>
> - Snort on a SERVER-A****
>
> - Database (MSSQL) on SERVER-B****
>
> - Web Portal (IIS7) on SERVER-C****
>
>  ****
>
> But I am baffled as to how I can access the Snort data from the database.*
> ***
>
> I have installed and configured base, adodb, and php on IIS7 and all
> indications are that the installs/configurations are correct.****
>
> When I access the "base" site from a browser: http://SERVER-C/base , I
> get the following error:****
>
>  ****
>
> ------------------------------------------****
>
> Warning: mssql_connect() [function.mssql-connect]: Unable to connect to
> server: SERVER-B in C:\WinIDS\adodb\drivers\adodb-mssql.inc.php on line 556
>
> Error connecting to DB : snort@SERVER-B****
>
> Check the DB connection variables in base_conf.php
>                = $alert_dbname   : MySQL database name where the alerts
> are stored
>                = $alert_host     : host where the database is stored
>                = $alert_port     : port where the database is stored
>                = $alert_user     : username into the database
>                = $alert_password : password for the username****
>
>  ------------------------------------------****
>
>  ****
>
> I have verified numberous times that the dbname, host, port, user and
> password information are entered correctly in the base_conf.php file.****
>
> I have also tried changing hostname with IP and resetting the password on
> the database instance with no luck.****
>
> I looked into the SQL server logs and it shows encryption is required for
> this communication. The exact error message in the mssql logs is:****
>
> "Encryption is required to connect to this server but the client library
> does not support encryption; the connection has been closed. Please upgrade
> your client library. [CLIENT: 192.168.15.111]"****
>
>  ****
>
> Client with IP 192.168.15.111 is SERVER-C.****
>
> My question is, how do I configure authentication encryption to access
> this database from Base?****
>
>  ****
>
>  ****
>
> Thanks,****
>
>  ****
>
> Tad.****
>
>  ****
>
>  ****
>
>  ****
>
>  ****
>
>  ****
>
>  ****
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d

_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users

Please visit http://blog.snort.org to stay current on all the latest Snort news!