gacq wiki - Contribuciones del usuario [es]

Installing Debian on Dell M1210

2011-11-01T02:10:46Z

Gacq:

[[Imagen:XPS-foto.jpg|right]]
'''My laptop was stolen :( Unmaintained page from June 2007'''

'''Now mainteined by me!. This guide is really usefull!...''' --[[Usuario:Yaco|Yaco]] 19:52 19 dic 2007 (ART)

=Summary=
{| border="1" align="center"
|+ Summary
! Component !! Status !! Comments
|-
! Camera || style="background:yellow" | Works || driver linux-uvc only support V4L2
|-
! Card reader || style="background:yellow" | Need more research || kernel patch? MMC dot work?
|-
! CD/DVD || style="background:green" | Works || parameter at boot?
|-
! Dual Core CPU || style="background:green" | Works || Install smp kernel
|-
! Ethernet || style="background:green" | Works || out of the box
|-
! Firewire || style="background:green" | Works ||
|-
! Media Butoms || style="background:green" | Works || out of the box
|-
! Modem || style="background:orange" | not tested, but... || Propietary driver limit modem to 14.4Kb
|-
! SATA Disk || style="background:green" | Works || out of the box
|-
! Sound || style="background:green" | Works || out of the box
|-
! Suspend to RAM || style="background:grey" | Need more research || working for other people
|-
! Suspen to disk || style="background:grey" | Need more research || working for other people
|-
! S-Video output || style="background:green" | Works ||
|-
! Touchpad || style="background:green" | Works || out of the box
|-
! USB || style="background:green" | Works || out of the box
|-
! VGA Port || style="background:green" | Works ||
|-
! Video (NVIDIA) || style="background:green" | Works || free and propietary driver
|-
! Wireless || style="background:green" | Works || Download driver: ipw3945
|-
|}

=Specifications=
*Dell XPS M1210 Laptop - AR$ 5.200 (1.700 U$S) - July 2006
**Intel Core 2 Duo Processor T2300 @ 1.66GHz
**1GB of Dual Channel DDR2 memory
**12.1" Widescreen WXGA (1280 x 800) display with TrueLife
**256MB NVIDIA GeForceTM Go 7400 TurboCache
**60GB 5400RPM SATA hard drive
**8x DVD/CD Burner (DVD+/-RW)
**Webcam
*Debian GNU/Linux Etch (testing) Daily Build Debian Installer
*kernel 2.6.18-3 - Custom build - Kernel source from sid

==Detected by preinstaled windows (the last words of)==
Modem:Conexant HDA D110 MDC V.92 (winmodem)
DVD: Sony DVD+-RW DW-Q58A
NIC: Intel(R) PRO/Wireless 3945ABG Network Connection
SATA: Intel(R) 82801GMB/GHM (ICH7-M Family) Serial ATA Storage Controller - 27C4
Card Reader: Ricoh Memory Stick Y MMC
Webcam: QuickCam for Dell Network
PAD: Synaptics PS/2 Port Pointing device

=Base installation=
;Debian GNU/Linux Lenny (testing) Daily Build Debian Installer
Kernel built in module for lan interface does not work, I used an old Etch (testing) net installer

=Kernel=
==Compiling a custom kernel==
apt-get install linux-source-2.6.18 libncurses5-dev kernel-package
cd /usr/src
tar jxf linux-source-2.6.18.tar.bz2
cd linux-source-2.6.18
make menuconfig
make-kpkg --initrd --revision gacq01 kernel_image
cd ..
dpkg -i linux-image-2.6.18_gacq01_i386.deb

Manually edit /boot/grub/menu.lst and reboot

=NVIDIA=
==Free drivers (nv)==
;Installed during xserver installation

==Proprietary drivers (nvidia)==
;Only for 3D acceleration and other advanced features, if not use free driver, you'll feel better.

===Installation===
apt-get install nvidia-kernel-2.6.18-4-686 nvidia-glx nvidia-settings nvidia-xconfig

==Configuration==
===Automatic===
nvidia-xconfig

===Manually===
Update your /etc/X11/xorg.conf
Section "Module"
[..]
#Load "dri"
[..]
EndSection

Section "Device"
Identifier "NVIDIA"
Driver "nvidia"
Option "NoLogo"
Option "RenderAccel" "true"
Option "NvAGP" "1"
EndSection

Section "Screen"
[..]
Device "NVIDIA"
[..]
EndSection

=Wireless interface=
apt-get install firmware-ipw3945 ipw3945d ipw3945-modules-`uname -r`

;Optional
apt-get install network-manager

network-manager-gnome requires users to be in the group 'netdev' for it to work. If users aren't in the group 'netdev' then it won't automatically appear, and work, in the Notification Area.

If you're looking for a manual installation procedure see the [[ipw3945 driver manual installation for Debian Etch]]

=WebCam - Only work with v4l2=
==Manual==
Driver: http://linux-uvc.berlios.de/
<pre><nowiki>
apt-get install libpt-plugins-v4l2
svn checkout http://svn.berlios.de/svnroot/repos/linux-uvc/
cd linux-uvc/linux-uvc/trunk
make
sudo make install
modprobe uvcvideo
dmesg | tail
ln -s /dev/video0 /dev/video
</nowiki></pre>

