Wednesday, November 12, 2008

Granting Access to database from remote IP


View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

* Login as root to mysql server .

Your shell prompt should now look like this:
mysql>

* Run the command:

GRANT ALL PRIVILEGES ON DATABASENAME.* TO USERNAME@IP IDENTIFIED BY 'PASSWORD';


USERNAME is the username that you would like to create. IP is the public IP address of your remote connection. PASSWORD is the password you would like to use for this username.


For example:

To grant access to database 'testdb' for the user 'alpha' identified by password 'changeme' from remoteip 62.54.10.20

GRANT ALL ON testdb.* TO alpha@'62.54.10.20' IDENTIFIED BY 'changeme';

* You now must flush MySQL's privileges

FLUSH PRIVILEGES;

* Run this command to exit MySQL

exit;

To allow remote Access to particular table in the database

GRANT ALL PRIVILEGES ON DATABASENAME.TABLENAME TO USERNAME@IP IDENTIFIED BY 'PASSWORD';

For example: To grant access to a table t1 in database alpha for the user testdb identified by password changeme from remoteip 62.54.10.20

GRANT ALL ON testdb.t1 TO alpha@'62.54.10.20' IDENTIFIED BY 'changeme';


GRANT ALL PRIVILEGES ON valija_registro.* TO valija_gi2@63.246.5.127 IDENTIFIED BY 'gitanava';

http://santhoshg.co.cc/forum/viewtopic.php?f=7&t=496&sid=6adebb0fcd24f7292047cb091f31cf94

Creating or Importing a Database

Ref : http://santhoshg.co.cc/forum/viewtopic.php?f=7&t=496&sid=6adebb0fcd24f7292047cb091f31cf94

Creating or Importing a Database

View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

To create a new database on a hosting account:

1. Click the Domains shortcut in the navigation pane.
2. Click the required domain name in the list.
3. Click Databases.
4. Click Add New Database.
5. Enter a name for the database.

We recommend that you choose a name that starts with a Latin alphabet symbol
and comprises only alphanumeric and underscore symbols (up to 64 symbols).
6. Select the database type that you are going to use: MySQL or PostgreSQL.
Click OK.
7. To set up database administrator's credentials, click Add New Database
User.
8. Type a user name and a password that will be used for accessing the
contents of the database.
9. Click OK.

To import an existing database:

1. Click the Domains shortcut in the navigation pane.
2. Click the required domain name in the list.
3. Click Databases.
4. Click Add New Database.
5. Enter a name for the database. We recommend that you choose a name that
starts with a Latin alphabet symbol and comprises only alphanumeric and
underscore symbols (up to 64 symbols).
6. Select the database type that you are going to use: MySQL or PostgreSQL.
Click OK.
7. To set up database administrator's credentials, click Add New Database
User.
8. Type a user name and a password that will be used for accessing the
contents of the database. Click OK.
9. Click the btn configure odbc DB WebAdmin icon in the Tools group. An
interface to phpMyAdmin (or phpPgAdmin) database management tool will open in
a separate browser window.
10. Click on the Query window icon in the left frame.
11. Click the Import files tab.
12. Select the text file that contains the data and click Go.
13. Click the Insert data from a text file link.

To manage your databases and their contents, use your favorite MySQL or
PostgreSQL client or the web based database management tool accessible from
Plesk control panel (Domains > domain name > Databases > Database name > DB
WebAdmin).
View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

Ref : http://santhoshg.co.cc/forum/viewtopic.php?f=7&t=496&sid=6adebb0fcd24f7292047cb091f31cf94

Useful Exim commands

Useful Exim commands

These are some useful Exim commands

--------> REMOVE MAILS BY ID -------->
# /usr/sbin/exim -v -Mrm (MAIL ID HERE)

--------> LIST QUEDED MAILS -------->
# /usr/sbin/exim -bp

--------> OUTPUT NUMBER OF QUEDED MAILS -------->
# /usr/sbin/exim -bpc

--------> DELETE FROZEN MAILS -------->
# /usr/sbin/exim -bp | awk '$6~"frozen" { print $3 }' | xargs exim -Mrm

--------> DELIVER FORCEFULLY EMAILS -------->
# /usr/sbin/exim -qff -v -C /etc/exim.conf &

--------> FREEZE MAILS FROM SENDER -------->
# /usr/sbin/exiqgrep -i -f (MAIL ADDRESS HERE) | xargs exim -Mf

--------> REMOVE MAILS FROM SENDER -------->
# /usr/sbin/exiqgrep -i -f (MAIL ADDRESS HERE) | xargs exim -Mrm


Ref : http://sysadmingear.blogspot.com/search/label/exim

Repairing Mysql database

