Hey, i am facing an error while trying to connect to ise db after enabling the data connect feature .
The code is:dataconnect ,ise
package maindataconnect ,ise
import (
"database/sql"
"fmt"
"log"
_ "github.com/sijms/go-ora/v2" // Oracle DB driver
)
func main() {
// Define the connection string for Oracle with SSL/TCP
dsn := `dataconnect/password@tcps(1.1.1.1:2484)/cpm10?ssl=true&ssl_cert=<path_to_cert>`
// Open a database connection using the go-ora driver
db, err := sql.Open("oracle", dsn)
if err != nil {
log.Fatalf("Failed to open connection: %v", err)
}
defer db.Close()
// Try to ping the database to check connectivity
err = db.Ping()
if err != nil {
log.Fatalf("Failed to ping database: %v", err)
} else {
fmt.Println("Successfully connected to the Cisco ISE Database!")
}
// Sample query: List Network Device Groups
rows, err := db.Query("SELECT * FROM NETWORK_DEVICE_GROUPS")
if err != nil {
log.Fatalf("Error executing query: %v", err)
}
defer rows.Close()
// Print query results
fmt.Println("\nList of Network Device Groups:")
for rows.Next() {
var id, name, status string
err := rows.Scan(&id, &name, &status)
if err != nil {
log.Fatalf("Error scanning row: %v", err)
}
fmt.Printf("ID: %s, Name: %s, Status: %s\n", id, name, status)
}
if err := rows.Err(); err != nil {
log.Fatalf("Row iteration error: %v", err)
}
}
the error i am facing is :
2024/12/24 15:11:16 Failed to ping database: missing port in address
Can someone tell me what mistake am I doing or if anyone could give steps on how to build a connection with the ISE Db after enabling the dataconnect feature.
