KlavoWiki - User contributions [en-gb]

Mysql commands

2008-03-12T05:29:06Z

124.178.240.153: New page: Handy Cheat-Sheet of MySQL Commands = From your login shell = Creating a Database <pre> mysqladmin create mydatabase </pre> Dropping (Removing) a Database <pre> mysqladmin drop ...

Handy Cheat-Sheet of MySQL Commands

= From your login shell =

Creating a Database 
<pre>
mysqladmin create mydatabase
</pre>

Dropping (Removing) a Database 
<pre>
mysqladmin drop mydatabase
</pre>

Populating an Existing Database from a *.sql File 
<pre>
mysql mydatabase < mydatabase.sql
</pre>

Dumping Database Structure and Data to a *.sql file 
<pre>
mysqldump --opt techmanual > techmanual.sql;
</pre>

= From within the MySQL interface =

Starting MySQL from the Command Line 
<pre>
mysql
</pre>

You will be welcomed with the following message:
<pre>
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is ## to server version: #.##.##

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

The prompt changes to "mysql>", which will be shown in each example below.
</pre>

Seeing What Databases are Available 
<pre>
show databases;
</pre>
(be sure to use the semi-colon to terminate the command)
 
Telling MySQL to Use a Specific Database 
<pre>use mydatabase;</pre>

Seeing What Tables are Available Within a Database 
<pre>
show tables;
</pre>

Looking at the Data in a Particular Table 
<pre>
select * from [tablename];
</pre>

Adding a Database User with Password 
grant all privileges on [databasename].* to [dbusername]@localhost identified by '[dbpassword]';
<pre>grant all privileges on mydatabase.* to joeuser@localhost identified by 'supersecretpasswd';
flush privileges;
</pre>

Removing a Database User 
<pre>
delete from mysql.user where user='techgeek' and host='localhost';
flush privileges;
</pre>

Performing Search-and-Replace Actions on a Table 
update DatabaseName set TableName = REPLACE(TableName,"[String to Search For]","[String Replacement]");
<pre>update roesublist set Grades = REPLACE(Grades,"Grades: Any","K,1,2,3,4,5,6,7,8,9,10,11,12");</pre>

[[Category : Linux]]

HUDlite

2008-03-06T06:02:40Z

124.178.240.153:

= Work in Progress =

=== What is HUDlite? ===

HUDlite is a desktop tool that provides the users on your system the ability to manage calls, manage their presence, transfer calls, park calls, and much more

<table cellSpacing="0" cellPadding="0" width="100%">
<tr>
<th>Download:</th>
<td>
[http://yum.trixbox.org/centos/4/RPMS/hudlite-server-1.4.32-1.i386.rpm hudlite-server-1.4.32-1.i386.rpm]</td>
</tr>
<tr>
<th>Build Date:</th>
<td>Mon Jul 23 09:35:23 2007</td>
</tr>
<tr>
<th>Packager:</th>
<td>admin@fonality.com</td>
</tr>
<tr>
<th>Size:</th>
<td>2.81 MB</td>
</tr>
</table>

=== Step by Step Install ===
Download:

<pre>
yum install cperl-Net-DNS.i386
</pre>

http://yum.trixbox.org/centos/4/RPMS/repodata/repoview/perl-POE-Component-Client-DNS-0-0.9803-1.2.el4.rf.html 
http://yum.trixbox.org/centos/4/RPMS/repodata/repoview/perl-POE-0-0.34-1.el4.rf.html 
http://mirror.internode.on.net/pub/cpan/modules/by-module/XML/XML-Parser-2.36.tar.gz 
http://yum.trixbox.org/centos/4/RPMS/repodata/repoview/perl-XML-Simple-0-2.14-2.2.el4.rf.html 
http://yum.trixbox.org/centos/4/RPMS/repodata/repoview/ircd-hybrid-0-7.2.1-2.html

=== HUDlite installation process ===
<pre>trixbox is the easiest and quickest server for HUDlite. trixbox has HUDlite server pre installed and configured.

If you want to install HUDlite on your scratch built Asterisk box this is how to set it up. HUDlite server
should work with most versions of Linux. It has been tested to work with CentOS and Fedora.

First you need to install a few Perl modules.
perl-POE-0.3401 (this version is required RPM included)
perl-POE-Component-Client-DNS
perl-XML-Parser
perl-XML-Simple

you can use the RPMS that are included with this package or install from CPAN

Next the IRC server must be installed. HUDlite uses IRC to communicate with the server. An RPM has been
included with this package

RPM –i ircd-hybrid-7.2.1-1.i386.rpm

The ircd server will start on the next reboot or type service ircd start to start it.

The HUDlite server can be installed anywhere. We usually put it in /usr/local

Move the ./fonality directory to /usr/local

Next configure the connections for the HUDlite server. Edit the connect.xml file. Enter the location and port for
your Asterisk box and the login info for your IRC server. The default file should have the right info already.

Now edit your context.xml
This has the user and password for the Asterisk Management interface and all the context information for calling
out and parking calls. The default should be OK for trixbox or FreePBX

The eventmap.xml configures how Asterisk Management interface messages are formated. The default file is set up
for Asterisk 1.2.7. If you are using another version of Asterisk you may need to edit this file.

Copy the files from the asterisk directory to your /etc/asterisk directory users.xml must be in a sub directory
called hud.

Include extensions_hud.conf in your dial-plan

Edit the users.xml and add an entry for each phone

Here is an example

SIP200 - is the name of the device. The name is created by adding the Device type (SIP or ZAP) to the name of
your entry for this peer in SIP.conf (usually the extension of the phone)
e200 - is the extension. This must be the extension number of your phone with an "e" in front of it.
Office Phone - is the name of the extension. (Can be anything)
Huduser – the HUDlite client will log in as this user
Pass – is the HUDlite client password
The next three entries are the email address, IM name, and Cell phone number of the person using HUDlite. They
are optional and unused at this time. They must be blank if they are not used.

10000 – the ID of the device. The ID must be numeric and unique in the users.xml file.

<opt>
<sip200>
<e200>Office Phone</e200>
<e200>huduser</e200>
<e200>pass</e200>
<e200>test@test.com</e200>
<e200>buddy</e200>
<e200>5551231234</e200>
<e200>10000</e200>
</sip200>
</opt>

That’s it. Fire up the server by typing ./hud_lite from the command line and log in with the HUDlite client.
Remember the server password is password (see connect.xml)</pre>

[[Category : Asterisk]] [[Category : Software]]

Samba

2007-09-10T05:04:49Z

124.178.240.153:

Firstly install the samba server and client

<pre>
yum install samba samba-client
</pre>

Once the required applicatons are installed we can add the computer to the domain by running authconfig.

<pre>
authconfig
</pre>

Under the User infromation select Use Winbind
Under Authentication select Use Winbind Authentication

Under the Authentication column the "Use MD5 Password" and "Use Shadow Passwords" should be automatically select. Leave them selected.

Security Model is ads
Domain is NETBIOS domain name
Domain Controllers is the name of a Domain Controller
ADS Realm is DNS (FQDN) domain name
by default the /bin/false is selected.

Select Join Domain.
Select Ok.

[[Category: Authentication]] [[Category: Shares]]

Samba

2007-09-10T04:59:27Z

124.178.240.153: New page: Firstly install the samba server and client <pre> yum install samba samba-client </pre> Once the required applicatons are installed we can add the computer to the domain by running authc...