一个expect问题

清潼止水

脚本：

1. #!/bin/bash
   
2. 
   
3. passwd="sohu.com"
   
4. 
   
5. expect -c "
   
6. set timeout -1
   
7. spawn mysql -u root -p test < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql
   
8. expect \"password:\"
   
9. send \"${passwd}\r\"
   
10. expect eof
    
11. "

复制代码

大家看这段代码有问题麽，mysql -u ..这条语句没执行，报：

1. send: spawn id exp6 not open
   
2.     while executing
   
3. "send "sohu.com\r""

复制代码

waker

expect -dc " ..........

观察一下吧

清潼止水

观察了：

1. 
   
2. expect: does "mysql  Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1\r\nCopyright (C) 2000-2008 MySQL AB\r\nThis software comes with ABSOLUTELY NO WARRANTY. This is free software,\r\nand you are welcome to modify and redistribute it under the GPL license\r\nUsage: mysql [OPTIONS] [database]\r\n  -?, --help          Display this help and exit.\r\n  -I, --help          Synonym for -?\r\n  --auto-rehash       Enable automatic rehashing. One doesn't need to use\r\n                      'rehash' to get table and field completion, but startup\r\n                      and reconnecting may take a longer time. Disable with\r\n                      --disable-auto-rehash.\r\n  -A, --no-auto-rehash \r\n                      No automatic rehashing. One has to use 'rehash' to get\r\n                      table and field completion. This gives a quicker start of\r\n                      mysql and disables rehashing on reconnect. WARNING:\r\n                      options deprecated; use --disable-auto-rehash instead.\r\n  -B, --batch         Don't use history file. Disable interactive behavior.\r\n" (spawn_id exp6) match glob pattern "password:"? no
   
3.                       (Enables --silent)
   

复制代码

waker

回复 3# 清潼止水


    mysql告诉你应该怎么使用它

waker

spawn mysql -u root -p test < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql
中mysql是要spawn命令,后面的全是mysql的参数,请确认mysql支持你那一串参数么?

Shell_HAT

1. #!/bin/bash
   
2. mysqlHost="testhost"
   
3. mysqlUser="root"
   
4. mysqlPassword="sohu.com"
   
5. mysqlDB="testdb"
   
6. expect -c "
   
7. set timeout -1
   
8. spawn mysql -h $mysqlHost -u$mysqlUser -p$mysqlPassword --databases $mysqlDB < "/root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql "
   
9. expect \"password:\"
   
10. send \"${passwd}\r\"
    
11. expect eof
    
12. "

复制代码

清潼止水

回复 5# waker

1. mysql -uroot -p test < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql

复制代码

这句在命令行敲是没问题的

清潼止水

回复 6# Shell_HAT


    多谢版主，把你的改了下，还是不行：

1. #!/bin/bash
   
2. 
   
3. mysqlHost="127.0.0.1"
   
4. mysqlUser="root"
   
5. mysqlPassword="sohu.com"
   
6. mysqlDB="test"
   
7. 
   
8. expect -c "
   
9. set timeout -1
   
10. spawn mysql -h $mysqlHost -u$mysqlUser -p --database $mysqlDB < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql
    
11. expect \"password:\"
    
12. send \"${mysqlPassword}\r\"
    
13. expect eof
    
14. "

复制代码

但是，不用expect，一条命令就可以了：

1. mysql -h $mysqlHost -u$mysqlUser -p${mysqlPassword} --database $mysqlDB < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql

复制代码

waker

回复  waker 这句在命令行敲是没问题的
清潼止水 发表于 2011-11-22 11:18

命令行是shell解释的,<进行重定向准备,而spawn不是的啊

waker

试试
spawn bash -c 'mysql -u root -p test < /root/package/centreon+nagios/tools/centreon-2.1.8/www/install/createNDODB.sql '