[Snort-users] cannot authenticate to MSSQL database from BASE

Jeremy Hoel jthoel at ...11827...
Thu Feb 2 10:04:42 EST 2012


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 at ...11827...> 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 at ...11827...> 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 at ...15507.....>
>> 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 at ...11827...> 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 at ...11827...> 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 at ...9077...>
>>>> 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 at ...11827...]
>>>>> Sent: Tuesday, January 17, 2012 11:31 AM
>>>>> To: snort-users at 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 at ...15494...
>>>>>
>>>>> 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 at 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!




More information about the Snort-users mailing list