Notes:
*Only [[v4l2]] is supported
*Add users to system group "video"

==Using packages (not working?)==
apt-get install linux-uvc-source libpt-plugins-v4l2
m-a prepare
m-a a-i linux-uvc
modprobe uvcvideo
dmesg | tail
ln -s /dev/video0 /dev/video

==Testing Webcam==

===Using Mplayer===
Just run this and you should see the webcam image:
$ mplayer -v tv:// -tv device=/dev/video0:driver=v4l2:outfmt=yuy2 -vc rawyuy2 -fps 15 -vo x11
===Using Luvcview===
Using luvcview we can take pics and record video.

apt-get install libsdl1.2-dev
wget http://mxhaard.free.fr/spca50x/Investigation/uvc/luvcview-20070512.tar.gz
tar -xvf luvcview-20070512.tar.gz
cd luvcview-20070512
make
sudo make install
luvcview -d /dev/video0 -f jpg -s 640x480

Now you can use the buttons (a bit ugly) or the following hotkeys while running the program:

*'''n''' -> BRIGHTNESS UP
*'''b''' -> BRIGHTNESS DOWN
*'''x''' -> CONTRAST UP
*'''w''' -> CONTRAST DOWN
*'''c''' -> SATURATION UP
*'''v''' -> SATURATION DOWN
*'''z''' -> GAIN UP
*'''a''' -> GAIN DOWN
*'''r''' -> SHARPNESS UP
*'''e''' -> SHARPNESS DOWN
*'''s''' -> SCREENSHOT
*'''p''' -> RECORD A VIDEO
*'''l''' -> RESET
*'''q''' -> QUIT

'''References'''
*http://linux-uvc.berlios.de/
*http://www.eldemonionegro.com/wordpress/archivos/category/informatica/

=Sound card=
If you have conflict with the webcam USB microphone you can use this configuration in /etc/modprobe.d/sound to set the correct device order asignation.
alias snd-card-0 snd-hda-intel
options snd-hda-intel index=0
alias snd-card-1 snd-usb-audio
options snd-usb-audio index=1

