Snort mailing list archives
Re: cannot authenticate to MSSQL database from BASE
From: tadios tefera <ttefera () gmail com>
Date: Wed, 1 Feb 2012 17:43:25 -0500
I am new to php and base... How exactly should I be using this test? If I save it as testing.php in the c:\inetpub\wwwroot\base, and attempt to run it from a browser by http://ServerName/base/testing.php, i just get the text content of the testing.php displayed in the browser. any suggestions? On Mon, Jan 30, 2012 at 4:29 PM, Billy Marshall <Billy.Marshall () state co us>wrote:
tad, To test MSSQL basic connect using ADOdb is: include('/path/to/set/here/adodb.inc.php'); $db =& ADONewConnection('odbc_mssql'); $dsn = *"Driver={SQL Server};Server=localhost;Database=northwind;"*; $db->Connect($dsn,'userid','password'); or if you prefer to use the mssql extension (which is limited to mssql 6.5 functionality): $db =& ADONewConnection('mssql'); $db->Execute('localhost', 'userid', 'password', 'northwind');tadios tefera <ttefera () gmail com> 1/26/2012 4:02 PM >>>not sure if my earlier message was delivered.... 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 Mon, Jan 23, 2012 at 1:34 PM, tadios tefera <ttefera () gmail com> wrote: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!
Current thread:
- cannot authenticate to MSSQL database from BASE tadios tefera (Jan 22)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Jan 22)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Jan 25)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Jan 29)
- Re: cannot authenticate to MSSQL database from BASE Billy Marshall (Jan 30)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Feb 02)
- Re: cannot authenticate to MSSQL database from BASE Jeremy Hoel (Feb 02)
- Re: cannot authenticate to MSSQL database from BASE Jeremy Hoel (Feb 02)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Feb 02)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Feb 03)
- Re: cannot authenticate to MSSQL database from BASE Jeremy Hoel (Feb 02)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Feb 03)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Feb 03)
- Re: cannot authenticate to MSSQL database from BASE Billy Marshall (Feb 06)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Feb 06)
- Message not available
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Feb 11)
- Re: cannot authenticate to MSSQL database from BASE tadios tefera (Jan 25)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Jan 22)