Linux.com

Home Linux Community Community Blogs

Community Blogs



My SPLAT

SPLAT

 
Guess what, I have SPLAT in my notebook, easy to install and easy to use. :)

 

Remote port tunnelling with SSH

Hi there, here's a quick blog about SSH port forwarding, let's describe the scenario with an example, of course port forwarding may be applied to everythin, not only to mysql as reported in the sample

 

Assume you've a remote host with MySQL server installed and running, of course for security reasons you've forbidden TCP connections from every machine except localhost, or at least this is how I usually configure my services. Your Python, PHP, Java apps and even CLI apps are happy with it, they can access mysql backend by connecting to localhost on 3306 port.

For security reasons when you're inside the mysql server you can connect to my by using:
myserver:~$ mysql --host=127.0.0.1 --user= --password=
pretty safe and good, I usually configure MySQL in this way:
myserver:~$ cat /etc/mysql/my.cnf|grep "bind-address"
bind-address = 127.0.0.1

so far, everything is perfect now but if you need to manage your remote db with MySQL Administrator or with your preferred tool how can you connect to this machine ? Easy, let's forward remote 3306 port to local 3306 or other port if needed, then you can connect to localhost and use the SSH tunnel in between. from your local machine:
localmachine:~$ ssh -l -L 3306:localhost:3306
So you open an ssh console to your machine from your localhost, with the connection you ask remote to port forward its 3306 port to your local 3306.
Now try to open your remote db from localhost, so if you use mysql command line utility you need to type:
localmachine:~$ mysql --host=127.0.0.1 --user= --password=
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 254
Server version: 5.0.51a-24 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

And that's it !

Obviously you can even use your favorite admin tool, not only mysql cli

 

Pretty easy and quick

Hope it helps someone

Ben

 

Remote desktop single command execution

On RDP protocol v5 and above you can open a remote windows session and open a single program only instead having the whole desktop up, it sounds like Metaframe but cheaper, I mostly use it from my Linux workstation for opening win programs on the server (business accounting apps or legacy win apps).
You need to have rdesktop installed in your system, each distro has its own names for this package

quick command from your linux desktop:

~$ rdesktop -u -p -d -g 1280x1024 -T "" -k it -s "notepad.exe" &

We're now opening notepad on remote machine and using it on local Linux desktop, I've just setup my resolution to 1280x1024 but of course you can change it to whatever you want

You'll have notepad opened on your desk ,when you close it rdesktop closes it by itself, this applies to windows servers with RDP 5 (example: win 2003 server or above)

 

Comments welcomed

Ben

 

Dual Boot Mac Mini

I was pleasantly surprised that changing a Mac Mini to dual boot Mac OS X and Linux was relatively painless. I more or less followed the instructions here: http://www.rickycampbell.com/ubuntu-easy-install/

I ran the Boot Camp thing in the Utilities folder and allocated the disk half and half.  (I was kind of annoyed that it assumed I was going to install Windows.)

Then I installed the rEFIt boot manager:  http://refit.sourceforge.net/

Finally, I installed Ubuntu 9.04.  The only problem now is that the display comes up in 800 x 600 when I boot into Linux.

 

 

Just„ÄÄstarted Local Drupal Group

Drupalのユーザーになってしまったのですが、残念なことに日本ではDrupalを使っている人が少ない。

I happen to be a Drupal user. But in Japan Drupal is not popular.

日本では商用ではMoovable Type,オープンソースではXoopsが人気のようですね。

In Japan, Moovable type and Xoops is popular.

でDrupalユーザーをネットで探したら、同じ思いをしている人がいてグループを立ち上げました。

And I was looking for a users on the net and found and decide d to have meet up events.

第一回の集まりでは18人のユーザーが、集まりました。

At the first meeting we have 18 users.

今週末は2回目の集まり。前回は時間が足りなかったので今回はちょっと多めになんと8時間。

This weekend is 2nd time gethering, and 8hours.

„Åß„ÇÇÊ•Ω„Åó„Åø„ÄÇ

 http://groups.drupal.org/node/22239

 

 

NEWB's adventures in Linux From Scratch

  Hello again,

   It seems I have the talent for sticking my foot in my mouth. I've just recently been informed that noob stands for : someone who believes they know it all , but in reality know little to nothing at all.  I stand corrected. (I though I said I was a newbie)

   Now that I've apparently found a book that I can understand,  learning is becoming much easier. I'm starting to organize.  Many of the things will save me time like the bash ctrl key functions so I've made a kind of overlay (remember Word Perfect?) that way I'll learn much faster. Seems that there are list and notes everywhere  in this book. There's a lot to learn and I've got to have somewhere easy to recall the most important things. For me that's a real paper notebook. 

 

FFMPEG Cropping and Re-sizing (order matters)

I discovered something whilst trying to crop and re-size a video with FFMPEG: the order of switches actually matters! I couldn't find any mention of this in the documentation, and nowhere could I find an explanation of why my video was being cropped after it was resized. The video I was re-encoding had some fuzziness at the top, and an ugly black border down the right-hand side. I wanted to remove these, but have a fixed output size.

Here's an example. Our input file, input.avi is a 640x480 video.

We run the following 2 commands:

ffmpeg -i input.avi -s qvga -croptop 8 -cropright 22 output1.avi
ffmpeg -i input.avi -croptop 8 -cropright 22 -s qvga output2.avi

