I used to stuck in Collection Manager installation for Cisco SCE

[Sirisak Chantanate]

I used to install Cisco Service Control Management Suite Collection Manager.

Before that I have to install CentOS 5.5 and then install MySQL Database.

For MySQL installation, I have to use some SQL command to complete the installation

but no configuration guide on cisco website and I have to find out how.

After 2 weeks, I can do it and I feel like I can fly.

I know somebody would stuck in the installation of MySQL like me.

I have the installation guide in my blog.

But only how to install MySQL Database for SCE and how to install SCSM Collection Manager.

See my blog at http://ciscoeasysetup.blogspot.com/

[davidfarjecalderon]

Hello Sirisak,

Do you still have the guide?  I clicked on your link for the blog post and could not find it.

I have opened a case with TAC but there is no engineer available.

Regards,

David Farje

[Sirisak Chantanate]

Hi David

You can see my blog post. Hope this can help you.

http://alleasysetup.blogspot.com/2011/10/most-difficult-when-install-cisco-sce.html

Regards,

Sirisak.C

[Itap]

thank you Sirisak

but i am trying install MySQL Database for SCE i have some issues

notification:

Would you like to configure the database? (yes/no): yes

Configuring CM:RDR Database...

Enter the DB type:

1 - Oracle

2 - MySQL

3 - Sybase

4 - exit

Enter your choice: 2

Enter MySQL server host (current is localhost) :

Enter MySQL server listening port (current is 3306) :

Enter MySQL server instance id (current is apricot) :

Enter CM schema user name (current is pqb_admin) :

Enter CM schema user password (current is pqb_admin) :

Do you want to test the DB connection? (yes/no): yes

FAIL:DB is not running

DB connection failed.

i show you my configuration DB MySQL

[root@sersce install-scripts]# mysql -u pqb_admin -p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4

Server version: 5.0.92-community-log MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| apricot            |

| test               |

+--------------------+

3 rows in set (0.00 sec)

so you see on my log the DB MySQL doesn't connected with CM 

what i can do it for resolve my problem ?

[Sirisak Chantanate]

You can try this step.

Login to mysql then follow by these command

host#mysql -u root

mysql> set password for 'root'@'localhost' = password('your_password');

mysql> set password for 'root'@'127.0.0.1' = password('your_password');

mysql> create database apricot;

mysql> set password for 'pqb_admin'@'localhost' = password('pqb_admin');

mysql> set password for 'pqb_admin'@'127.0.0.1' = password('pqb_admin');

[Itap]

i am trying do it those steps :

mysql> set password for 'pqb_admin'@'localhost' = password('pqb_admin');

ERROR 1133 (42000): Can't find any matching row in the user table

[Sirisak Chantanate]

Hi Itap.

     I would like to recommend you to follow my step by following link.

http://alleasysetup.blogspot.com/2011/10/most-difficult-when-install-cisco-sce.html

PS. (just do the fresh installation)