Re: cannot authenticate to MSSQL database from BASE

[Jeremy Hoel <jthoel () gmail com>]

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!

------------------------------------------------------------------------------
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!