Data Backup and Recovery

SnapCreator 3.5 mysql plugin. not able to quiesce

wolfsonmicro
7,442 Views

Hi

I am having problem to make it work 😕

I am not able to quiesce  MySql database even from the host.

########## Application quiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Quiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00001] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

at the beginnig I thought my problem could be relative to my network , so I ran the commande line directly from my Mysql server.

./snapcreator --action quiesce --profile macas --verbose --debug

everytime I have 

root@alain macas]# cat macas.debug.20120123143046.log
[Mon Jan 23 14:30:46 2012] DEBUG: GMT - Mon Jan 23 14:30:46 2012
[Mon Jan 23 14:30:46 2012] DEBUG: Version: NetApp Snap Creator Framework 3.5.0
[Mon Jan 23 14:30:46 2012] DEBUG: Profile: macas
[Mon Jan 23 14:30:46 2012] DEBUG: Config Type: STANDARD
[Mon Jan 23 14:30:46 2012] DEBUG: Action: quiesce
[Mon Jan 23 14:30:46 2012] DEBUG: Application Plugin: mysql
[Mon Jan 23 14:30:46 2012] DEBUG: File System Plugin: null
[Mon Jan 23 14:30:46 2012] DEBUG: Policy: null
[Mon Jan 23 14:30:46 2012] DEBUG: Snapshot Name: null
[Mon Jan 23 14:30:46 2012] INFO: Logfile timestamp: 20120123143046
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112


########## Parsing Environment Parameters ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing VOLUMES - controller: mercury volume: cdump
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing NTAP_USERS - controller: mercury user: root
[Mon Jan 23 14:30:46 2012] DEBUG: Parsing NTAP_SNAPSHOT_RETENTIONS - policy: daily retention: 3

########## Application quiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Quiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00001] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

########## Application unquiesce ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Timeout of authentication at /</NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Mon Jan 23 14:30:46 2012] INFO: Unquiescing databases
[Mon Jan 23 14:30:46 2012] ERROR: [mys-00004] Database connection does not exist
[Mon Jan 23 14:30:46 2012] ERROR: [scf-00054] Application unquiesce for plugin mysql failed with exit code 1, Exiting!

########## PRE EXIT COMMANDS ##########
[Mon Jan 23 14:30:46 2012] INFO: No commands defined

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########
[Mon Jan 23 14:30:46 2012] DEBUG: Exiting with error code - 2

looks like the authentification to my Mysql databse does not work

I created a new REDHAT VM and install MySql on. I use root to connect to the database for the test but unfortunatly I still have the same issue.

could be the problem be it in a VM? what setting(s) should I check ?

I am not using SSL

I attached configuration file(named mysql.conf)

Many thanks in advanced

Alain

1 ACCEPTED SOLUTION

ktenzer
7,441 Views

It looks like SC cant get a database connection. Below are your settings:

MYSQL_DATABASES=mysql:root/53616c7465645f5f9b57ab314e02617d65cf27adbba602ed266987370e53704f

HOST=172.20.20.192

PORTS=mysql:3306

MASTER_SLAVE=N

I would change HOST=localhost

I would verify is DB really running on 3306? Do a
"telnet localhost 3306"

I would check the database connection: mysql -uUsername -pPassword

Do you get a connection using same user running SC with password SC is using for mysql?

I would not use --action quiesce, the --action snap is better, it will run quiesce as well.

Finally what version of SC do you have? The latest version on NOW is 3.5, if you have 3.3 or something old, I would get 3.5.

Let me know if this helps?

Regards,

Keith

View solution in original post

12 REPLIES 12

ktenzer
7,442 Views

It looks like SC cant get a database connection. Below are your settings:

MYSQL_DATABASES=mysql:root/53616c7465645f5f9b57ab314e02617d65cf27adbba602ed266987370e53704f

HOST=172.20.20.192

PORTS=mysql:3306

MASTER_SLAVE=N

I would change HOST=localhost

I would verify is DB really running on 3306? Do a
"telnet localhost 3306"

I would check the database connection: mysql -uUsername -pPassword

Do you get a connection using same user running SC with password SC is using for mysql?

I would not use --action quiesce, the --action snap is better, it will run quiesce as well.

Finally what version of SC do you have? The latest version on NOW is 3.5, if you have 3.3 or something old, I would get 3.5.

Let me know if this helps?

Regards,

Keith

wolfsonmicro
7,413 Views

Hi Keith

Many thanks for you quick answer 🙂

My current config at work

redhat 5.7

mysql 5.0.77

I know it it's not in the matrix:-(

and I am using Snapcreator 3.5.0 scServer.

