Hi All,
I need to run the same command on many servers. I am using ssh for the same. Following is the script that I am using to fire the same command on multiple machines.
#!/bin/bash
# Linux/UNIX box with ssh key based login
#SERVERS="iqmevrick,iqmango"
# SSH User name
USR="root"
#... (1 Reply)
Hi,
I want to do automation on UI using shellscript.
eg:
1) Drop down menu contains assign , investigate, closed.
now there is one id want assign it using assign tab then need to investigate it and lastly close. Sometimes the id can't assign to perticular user.
there are so many... (11 Replies)
hi there ,
i want to use the scp to transfer the file from one machine to another machine non-stop. i have put it in a .sh file. but everytime i run it and it prompts me to input password.
pc3@pc3-desktop:~/Documents$ ./sample3.sh
pc-main@192.168.1.117's password:
screenshot.jpg ... (4 Replies)
Hi, I wanted to automate the scp command where i do not want to enter the password each time. So thought of using expect command. Script is executing without any issues but files are not copied to remote server. Can any one help me?
Below is my shell script..
#!/bin/ksh
... (6 Replies)
Im trying to write an automation script using python. I expect this script to log in to a remote server, execute commands and get its output.
import pexpect
child=pexpect.spawn('ssh myuser@192.168.151.80')
child.expect('Password:')
child.sendline('mypassword')
get_output =... (4 Replies)
Hi Gurus,
I have a clearcase script that i use to check in a single file at time on my clearcase server. the script is as follows
setmyview
settask 75098_MSI_TRILOGY_EIM
cd /vobs/Trilogy_R12/custom/msieim/12.0.0/sql/
cleartool co -nc .
ct mkelem -nc Filename_1.sql
cp... (3 Replies)
Frequently we need to stop or start services on Linux systems.
For exmaple : To start or stop vsftpd daemon
# /etc/init.d/vsftpd start
or
# /etc/init.d/vsftpd stop
Following script will check the vsftpd service and if it is running, it will be stopped or vice-versa.
# cat... (5 Replies)
I m passing a variable stringg from Unix shell which has value 'Good Day' to ansible and from ansible to a second shell script where it print only Good instead of 'Good Day'
passing the variable stringg from unix shell script1.sh
echo $stringg
ansible-playbook install.yml -i... (1 Reply)
Hello,
I need ansible playbook to create new user on remote server. Remote server blocked direct root login so I must login first application user and later I must run "useradd" command with sudo.
I need playbook.yml and cli command.
Best regards, (0 Replies)
I have a standalone Oracle Linux server which has no connectivity to the internet.
I was following a blog which directed me to download all ansible dependent setup files and install them using the below command.
# yum localinstall -y python-crypto-2.6.1-1.el7.rf.x86_64.rpm... (7 Replies)
Discussion started by: mohtashims
7 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::mysql
DBIx::SearchBuilder::Handle::mysql(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::mysql(3pm)NAME
DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of MySQL.
METHODS
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
If the insert succeeds, returns the id of the insert, otherwise, returns a Class::ReturnValue object with the error reported.
SimpleUpdateFromSelect
Customization of "SimpleUpdateFromSelect" in DBIx::SearchBuilder::Handle. Mysql doesn't support update with subqueries when those fetch
data from the table that is updated.
DatabaseVersion
Returns the mysql version, trimming off any -foo identifier
CaseSensitive
Returns undef, since mysql's searches are not case sensitive by default
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT Name FROM mysql.time_zone_name;
Read docs about keeping timezone data up to date:
http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::mysql(3pm)