Notice that in the first case, we've set the size first (qvga means 320x240).

In the second case we set the cropping first.

Now let's look at the output with: file *.avi.

input.avi: RIFF (little-endian) data, AVI, 640 x 480, 25.00 fps, video: XviD, audio: MPEG-1 Layer 3 (stereo, 44100 Hz)
output1.avi: RIFF (little-endian) data, AVI, 298 x 232, 25.00 fps, video: FFMpeg MPEG-4, audio: MPEG-1 Layer 1 or 2 (stereo, 44100 Hz)
output2.avi: RIFF (little-endian) data, AVI, 320 x 240, 25.00 fps, video: FFMpeg MPEG-4, audio: MPEG-1 Layer 1 or 2 (stereo, 44100 Hz)

As you can see, the first output file has its dimensions cropped after resizing. The second one before, and its the second one I wanted, cropping the video first, then resizing it.

I have never encountered a command-line app where the order of the switches actually mattered, until now. I don't know how many other ffmpeg switches this also applies to, but I thought I'd share it as I personally couldn't find anything about it elsewhere.

Hope this is helpful!

Thom

 

Testing the linux.com blog platform

seems to be fairly cool for sure!

 I think that the pop-up editor is a cool feature.

 Oh, sorry, I mean:

 

Hello world!

 

Andrew.

 

Likewise Software Ships with SUSE Linux Enterprise Desktop 11 from Novell

 

Integrates SUSE Linux Desktop with Microsoft Networks

 

BELLEVUE, Wash., May 19, 2009 - Likewise announced today that its Likewise Enterprise offering will ship as part of SUSE Linux Enterprise Desktop 11 from Novell.

 

Likewise Enterprise securely connects computers running  SUSE Linux Enterprise Desktop 11 with Microsoft Active Directory -- making it easy to authenticate users, control access to applications and data, centrally manage settings with group policies and create reports for regulatory audits.

 

"Likewise is seeing acceleration in the number of our Linux desktop projects," said Barry Crist, CEO of Likewise. "Novell is a natural partner for us as it has been a pioneer in the area of Linux desktops with SUSE Linux Enterprise Desktop. The company clearly understands the widespread demand to offer better integration into Active Directory environments."

 

The group policies in Likewise Enterprise let system administrators manage the security settings of SUSE Linux Enterprise Desktop computers and users from a central system. Likewise Enterprise also includes GNOME group policies to control SUSE Linux Enterprise Desktop user and computer settings -- policies that are based on the GNOME GConf project to define preferences like the default web browser or when to lock down a desktop.

 

"Likewise helps us meet the requirements that our customers demand; the need for advanced Active Directory integration including support for AD security settings and group policy," said Guy Lunardi, director for Client Preloads at Novell. "SUSE Linux Enterprise Desktop 11 is the most interoperable Linux desktop in the industry and in combination with Likewise Enterprise offers a highly-scalable enterprise solution for large Linux desktop deployments."

 

Under the terms of the agreement between Likewise and Novell, all Novell customers who buy SUSE Linux Enterprise Desktop 11 will get Likewise Enterprise, and it will be part of the SUSE Linux Enterprise Desktop software repositories.

 

"Many organizations are integrating their Linux systems into Active Directory because of the centralized identity and policy management capabilities, with the added benefits of enhanced authentication and sign-on reduction," noted Mark Diodati, senior identity and security analyst at Burton Group. "The embedding of the Active Directory component into the Linux operating system should simplify enterprise deployments."

 

Likewise Enterprise addresses the authentication, auditing, and reporting needs of companies running multiple operating systems in their network. Likewise Enterprise is a simple upgrade for customers who have installed Likewise Open and want to use group policies to manage their mixed environment and use the auditing features of Likewise Enterprise to view access reports. The auditing features help companies comply with regulatory requirements, such as those of Sarbanes-Oxley.

 

About Likewise

Likewise provides identity management solutions that improve security, enhance operational efficiency, and help achieve regulatory compliance in mixed networks. Likewise Open lets large organizations securely authenticate Linux, Unix, and Mac systems with Active Directory, a popular and proven unified directory system. Likewise Enterprise includes all the core authentication technology that comes with Likewise Open, plus world-class modules for access control, migration, group policy, auditing, and reporting. For more information, visit http://www.likewise.com/.

 

Likewise is a trademark of Likewise Software. All other trademarks referenced herein are the property of their respective owners.

 

Sigh - Lost

Sigh - Lost my first blog post - ;)
 

Effortless XML manipulation with Groovy slurping

To be a successful software developer in this day and age, you need a set of tools that makes dealing with XML effortless. Groovy introduces new and better ways to create and process XML. With the help of some examples, this article shows you how Groovy makes building and parsing XML refreshingly simple.
 
Page 122 of 146

Upcoming Linux Foundation Courses

  1. LFD211 Introduction to Linux for Developers
    08 Dec » 09 Dec - Virtual
    Details
  2. LFS220 Linux System Administration
    08 Dec » 11 Dec - Virtual
    Details
  3. LFD331 Developing Linux Device Drivers
    15 Dec » 19 Dec - Virtual
    Details

View All Upcoming Courses


Who we are ?

The Linux Foundation is a non-profit consortium dedicated to the growth of Linux.

More About the foundation...

Frequent Questions

Join / Linux Training / Board