I am a newbie to perl so please forgive. My question. Can Net::ssh:expect be used to read from a local database(using DBI)for password and userid information. For exmaple Mysql. I am trying to set something up where the userid and password are taken from a local mysql database based on if they are active(ie flag) customer. If so. Read from the local database that contains login infromation and then establish a remote connection to another server.
Well after some painful research and trial and error. I have my code reading from a mysql database instead of hard coding the password(s) in the code. I can connect just fine and run commands. Now the problem I am facing is trying to start a SFTP command on the remote machine and ftping a file back to my localhost. Can this be done within Net::ssh:expect or do I have to use something outside of Net:ssh:expect like Net:scp or Net:sftp.