0

Tips & Tricks : SugarCRM CRASH error after installation

-

When tried to access SugarCRM 6.5.13 after installation following error showed up in browser:

CRASH: PHP segmentation violation in session_start() called at [/install.php:486]

To fix that issue .htaccess file has to be created in SugarCRM main older with following content:

(more…)

0

Tips & Tricks : Microsoft SQL Server 2008 & 2012 Feature Packs

-

Some of applications require additional SQL Server 2008 or 2012 fetures installed. Some of these features might not be available in standard setup of SQL Server. In that case you have to refer to Microsoft Dowloads web page in order to download additional components required for installation:

0

Apps : Cisco7PCF for Android

-

Just released small app for Android platform. This app allows to decrypt type 7 password from Cisco devices as well as passwords from Cisco VPN profiles (PCF files).

Password which can be recovered using this app:

  • wireless keys fro Cisco access points,
  • RADIUS/TACACS shared secrets
  • NTP authentication keys
  • Enable passwords (NOT enable secrets, which are stored using MD5)
  • enc_GroupPwd – VPN group password from PCF file
  • enc_UserPassword – VPN user password from PCF file

You can find app in Google Play:

en_app_rgb_wo_60

0

Code snippets : SQL : Backup and FTP Database

-

When browsing repository of all scripts I did use in past, I found one which might be interesting. What this script does is:

  • Backups database to disk (name of database stored in @dbname, patch for backup stored in @archive_path, name of backup fine stored in @fname)
  • Compresses database backup using WinRAR (full command where to find WinRAR and how ot use it stored in @archive_cmd)
  • Generates set of commands for FTP client (series of xp_cmdshell commands redirecting output to F:\Backup\ftpcmds)
  • Uploads compressed backup to FTP server using command prompt FTP client command

I had that as small procedure executed automatically with SQL Server Agent. Script is for Microsoft SQL Server and I was running it on SQL Server 2000 and 2005. Here is code for that small procedure:

 

DECLARE @fname varchar(255)
DECLARE @fname_backup varchar(255)
DECLARE @fname_archive varchar(255)
DECLARE @archive_path varchar(255)
DECLARE @dbname varchar(255)
DECLARE @archive_cmd varchar(255)
DECLARE @put_cmd varchar(255)

SET @dbname = 'dbApplication'
SET @fname = @dbname + '_' + LTRIM(STR(DAY(GETDATE())))  + '.' + LTRIM(STR(MONTH(GETDATE()))) + '.' + LTRIM(STR(YEAR(GETDATE())))
SET @archive_path = 'F:\Backup\'
SET @fname_backup = @archive_path + @fname + '.BAK'
SET @fname_archive = @archive_path + @fname + '.RAR'
SET @archive_cmd = '"C:\Program Files\WinRAR\WinRAR.EXE" a ' + @fname_archive + ' ' + @fname_backup
SET @put_cmd = 'echo put ' + @fname_archive + '>> F:\Backup\ftpcmds'

PRINT @fname_backup
PRINT @fname_archive

BACKUP DATABASE @dbname TO DISK = @fname_backup WITH INIT

EXEC xp_cmdshell @archive_cmd
EXEC xp_cmdshell 'echo open 192.168.10.101> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'echo user dbupload>> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'echo password123>> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'echo cd DB_Backup>> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'echo bin>> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'echo ha>> F:\Backup\ftpcmds'
EXEC xp_cmdshell @put_cmd
EXEC xp_cmdshell 'echo bye>> F:\Backup\ftpcmds'
EXEC xp_cmdshell 'ftp -d -i -n -s:F:\BACKUP\ftpcmds'

I hope that will be handy for someone to automate databsae backups and transfers.

0

How-to : Create Zend Framework 1.x based project with home.pl as hosting platform

-

I’m using home.pl to host some of my projects. Also, this is test platform for some of the application I work on. At some point I started using Zend Framework and when tried to use home.pl to host Zend Framework-based project went into bit of trouble. By default there is no shell access, so no way to manipulate httpd settings.

After few emails with Technical Support from home.pl I received step-by-step instructions from them on how to create Zend Framework-based project and make it run correctly, so I thought it is worth to share.

(more…)

5

How-to : Access BlackBerry PlayBook via SSH

-

So, I was wondering how to access my PlayBook using SSH. It would be really convinient to access it from laptop, browse files, etc. I did poke around on Internet and finally identified solution how to SSH to PlayBook 🙂 For now only as a normal user and working towards getting root access (I guess Dingleberry will be helpful at some stage) 🙂

For now let’s have a look into details of accessing PlayBook via SSH. for that I will use:

  • BlackBerry Tablet SDK 2.0.0 – available for free on BlackBerry web page here. There might be newer version available by now.
  • PuTTY – I guess most popular free terminal emulator for SSH, Telnet and Serial connections, available here. From that package PuTTY.exe and PuTTYgen.exe will be required.

(more…)