Snort mailing list archives
Re: cannot authenticate to MSSQL database from BASE
From: "Michael Steele" <michaels () winsnort com>
Date: Fri, 3 Feb 2012 10:32:10 -0500
No, the guide does not tell you to place the 'test.php' in 'wwwroot/base' folder, and test. Testing PHP happens way before the base folder is created. If the 'test.php' file from the winsnort software pack successfully executes in the 'wwwroot/base' folder, and after executing the 'testing.php' file in that same folder only displays text, then the problem with the 'testing.php' file. Text editors can do some strange things with text files. Just because a .php extension is placed on a file, PHP may not see it as a legitimate .php file. Varied results could happen, like text being displayed. With WordPad, how a file is loaded, is how its saved back. The reason why the guide specifically tells the installer to right click the file and load, is to make sure the file keeps its attributes intact when its saved back. Kindest regards, Michael... WINSNORT.com Management Team Member -- ****************** Established ~ 2001 ******************* * Visit Us @ <http://www.winsnort.com> http://www.winsnort.com * * ~~ FREE WinIDS Snort installation guides ~~ * * ~~ FREE support forums ~~ * * Snort: Open Source Network IDS - <http://www.snort.org> http://www.snort.org * ********************************************************* From: tadios tefera [mailto:ttefera () gmail com] Sent: Thursday, February 02, 2012 10:23 AM To: Jeremy Hoel Cc: Billy Marshall; snort-users () lists sourceforge net Subject: Re: [Snort-users] cannot authenticate to MSSQL database from BASE How can I confirm php is executing? Per the documentation on Winsnort.com on how to setup snort and Base on Windows, I have followed the test procedure to verify that php is executing. the procedure states, to place a test.php file in c:\inetpub\wwwroot\base. The from a browser to execute test.php by http://ServerName/base/test.php Test.php contains the following: <?php phpinfo(); ?> The outcome on my browser is what is expected per the documentation on Winsnort.com; it is a table showing php version, system, build date, configure command, server api, etc.... Is this not a sufficient way to confirm that php is executing? On Thu, Feb 2, 2012 at 10:04 AM, Jeremy Hoel <jthoel () gmail com> wrote: Err.. sorry. Got cut off at work php is not parsing the file correctly.. it's not being interpreted by the web server. On Thu, Feb 2, 2012 at 3:03 PM, Jeremy Hoel <jthoel () gmail com> wrote:
if you just see the text of the php file and not the rendered version, then php isn't executing.. On Wed, Feb 1, 2012 at 10:43 PM, tadios tefera <ttefera () gmail com> wrote: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!
------------------------------------------------------------------------------ Try before you buy = See our experts in action! 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-dev2
_______________________________________________ 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:
- Re: cannot authenticate to MSSQL database from BASE, (continued)
- 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 Joel Esler (Feb 11)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Feb 11)
- Re: cannot authenticate to MSSQL database from BASE Joel Esler (Feb 11)
- Re: cannot authenticate to MSSQL database from BASE Michael Steele (Feb 03)
- Re: cannot authenticate to MSSQL database from BASE waldo kitty (Feb 03)