telnet localhost 3306 works fine.

login and password are different for Snapcreator and mysql

login for mysql is root

I follow your advice and  modify the host=localhost , there is an improvement now I can quiesce  but got "bad handshake" with

"./snapcreator --action quiesce --profile macas --verbose --debug" and "./snapcreator --action snap --policy daily --profile macas --verbose --debug"

[root@alain scServer3.5.0]# ./snapcreator --action snap --policy daily --profile macas --verbose --debug
[Wed Jan 25 10:38:55 2012] DEBUG: Loaded Config File /NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/configs/macas/macas.conf Successfully
[Wed Jan 25 10:38:55 2012] DEBUG: GMT - Wed Jan 25 10:38:55 2012
[Wed Jan 25 10:38:55 2012] DEBUG: Version: NetApp Snap Creator Framework 3.5.0
[Wed Jan 25 10:38:55 2012] DEBUG: Profile: macas
[Wed Jan 25 10:38:55 2012] DEBUG: Config Type: STANDARD
[Wed Jan 25 10:38:55 2012] DEBUG: Action: snap
[Wed Jan 25 10:38:55 2012] DEBUG: Application Plugin: mysql
[Wed Jan 25 10:38:55 2012] DEBUG: File System Plugin: null
[Wed Jan 25 10:38:55 2012] DEBUG: Policy: daily
[Wed Jan 25 10:38:55 2012] DEBUG: Snapshot Name: macas-daily_20120125103855
[Wed Jan 25 10:38:55 2012] INFO: Logfile timestamp: 20120125103855

########## Parsing Environment Parameters ##########
[Wed Jan 25 10:38:55 2012] DEBUG: Parsing VOLUMES - controller: mercury volume: cdump
[Wed Jan 25 10:38:55 2012] DEBUG: Parsing NTAP_USERS - controller: mercury user: root
[Wed Jan 25 10:38:55 2012] DEBUG: Parsing NTAP_SNAPSHOT_RETENTIONS - policy: daily retention: 3

########## PRE APPLICATION QUIESCE COMMANDS ##########
[Wed Jan 25 10:38:55 2012] INFO: No commands defined

########## PRE APPLICATION QUIESCE COMMANDS FINISHED SUCCESSFULLY ##########

########## Application quiesce ##########
[Wed Jan 25 10:38:55 2012] INFO: Quiescing databases
[Wed Jan 25 10:38:55 2012] INFO: Quiescing database mysql
[Wed Jan 25 10:38:55 2012] DEBUG: Connection to mysql successfully established
[Wed Jan 25 10:38:55 2012] DEBUG: Executing sql command 'flush tables with read lock' for database mysql
[Wed Jan 25 10:38:55 2012] ERROR: #08S01Bad handshake
[Wed Jan 25 10:38:55 2012] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

########## Application unquiesce ##########
[Wed Jan 25 10:38:55 2012] INFO: Unquiescing databases
[Wed Jan 25 10:38:55 2012] INFO: Unquiescing database mysql
[Wed Jan 25 10:38:55 2012] DEBUG: Connection to mysql established successfully
[Wed Jan 25 10:38:55 2012] DEBUG: Executing sql command 'unlock tables' for database mysql
[Wed Jan 25 10:38:55 2012] ERROR: #08S01Bad handshake
[Wed Jan 25 10:38:55 2012] ERROR: [scf-00054] Application unquiesce for plugin mysql failed with exit code 1, Exiting!

########## PRE EXIT COMMANDS ##########
[Wed Jan 25 10:38:55 2012] INFO: No commands defined

########## PRE EXIT COMMANDS FINISHED SUCCESSFULLY ##########
[Wed Jan 25 10:38:55 2012] DEBUG: Exiting with error code - 2

Kind regards

Alain

Message was edited by: Robert Gray I found one of your advices on the community about a workaround for "#08S01Bad handshake" commenting out APP_NAME=mysql #APP_NAME=mysql in config): and add in config file APP_QUIESCE_CMD01=mysql <arguments> <sql query=flush tables with read lock> APP_QUIESCE_CMD02=mysql <arguments> <sql query=flush logs> APP_UNQUIESCE_CMD01=mysql <arguments> <sql query=unlock tables> PRE_EXIT_CMD01=mysql <arguments> <sql query=unlock tables> unfortunatly I was not confortable how to modify the file but I did. I thought it did work but when I check the debug file 😞 I had what's bellow. Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_QUIESCE_CMD01, please check configuration file [Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_QUIESCE_CMD02, please check configuration file [Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_UNQUIESCE_CMD01, please check configuration file [Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter PRE_EXIT_CMD01, please check configuration file [Wed Jan 25 15:31:46 2012] DEBUG: Loaded Config File /NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/configs/macas/macas.conf Successfully I 've attached  teh debug file and config file. Many thanks in advance

