Hi all,
I am running this script on Mandrakelinux release 10.1, 2.6.8.1-12mdksmp #1 SMP
I have also installed 'expect' separately.
I have created an Rsync script, but before any Rsync command does run, a MySql dump must be done first, and I am battling a bit to pass the MySql password from... (2 Replies)
I'm trying to export a mysql query to a .csv file, right now I'm running a successful query like:
us_id=`mysql -u $USER_NAME --password=$PASSWORD -D "databasename" \
-e "SELECT * \
FROM databasename.table \
WHERE somefield >0 AND otherfield ='$ctry' \
ORDER BY... (1 Reply)
Ok the issue I have is a bit complicated, for me, and my understanding of shell programming and bash is non-existent.
Background: I do web development for a team of programmers that make custom kernels for the Android OS. The guys are using a bash script (through gerrit or github, like I said... (4 Replies)
Can someone tell me the syntax to run a shell script from within MySQL? I know there is a way to do it, but I can't remember the syntax. I thought it was something like:
mysql> \. /user/myscript;
but I get this error:
Failed to open file '/user/myscript;', error: 2
Please help!... (4 Replies)
Hi,
I'm having problems with a script which some of you helped me with last week. It's a script to check the status of orders in an SQL database, and if the count(*) is zero, then the script stops. If it's non-zero, the script echos the result to a file and then in cron, I cat the file and mail... (3 Replies)
Hello!
I've got script to write. It should read databases (names, volumes) from table testdatabase and compares it to actually existing databases in /var/lib/mysql/. If there is no informations about database in table - we should see information "There is no declared informations about database... (1 Reply)
Hi,this doesnt give any output
mysql -uroot -phruti2 -B -e "use WebNmsDB;select HEADERINDEX from meas_headers where CLLI= '$clli' and IVALSTART>'$ivalstart' and IVALSTART<'$ivalend' and RPTTYPE='$rpttype';" > asdf.txt
This generates "good" output
mysql -uroot -phruti2 -B -e "use... (1 Reply)
1. bash
-bash escape rules, esp. ',",
-how to use Ctrl+R reverse cmd search with regex?
2. mysql
-how to use grep in mysql
3. php
-why !0 is not evaluated to true? what's its value
-php getopt: what if there is duplicate in cmdline args (2 Replies)
I think(hope) I've got a simple one - I just need to send an email if a mysql query returns any results (ideally - it will never match).
Currently I just pipe the mysql query output to the mail program, but of course that emails regardless of the output( and I check this every 10 minutes from... (5 Replies)
Hi,
Below is my code to execute mysql statement , how to save the output to a file ?
#!/usr/bin/bash
#Script to run automated sql queries
#Declaring mysql DB connection
MASTER_DB_USER='root'
MASTER_DB_PASSWD='root'
MASTER_DB_PORT=3306
MASTER_DB_HOST='localhost'... (1 Reply)
Discussion started by: Pratik4891
1 Replies
LEARN ABOUT SUSE
mail::spamassassin::sqlbasedaddrlist
Mail::SpamAssassin::SQLBasedAddrList(3) User Contributed Perl Documentation Mail::SpamAssassin::SQLBasedAddrList(3)NAME
Mail::SpamAssassin::SQLBasedAddrList - SpamAssassin SQL Based Auto Whitelist
SYNOPSIS
my $factory = Mail::SpamAssassin::SQLBasedAddrList->new()
$spamtest->set_persistent_addr_list_factory ($factory);
... call into SpamAssassin classes...
SpamAssassin will call:
my $addrlist = $factory->new_checker($spamtest);
$entry = $addrlist->get_addr_entry ($addr, $origip);
...
DESCRIPTION
A SQL based persistent address list implementation.
See "Mail::SpamAssassin::PersistentAddrList" for more information.
Uses DBI::DBD module access to your favorite database (tested with MySQL, SQLite and PostgreSQL) to store user auto-whitelists.
The default table structure looks like this: CREATE TABLE awl (
username varchar(100) NOT NULL default '',
email varchar(255) NOT NULL default '',
ip varchar(16) NOT NULL default '',
count int(11) NOT NULL default '0',
totscore float NOT NULL default '0',
signedby varchar(255) NOT NULL default '',
PRIMARY KEY (username,email,signedby,ip) ) TYPE=MyISAM;
Your table definition may change depending on which database driver you choose. There is a config option to override the table name.
This module introduces several new config variables:
user_awl_dsn
user_awl_sql_username
user_awl_sql_password
user_awl_sql_table
user_awl_sql_override_username
see "Mail::SpamAssassin::Conf" for more information.
new
public class (Mail::SpamAssassin::SQLBasedAddrList) new ()
Description: This method creates a new instance of the SQLBasedAddrList factory and calls the parent's (PersistentAddrList) new method.
new_checker
public instance (Mail::SpamAssassin::SQLBasedAddrList) new_checker (\% $main)
Description: This method is called to setup a new checker interface and return a blessed copy of itself. Here is where we setup the SQL
database connection based on the config values.
get_addr_entry
public instance (\%) get_addr_entry (String $addr, String $signedby)
Description: This method takes a given $addr and splits it between the email address component and the ip component and performs a lookup
in the database. If nothing is found in the database then a blank entry hash is created and returned, otherwise an entry containing the
found information is returned. If a with_awl_signer configuration option is enabled only addresses signed by the given signing identity
are taken into account, or, if $signedby is undefined (or empty) only unsigned entries are considered.
A key, "exists_p", is set to 1 if an entry already exists in the database, otherwise it is set to 0.
add_score
public instance (\%) add_score (\% $entry, Integer $score)
Description: This method adds a given $score to a given $entry. If the entry was marked as not existing in the database then an entry will
be inserted, otherwise a simple update will be performed.
NOTE: This code uses a self referential SQL call (ie set foo = foo + 1) which is supported by most modern database backends, but not
everything calling itself a SQL database.
remove_entry
public instance () remove_entry (\% $entry)
Description: This method removes a given $entry from the database. If the ip portion of the entry address is equal to "none" then remove
any perl-IP entries for this address as well.
finish
public instance () finish ()
Description: This method provides the necessary cleanup for the address list.
_unpack_addr
private instance (String, String) _unpack_addr(string $addr)
Description: This method splits an autowhitelist address into it's two components, email and ip address.
perl v5.12.1 2010-03-16 Mail::SpamAssassin::SQLBasedAddrList(3)