View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

Repairing Mysql database
0
Written on July 16, 2007 by admin

cd /var/lib/mysql/DBNAME
if mysql data directory is /var/lib/mysql

myisamchk *.MYI
or
myisamchk -r db.MYI
or
myisamchk -r –safe *.MYI

View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

Webserver Administrators Blog

Basic information
-----------------------------

Print a count of the messages in the queue:

root@localhost# exim -bpc

Print a listing of the messages in the queue (time queued, size, message-id, sender, recipient):

root@localhost# exim -bp

Print a summary of messages in the queue (count, volume, oldest, newest, domain, and totals):

root@localhost# exim -bp | exiqsumm

Print what Exim is doing right now:

root@localhost# exiwhat

Test how exim will route a given address:

root@localhost# exim -bt alias@localdomain.com
user@thishost.com
<-- alias@localdomain.com
router = localuser, transport = local_delivery
root@localhost# exim -bt user@thishost.com
user@thishost.com
router = localuser, transport = local_delivery
root@localhost# exim -bt user@remotehost.com
router = lookuphost, transport = remote_smtp
host mail.remotehost.com [1.2.3.4] MX=0

Run a pretend SMTP transaction from the command line, as if it were coming from the given IP address. This will display Exim's checks, ACLs, and filters as they are applied. The message will NOT actually be delivered.

root@localhost# exim -bh 192.168.11.22

Display all of Exim's configuration settings:

root@localhost# exim -bP

Searching the queue with exiqgrep

Exim includes a utility that is quite nice for grepping through the queue, called exiqgrep. Learn it. Know it. Live it. If you're not using this, and if you're not familiar with the various flags it uses, you're probably doing things the hard way, like piping `exim -bp` into awk, grep, cut, or `wc -l`. Don't make life harder than it already is.

First, various flags that control what messages are matched. These can be combined to come up with a very particular search.

Use -f to search the queue for messages from a specific sender:

root@localhost# exiqgrep -f [luser]@domain

Use -r to search the queue for messages for a specific recipient/domain:

root@localhost# exiqgrep -r [luser]@domain

Use -o to print messages older than the specified number of seconds. For example, messages older than 1 day:

root@localhost# exiqgrep -o 86400 [...]

Use -y to print messages that are younger than the specified number of seconds. For example, messages less than an hour old:

root@localhost# exiqgrep -y 3600 [...]

Use -s to match the size of a message with a regex. For example, 700-799 bytes:

root@localhost# exiqgrep -s '^7..$' [...]

Use -z to match only frozen messages, or -x to match only unfrozen messages.

There are also a few flags that control the display of the output.

Use -i to print just the message-id as a result of one of the above two searches:

root@localhost# exiqgrep -i [ -r | -f ] ...

Use -c to print a count of messages matching one of the above searches:

root@localhost# exiqgrep -c ...

Print just the message-id of the entire queue:

root@localhost# exiqgrep -i

Managing the queue

The main exim binary (/usr/sbin/exim) is used with various flags to make things happen to messages in the queue. Most of these require one or more message-IDs to be specified in the command line, which is where `exiqgrep -i` as described above really comes in handy.

Start a queue run:

root@localhost# exim -q -v

Start a queue run for just local deliveries:

root@localhost# exim -ql -v

Remove a message from the queue:

root@localhost# exim -Mrm [ ... ]

Freeze a message:

root@localhost# exim -Mf [ ... ]

Thaw a message:

root@localhost# exim -Mt [ ... ]

Deliver a message, whether it's frozen or not, whether the retry time has been reached or not:

root@localhost# exim -M [ ... ]

Deliver a message, but only if the retry time has been reached:

root@localhost# exim -Mc [ ... ]

Force a message to fail and bounce as "cancelled by administrator":

root@localhost# exim -Mg [ ... ]

Remove all frozen messages:

root@localhost# exiqgrep -z -i | xargs exim -Mrm

Remove all messages older than five days (86400 * 5 = 432000 seconds):

root@localhost# exiqgrep -o 432000 -i | xargs exim -Mrm

Freeze all queued mail from a given sender:

root@localhost# exiqgrep -i -f luser@example.tld | xargs exim -Mf

View a message's headers:

root@localhost# exim -Mvh

View a message's body:

root@localhost# exim -Mvb

View a message's logs:

root@localhost# exim -Mvl

Add a recipient to a message:

root@localhost# exim -Mar
[
... ]

Edit the sender of a message:

root@localhost# exim -Mes

View more similar posts...visit my personal site http://santhoshg.co.cc Also visit my forum http://santhoshg.co.cc/forum

Ref : http://bradthemad.org/tech/notes/exim_cheatsheet.php