Re: [cisco-ttl] ACS Server SQL iliskisi nasil kurulur?

From: Levent Ogut (levent_at_networkakademi.com)
Date: Thu Jan 27 2005 - 08:29:13 GMT

  • Next message: Faruk Önder Yerli: "RE: [cisco-ttl] PRI'a gelen telefon aramalarının yönlendirilmesi sorunu"

    Kendi veritabaninizi olusturup, bunu ODBC ye baglamaniz gerekiyor once.

    Daha sonra MSSQL de bir procedure yazip accept / reject kodunu geri
    gondermeniz gerekiyor.

    http://www.cisco.com/en/US/products/sw/secursw/ps2086/products_user_guide_chapter09186a008007dea7.html

    http://www.cisco.com/en/US/products/sw/secursw/ps2086/products_user_guide_chapter09186a008007dec4.html#3259

    >>>>>>>>>>>>>>>>>>>>>>>>>>
    Sample Routine for Generating a PAP Authentication SQL Procedure
    The following example routine creates a procedure named CSNTAuthUserPap in
    Microsoft SQL Server, the default procedure used by Cisco Secure ACS for
    PAP authentication. Table and column names that could vary for your
    database schema are presented in variable text. The Cisco Secure ACS
    product CD includes a stub routine for creating a procedure in either SQL
    Server or Oracle. For more information about data type definitions,
    procedure parameters, and procedure results, see the "ODBC Database"
    section.

    if exists (select * from sysobjects where id = object_id
    (\Qdbo.CSNTAuthUserPap') and sysstat & 0xf = 4)
    drop procedure dbo.CSNTAuthUserPap
    GO

    CREATE PROCEDURE CSNTAuthUserPap
    @username varchar(64), @pass varchar(255)
    AS
    SET NOCOUNT ON
    IF EXISTS( SELECT username
     FROM users
    WHERE username = @username
    AND csntpassword = @pass )
    SELECT 0,csntgroup,csntacctinfo,"No Error"
     FROM users
    WHERE username = @username
    ELSE
    SELECT 3,0,"odbc","ODBC Authen Error"

    GO
    GRANT EXECUTE ON dbo.CSNTAuthUserPap TO ciscosecure
    GO

    On Thu, 27 Jan 2005 08:16:24 -0000, Mehmet <meku_at_gmx.com.tr> wrote:

    >
    >
    > Merhabalar;
    > Cisco ACS server 3.3'u Win2003Server uzerine kuruyorum. SQL Server
    > 2000'de var. Fakat SQL uzerinde database'i nasıl olusturacagima dair
    > hicbir help dokumani bulamadim. SQL server uzerinde database manuel
    > mi olusturuyor yoksa ACS server ODBC yardimiyla kendisi olustururmu.
    > Kendim bir baska ornekten cikarak ACS adinda bir database olusturdum
    > ve icine table'lari baska bir SQL uzerinden import ettim. ODBC
    > uzerinde de SystemDNS tanimladim. ACS icinde de External Database
    > bolumune bu bilgileri giriyorum. Ama bir turlu SQL uzerindeki
    > verileri kullanarak login olunamiyor. Failed Attempts'e baktigimda
    > verdigi hata "External DB reports error condition"
    > AAA Client Bolumune de router bilgilerini (ip ve key bilgisi)
    > girilmis durumda. Basindan boyle bir sorun gecen varsa yardımci
    > olursa sevinirim.
    > Not: ACS icine girdigim user ile Authentication saglanabiliyor.
    >
    > Mehmet
    >
    >
    >
    >
    >
    > Bu listenin Cisco Systems ile herhangi bir baglantisi bulunmamaktadir.
    >
    > Listeden cikmak için cisco-ttl-unsubscribe_at_yahoogroups.com adresine bir
    > e-posta gönderebilirsiniz.
    > Yahoo! Groups Links
    >
    >
    >
    >
    >
    >
    >
    >

    Bu listenin Cisco Systems ile herhangi bir baglantisi bulunmamaktadir.

    Listeden cikmak için cisco-ttl-unsubscribe_at_yahoogroups.com adresine bir e-posta gönderebilirsiniz.
    Yahoo! Groups Links

    <*> To visit your group on the web, go to:
        http://groups.yahoo.com/group/cisco-ttl/

    <*> To unsubscribe from this group, send an email to:
        cisco-ttl-unsubscribe_at_yahoogroups.com

    <*> Your use of Yahoo! Groups is subject to:
        http://docs.yahoo.com/info/terms/
     



    This archive was generated by hypermail 2.1.5 : Thu Jan 27 2005 - 12:32:14 GMT