=Frontal multimedia buttons=
Configure the frontal buttons using [http://lineak.sourceforge.net/ LineAK].
apt-get install lineak

Then you should add button configurations in '''/etc/lineakd.def'''. Add the following lines to the end of the file:

# Dell XPS M1210
[DXPS]
brandname = "Laptop/notebook"
odelname = "Dell XPS and Inspiron 9100"
[KEYS]
Play = 162
Previous = 144
Next = 153
Stop = 164
VolumeUp = 176
VolumeDown = 174
Mute = 160
[END KEYS]
[END DXPS]
# end Dell XPS/I9100 Laptop

Now do:

$ lineakd -c DXPS

Then you can attach a command to the different buttons. Make your changes in '''$HOME/.lineakd/lineakd.conf'''. This is just an example using Amarok (media player) and Aumix for volume control:

Mute = "aumix -v 0"
Next = "amarok -f"
Play = "amarok -t"
Previous = "amarok -r"
Stop = "amarok -s"
VolumeDown = "aumix -v -5"
VolumeUp = "aumix -v +5"

Finally, you have to run the lineak daemon:

$ lineakd&

Add this to any start script (like .xinitrc) to run it on start up.

=dvd/cdrom=
Error trying to open /dev/sg0 exclusively (Permission denied)... retrying in 1 second.
cdrecord: Permission denied. Cannot open '/dev/sg0'. Cannot open SCSI driver.
do:
chgrp cdrom /dev/sg0

=Modem (Not tested)=
==Driver==
*http://www.linuxant.com
These are NOT free, however - an uncrippled version will set you back USD 19.99, the free ones only support 14k4 :-(

*[http://criadoindomable.wordpress.com/2008/01/09/modem-para-las-dell-inspiron-en-ubuntu-710/ Modem para las Dell Inspiron en Ubuntu 7.10]

'''Hacerlo andar igual'''
*http://www.linuxespanol.com/tema7832.html?sid=992dcc97f759926ea2ec902a71a44eb5

'''Otros'''
http://www.thinkwiki.org/wiki/Conexant_HSF_modem_drivers

=Ricoh Card Reader=
'''research'''
*http://imaging.ugent.be/mr/Suse/suse-m1210.html

=Suspend=
==Suspend to RAM - Not working yet==
apt-get install gnome-power-manager

'''research'''
*http://imaging.ugent.be/mr/Suse/suse-m1210.html
*http://en.opensuse.org/NVidia_Suspend_HOWTO
*https://help.ubuntu.com/community/NvidiaLaptopBinaryDriverSuspend
*https://help.ubuntu.com/community/SuspendHowto

'''to validate'''
*After the installation of the NVIDIA driver, Suspend to RAM worked well after setting SUSPEND2RAM_FORCE="yes" in '/etc/powersave/sleep'.

=General references=
==Other sites about M1210 & Linux==
*http://imaging.ugent.be/mr/Suse/suse-m1210.html
*http://dotcommie.net/projects/XPS-M1210/
*http://www.centre-cired.fr/forum/article441.html
*http://toufeeq.blogspot.com/2006/07/linux-on-dell-xps-m1210.html
*http://www.serpentine.com/blog/software/linux-on-m1210.html
*http://www.serveur32.net/~tom/wordpress/materiel/xps1210/
*http://toufeeq.blogspot.com/2006/06/dell-xps-m1210.html
*http://g33k.wordpress.com/2006/07/20/the-dell-xps-m1210-a-mini-review/
*http://dellxpsm1210.blogspot.com/
*https://wiki.ubuntu.com/LaptopTestingTeam/DellXPSM1210

==About Debian==
*[http://www.ehomeupgrade.com/entry/2812/how-to_setup_debian How-To: Setup Debian Linux Desktop with Full Multimedia Support and Faster Processing]

==Others==
*[http://mundogeek.net/archivos/2007/04/23/temperatura-de-portatiles-dell-en-ubuntu/ Temperatura de portátiles Dell en Ubuntu]
*[http://mundogeek.net/archivos/2007/04/23/desactivar-touchpad-mientras-se-escribe-en-linux/ Desactivar touchpad mientras se escribe en Linux]

Ipw3945 driver manual installation for Debian Etch

2011-11-01T02:08:28Z

2010-10-21T12:05:19Z

Gacq:

=Documentation=
*[http://dev.mysql.com/doc/ MySQL official documentation page]
**[http://dev.mysql.com/doc/refman/5.1/en/index.html MySQL 5.1 Reference Manual]

=Tools=
*PHPMyAdmin
*mytop
*mtop
*[http://www.xaprb.com/innotop innotop]
**[http://www.xaprb.com/blog/2006/07/02/innotop-mysql-innodb-monitor/ innotop Article]

=Performance=
*[http://www.mysqlperformanceblog.com MySQL Performance Blog]
**[http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ What to tune in MySQL Server after installation]

=Syntax=
==Select==
CONCAT(first_name, ' ', last_name)

=Integration=
Authentication using LDAP, kerberos, etc is not ready yet
*[http://forge.mysql.com/wiki/PluggableAuthenticationSupport This page describes the MySQL plan for Pluggable Authentication Support, which is currently under consideration - PluggableAuthenticationSupport]

=Common task=
==Change password==
set password = password("yournewpassword");

=Database Backups=
==Hot backup - One database==
<pre>
#!/bin/sh
# by gacq
#
USERNAME=$1
PASSWORD=$2
DATABASE=$3
OUTPUTDIR="/srv/backup/mysql"

# Delete backups older than the number of days specified in DAYS
DAYS=8

date=`date +%F_%T | tr \: _`
mysqldump --user=$USERNAME --password=$PASSWORD $DATABASE | gzip > $OUTPUTDIR/dbbackup_$DATABASE-${date}.sql.gz

# Delete older backups
find $OUTPUTDIR -type f -name "dbbackup_$DATABASE*" -ctime $DAYS -exec rm -f {} \;
</pre>

==Hot backup - All databases==
#!/bin/sh
# by gacq
#
# MySQL root password
PASSWORD=$1
OUTPUTDIR="/srv/backup/mysql"

# Delete backups older than the number of days specified in DAYS
DAYS=8

date=`date +%F_%T | tr \: _`
mysqldump --all-databases --password=$PASSWORD | gzip > $OUTPUTDIR/all-databases-${date}.sql.gz

# Delete older backups
find $OUTPUTDIR -type f -name "all-databases.*.sql" -ctime $DAYS -exec rm -f {} \;

==Hot backup - All databases, each database in a separated file==
#!/bin/sh
# by gacq
#
# MySQL root password
PASSWORD=$1
BASEDIR="/srv/backup/mysql"

# Delete backups older than the number of days specified in DAYS
DAYS=8

date=`date +%F_%T | tr \: _`

OUTPUTDIR="$BASEDIR/mySQLbackup_$date"
mkdir -p $OUTPUTDIR

databases=`echo "show databases;" | mysql -Bs -uroot -p$PASSWORD`
for db in `echo $databases`
do
mysqldump --databases --password=$PASSWORD $db | gzip > $OUTPUTDIR/mySQLdump-$db-${date}.sql.gz
done

# Delete older backups
find $BASEDIR -type d -name "mySQLbackup*" -ctime $DAYS -exec rm -fr {} \;

==Selected databases==
databases="db1 db2 db3"
for db in `echo $databases`
do
mysqldump --databases -uroot -p$passwd $db | gzip > $dir/mySQL/mySQLdump-$db.dump.gz
done

==Backup using LVM snapshots==
*[http://mike.kruckenberg.com/archives/2006/04/limits_in_mysql.html Limits in mysqldump?]
*[http://mike.kruckenberg.com/archives/2006/05/mysql_backups_u.html MySQL Backups using LVM Snapshots]
*[http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for-mysql-backup-and-replication-setup/ Using LVM for MySQL Backup and Replication Setup]

= Errors =
== Error 1044 on mysqldump ==
<pre>
mysqldump: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when using LOCK TABLES
</pre>

Resolved using the '--single-transaction' option of mysqldump

* http://forums.mysql.com/read.php?10,108835,112951#msg-112951

Portada

2010-09-29T20:46:18Z

Gacq: /* Server */ Drupal va en Drupal

=Conceptos básicos=
Una selección de textos en español sobre conceptos básicos acerca del uso de las tecnologías - Su lectura no requiere de conocimientos técnicos
*[[Conocimiento Libre]]
*[[Estandares Libres]]
*[[Software Libre]]
*[[Patentes de Software]]
*[[Servicios Privativos]]
*[[Pirateria]]
*[[DRM]]
*[[Proyecto GNU]]
*[[Copyleft]]

=Software=
==Server==
*[[Apache]]
*[[Bind]]
*[[CVS]]
*[[CUPS]]
*[[Cyrus Imap]]
*[[dhcpd]]
*[[DotProject]]
*[[egroupware]]
*[[Fetchmail]]
*[[Flowscan]]
*[[FTP]]
*[[gallery]]
*[[GOsa]]
**[[GOsa on CentOS]]
*[[Jabberd]]
*[[Mailman]]
*[[MediaWiki]]
*[[Munin]]
*[[MySQL]]
*[[NFS]]
*[[OpenLDAP]]
*[[PostFix]]
*Pentaho
**[[Pentaho 1.7 - Base installation]]
**[[Pentaho 1.7 - CAS Integration]]
**[[Pentaho 1.7 - MySQL datasource]]
**[[Pentaho 1.7 - msSQL datasource]]
*[[ProcMail]]
*[[rdiff-backup]]
*[[Redmine]]
*[[rsyslog]]
*[[Samba]]
*[[SASL-LDAP]]
*[[Squid]]
**[[Chpasswd]]
*[[Squirrelmail]]
*[[SSH]]
*[[Subversion]]
*[[SugarCRM]]
*[[Varnish]]
*[[Xen]]
**[[Cloning a XEN VM]]
*[[Xoops]]
*[[Zabbix]]

==Desktop==
*[[aircrack]]
*[[Bash]]
*[[BitTorrent]]
*[[Eclipse]]
*[[Gaim]]
*[[gimp]]
*[[GNOME]]
*[[GnuPG]]
*[[gnuplot]]
*[[grep]]
*[[grub]]
*[[iptables]]
*[[JigDo]]
*[[kismet]]
*[[Mozilla]]
*[[Mutt]]
*[[NetworkManager]]
*[[Open Dental]]
*[[OpenSSL]]
*[[rsync]]
*[[v4l2]]
*[[Vim]]
*[[VirtualBox]]
*[[wget]]
*[[XDMCP]]
*[[XGL]]
*[[Xserver]]

==Varios==
*[[Raid por software]]
*[[Análisis de tráfico]]
*[[Monitoreo]]
*[[Comandos varios]]
*[[Filesystems]]
*[[Localizacion de pais]]
*[[Infraestructure Management]]
*[[Internet server configuration]]
*[[Maquinas Chicas]]
*[[Mail servers]]
*[[Analisis de logs]]
*[[Herramientas de diagnostico]]
*[[CDs y DVDs]]
*[[Protocolos a manopla]]
*[[System debuging]]
*[[Video]]
*[[Sonido]]
*[[Java]]
*[[Expresiones regulares]]
*[[Wake on lan]]
*[[Kernel 2.6]]
*[[Copiar directorios via tar y SSH]]
*[[Ubuntu]]
*[[Default passwords]]
*[[Antispam methods]]
*[[Consultorio Odontologico]]
*[[Maquinas virtuales]]
*[[Seguridad Informatica]]
*[[Streaming]]
*[[amavis]]
*[[Wireless]]
*[[DNS Dinamico]]
*[[Bootsplash]]
*[[Desktop]]
*[[CRM]]
*[[ERP]]
*[[Electronica]]
*[[VPN]]
*[[Suspend - Hibernate]]
*[[Virtualization]]
*[[XML]]
*[[Python]]
*[[Linux tips]]
* Debian
**[[Upgrade Debian: Etch to Lenny]]
**[[Debian]]
**[[Debian - Atlhon 64 bits]]
**[[Debian default system groups description]]
* [[Recuperar contraseña de root]]

==Software no libre==
*[[VMWare]]
*[[Windows]]
**[[Software Libre para Windows]]
**[[Migracion desde Windows]]
**[[Integracion con Windows]]
**[[Microsoft Varios]]
*SUN
**[[Solaris]]
**[[Sun One Directory Server]]
*[[Sybase]]
*[[Oracle]]
*[[Skype]]

=Hardware=
*[http://kmuto.jp/debian/hcl/ Debian GNU/Linux device driver check page]
*[[ProveedoresHardware]]
*[[Hardware roto]]
==Por tipo==
*[[ADSL]]
*[[Cable Modem]]
*[[Camaras Digitales]]
*[[FireWire]]
*[[Impresoras]]
*[[Laptops]]
*[[Modems]]
*[[Monitores]]
*[[Motherboards]]
*[[Palm]]
*[[Placas de Video]]
*[[RAID controllers]]
*[[Scanners]]
*[[WebCams]]
*[[Dispositivos wireless]]
*[[Wired network devices]]
*[[PC Power Supply]]
*[[Tablet PC]]

=Internet=
*[[Bookmarks]]
*[[Sitios web problematicos]]
*[[Dominios]]
*[[Internet Service Providers]]

=Varios=
*[[Diseño Grafico]]
*[[Temas generales]]
*[[Licencias de software]]

==Desordenado==
*[[Ordenar]]

Este Wiki esta orientado hacia temas generales relacionados con tecnologías libres, principalmente en cuanto a lo que se refiere a la administracion de sistemas, aunque también se pueden encontrar otros temas. La información puede estar desactualizada o no ser correcta, por lo que se recomienda usarla con precaución. [http://www.writers.ph freelance writer]

Cyrus Imap

2010-09-27T21:05:42Z

Gacq: /* Quota monitoring and warning mail */

= Subpages =
*[[Cyrus - Basic Configuration]]
*[[Cyrus - Exim4 configuration]]
*[[Cyrus - Sieve filtering]]
*[[Cyrus - Migrating from Courier-IMAP]]
*[[Cyrus - LDAP]]
= Utils =
== Search and expunge a set of folders ==
<pre>
import imaplib

imap = imaplib.IMAP4()
imap.login('manager', 'thepasswd')

for mbox in imap.list('', '*quotatest1*')[1]:
mailbox=mbox.split('"')[3]
imap.setacl(mailbox,'manager', 'lrswikxtecda')
print imap.select(mailbox)
print imap.expunge()
imap.setacl(mailbox,'manager', '')

</pre>

== Migrate mbolixt script ==
<pre>
import fileinput

for line in fileinput.input( "source-ctl_mboxlist-d" ):

mailbox_end = line.find(".",5)
if ( mailbox_end == -1 ):
mailbox_end = line.find("\t",5)
folder = ""
else:
folder = line[mailbox_end+1:line.find("\t",mailbox_end)]

mailbox=line[5:mailbox_end]

if folder:
print "mailserver.gacq.com!user.%s.%s\t0 default %s@mailserver.gacq.com\tlrswipkxtecda\t" % (mailbox,folder,mailbox)
else:
print "mailserver.gacq.com!user.%s\t0 default %s@mailserver.gacq.com\tlrswipkxtecda\t" % (mailbox,mailbox)
</pre>

== Recreate cyrus spool and database folders ==
<pre>
#rm -fr /var/spool/cyrus
#rm -fr /var/lib/cyrus
mkdir /var/spool/cyrus
mkdir /var/lib/cyrus
./cyrus-makedirs --cleansquat
chown -R cyrus:mail /var/spool/cyrus
chown -R cyrus:mail /var/lib/cyrus
</pre>

== Quota monitoring and warning mail ==
<pre>
#!/bin/bash
#

USERWARN=70

function send_warnmail {
noti_mailbox=$1
noti_used=$2
/kolab/sbin/sendmail $noti_mailbox << EOM
subject: ATENCION: La casilla $noti_mailbox esta al % $noti_used de su capacidad
from: Mail server <postmaster@domain.com>
to: $noti_mailbox

ATENCION: La casilla $noti_mailbox esta al % $noti_used de su capacidad

EOM
}

/kolab/bin/cyrquota | while read line
do
used=`echo $line | cut -d" " -f2`
mailbox=`echo $line | cut -d" " -f4 | cut -d"/" -f2`

if [ "$used" != "%" ]
then
if [ $used -gt $USERWARN ] && [ $used -lt 100 ]
then
send_warnmail $mailbox $used
fi
fi
done
</pre>

== Quota monitoring - Admin report ==
<pre>
#!/bin/bash
#

MAX=70
ADMIN=admin@domain.com

function enviar_reporte {
/kolab/sbin/sendmail $ADMIN << EOM
subject: KOLAB - Informe de uso de casillas de correo
from: Mail server <postmaster@domain.com>
to: $ADMIN

Casilla - Porcentaje usado
#####################################
`listar_llenas|sort -n -k3 -r`

EOM
}

function listar_llenas {
/kolab/bin/cyrquota | while read line
do
used=`echo $line | cut -d" " -f2`
mailbox=`echo $line | cut -d" " -f4 | cut -d"/" -f2`

if [ "$used" != "%" ]
then
if [ $used -gt $MAX ]
then
echo $mailbox - $used
fi
fi
done
}

enviar_reporte
</pre>

Cyrus Imap

2010-09-27T21:04:03Z

Gacq:

2010-04-14T18:23:35Z

Gacq: Deshecha la edición 3008 de Adrianjackson21 (disc.)

=Introduction=
License: GPL
Developed in .NET (Current estimate on running Open Dental on Linux or Mac is December 2006 using Mono)
*[http://www.open-dent.com/ Open Dental web site]
**[http://www.open-dent.com/manual/toc.html Manual]
**[http://www.open-dent.com/OpenDentalDocumentation.xml Database documentation]
**[http://www.open-dent.com/manual/previous.html Previous Versions - changelog]
**[http://www.bcdentalcare.ca/CosmeticDentistry/tabid/471/Default.aspx Dentist Thornhill]
*[http://www.ecuaodontologos.com/aorybg/opendent/index.html Descripción en español]

Installation tutorial
*http://www.opendental-solutions.com/

=Using MySQL database on Linux=

Distribution: Debian/Ubuntu

'''On Windows machine'''
*Install opendental on a windows computer with local db - complete install
*Make sure it works ok, put some data
*Backup the MySQL database using MySQL with something like (using this as a guide http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database/)
cd C:\Program Files\MySQL\MySQL Server 5.0\bin
mysqldump --add-drop-table opendental > \opendental.sql
this puts all the data into a single file, including the db meta info

'''On Linux server'''
apt-get update
apt-get install mysql-server mysql-client apache2 phpmyadmin samba php5 libapache2-mod-php5

==Samba configuration==
/etc/samba/smb.conf
[global]
workgroup = Consul
server string = %h Consul (Samba %v)
security = SHARE
map to guest = Bad User
passdb backend = tdbsam
syslog = 0
log file = /var/log/samba/log.%m
max log size = 1000
time server = Yes
panic action = /usr/share/samba/panic-action %d
invalid users = root

[OpenDentalData]
comment = OpenDentalData
path = /srv/OpenDental/OpenDentalData
valid users = gacq
read only = no
create mask = 0640
directory mask = 0750

smbpasswd gacq
mkdir -p /srv/OpenDental/OpenDentalData
chown gacq.users /srv/OpenDental/OpenDentalData
/etc/init.d/samba restart

==MySQL configuration==
SET PASSWORD FOR 'root'@ 'consul' = PASSWORD( '***********' )
CREATE DATABASE `consul01` ;
CREATE USER 'consul'@ '%' IDENTIFIED BY '********';
GRANT USAGE ON * . * TO 'consul'@ '%' IDENTIFIED BY '********' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
GRANT ALL PRIVILEGES ON `consul01` . * TO 'consul'@'%' WITH GRANT OPTION ;

Load database
mysql -u gacq -p opendental < opendental.sql

Enable remote connections at /etc/mysql/my.cnf commenting out
#bind-address = 127.0.0.1

/etc/init.d/mysql restart

==Apache configuration==
==Pointing Open Dental to new the server==
*Copy all file under C:\OpenDentalData to the new network share
*Import database data
*Change configuration parameter at OpenDent

==References==
*[http://freedental.forumco.com/topic~TOPIC_ID~486~SearchTerms~,.asp Another procedure]
*[http://wwww.bcdentalcare.ca Richmond Hill dentist]

=Backups=
==Scripts==
These scripts were made for Debian and Ubuntu

===mysql-Hot_Backup-One_database===
Backup one database in a compressed dump file.
For a hot backup every 30 minutes put something like this in a new file in /etc/cron.d:
MAILTO=root
*/30 * * * * root /usr/local/scripts/mysql-Hot_Backup-One_database <mysql_root_passwd> <OD_database> <directory>

and restart cron:
/etc/init.d/cron restart

===backup-system-total-consul===
Backup OD A-Z files, system config and a mySQL cold backup
Configure the script and put it in your /etc/cron.daily

=Misc=
==Download Manual==
To download full user manual and images and recreate internal links structure for off line reading use:
wget -c -t 50 -T 5 -w 1 -e robots=off -r -k -I manual,images http://www.open-dent.com/manual/toc.html

=Multiple servers=
==OpenDent to another server==
#Make backup of existing files using the backup feature in the manage module. One of those USB Flash Drives work well.
#Install OD in new server. Be sure to install as Server (includes MySQL).
#Run OD on the new server and go to the Manage module. Select the backup/restore function.
#Restore from the backup.
Very easy. You could also do it by copying the database folder (Opendental) and the A-Z folders.

==Multiple monitors==
This is how it done
#Hardware. A new dual-head video card (or add another video card to your existing computer) and 2 monitors
#You know you can open 2 (or more) OD window by just clicking at OD icon one more time, then move that new OD window to the other monitor.

=Errors=
==Security Policy==
After build the installer when you try to install Open Dent in a clean PC you get the following error:
Microsoft .NET Framework
Application attempted to perform an operation not allowed by the security policy. To grant..........
......
......
Request for the permission of type
'System.Security.Permissions.FileIOPermission, mscorlib,
Version=2.0.0.0, Culture=neutral,
PublicKeyToken=.....' failed
Details:
************** Exception Text **************
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
......
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
The action that failed was:
Demand
The type of the first permission that failed was:
System.Security.Permissions.FileIOPermission
The Zone of the assembly that failed was:
Internet

Resolutions:
*You have to execute the installer from a local drive, See this [http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=167847&SiteID=1 page]

2009-12-13T12:00:42Z

Gacq: /* Server */

=Conceptos básicos=
Una selección de textos en español sobre conceptos básicos acerca del uso de las tecnologías - Su lectura no requiere de conocimientos técnicos
*[[Conocimiento Libre]]
*[[Estandares Libres]]
*[[Software Libre]]
*[[Patentes de Software]]
*[[Servicios Privativos]]
*[[Pirateria]]
*[[DRM]]
*[[Proyecto GNU]]
*[[Copyleft]]

=Software=
==Server==
*[[Apache]]
*[[Bind]]
*[[CVS]]
*[[CUPS]]
*[[Cyrus Imap]]
*[[dhcpd]]
*[[DotProject]]
*[[drupal]]
*[[egroupware]]
*[[Fetchmail]]
*[[Flowscan]]
*[[FTP]]
*[[gallery]]
*[[GOsa]]
**[[GOsa on CentOS]]
*[[Jabberd]]
*[[Mailman]]
*[[MediaWiki]]
*[[Munin]]
*[[MySQL]]
*[[NFS]]
*[[OpenLDAP]]
*[[PostFix]]
*Pentaho
**[[Pentaho 1.7 - Base installation]]
**[[Pentaho 1.7 - CAS Integration]]
**[[Pentaho 1.7 - MySQL datasource]]
**[[Pentaho 1.7 - msSQL datasource]]
*[[ProcMail]]
*[[rdiff-backup]]
*[[rsyslog]]
*[[Samba]]
*[[SASL-LDAP]]
*[[Squid]]
**[[Chpasswd]]
*[[Squirrelmail]]
*[[SSH]]
*[[SugarCRM]]
*[[Varnish]]
*[[Xen]]
**[[Cloning a XEN VM]]
*[[Xoops]]
*[[Zabbix]]

==Desktop==
*[[aircrack]]
*[[Bash]]
*[[BitTorrent]]
*[[Eclipse]]
*[[Gaim]]
*[[gimp]]
*[[GNOME]]
*[[GnuPG]]
*[[gnuplot]]
*[[grep]]
*[[grub]]
*[[iptables]]
*[[JigDo]]
*[[kismet]]
*[[Mozilla]]
*[[Mutt]]
*[[NetworkManager]]
*[[Open Dental]]
*[[OpenSSL]]
*[[rsync]]
*[[v4l2]]
*[[Vim]]
*[[VirtualBox]]
*[[wget]]
*[[XDMCP]]
*[[XGL]]
*[[Xserver]]

==Varios==
*[[Raid por software]]
*[[Análisis de tráfico]]
*[[Monitoreo]]
*[[Comandos varios]]
*[[Filesystems]]
*[[Localizacion de pais]]
*[[Infraestructure Management]]
*[[Internet server configuration]]
*[[Maquinas Chicas]]
*[[Mail servers]]
*[[Analisis de logs]]
*[[Herramientas de diagnostico]]
*[[CDs y DVDs]]
*[[Protocolos a manopla]]
*[[System debuging]]
*[[Video]]
*[[Sonido]]
*[[Java]]
*[[Expresiones regulares]]
*[[Wake on lan]]
*[[Kernel 2.6]]
*[[Copiar directorios via tar y SSH]]
*[[Ubuntu]]
*[[Default passwords]]
*[[Antispam methods]]
*[[Consultorio Odontologico]]
*[[Maquinas virtuales]]
*[[Seguridad Informatica]]
*[[Streaming]]
*[[amavis]]
*[[Wireless]]
*[[DNS Dinamico]]
*[[Bootsplash]]
*[[Desktop]]
*[[CRM]]
*[[ERP]]
*[[Electronica]]
*[[VPN]]
*[[Suspend - Hibernate]]
*[[Virtualization]]
*[[XML]]
*[[Python]]
*[[Linux tips]]
* Debian
**[[Upgrade Debian: Etch to Lenny]]
**[[Debian]]
**[[Debian - Atlhon 64 bits]]
**[[Debian default system groups description]]
* [[Recuperar contraseña de root]]

==Software no libre==
*[[VMWare]]
*[[Windows]]
**[[Software Libre para Windows]]
**[[Migracion desde Windows]]
**[[Integracion con Windows]]
**[[Microsoft Varios]]
*SUN
**[[Solaris]]
**[[Sun One Directory Server]]
*[[Sybase]]
*[[Oracle]]
*[[Skype]]

=Hardware=
*[http://kmuto.jp/debian/hcl/ Debian GNU/Linux device driver check page]
*[[ProveedoresHardware]]
*[[Hardware roto]]
==Por tipo==
*[[ADSL]]
*[[Cable Modem]]
*[[Camaras Digitales]]
*[[FireWire]]
*[[Impresoras]]
*[[Laptops]]
*[[Modems]]
*[[Monitores]]
*[[Motherboards]]
*[[Palm]]
*[[Placas de Video]]
*[[RAID controllers]]
*[[Scanners]]
*[[WebCams]]
*[[Dispositivos wireless]]
*[[Wired network devices]]
*[[PC Power Supply]]
*[[Tablet PC]]

=Internet=
*[[Bookmarks]]
*[[Sitios web problematicos]]
*[[Dominios]]
*[[Internet Service Providers]]

=Varios=
*[[Diseño Grafico]]
*[[Temas generales]]
*[[Licencias de software]]

==Desordenado==
*[[Ordenar]]

Este Wiki esta orientado hacia temas generales relacionados con tecnologías libres, principalmente en cuanto a lo que se refiere a la administracion de sistemas, aunque también se pueden encontrar otros temas. La información puede estar desactualizada o no ser correcta, por lo que se recomienda usarla con precaución.

Cyrus - LDAP

2009-12-13T11:58:51Z

Gacq: /* /etc/default/saslauthd.conf */

= Packages =
<pre>
aptitude install cyrus-admin-2.2 cyrus-clients-2.2 cyrus-common-2.2 cyrus-doc-2.2 \
cyrus-imapd-2.2 cyrus-pop3d-2.2 cyrus-sasl2-doc libsasl2-modules libsasl2-2 \
libsasl2-modules-ldap sasl2-bin
</pre>

;Other packages
<pre>
aptitude install amavisd-new spamassassin clamav postgrey
aptitude install zoo unzip bzip2 unzoo mc nmap iftop htop
aptitude install phpldapadmin
aptitude install squirrelmail
aptitude install mailman
</pre>

= Config files =
== /etc/imapd.conf ==
<pre>
admins: cyrus
allowanonymouslogin: no
allowplaintext: yes
altnamespace: no
autocreatequota: 0
configdirectory: /var/lib/cyrus
defaultdomain: hostname.domain.com.ar
defaultpartition: default
hashimapspool: true
idlemethod: poll
idlesocket: /var/run/cyrus/socket/idle
lmtp_downcase_rcpt: yes
lmtpsocket: /var/run/cyrus/socket/lmtp
newsspool: /var/spool/news
notifysocket: /var/run/cyrus/socket/notify
partition-default: /var/spool/cyrus/mail
partition-news: /var/spool/cyrus/news
popminpoll: 0
sasl_auto_transition: no
sasl_mech_list: PLAIN LOGIN
sasl_pwcheck_method: saslauthd
sievedir: /var/spool/sieve
sieveusehomedir: false
syslog_prefix: cyrus
tls_ca_path: /etc/ssl/certs
tls_cipher_list: TLSv1+HIGH:!aNULL:@STRENGTH
tls_session_timeout: 1440
umask: 077
unixhierarchysep: yes
virtdomains: userid
#tls_ca_file: /etc/ssl/certs/server.crt
#tls_cert_file: /etc/ssl/certs/server.crt
#tls_key_file: /etc/ssl/certs/server.key
</pre>

== /etc/default/saslauthd ==
<pre>
START=yes
DESC="SASL Authentication Daemon"
NAME="saslauthd"
MECHANISMS="ldap"
MECH_OPTIONS=""
THREADS=5
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd"
</pre>

== /etc/default/saslauthd.conf ==
<pre>
ldap_servers: ldap://ldap.dominio.org.ar/
ldap_version: 3
ldap_timeout: 10
ldap_time_limit: 10
ldap_cache_ttl: 30
ldap_cache_mem: 32768
ldap_scope: sub
ldap_search_base: dc=dominio,dc=org,dc=ar
ldap_auth_method: bind
ldap_bind_dn: cn=admin,dc=dominio,dc=org,dc=ar
ldap_password: lapass
#ldap_filter: uid=%U
ldap_filter: (|(mail=%u@%d)(mail=%u)(uid=%u))
</pre>

Cyrus - LDAP

2009-12-13T11:56:42Z

Gacq: /* /etc/postfix/master.cf */

= Packages =
<pre>
aptitude install cyrus-admin-2.2 cyrus-clients-2.2 cyrus-common-2.2 cyrus-doc-2.2 \
cyrus-imapd-2.2 cyrus-pop3d-2.2 cyrus-sasl2-doc libsasl2-modules libsasl2-2 \
libsasl2-modules-ldap sasl2-bin
</pre>

;Other packages
<pre>
aptitude install amavisd-new spamassassin clamav postgrey
aptitude install zoo unzip bzip2 unzoo mc nmap iftop htop
aptitude install phpldapadmin
aptitude install squirrelmail
aptitude install mailman
</pre>

= Config files =
== /etc/imapd.conf ==
<pre>
admins: cyrus
allowanonymouslogin: no
allowplaintext: yes
altnamespace: no
autocreatequota: 0
configdirectory: /var/lib/cyrus
defaultdomain: hostname.domain.com.ar
defaultpartition: default
hashimapspool: true
idlemethod: poll
idlesocket: /var/run/cyrus/socket/idle
lmtp_downcase_rcpt: yes
lmtpsocket: /var/run/cyrus/socket/lmtp
newsspool: /var/spool/news
notifysocket: /var/run/cyrus/socket/notify
partition-default: /var/spool/cyrus/mail
partition-news: /var/spool/cyrus/news
popminpoll: 0
sasl_auto_transition: no
sasl_mech_list: PLAIN LOGIN
sasl_pwcheck_method: saslauthd
sievedir: /var/spool/sieve
sieveusehomedir: false
syslog_prefix: cyrus
tls_ca_path: /etc/ssl/certs
tls_cipher_list: TLSv1+HIGH:!aNULL:@STRENGTH
tls_session_timeout: 1440
umask: 077
unixhierarchysep: yes
virtdomains: userid
#tls_ca_file: /etc/ssl/certs/server.crt
#tls_cert_file: /etc/ssl/certs/server.crt
#tls_key_file: /etc/ssl/certs/server.key
</pre>

== /etc/default/saslauthd ==
<pre>
START=yes
DESC="SASL Authentication Daemon"
NAME="saslauthd"
MECHANISMS="ldap"
MECH_OPTIONS=""
THREADS=5
OPTIONS="-c -m /var/spool/postfix/var/run/saslauthd"
</pre>

== /etc/default/saslauthd.conf ==
<pre>
ldap_servers: ldap://127.0.0.1/
ldap_version: 3
ldap_timeout: 10
ldap_time_limit: 10
ldap_cache_ttl: 30
ldap_cache_mem: 32768
ldap_scope: sub
ldap_search_base: ou=people,dc=dominio,dc=com,dc=ar
ldap_auth_method: bind
ldap_bind_dn: cn=System Administrator,ou=people,dc=dominio,dc=com,dc=ar
ldap_password: lapass
ldap_filter: uid=%U
ldap_password_attr: sambaLMPassword
</pre>