Sunday, October 4th, 2009
Login to mysql and :
use psa;
SELECT accounts.id, mail.mail_name, accounts.password, domains.name FROM domains LEFT JOIN mail ON domains.id = mail.dom_id LEFT JOIN accounts ON mail.account_id = accounts.id
It should print all emails that are created and their passwords.
Tags: account, email, password, plesk
Posted in Tips & Tricks | No Comments »
Thursday, October 1st, 2009
rpm -qa –queryformat ‘%{SIZE} %{NAME} %{VENDOR}\n’ | sort -n -r | head -10
Check :rpm –querytags for all the tags
Tags: head, name, querytags, rpm, size, sort, vendor
Posted in Centos, Fedora, Linux, Redhat, Tips & Tricks | No Comments »
Wednesday, August 19th, 2009
To perform the update, either follow the instructions from the Administration Control Panel->System Tab – this should point out that you are running an outdated version and will guide you through the update – or follow the instructions listed below.
Go to the downloads page and download the latest update package listed there, matching your current version.
Upload the archives contents to your phpBB installation – only the install folder is required. Upload the whole install folder, retaining the file structure.
After the install folder is present, phpBB3 will go offline automatically.
Point your browser to the install directory, for example http://www.example.com/phpBB3/install/
Choose the “Update” Tab and follow the instructions
Tags: 3.0.5, install, phpbb, update 3.0.4
Posted in Tips & Tricks | No Comments »
Thursday, July 30th, 2009
Login with your mysql client and issue either one of these:
UPDATE `jos_users` SET `password` =MD5(“getsmart”) WHERE usertype = “Super Administrator”;
or
UPDATE `jos_users` SET `password` =MD5(“getsmart”) WHERE usertype = “Administrator”;
Tags: change, joomla, md5, mysql, password, update, where
Posted in Tips & Tricks | No Comments »
Thursday, July 30th, 2009
Site->Global Configuration-> Go to Search Engine Friendly URLs and select and Use Apache mod_rewrite. Select both to “YES”.
Then on your hosting server copy htaccess.txt to .htaccess. Now you should have urls like : http://site.com/contact
Tags: .htaccess, joomla, mod_rewrite, seo
Posted in Tips & Tricks | No Comments »
Thursday, July 30th, 2009
Got this error while I was trying to configure Joomla to work with suPHP. This is the config I`m using to make it work:
ServerAdmin aa@aa.com
ServerName www.site.org
ServerAlias site.org
DocumentRoot /home/virtuals/www.site.org/public_html/
ErrorLog /home/virtuals/www.site.org/logs/error.log
CustomLog /home/virtuals/www.site.org/logs/access.log combined
ServerSignature On
php_admin_flag safe_mode Off
php_admin_flag register_globals On
php_admin_value open_basedir /home/virtuals/www.site.org/public_html:/tmp
AllowOverride All
Allow from All
Options Indexes FollowSymLinks
php_admin_flag engine on
suPHP_Engine on
AddHandler php5-script .php
php_admin_flag engine on
Tags: joomla, premature, script, script headers, suphp
Posted in Tips & Tricks | No Comments »
Thursday, July 30th, 2009
Got this error :
Database Error: Unable to connect to the database:The MySQL adapter “mysql” is not available.
There are some reasons why this occurs:
- php-mysql not installed
- php admin flags wrong set
- wrong suphp configuration, handlers should be:
[handlers]
;Handler for php-scripts
x-httpd-php=”php:/usr/bin/php”
;Handler for CGI-scripts
x-suphp-cgi=”execute:!self”
Tags: mysql, suphp
Posted in Tips & Tricks | 1 Comment »
Thursday, July 30th, 2009
Got this error these days :
[Thu Jul 30 06:58:16 2009] [warn] Script “/home/virtuals/www.site.org/public_html/index.php” resolving to “/home/virtuals/www.site.org/public_html/index.php” not within configured docroot
add docroot into your suphp.conf file and restart apache
Tags: docroot, suphp
Posted in Tips & Tricks | No Comments »
Saturday, July 11th, 2009
export LINES=57; export COLUMNS=157; resize
eval $(tset -s xterm; resize; alias ll=”ls -Al”)
ps -e -ww -o user,pid,ppid,pcpu,pmem,size:7=Swap,lstart,args=Command –sort=-rss
Tags: bash
Posted in Tips & Tricks | No Comments »
Saturday, July 11th, 2009
qmail-qread – list outgoing messages and recipients
[root@server ~]# /var/qmail/bin/qmail-qread | grep remote | awk -F\@ ‘{print $2}’ |sort | uniq | sort -n
aol.com
bigpond.net.au
comcast.net
gmail.com
hotmail.com
msn.com
nc.rr.com
yahoo.com
yahoo.co.uk
qmHandle – qmail Handler
[root@server ~]# qmHandle -s
Total messages: 225
Messages with local recipients: 0
Messages with remote recipients: 225
Messages with bounces: 0
Messages in preprocess: 0
qmHandle -l list all emails in queue
qmHandle -mN show email no N from queue
qmHandle -dN delete email no N from queue
qmHandle -R show remote emails from queue
qmHandle -D delete all messages from queue
qmHandle -a try to send messages from queue
[root@server ~]# /var/qmail/bin/qmail-qstat
messages in queue: 224
messages in queue but not yet preprocessed: 0
Tags: awk, qmail, qmail-qread, qmHandle
Posted in Tips & Tricks | No Comments »