PHP连接MySQL数据库时expect,expect实用示例

港控/mmm° 2023-01-17 15:49 209阅读 0赞

1. 自动登录开发环境服务器

\#!/usr/bin/expect

set timeout 30

\#获取输入的第一个参数，赋值给变量docker\_which

set docker\_which \[lindex $argv 0\]

\#如果docker\_which无值，则默认值设置为0

if \{"$docker\_which"==""\} \{

set docker\_which 0

\#登录149

spawn sudo ssh -p 8044 yhm@123.56.71.70

expect "\*password\*"

send "phpernote.com\\r"

expect "\*login:\*"

\#切换账号

send "su b\\r"

expect "\*密码\*"

send "b\\r"

\#进入docker

send "ssh docker\\r"

expect "login:"

\#进入docker c环境

send ". gotoc $docker\_which\\r"

expect "\*root@\*"

\#进入数据库环境

send "db\\r"

expect "\*mysql>\*"

send "show databases;\\r"

expect "\*rows in set\*"

send "use phparticle\_db;\\r"

interact

2. 查看日志

\#!/usr/bin/expect

set timeout 30

set date \[ clock format \[ clock seconds \] -format "%Y-%m-%d" \]

set env\_which \[lindex $argv 0\]

set file\_dir /data/t/xnw/laravel/storage/logs/

if \{"$env\_which"==""\} \{

set env\_which local

set file \[lindex $argv 1\]

if \{"$file"==""\} \{

\#set file "$file\_dir"laravel-$date.log

set file /data/t/xnw/laravel/storage/logs/laravel-$date.log

switch -- $env\_which \{

local \{

spawn gotoc

expect "\*oot@\*"

xdev0 \{

spawn sudo ssh -p 8044 yhm@192.168.2.149

expect "\*password\*"

send "xnw.com\\r"

expect "\*login:\*"

send "su b\\r"

expect "\*密码\*"

send "b\\r"

send "ssh docker\\r"

expect "login:"

send ". gotoc 0\\r"

expect "\*root@\*"

demo0 \{

spawn sudo ssh -p 8044 yhm@192.168.2.149

expect "\*password\*"

send "xnw.com\\r"

expect "\*login:\*"

send "su b\\r"

expect "\*密码\*"

send "b\\r"

send "ssh demo\\r"

expect "login:"

send ". gotoc 0\\r"

expect "\*root@\*"

send "tail -f $file\\r"

interact

3. 自动打开今天的日志

\#!/usr/bin/expect

set timeout 30

set date \[ clock format \[ clock seconds \] -format "%Y-%m-%d" \]

spawn sudo ssh -p 8044 yhm@192.168.2.149

expect "\*password\*"

send "xxx.com\\r"

expect "\*login:\*"

send "su b\\r"

expect "\*密码\*"

send "b\\r"

send "ssh w167\\r"

expect "uploader@"

send "cd /data/t/xnw\\r"

expect "uploader@"

send "tail -f laravel/storage/logs/laravel-$date.log\\r"

interact

4. 自动登录到服务器的docker环境 (2020年09月27日09:56:53 更新)

\#!/usr/bin/expect

set timeout 30

set docker\_which \[lindex $argv 0\]

if \{"$docker\_which"==""\} \{

set docker\_which 0

set date \[ clock format \[ clock seconds \] -format "%Y-%m-%d" \]

spawn sudo ssh -p 8044 yhm@192.168.2.149

expect "\*password\*"

send "xnw.com\\r"

expect "\*login:\*"

send "su b\\r"

expect "\*密码\*"

send "b\\r"

send "ssh docker\\r"

expect "login:"

send ". gotoc $docker\_which\\r"

expect "\*root@\*"

send "cd /data/t/xnw/laravel\\r"

expect "\*root@\*"

send "tail -f storage/logs/laravel-$date.log\\r"

interact

PHP连接MySQL数据库时expect,expect实用示例

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 php 7连接mysql数据库

相关 PHP连接数据库时出错

相关 PHP连接MySQL数据库时expect,expect实用示例

相关 php连接mysql数据库实例_PHP连接MYSQL数据库实例

相关 php mysql访问数据库服务器_PHP MySQL：连接MySQL数据库

相关 php和nodejs连接mysql数据库_Nodejs如何连接mysql数据库？

相关 PHP连接mysql数据库

相关 PHP与MySql数据库连接

相关简单实用的php连接mysql封装类

相关 php 数据库连接