PHP NET_SSH Read and Write not working as intended

Question

I'm trying to connect to a mysql database through an SSH connection using NET_SSH. I'm using the interactive shell with read and write.

My code looks like this:

echo '<pre>';
        $ssh -> setTimeout(10);
        echo $ssh -> read('');

        $ssh -> write('ls');
        echo $ssh -> read('');
        echo '<br />';

        $string = 'mysql -u '. $database -> database_user . ' -h ' . $database -> datbase_host . ' --password=' . $database -> database_password . ' ' . $database -> database_name. '; show databases;';
        $ssh -> write($string);
        echo $ssh -> read('mysql>');
        echo '<br />';

        $this -> write('show databases;');

        echo $ssh -> read('');
        echo '<br />';

But my output looks like this:

    lsubuntu@ip-xxxxxx:~$ ls
    Last login: Fri Dec 28 16:08:39 2012 from ool3.dyn.optonline.net

    mysql -u db_user -h xxx.us-east-1.rds.amazonaws.com --password=abc123 my_database; show databases;ubuntu@ip-xxxxxx:~$ mysql -u db_user -h xxx.rds.amazonaws.com --password=abc123 my_database; show databases;
    Last login: Fri Dec 28 16:08:49 2012 from ool3.dyn.optonline.net

show databases;ubuntu@ip-10-151-4-222:~$ show databases;

My question is, why is not being interactive like I thought it would? I should say the expected results was a mysql connection or at least a mysql prompt. But I just get that. Am I doing something wrong?

neubert · Accepted Answer · 2012-12-29 20:49:40Z

1

Honestly, I would totally rewrite that. eg.

echo '<pre>';
        echo $ssh -> read('[prompt]');

        $ssh -> write("ls\n");
        echo $ssh -> read('[prompt]');
        echo '<br />';

        $string = 'mysql -u '. $database -> database_user . ' -h ' . $database -> datbase_host . ' --password=' . $database -> database_password . ' ' . $database -> database_name. '; show databases;';
        $ssh -> write("$string\n");
        echo $ssh -> read('mysql>');
        echo '<br />';

        $this -> write("show databases;\n");

        echo $ssh -> read('mysql>');
        echo '<br />';

Only time I'd ever use read('') is to figure out what the prompt is.

Also, note how I'm ending every write request with a \n. Linux isn't some AJAXified server. You don't just type the command and expect it to be ran. You have to hit enter.

I mean, sometimes you can hit keys and they'll just do things without enter being pressed. Like in some situations in vi. You're in normal mode (as opposed to insert mode) and you hit dd on some open text file and the whole line you're on gets deleted even though you didn't hit enter.

edited Dec 29, 2012 at 20:49

answered Dec 29, 2012 at 6:44

neubert

17k28 gold badges140 silver badges262 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Devin Dixon Over a year ago

Same result with the prompt

neubert Over a year ago

I updated my post. Long story short... add \n to the end of all your write() calls.

Collectives™ on Stack Overflow

PHP NET_SSH Read and Write not working as intended

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related