RIMSYSTEM
7,413 Views

Hi,

I have the same problem. I'm trying to snapshot a mysql DB. Quiescing doesn't work.

I use snapcreator 3.5.

Here are the agent logs:

[Wed Jan 25 14:17:29 2012] DEBUG: 1.2.3.4 is allowed to send requests

[Wed Jan 25 14:17:29 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:17:29 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:17:29 2012] INFO: Starting watchdog with [7677], forced unquiesce timeout [65] second(s)

[Wed Jan 25 14:17:29 2012] DEBUG: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Wed Jan 25 14:17:29 2012] INFO: Quiescing databases

[Wed Jan 25 14:17:29 2012] ERROR: [mys-00001] Database connection does not exist

[Wed Jan 25 14:17:29 2012] DEBUG: Reloading configuration from /usr/local/scAgent3.5.0/config/agent.conf

[Wed Jan 25 14:17:29 2012] DEBUG: Reloading configuration finished with

exit code: [0]

stdout: []

stderr: []

[Wed Jan 25 14:17:29 2012] DEBUG: 1.2.3.4 is allowed to send requests

[Wed Jan 25 14:17:29 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:17:29 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:17:29 2012] DEBUG: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Wed Jan 25 14:17:29 2012] INFO: Unquiescing databases

[Wed Jan 25 14:17:29 2012] ERROR: [mys-00004] Database connection does not exist

[Wed Jan 25 14:24:22 2012] DEBUG: Reloading configuration from /usr/local/scAgent3.5.0/config/agent.conf

[Wed Jan 25 14:24:22 2012] DEBUG: Reloading configuration finished with

exit code: [0]

stdout: []

stderr: []

[Wed Jan 25 14:24:22 2012] DEBUG: 1.2.3.4 is allowed to send requests

[Wed Jan 25 14:24:22 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:24:22 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:24:22 2012] INFO: Starting watchdog with [7679], forced unquiesce timeout [65] second(s)

[Wed Jan 25 14:24:23 2012] DEBUG: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Wed Jan 25 14:24:23 2012] INFO: Quiescing databases

[Wed Jan 25 14:24:23 2012] ERROR: [mys-00001] Database connection does not exist

[Wed Jan 25 14:24:23 2012] DEBUG: Reloading configuration from /usr/local/scAgent3.5.0/config/agent.conf

[Wed Jan 25 14:24:23 2012] DEBUG: Reloading configuration finished with

exit code: [0]

stdout: []

stderr: []

[Wed Jan 25 14:24:23 2012] DEBUG: 1.2.3.4 is allowed to send requests

[Wed Jan 25 14:24:23 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:24:23 2012] INFO: Authorized request from [scServer@*]

[Wed Jan 25 14:24:23 2012] DEBUG: Couldn't connect to localhost:3306/tcp: IO::Socket::INET: connect: Connection refused at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

=== I tested the connection using mysql CLI and it works ===

[Wed Jan 25 14:24:23 2012] INFO: Unquiescing databases

[Wed Jan 25 14:24:23 2012] ERROR: [mys-00004] Database connection does not exist

Regards,

Greg.

ktenzer
7,413 Views

What version of MySQL? What are your config settings for MySQL?

As workaround you can use the above method, mentioned in thread and the mysql command. Also I would like at IMT for Snap Creator, what is supported should work, but we certainly dont test every version, especially really old versions of MySQL.

Various 5.0 versions of MySQL 5.0.77 have had issues with the MySQL client:

http://forums.mysql.com/read.php?51,356486,356927#msg-356927

Again change the HOST setting to HOST=localhost and ensure that the mysql port is open.

1. telnet localhost 3306

2. mysql -u root -h localhost -P 3306 -p

Let us know

Regards,

Keith

ktenzer
7,413 Views

This looks like issue with MySQL client, I did some research on MySQL forums and there seems to be issues with old versions of MySQL which we dont test.

I am glad you found work around this is definitely a decent workaround and is pretty simple.

I will see if maybe we can look at a using a MySQL client that is less sensitive, there seems to be other options to look into.

Regards,

Keith

wolfsonmicro
7,413 Views

Hi Keith

I have another problem now , after I modified the file config adding

####################
### Pre Commands ###
####################
#PRE_APP_QUIESCE_CMD01=
#PRE_NTAP_CMD01=
#PRE_NTAP_CLONE_DELETE_CMD01=
#PRE_APP_UNQUIESCE_CMD01=
#PRE_RESTORE_CMD01=
#PRE_CLONE_CREATE_CMD01=


