Categories
Blackberry

Blackberry BES Express database woes

When installing BES Express, I found that myself and a lot of others trying to install on SBS2003 we encountering a lot of problems with the Database Connection section. Kept seeing the following error in the installation log :

After trying many various methods, I came accross the following :

ConnectionItem::ConnectToDB: COM Error 0x80004005 - Unspecified error - Source: "Microsoft OLE DB Provider for SQL Server" - Description "[DBNETLIB][ConnectionOpen (Connect()).]Specified SQL server not found." - Command "ConnectionItem::ConnectToDB"

  • Go to Start > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager > SQL Server 2005 Network Configuration.
  • Select the Microsoft SQL server instance that houses the BlackBerry Configuration Database.
  • Right click on Named Pipes and select Enable.
  • Right click on TCP/IP and select Enable.
  • If you enabled a protocol in step c, restart the Microsoft SQL Services.

Worked a treat…

Categories
Linux Plesk

Plesk server – ‘www’ prefix not working

If you didn’t add the ‘www’ prefix at the time of setting up the domain, even adding it back in later doesn’t seem to work. This fault seems to be present within all current versions of Plesk up to my current version v9.2

To work around this problem, firstly – turn on the ‘www’ prefix again within the Plesk control panel.

Domains > yourdomain.com > Modify > WWW Prefix – Tick this box

The www prefix will still not work… to correct this, we need to re-build the Apache config after turning it back on:

/usr/local/psa/admin/sbin/websrvmng -v -a
Categories
Linux Plesk

Lookup client passwords on Plesk

1. Connect to the Plesk Database

mysql -u admin -p`cat /etc/psa/.psa.shadow`
use psa

2. Select one of the following commands:

Get all e-mail account passwords:

SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
ORDER BY domains.name ASC,mail.mail_name ASC;

Email account passwords for a specific domain:

SELECT account_id AS �ID�, mail_name AS �USERNAME�, password AS �PASSWORD�, postbox as �MAILBOX?�, name AS �DOMAIN�, redir_addr as REDIRECT 
FROM mail M, domains D, accounts A 
WHERE M.account_id = A.id AND M.dom_id = D.id AND D.name=�****DOMAIN_NAME****�;

Get e-mail account passwords that are made up of only letters:

SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
AND accounts.password RLIKE BINARY '^[a-z]+$'
ORDER BY domains.name ASC,mail.mail_name ASC;

Get e-mail account passwords that are made up of only numbers:

SELECT CONCAT_WS('@',mail.mail_name,domains.name),accounts.password
FROM domains,mail,accounts
WHERE domains.id=mail.dom_id AND accounts.id=mail.account_id
AND accounts.password RLIKE  '^[0-9]+$'
ORDER BY domains.name ASC,mail.mail_name ASC;

Find domains that are using catch-all accounts:

SELECT d.name AS domains, p.value AS catchall_address
FROM Parameters p, DomainServices ds, domains d
WHERE d.id = ds.dom_id AND ds.parameters_id = p.id AND p.parameter = 'catch_addr'
ORDER BY d.name;

Lookup FTP credentials:

SELECT account_id AS �ID�, login AS �USERNAME�, password AS �PASSWORD�, home AS �HOMEDIR� 
FROM sys_users S, accounts A 
WHERE S.account_id = A.id;
Categories
Linux

Denyhosts – Blocking your own IP

Stop the Denyhosts service

/etc/init.d/denyhosts stop

Remove your IP from the log file

vi /etc/hosts.deny

(Look for your IP then “dd” on the line to remove it, then “ZZ” to save and exit)

Check to see if your IP is in any other files

grep "82.68.113.238" /var/lib/denyhosts/*

Start the Denyhosts service again

/etc/init.d/denyhosts start

Adapted from the following post : DenyHosts: Remove / Delete an IP address