Pode usar assim: REPLACE( REPLACE( REPLACE( FORMAT( value, 2), '.', '|'), ',', '.'), '|', ',') Alguem sabe uma forma mais direta? | |
| | |
sexta-feira, 28 de maio de 2010
Number format no mysql - Fórum do Clube do Hardware
terça-feira, 25 de maio de 2010
HOWTO: Install FreeNX - Ubuntu Forums
What is FreeNX
FreeNX is a system that allows you to access your desktop from another machine over the Internet. You can use this to login graphically to your desktop from a remote location. One example of its use would be to have a FreeNX server set up on your home computer, and graphically logging in to the home computer from your work computer, using a FreeNX client.
It's Open Source, secure (SSH based), fast and versatile!
Note: Running FreeNX as server on Ubuntu with the free "NX Client for Windows" from NoMachine on a Windows workstation is working fine.
Terminology
The Server is the computer you want to connect to. This is the computer where the FreeNX server will need to be installed. The name of the Ubuntu package providing the server is "freenx". For the example used here, the home computer is the server.
The Client is the computer from which you want to be able to access the Server. The name of the Ubuntu package providing the client is "nxclient". For the example used here, the work computer is the client.
Installation
Before installing FreeNX server make sure you have SSH set up and is working. You can find the SSH Howto here: https://help.ubuntu.com/community/SSHHowto
We will be installing the FreeNX server on the Server machine, i.e., the machine that you want to access remotely. In the stated example, this is your computer that is at home.
FreeNX is not included in Ubuntu, so we'll add it from the FreeNX Team PPA.
For the paranoid: there is an added security risk involved in using the default keys. If you keep the default keys then everybody will be able to connect to your SSH server as the NX user which is added to your system during the installation. This opens an additional (and unnecessary) opportunity to attack your computer. You could avoid it by using custom SSH keys, as explained later.
Installing the FreeNX server on Ubuntu Lucid (10.04)
Ubuntu Lucid now uses Neatx, the Open Source NX server from Google.
Installation is simple enough, and similar to the Ubuntu Karmic method.
Open your terminal
Applications->Accessories->Terminal
and type in this command
sudo add-apt-repository ppa:freenx-team
Then Update Apt
sudo apt-get update
At this point, the repository is added and apt is updated, then install the neatx-server package (using Aptitude to install extra needed packages).
sudo apt-get install neatx-server
Installing the FreeNX server on Ubuntu Karmic (9.10)
Karmic introduces the add-apt-repository command that simplifies most of the work of adding a third party repository.
Open your terminal
Applications->Accessories->Terminal
and type in this command
sudo add-apt-repository ppa:freenx-team
NOTE: If you do not have add-apt-repository installed add the following
sudo apt-get install python-software-properties
Then Update Apt
sudo apt-get update
At this point, the repository is added and apt is updated, then install the freenx package (using Aptitude to install extra needed packages).
sudo aptitude install freenx
Now use nxsetup to install necessary files and create the special user "nx"
sudo /usr/lib/nx/nxsetup --install
Installing the FreeNX server on older Ubuntu Versions
This Instructions are for older Ubuntu versions. FreeNX is not included in Ubuntu, so we'll add it from the FreeNX Team PPA.
Add this repository using the Third-Party Sources Tab in Software Sources. When it asks, Reload the information about available software. Now you can see and install the freenx package in Synaptic Package Manager.
You must edit the configuration files and install by hand:
Open your apt sources list
gksudo gedit /etc/apt/sources.list
and append the two lines for the repository
deb http://ppa.launchpad.net/freenx-team/ppa/ubuntu VERSION main
deb-src http://ppa.launchpad.net/freenx-team/ppa/ubuntu VERSION mainwhere VERSION can be: dapper, hardy, intrepid or jaunty. More information can be found at FreeNX Team PPA.
- Save and then close.
To add the public key of FreeNX PPA run:
sudo apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 2a8e3034d018a4ce
Then Update Apt
sudo apt-get update
After you add the repository, then install the freenx package (using Aptitude to install extra needed packages).
sudo aptitude install freenx
Now use nxsetup to install necessary files and create the special user "nx"
sudo /usr/lib/nx/nxsetup --install
Installing the NX Client
The official NX client is not in the Ubuntu repositories.
You should be able to access your Ubuntu box from any Windows or Linux box using the free client from NoMachine's website. You can also embed your NX Server in a webpage by installing the Nomachine Web Companion and the Apache webserver.
Now you can execute the installed client using the following command:
/usr/NX/bin/nxclient &
Or by looking it up in the menu
This will start the NX client in a GUI, and step you through getting connected to the FreeNX server, and you will be on your way! [Note: If you are behind a firewall you may need to enable SSL encryption under the Advanced configuration tab - JeremySchroeder]
Installing QTNX (Opensource client)
sudo apt-get install qtnx
Miscellany
NX Server Free Edition
NX Server Free Edition provided by NoMachine is not related to FreeNX. NXSFE has a limit of 2 sessions per server. FreeNX doesn't have this limit.
FreeNX on PowerPC
There are no precompiled binaries of FreeNX on this platform (Launchpad PPA doesn't provide support), so FreeNX have to be compiled from source. Sources can be found at the FreeNX Team PPA.
These steps will build FreeNX from source (you need to add the deb-src repository):
Create a directory to hold the FreeNX source, and cd into it.
mkdir freenxSource; cd freenxSource
Build the freenx packages and install related packages.
sudo apt-get build-dep nx freenx
This will download the source tarballs and build the freenx packages (*.deb) in the current directory.
apt-get -b source nx freenxInstall the FreeNX packages.
sudo dpkg -i *.deb
If dpkg complains about missing packages, let apt fix it
sudo apt-get -f install
sudo dpkg -i *.deb
How to start/stop FreeNX
The FreeNX server is not a service but uses ssh. The following command will stop the FreeNX program from accepting connections.
sudo /etc/init.d/freenx-server stop
(Replace stop by start for starting it again)
Configuring SSH port
By default, nxserver uses port 22 for communicating over SSH. On some machines or networks, port 22 may be blocked; some Internet providers block port 22, for instance. Port 22 is also a common target of people trying to crack into a network. To make the SSH server listen on port 8888, you can do the following:
Edit the file /etc/ssh/sshd_config
gksudo gedit /etc/ssh/sshd_config
Find
Port 22
and change it to
Port 8888
You then need to restart SSHD. Try
/etc/init.d/ssh restart
FreeNX should detect the SSHD port, but otherwise: Edit the file /etc/nxserver/node.conf
gksudo gedit /etc/nxserver/node.conf
Find
# The port number where local 'sshd' is listening.
#SSHD_PORT=22
and change it to:
# The port number where local 'sshd' is listening.
SSHD_PORT=8888
That is, change the port number to the one that sshd is listening to, and uncomment the line.
Using custom SSH keys
After installation, FreeNX will use a set of default ssh keys for authentication. This is a security risk, especially on any internet-facing machines, and the default keys should be replaced with your own custom keys.
To change the default keys to your own custom keys - on the machine hosting the freenx-server, run the command:
sudo dpkg-reconfigure freenx-server
This will launch a dialogue that will guide you through the generation of custom keys. On the first page hit 'OK' and on the second page select 'Create new custom keys'
a key file called client.id_dsa.key will be created in: /var/lib/nxserver/home/custom_keys/
Now, we need to transfer the key to the client machine so that it can be imported in the FreeNX client application. First copy the key to your home directory on the server machine:
sudo cp /var/lib/nxserver/home/custom_keys/client.id_dsa.key ~/
Next, copy client.id_dsa.key to your client machine. Ideally you should copy the file securely, for example by running the following command from the client computer:
scp user@freenx-server:~/client.id_dsa.key ~/
which will securely copy the client.id_dsa.key file from the freenx-server computer to your home directory on the client.
If your client is a Windows machine, just copy the key with your preferred method.
In the nx client software you can now import this key.
After you have tested that authentication is working using your custom keys you should then remove the client.id_dsa.key file from your home directories on both the server and client machines.
Troubleshooting
Problem: Everything is installed as described above, but I still get errors at installing nxsetup --install
Solution: Check that this line exists in /etc/ssh/sshd_config "AllowUsers nx" and this line also exists and is set to authorized_keys2 "AuthorizedKeysFile %h/.ssh/authorized_keys2", if commented, just uncomment them. after that run this command in a terminal sudo /etc/init.d/ssh restart .This issue is due custom SSH server configuration.
Problem: At the client, the !M logo window appears, but after a few seconds that window just closes, even without showing any error message.
Solution: In the server, access your home directory and run this command, sudo rm .Xauthority* followed by touch .Xauthority and finally chmod 600 .Xauthority . This issue is due custom VNC configuration.
Problem: What can I do if I get the error 'Could not yet establish the connection to the remote proxy' ?
Solution: This commonly happens when the Advanced tab configuration option "Disable encryption of all traffic" has been selected, but the appropriate firewall ports have not been opened. Open the necessary firewall ports, or uncheck the option to re-enable encryption over SSH. NoMachine knowledge base article
Problem: NX Client connects and displays the desktop but the screen does not refresh.
Solution: Set Disable Direct Draw for screen rendering in the client's advanced configuration tab.
References
FreeNX Team PPA An up-to-date repository from the FreeNX Team, for Ubuntu 8.04 (Hardy), 8.10 (Intrepid) or 9.04 (Jaunty)
Seveas' Packages FreeNX old repository
Ubuntu Forums HowTo FreeNx How to remote desktop using SSH and FreeNX - OpenGL Seveas Repositories
Related docs
You can also have a look at the article about installing the NX packages provided by NoMachine company
Desktop integration wanted
For those who want to have freenx supported in krfb, krdc, log into bugs.kde.org, and add a comment and vote for the following bugs (wishlist) :
187310 : nxserver support in krfb
149482 :nx support in krdc (client), it seems that work is already in progress, and there only a few problems left.
The same should be done on gnome side, for vino and vinagre.
comment-77547 : vinagre has a plan to support nx
vino goals/to-do v2 : no mention of nx; only rdp and vnc
NXLaunch is another solution and could possibly be integrated in other Remote Desktop clients.
msg00330, 2007-Sept : committed source
msg00404, 2007-Sept : integration
HOWTO: Install FreeNX - Ubuntu Forums
This is my experience in installing the FreeNX server and the NoMachine NX Client on my Kubuntu Breezy.
I had some troubles in getting the whole thing work, so I write this little howto hoping that it may be useful for other (K)Ubuntu users
0. CONFIGURING THE RIGHT PACKAGE REPOSITORY
I used .deb packages from Seveas repository. In order to configure it for apt-get (or Synaptic) add the following line to /etc/apt/sources.list:
deb http://seveas.ubuntulinux.nl/ breezy-seveas all
gpg --keyserver subkeys.pgp.net --recv-keys 1135D466
gpg --export --armor 1135D466 | sudo apt-key add -
1. INSTALLING THE SERVER
Having Seveas repository configured, it is easy to install the server part of FreeNX. Simply install the freenx package:
sudo apt-get install freenx
Please note that the key is used for public key authentication on the user "nx", who is used by the NX protocol to establish an SSH tunnel for the secure protocol data transport. Session authentication is (by default setup) based on PAM, allowing server users to establish a remote NX session by mean of their own credentials (username and password, as defined on the server).
It is now necessary to check some settings of the ssh subsystem, by editing the /etc/ssh/sshd_config file:
1) sshd should listen on the standard 22 port. Please check that the sshd_config contains the line "Port 22" and that it is not commented out.
2) public key authentication is turned on. Check the sshd_config so it contains the line "PubkeyAuthentication yes"
3) modify the "AuthorizedKeysFile" line in "AuthorizedKeysFile %h/.ssh/authorized_keys2" (default is "%h/.ssh/authorized_keys")
4) By default, sshd should allow every system user to access the system. If your system is configured differently, please add (or modify) the "AllowUsers nx" line to allow the nx user to access. I think you can use the "user@host" syntax for this sshd parameter to limit hosts from which users can logon via NX.
If you have made any change to the sshd_config, restart the ssh daemon with
sudo /etc/init.d/ssh restart
2. INSTALLING THE CLIENT
On the client machine, from the Seveas repository, install the nxclient package.
In my KDE, I found the "NX Client for Linux" in the "Lost+found" submenu. Launching the client for the first time brings up a connection wizard that will allow you to setup a connection to a remote NX server (in this case, the one configured above). Insert the session name (just an identifier of the server/service/host you will connect to), the server IP address and pay attention to check the "Enable SSL encryption of all traffic" option. You may set other options in the connection wizard, for example the type of remote window manager to fire up when the nx user connects (KDE, GNOME, others) and the resolution of the virtual NX session.
Please note that the connection created by the wizard make use of the standard NoMachine key. We will see later how to change the connection key to a custom one.
At the end of the wizard, the NX client logon form fires up. You can insert the username, the password and choose one of the defined sessions.
The login button will attempt the NX connection to the server as defined in the selected session. If you press the "Configure..." button, you can change ALL the parameters of the selected session (the ones defined with the connection wizard and other...).
3. (Optional) DEFINING AND USING CUSTOM KEYS
If you chose "Custom keys" when prompted during the server package, the installation creates a random authentication key for the user "nx". If you chose the standard NoMachine key, you can reconfigure the freenx package to change this setting to "Custom keys" with the following command:
sudo dpkg-reconfigure freenx
To import the key, open the NX client, select the right session and click on the "Configure" button. From the "General" tab of the configuration window, click on the "Key" button and then on the "Import" button. Then select the client.id_dsa.key you copied from the server and click on the "Save" button, "OK" button (please confirm to save the new configuration)
From now on the NX connection to the server will use the new key. Clients with the default key (or other custom keys) cannot authenticate to the server anymore.
You can return to the standard NoMachine key by reconfiguring the freenx package on the server, and by modifying the key used by the client with the same procedure described above, but clicking on the "Default" button instead of the "Import" button we used before.
If you played with NX keys and your client doesn't authenticate anymore to the server, you can start from a clean state by reconfiguring the freenx package on the server and choosing the "Remove freenx keys" and reconfiguring again choosing the "NoMachine keys" or the "Custom keys" options.
Conclusions
I apologize for my english, far from being good. However I hope that this howto can help some user that (like me) has encountered troubles in configuring this powerful remote control protocol.
As a last note, if you has other troubles and you have set up a firewall, please check firewall settings keeping in mind that only the port 22 (ssh) have to be enabled in order to establish a connection to the server.
Bye
Macros in Database Documents - OpenOffice.org Wiki
http://wiki.services.openoffice.org/wiki/Database
http://sheepdogguides.com/fdb/opof6oppeventsintro.htm
http://sheepdogguides.com/fdb/opof6button.htm
http://sheepdogguides.com/fdb/opof6button.htm#gotoDocument
http://sheepdogguides.com/fdb/fdb6exportcsv.htm
http://wiki.services.openoffice.org/wiki/Macros_in_Database_Documents
http://wiki.services.openoffice.org/wiki/Common_tasks
http://wiki.services.openoffice.org/wiki/Database#Examples
http://codesnippets.services.openoffice.org/Database/Database.CopyRecordToNew.snip
http://sheepdogguides.com/fdb/fdb7peopproj.htm
http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=2665
http://www.gkspk.com/view/programming/connecting-to-openofficeorg-base-form-macro/
http://office-software.suite101.com/article.cfm/openoffice_automating_macros
segunda-feira, 24 de maio de 2010
MySQL :: Re: How to set field value to NULL using MySQL Query Browser
Hi,Try this,
update [tableName] set [field_name]=null;
segunda-feira, 10 de maio de 2010
Upgrade Alsa (1.0.23) on Ubuntu Lucid Lynx 10.04 | To a free world
Upgrade Alsa (1.0.23) on Ubuntu Lucid Lynx 10.04
| Ubuntu Lucid Lynx 10.04 is coming by default with the version 1.0.21 of Alsa so I decided to upgrade to the last version wich is 1.0.23. |
What is Alsa (Advanced Linux Sound Architecture) ?
According to Wikipedia, Alsa is a Linux kernel component intended to replace the original Open Sound System (OSS) for providing device drivers for sound cards. Some of the goals of the ALSA project at its inception were automatic configuration of sound-card hardware, and graceful handling of multiple sound devices in a system, goals which it has largely met.
Installation :
To do this, we must begin by determining our version of alsa as follows :cat /proc/asound/version
Advanced Linux Sound Architecture Driver Version 1.0.21.
To avoid problems during the upgrade of Alsa-utils, we need to stop it with the following command :
sudo /etc/init.d/alsa-utils stop
sudo apt-get -y install build-essential ncurses-dev gettext xmlto libasound2-dev
sudo apt-get -y install linux-headers-`uname -r` libncursesw5-dev
Then, we go in our personal folder and download alsa-driver, alsa-lib and alsa-utils :
cd ~
rm -rf ~/alsa* ~/.pulse*
wget ftp://ftp.alsa-project.org/pub/driver/alsa-driver-1.0.23.tar.bz2
wget ftp://ftp.alsa-project.org/pub/lib/alsa-lib-1.0.23.tar.bz2
wget ftp://ftp.alsa-project.org/pub/utils/alsa-utils-1.0.23.tar.bz2
After that, we create a new folder for the compilation and installation of the 3 files. Then, we move the 3 tar files that we just downloaded in this folder :
sudo rm -rf /usr/src/alsa
sudo mkdir -p /usr/src/alsa
cd /usr/src/alsa
sudo cp ~/alsa* .
Unpack the 3 tar files :
sudo tar xjf alsa-driver*
sudo tar xjf alsa-lib*
sudo tar xjf alsa-utils*
We compile and install alsa-driver :
cd alsa-driver*
sudo ./configure
sudo make
sudo make install
We compile and install alsa-lib :
cd ../alsa-lib*
sudo ./configure
sudo make
sudo make install
We compile and install alsa-utils :
cd ../alsa-utils*
sudo ./configure
sudo make
sudo make install
Then, we remove the 3 tar files in our personal folder that are not anymore necessary :
rm -f ~/alsa-driver*
rm -f ~/alsa-lib*
rm -f ~/alsa-utils*
Then, just restart your computer and your alsa version should be 1.0.23!
You can verify that you have now indeed have this version of alsa :
cat /proc/asound/version
Advanced Linux Sound Architecture Driver Version 1.0.23.
Compiled on May 2 2010 for kernel 2.6.32-21-generic (SMP).
Just to be sure everything is well configured, execute this command :
sudo alsaconf
and reboot again!
Related Posts
- Upgrade Alsa (1.0.23) on Ubuntu Karmic Koala 9.10
- Upgrade Alsa (1.0.22.1) on Ubuntu Karmic Koala 9.10
- Upgrade Alsa (1.0.21) on Ubuntu Karmic Koala 9.10
- Upgrade Alsa (1.0.21) on Ubuntu Jaunty 9.04
- Upgrade Alsa (1.0.20) on Ubuntu Jaunty 9.04
- Upgrade Alsa (1.0.19) on Ubuntu Jaunty 9.04
- Acer aspire 6920 – No sound on Ubuntu 8.10 – Upgrade of alsa
sexta-feira, 30 de abril de 2010
Large, multi-script Unicode fonts for Windows computers
These fonts are chinese Unicode fonts which include the following charsets:
- Big5
- GB2312-80
- ISO8859-1,2,3,4,7,9,10,13,14,15
- Bopomofo Extended for Minnan and Hakka (台、客語)
- HKSCS (香港), CNS11643, GB18030, Japanese and Korean are work in progress.
Current release: 0.0.20041205-1
License: [Arphic Public License]
The fonts can be downloaded from http://debian.linux.org.tw/pub/3Anoppix/people/arne/ as tarball and deb package.
- Mingti: ShanHeiSun-Uni ttf-arphic-uming [tgz] [deb]
- Kaiti: Zenkai-Uni-Medium ttf-arphic-ukai [tgz] [deb]
Apt-repository: deb ftp://debian.linux.org.tw/pub/apt/ unstable main
If you have already downloaded a tarball version of the fonts and only want to upgrade to a newer release, you can use xdelta to apply binary patches.
Xdeltas of the fonts are in http://debian.linux.org.tw/pub/3Anoppix/people/arne/xdeltas/
- For upgrading between releases download the xdelta file from the corresponding subdirectory. (Example: 0.0.20041031-1_0.0.20041205-1/)
Windows users can visit http://www.eng.uwaterloo.ca/~ejones/software/xdelta-win32.html
Then put your tar.gz pagage of the old font and the downloaded xdelta file into a temporary directory and use:
xdelta patch
(without the <> of course).
These pdf files show which glyphs are already encoded (Size: 35 MB each):
Xdelta files are in http://debian.linux.org.tw/pub/3Anoppix/people/arne/xdeltas/pdf/The font packages contain two variants of the font, which only differ in the Bopomofo Extended glyphs. These glyphs are mainly used in Taiwan for teaching Taiwanese and Hakka. There exist two varaints of those glyphs, one according to the Unicode standard and one, called Modern Bopomofo Extensions (MBE), which has been developed by Mr. Yang Qing-Chu (楊青矗). The MBE variants are considered easier to read and write.
To get a picture how those glyphs differ:
- Bopomofo Extensions according to Unicode 4.0
- Modern Bopomofo Extensions according to Mr. Yang Qing-Chu (楊青矗)
The TTF in the font packages contains both variants already, the Unicode variant is the default. The MBE variant is encoded seperately as stylistic alternative to the Unicode variant. If your application supports this, you can choose which variant you want to see there.
If your applications don't support the stylistic alternatives feature, you can patch the TTF file with the xdelta file included in the tarball. To do this, copy the TTF file and the xdelta file into a temporary directory and use the xdelta command like shown above. You can also install both variants in parallel.
Development ressources:
Author: Arne Götje (高盛華), Taiwan : arne at linux dot org dot tw
If you want to contribute, please send me a mail.
Contributers:
- Akar Chen (), Hong Kong