APP_QUIESCE_CMD01=mysql <arguments> <sql query=flush tables with read lock>
APP_QUIESCE_CMD02=mysql <arguments> <sql query=flush logs>

I can see it complaining about "<" character in the debug log. What I am doing wrong?  

do you have a example of config file for quiescing mysql without the plugin?

########## PRE NETAPP COMMANDS FINISHED SUCCESSFULLY ##########

[Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_QUIESCE_CMD01, please check configuration file

[Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_QUIESCE_CMD02, please check configuration file

[Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter APP_UNQUIESCE_CMD01, please check configuration file

[Wed Jan 25 15:31:46 2012] WARN: [scf-00132] Invalid character "<" defined in parameter PRE_EXIT_CMD01, please check configuration file

[Wed Jan 25 15:31:46 2012] DEBUG: Loaded Config File /NetApp_Snap_Creator_Framework3.5.0-Linux64/scServer3.5.0/config

Many thanks for your help

Alain

ktenzer
7,413 Views

Hi Alain,

Snap Creator will ignore the "<" character if it is present in a CMD, meaning SC will skip the command if it finds the "<" present in command. This character will break our XML encoding which happens between scServer and scAgent.

If you have to use the "<" character then you need to add command to a wrapper script and call the script.

The only acceptions where a "<" is allowed is the SUCCESS_TRAP and SENDTRAP commands.

Regards,

Keith

wolfsonmicro
7,413 Views

Hi Keith

thanks for your answer. but I don't don't have your knowledge about scripting , mysql etc.. do you have an file sample I can refer too?

I would apreciate and I am sure that will help lot a people too

Many thanks for you help

Alain

ktenzer
7,413 Views

Hi Alain,

Nothing really to script just basic mysql commands.

Something like:

APP_QUIESCE_CMD01=mysql  –Dmysql –uuser –Ppwd < /path/to/quiesce.script

APP_UNQUIESCE_CMD01=mysql  –Dmysql –uuser –Ppwd < /path/to/unquiesce.script

PRE_EXIT_CMD01=mysql  –Dmysql –uuser –Ppwd < /path/to/unquiesce.script

The -D argument is for your database name, probably mysql

The -u argument is for username

The -P argument is for password

In the quiesce quiesce.script you would have:

flush tables with read lock

flush logs

In unquiesce.script you would have:

unlock tables

I am not a mysql expert either, this was just google

Point is in SC you can simply run commands so figure out how you want or can do the mysql queries in the quiesce.script and unquiesce.script and that is it.

Regards,

Keith

wolfsonmicro
5,844 Views

Hi Keith

this is the answer to how quiesce Mysql. I have to thanks Jean-Marc B

First, can you login manually like this:

# /usr/bin/mysql -u root -p
Enter password:
...
mysql>

Then like this

# /usr/bin/mysql -u root -ppassword

If it works, then try this:

# /bin/echo "show databases" | /usr/bin/mysql -u root -ppassword

If ok, give this a try:

APP_QUIESCE_CMD01=/bin/echo "flush tables with read lock" | /usr/bin/mysql -u root -ppassword
APP_QUIESCE_CMD02=/bin/echo "flush logs" | /usr/bin/mysql -u root -ppassword
APP_UNQUIESCE_CMD01=/bin/echo "unlock tables" | /usr/bin/mysql -u root -ppassword
PRE_EXIT_CMD01=/bin/echo "unlock tables" | /usr/bin/mysql -u root -ppassword

works perfectly 🙂

Hope that will help .

Alain

ktenzer
5,844 Views

Hi Alain,

Thank you and Jean-Marc B for getting back to us and sharing this. It is community posts like this that make community a better place for everyone I am sure others will find this info very useful and I will certainly refer to it in the future.

Happy Snap Creating!

Regards,

Keith

uptimenow
5,844 Views

Hi,

I was running into the exact same problem this afternoon, yet the fix for my problem was not mentioned in this thread so I'll add my 2 cents here.

So, I was getting these errors (MySQL on Linux with SC agent 3.5, SC server is version 3.5 on Windows):

[Fri May  4 14:27:55 2012] [vc6apachedmz03t:9090(3.5.0.1)] ERROR: [mys-00001] Database connection does not exist

[Fri May  4 14:27:50 2012] [vc6apachedmz03t:9090(3.5.0.1)] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

I used the SC 3.5 GUI to create this MySQL configuration, and I used the following fields in the GUI:

Db:User/Password:   snapcreator_test:root/mypassword

Host: localhost

Port: snapcreator_test:3306

After some digging around I found this logfile which contained some useful info:

/usr/local/scAgent3.5.0/logs/MYSQL/vc6apachedmz03t-daily.debug.20120504151715.agent.log

(by the way, it's annoying that this particular logfile is not available from the GUI,

otherwise I would have discovered the nature of the problem much sooner)

The errors in this logfile were:

[Fri May  4 15:17:21 2012] INFO: Starting watchdog with [25286], forced unquiesce timeout [65] second(s)

[Fri May  4 15:17:21 2012] DEBUG: Couldn't connect to localhost:snapcreator_test/tcp: IO::Socket::INET: Bad service 'snapcreator_test' at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Fri May  4 15:17:21 2012] INFO: Quiescing databases

[Fri May  4 15:17:21 2012] INFO: Quiescing database snapcreator_test

[Fri May  4 15:17:21 2012] ERROR: [mys-00002] Database connection problem for snapcreator_test detected

[Fri May  4 15:17:21 2012] DEBUG: Couldn't connect to localhost:snapcreator_test/tcp: IO::Socket::INET: Bad service 'snapcreator_test' at /</usr/local/scAgent3.5.0/snapcreator>SnapCreator/MOD/MYSQL.pm line 112

[Fri May  4 15:17:21 2012] INFO: Unquiescing databases

[Fri May  4 15:17:21 2012] INFO: Unquiescing database snapcreator_test

[Fri May  4 15:17:21 2012] ERROR: [mys-00005] Database connection problem for snapcreator_test detected

From this, I gathered that there was some mixup with the portnumbers somewhere.

Here's the problem: in the actual configuration file, I saw this:

PORTS=snapcreator_test:snapcreator_test:3306

So this created this error. I fixed it by specifying:

Port: 3306

In the GUI, which resulted in this in the config file:

PORTS=snapcreator_test:3306

I guess this could qualify as a bug of some kind.

Additionally, when specifying more than one database, following the official documentation

doesn't seem to work:

MYSQL_DATABASES=snapcreator_test:root/mypassword;sc:root/mypassword

HOST=localhost

PORTS=snapcreator_test:3306;sc:3306

This yields:

########## Application quiesce ##########

[Fri May  4 15:54:01 2012] [vc6apachedmz03t:9090(3.5.0.1)] ERROR: [agt-00013] send: Cannot determine peer address at /</usr/local/scAgent3.5.0/snapcreator>Net/MySQL.pm line 293

[Fri May  4 15:53:56 2012] ERROR: send: Cannot determine peer address at /</usr/local/scAgent3.5.0/snapcreator>Net/MySQL.pm line 293

[Fri May  4 15:53:56 2012] [vc6apachedmz03t:9090(3.5.0.1)] ERROR: [scf-00053] Application quiesce for plugin mysql failed with exit code 1, Exiting!

########## Application unquiesce ##########

[Fri May  4 15:54:02 2012] [vc6apachedmz03t:9090(3.5.0.1)] ERROR: [agt-00013] send: Cannot determine peer address at /</usr/local/scAgent3.5.0/snapcreator>Net/MySQL.pm line 293

[Fri May  4 15:53:56 2012] ERROR: send: Cannot determine peer address at /</usr/local/scAgent3.5.0/snapcreator>Net/MySQL.pm line 293

[Fri May  4 15:53:56 2012] ERROR: [scf-00054] Application unquiesce for plugin mysql failed with exit code 1, Exiting!

Basically I just put this for the PORTS parameter:

PORTS=3306

Also, I think there may also be a problem with DB consistency when specifying more than one database, I see this in my MySQL log:

120504 15:53:10 2 Connect   root@localhost on
                2 Query select @@version_comment limit 1
120504 15:53:13 2 Query SELECT DATABASE()
                2 Init DB   sc
                2 Query show databases
                2 Query show tables
                2 Field List    event
120504 15:53:22 2 Query describe events
120504 15:53:25 2 Query describe event
120504 15:53:27 2 Quit
120504 15:54:01 3 Connect   root@localhost on snapcreator_test
                3 Query SHOW VARIABLES LIKE "%version%"
                3 Query flush tables with read lock
                3 Query flush logs

/usr/libexec/mysqld, Version: 5.1.52-log (Source distribution). started with:

Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock

Time             Id CommandArgument
120504 15:54:02 4 Connect   root@localhost on snapcreator_test
                4 Query SHOW VARIABLES LIKE "%version%"
                4 Query unlock tables
                4 Quit

I am no MySQL expert, but I think only the "snapcreator_test" database is flushed, not the "sc" database, even though it was also specified in the SC configuration. Should I report this problem in a different forum post ?

Best regards,

Filip Sneppe

Public