вторник, 3 декабря 2013 г.

How to install asp.net mvc3 after mvc4 installation

I have Visual Studio 2010, Service Pack1 and MVC4 installed and worked perfectly.
I want to build my old MVC3 project. But AspNetMVC3ToolsUpdateSetup.exe is failed to setup.

Solution:
extract and install only this packages from AspNetMVC3ToolsUpdateSetup
aspnetmvc3.msi
aspnetwebpages.msi
aspnetmvc3vs2010tools.msi
aspnetwebpagesvs2010tools.msi

is taken from here

вторник, 3 сентября 2013 г.

Howto repair mssql databasse.

ALTER DATABASE [dbname] SET EMERGENCY
ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
DBCC CHECKCONSTRAINTS
DBCC CHECKDB([dbname], REPAIR_ALLOW_DATA_LOSS)
ALTER DATABASE [dbname] SET MULTI_USER

суббота, 13 июля 2013 г.

install mysql on raspberry pi and connect from laptop

$ sudo apt-get update
$ sudo apt-get install apache2 php5 mysql-server
$ sudo apt-get install phpmyadmin

to enable remote connection replace 127.0.0.1 in /etc/mysql/my.conf to real ip

the working application is at http://your_rpi_host/phpmyadmin
or download any application and look at db from it

to add user
$ mysql -u root -p mysql
mysql> GRANT ALL PRIVILEGES ON *.* TO  'dbuser'@'%'  IDENTIFIED  BY  'dbpassword';
mysql> FLUSH PRIVILEGES;

mysql> CREATE DATABASE foo;
mysql> GRANT ALL ON foo.* TO 'foouser'@'%' IDENTIFIED BY 'PASSWORD';

вторник, 11 июня 2013 г.

GoogleReader replacement with RaspberryPi + rss2email + cron + GMail


1. Install rss2email
sudo apt-get install rss2email

2. Configure rss2email
#It stores things in ~/.rss2email
r2e new email-example@gmail.com
cat <<EOF >~/.rss2email/config.py
HTML_MAIL = 1
DATE_HEADER = 1
DEFAULT_FROM = "email-example@gmail.com"
FORCE_FROM = 1
SMTP_SERVER=  "smtp.gmail.com"
AUTHREQUIRED=1
SMTP_SEND = 1
SMTP_USER = "email-example@gmail.com"
SMTP_PASS = 123456
SMTP_SSL = 1
TRUST_GUID=1
EOF

3. Import subscriptions
Use Google Takeaway to get a copy of your Reader subscription data.

#import to rss2email
r2e opmlimport subsciptions.xml
#get list of subsciptions
r2e list

4. Fetch data
#fetch rss data but don't send. we are already had read them
r2e run --no-send
#some time later fetch to get new ones
r2e run

5. Automate
#the better way is to use cron to automaticaly fetch each 2 time in hour
sudo crontab -u user1 -e
#add this line and save
*/30 * * * * r2e run

6. Some useful rss2email commands
r2e add http://www.example.com/feed/
r2e opmlexport > subscriptions.xml
r2e list
r2e delete 123

7. In gmail create filters for you feeds.

понедельник, 8 апреля 2013 г.

Compiling kernel 3.4 on debian wheezy

sudo apt-get install kernel-package fakeroot build-essential


mkdir ~/tmp
cd ~/tmp
wget http://www.kernel.org/pub/linux/kernel/v3.0/linux-3.4.tar.bz2
tar xvf linux-3.4.tar.bz2
cd linux-3.4/
cat /boot/config-`uname -r`>.config
make oldconfig

If your current kernel is 3.3.5 the questions that await are given at the bottom of this post with links to descriptions of the different options. As usual, if in doubt, just hit enter.

make-kpkg clean

Building takes ages (depending on number of cores committed), so don't launch it at 4 pm on a Friday if you need to shut down your computer before going home... As usual, use the -jX switch for parallel builds, where X is the number of cores+1 (i.e. 4 cores => -j5)

The following command goes on a single line
time fakeroot make-kpkg -j5 --initrd --revision=3.4.0 --append-to-version=-amd64 kernel_image kernel_headers

Once the build is done, move the .deb files out of the way and to your linux-3.4 directory for safe-keeping
 mv ../*3.4.0*.deb .
sudo dpkg -i *.deb
(c) from here

понедельник, 25 февраля 2013 г.

rpm how-to


List all installed packages
# rpm -qa
How do I uninstall rpm packages?
#rpm -e <package name>
How do I install rpm packages?
#rpm -i <package name>
Examples - extract files from rpm
#rpm2cpio php-5.1.4-1.esp1.x86_64.rpm | cpio -idmv