Olvide mi contrasenã de Mysql

Mirar
http://www.debian-administration.org/articles/442

Instalando REDMINE en Windows XP (Configuracion de Email)

Email Configuration

• Email Configuration
  • Configuration Directives
    • authentication
    • delivery_method
      • Asynchronous delivery_methods
  • Example configuration.yml Configurations
    • Simple Login Authentication (default settings)
    • No Authentication
    • Using sendmail command
  • More information

Configuration Directives

This page is a work in progress, the following configuration directives are only a partial list.

authentication

The type of authentication method expected by your service provider.
Valid settings:

• :login
• :none

(note: if you set this to :none, you must not include the user_name and password settings)

delivery_method

The mail transport method to be used.
Valid settings:

• :smtp
• :async_smtp - valid in trunk/0.9+ only
• :sendmail
• :async_sendmail - valid in trunk/0.9+ only

Asynchronous delivery_methods

The :async_smtp and :async_sendmail use asynchronous sends, which means Redmine does not wait for the email to be sent to display the next page. See Asynchronous Email Delivery for more details.

Example configuration.yml Configurations

Simple Login Authentication (default settings)

# Outgoing email settings

production:
  delivery_method: :smtp
  smtp_settings:
    address: smtp.example.net
    port: 25
    domain: example.net
    authentication: :login
    user_name: redmine@example.net
    password: redmine

development:
  delivery_method: :smtp
  smtp_settings:
    address: 127.0.0.1
    port: 25
    domain: example.net
    authentication: :login
    user_name: redmine@example.net
    password: redmine

If you want to use GMail/Google Apps and other TLS-requiring SMTP servers, you'll have to add some TLS-related settings :

production:
  delivery_method: :smtp
  smtp_settings:
    tls: true
    enable_starttls_auto: true
    address: "smtp.gmail.com" 
    port: '587'
    domain: "smtp.gmail.com" 
    authentication: :plain
    user_name: "your_email@gmail.com" 
    password: "your_password" 

However, this will only work with "recent" enough ruby and rails versions (1.8.7 patchset 2xx and 2.3.5).
(See #5814 )

No Authentication

Example for an SMTP service provider with no authentication. Note the colon before none.

production:
  delivery_method: :smtp
  smtp_settings:
    address: smtp.knology.net
    port: 25
    domain: cybersprocket.com
    authentication: :none

Using sendmail command

Example for a unix system that uses the /usr/sbin/sendmail command.

production:
  delivery_method: :sendmail

Instalando REDMINE en Windows XP

REQUERIMIENTOS
- Se necesita Rake, que está escrito en Ruby, por lo que toca instalar ambos (depende de las versiones, puesto que hay muchas que no se pueden usar juntas porque no las interpreta de manera correcta):

Instale primero Ruby haciendo clic aqui. (nota: redmine no funciona con versiones de ruby superiores a 1.8.x.x). Luego de instalado, en la consola escriba             gem install rails para instalar RAILS. Luego, de la misma forma, installar RACK gem install rack -v=1.1.0 finalmente, de la misma forma, installar Rake gem install rake   Tambièn instalar Mongrel, escribiendo en la consola de Ruby   “gem install mongrel"

Finalmente, instalar mysql dentro de Ruby

gem install mysql

En algunos casos, es necesario instalar lo siguiente:                                                              gem install i18n -v=0.4.2 Base de Datos Se pueden usar las siguientes bases de datos: MySQL 5.0 or higher (recommended) make sure to install the C bindings for Ruby that dramatically improve performance.  You can get them by running gem install mysql. If you have problem installing the mysql gem refer Rails Wiki pages PostgreSQL 8 make sure your database datestyle is set to ISO (Postgresql default setting).  You can set it using: ALTER DATABASE "redmine_db" SET datestyle="ISO,MDY"; some bugs in PostgreSQL 8.4.0 and 8.4.1 affect Redmine behavior (#4259, #4314),  they are fixed in PostgreSQL 8.4.2 make sure to install the PosgreSQL adapter for Ruby. You can get it by running(one of the following): gem install postgres-pr (native Ruby implementation no more actively maintained by its author, presents issues with 9.x) gem install pg (works with SSL connections, may need development libraries/packages for your OS before it will compile) Ubuntu OS: development libraries can be installed with (or similar): sudo aptitude install libdbd-pg-ruby1.8 SQLite 3 PROCEDIMIENTO DE INSTALACIÓN Descargar Redmine de aqui Cree 3 bases de datos llamada redmine, redmine-developer, redmine-test, por ejemplo.  para MYSQL se usaran los siguientes comandos create database redmine character set utf8; create user 'redmine'@'localhost' identified by 'my_password'; grant all privileges on redmine.* to 'redmine'@'localhost'; 3. Extraer Redmine en una nueva carpeta creada en Ruby, llamada apps, por ejemplo.  C:\Ruby187\apps\ 4. En la carpeta C:\Ruby187\apps\redmine-1.2.1\config, copiar el archivo database.yml.example y llamarlo database.yml, y editar las propiedades: Para MYSQL, modificar las siguientes lineas (segun el nombre de usuario y contraseña que le hayamos dado) production: adapter: mysql database: redmine host: localhost username: redmine password: my_password   Hacer lo mismo con las otras dos bases de datos (developer y test) Si el servidor no está corriendo en el puerto por defecto (3306),use esta configuracion:   production: adapter: mysql database: redmine host: localhost port: 3307 (o puerto que esté configurado) username: redmine password: my_password   4. Instalar unidad de pruebas en Ruby, por si no la tiene, con el siguiente comando: gem install test-unit    5. En algunos casos, es necesario pegar la libreria libmysql.dll el la carpeta de ruby/bin haciendo click acá   6. Ahora, dentro de la carpeta de Redmine pegada en la de Ruby (escribir en la consola cd carpetaRedmine/), escribir en la consola:   “rake db:migrate“ 7.Si está usando Redmine v0.8.7 o versiones posteriores, colocar en la consola   “rake generate_session_store”    8. Probar el servidor con Mongrel o con Webrick   Con Webrick   "ruby script/server webrick -e production " Con Mongrel “mongrel_rails start“ Y probar en el navegador http://localhost:[port]/ , donde [port] es el puerto en el que abre el servidor (por lo general 3000). Se debe abrir la página principal de Redmine. Use la cuenta de administrador por defecto para ingresar: login: admin password: admin You can go to Admin & Settings to modify application settings.   At the command prompt: “gem install win32-service“ At the command prompt: “gem install mongrel_service“ Install Redmine as a Windows service, at the command prompt: “mongrel_rails service::install -N Redmine -c [your redmine folder] -p [portno] -e production“, replacing [your redmine folder] with the full path to the Redmine folder in the filesystem, and the [portno] being the port you’d like redmine to server on, e.g. 80 for standard http port 80. If at any time you wish to remove the Redmine windows service (uninstall), you can enter “mongrel_rails service::remove -N Redmine” at the command prompt to remove it.

Configuring analog tv card KWORLD

Look at this: http://www.ubuntu-es.org/node/76276
translation soon!

Finally I could configure my tv card (KWORLD PCI ANALOG TV CARD LITE - PVR-TV 7134SE)http://www.ubuntu-es.org/node/92224

THE THING IS TO FIND THE PERFECT COMBINATION BETWEEN TUNER AND CARD.... IT DEPENDS ON THE TYPE OF TV CARD YOU HAVE, SO.... THIS ONE WORKED FOR ME:

1. La tarjeta Terminator fue fácil de configurar:
Para estar seguro que es la tarjeta en Terminator puede usarse el comando desde la consola:

$ lspci | grep Multimedia

y retorna:

Multimedia controller: Philips Semiconductors SAA7133/SAA7135 Video Broadcast Decoder (rev d0)

Para configurar la tarjeta con los parámetros adecuados se edita el archivo de opciones con la orden desde la consola:

$ sudo gedit /etc/modprobe.d/options

y se agrega la siguiente linea al final del archivo:

options saa7134 card=65 tuner=54

Puedes instalar tvtime.
Se reinicia y listo.

---

2. Por mucho tiempo no pude configurar mi capturadora Kworld de TV, lo intente desde que tenia Gutsy (ahora tengo felizmente Hardy) pero la solución no la encontraba aunque hay varias páginas donde aparecen soluciones para tarjetas con chip Philips SAA713x. Como lo pueden imaginar para mi era frustrante que en mi nuevo equipo no tuviese TV y el que estaba heredando a mi hijo funcionaba de lujo, por otro lado me encanta encanta editar vídeos con cinelerra.
Como podrán darse cuenta el método de solución es exactamente el mismo que describí anteriormente, lo que no encontraba era los parámetros correctos de card y tuner. Aunque en varias partes aparece la lista de hardware soportado, e indican que se puede desmontar y montar los parámetros con:

$ sudo modprobe -r saa7134_alsa
$ sudo modprobe -r saa7134
$ sudo modprobe saa7134 card=63 tuner=47

para luego probar si sirve con tvtime, esto no es aconsejable pues por alguna razón no carga los módulos requeridos y uno podría descartar la combinación triunfadora(en nuestro caso card=63 tuner=47).
Y ahora sí manos a la obra:
Para estar seguro que es la tarjeta Kworld que describo puede usar el comando desde la consola:

$ lspci | grep Multimedia

y retorna:

07:02.0 Multimedia controller: Philips Semiconductors SAA7134/SAA7135HL Video Broadcast Decoder (rev 01)

Para configurar la tarjeta con los parámetros adecuados se edita el archivo de opciones con la orden desde la consola:

$ sudo gedit /etc/modprobe.d/options

y se agrega la siguiente linea al final del archivo:

options saa7134 card=63 tuner=47

Puedes instalar tvtime.
Hasta aquí valdría la pena ver si funciona la configuración reiniciando el sistema, y corriendo tvtime, tal vez sin sonido, para resolver esto solo un pequeño "truco hardware"(ja,ja,ja): conecte los parlantes a la salida de la tarjeta capturadora y listo, el defecto que queda con este método es que no puedo controlar el volumen hasta momento.
Otra posible solución para el sonido podría ser utilizar un cable con conectores "machos", para conectar la salida de sonido de la tarjeta capturadora con una de las entradas de la tarjeta de sonido (Puede usar la entrada del microfono o Line In, en teoría podría tener controlar el volumen). Creo que también se puede usar el comando arecord para hacerlo a nivel software.
Invito a los que tengan tarjetas de Tv a postear la salida del comando lspci | grep Multimedia y los parámetros card y tuner que están usando, de esta manera ayudar a configurar a los que todavía no han podido.
Saludos.
PD: Sé que lo que presento aquí no es nada innovador pero en verdad no encontré los parámetros adecuados en otros post, ni en páginas especializadas. Me gustaría tener opiniones de como puedo mejorar la configuración de esta tarjeta.
PD: Por el momento sólo me queda un problema de Hardware configurar la impresora Lexmark z1320, que la reconoce ubuntu pero no tiene drives para poder imprimir, por el momento imprimo desde una maquina virtual con el Inombrable...Bueno pero esa es otra historia para mi bitácora...
PD: Adjunto los archivos de configuración de tvtime que se encuentran en el directorio oculto .tvtime:
Archivo tvtime.xml:

<?xml version="1.0"?>
<!DOCTYPE tvtime PUBLIC "-//tvtime//DTD tvtime 1.0//EN" "http://tvtime.sourceforge.net/DTD/tvtime1.dtd">
<tvtime xmlns="http://tvtime.sourceforge.net/DTD/">
  <option name="WideScreen" value="0"/>
  <option name="DefaultBrightness" value="-1"/>
  <option name="DefaultContrast" value="-1"/>
  <option name="DefaultSaturation" value="-1"/>
  <option name="DefaultHue" value="-1"/>
  <option name="PrevChannel" value="50"/>
  <option name="Channel" value="50"/>
  <option name="FramerateMode" value="0"/>
  <option name="OverScan" value="3.5"/>
  <option name="CheckForSignal" value="1"/>
  <option name="AudioBoost" value="90"/>
  <option name="AlwaysOnTop" value="0"/>
  <option name="QuietScreenshots" value="0"/>
  <option name="UnmuteVolume" value="23387"/>
  <option name="Muted" value="1"/>
  <option name="V4LInput" value="1"/>
  <option name="V4LDevice" value="/dev/video2"/>
  <option name="VBIDevice" value="/dev/dsp"/>
  <option name="AudioMode" value="stereo"/>
  <option name="PalDKMode" value="0"/>
  <option name="FullScreen" value="0"/>
  <option name="Norm" value="NTSC"/>
</tvtime>

card=0 *** UNKNOWN/GENERIC ***
card=1 MIRO PCTV
card=2 Hauppauge (bt848)
card=3 STB, Gateway P/N 6000699 (bt848)
card=4 Intel Create and Share PCI/ Smart Video Recorder III
card=5 Diamond DTV2000
card=6 AVerMedia TVPhone
card=7 MATRIX-Vision MV-Delta
card=8 Lifeview FlyVideo II (Bt848) LR26 / MAXI TV Video PCI2 LR26
card=9 IMS/IXmicro TurboTV
card=10 Hauppauge (bt878) [0070:13eb,0070:3900,2636:10b4]
card=11 MIRO PCTV pro
card=12 ADS Technologies Channel Surfer TV (bt848)
card=13 AVerMedia TVCapture 98 [1461:0002,1461:0004,1461:0300]
card=14 Aimslab Video Highway Xtreme (VHX)
card=15 Zoltrix TV-Max [a1a0:a0fc]
card=16 Prolink Pixelview PlayTV (bt878)
card=17 Leadtek WinView 601
card=18 AVEC Intercapture
card=19 Lifeview FlyVideo II EZ /FlyKit LR38 Bt848 (capture only)
card=20 CEI Raffles Card
card=21 Lifeview FlyVideo 98/ Lucky Star Image World ConferenceTV LR50
card=22 Askey CPH050/ Phoebe Tv Master + FM [14ff:3002]
card=23 Modular Technology MM201/MM202/MM205/MM210/MM215 PCTV, bt878 [14c7:0101]
card=24 Askey CPH05X/06X (bt878) [many vendors] [144f:3002,144f:3005,144f:5000,14ff:3000]
card=25 Terratec TerraTV+ Version 1.0 (Bt848)/ Terra TValue Version 1.0/ Vobis TV-Boostar
card=26 Hauppauge WinCam newer (bt878)
card=27 Lifeview FlyVideo 98/ MAXI TV Video PCI2 LR50
card=28 Terratec TerraTV+ Version 1.1 (bt878) [153b:1127,1852:1852]
card=29 Imagenation PXC200 [1295:200a]
card=30 Lifeview FlyVideo 98 LR50 [1f7f:1850]
card=31 Formac iProTV, Formac ProTV I (bt848)
card=32 Intel Create and Share PCI/ Smart Video Recorder III
card=33 Terratec TerraTValue Version Bt878 [153b:1117,153b:1118,153b:1119,153b:111a,153b:1134, 153b:5018]
card=34 Leadtek WinFast 2000/ WinFast 2000 XP [107d:6606,107d:6609,6606:217d,f6ff:fff6]
card=35 Lifeview FlyVideo 98 LR50 / Chronos Video Shuttle II [1851:1850,1851:a050]
card=36 Lifeview FlyVideo 98FM LR50 / Typhoon TView TV/FM Tuner [1852:1852]
card=37 Prolink PixelView PlayTV pro
card=38 Askey CPH06X TView99 [144f:3000,144f:a005,a04f:a0fc]
card=39 Pinnacle PCTV Studio/Rave [11bd:0012,bd11:1200,bd11:ff00,11bd:ff12]
card=40 STB TV PCI FM, Gateway P/N 6000704 (bt878), 3Dfx VoodooTV 100 [10b4:2636,10b4:2645,121a:3060]
card=41 AVerMedia TVPhone 98 [1461:0001,1461:0003]
card=42 ProVideo PV951 [aa0c:146c]
card=43 Little OnAir TV
card=44 Sigma TVII-FM
card=45 MATRIX-Vision MV-Delta 2
card=46 Zoltrix Genie TV/FM [15b0:4000,15b0:400a,15b0:400d,15b0:4010,15b0:4016]
card=47 Terratec TV/Radio+ [153b:1123]
card=48 Askey CPH03x/ Dynalink Magic TView
card=49 IODATA GV-BCTV3/PCI [10fc:4020]
card=50 Prolink PV-BT878P+4E / PixelView PlayTV PAK / Lenco MXTV-9578 CP
card=51 Eagle Wireless Capricorn2 (bt878A)
card=52 Pinnacle PCTV Studio Pro
card=53 Typhoon TView RDS + FM Stereo / KNC1 TV Station RDS
card=54 Lifeview FlyVideo 2000 /FlyVideo A2/ Lifetec LT 9415 TV [LR90]
card=55 Askey CPH031/ BESTBUY Easy TV
card=56 Lifeview FlyVideo 98FM LR50 [a051:41a0]
card=57 GrandTec Grand Video Capture (Bt848) [4344:4142]
card=58 Askey CPH060/ Phoebe TV Master Only (No FM)
card=59 Askey CPH03x TV Capturer
card=60 Modular Technology MM100PCTV
card=61 AG Electronics GMV1 [15cb:0101]
card=62 Askey CPH061/ BESTBUY Easy TV (bt878)
card=63 ATI TV-Wonder [1002:0001]
card=64 ATI TV-Wonder VE [1002:0003]
card=65 Lifeview FlyVideo 2000S LR90
card=66 Terratec TValueRadio [153b:1135,153b:ff3b]
card=67 IODATA GV-BCTV4/PCI [10fc:4050]
card=68 3Dfx VoodooTV FM (Euro) [10b4:2637]
card=69 Active Imaging AIMMS
card=70 Prolink Pixelview PV-BT878P+ (Rev.4C,8E)
card=71 Lifeview FlyVideo 98EZ (capture only) LR51 [1851:1851]
card=72 Prolink Pixelview PV-BT878P+9B (PlayTV Pro rev.9B FM+NICAM) [1554:4011]
card=73 Sensoray 311 [6000:0311]
card=74 RemoteVision MX (RV605)
card=75 Powercolor MTV878/ MTV878R/ MTV878F
card=76 Canopus WinDVR PCI (COMPAQ Presario 3524JP, 5112JP) [0e11:0079]
card=77 GrandTec Multi Capture Card (Bt878)
card=78 Jetway TV/Capture JW-TV878-FBK, Kworld KW-TV878RF [0a01:17de]
card=79 DSP Design TCVIDEO
card=80 Hauppauge WinTV PVR [0070:4500]
card=81 IODATA GV-BCTV5/PCI [10fc:4070,10fc:d018]
card=82 Osprey 100/150 (878) [0070:ff00]
card=83 Osprey 100/150 (848)
card=84 Osprey 101 (848)
card=85 Osprey 101/151
card=86 Osprey 101/151 w/ svid
card=87 Osprey 200/201/250/251
card=88 Osprey 200/250 [0070:ff01]
card=89 Osprey 210/220/230
card=90 Osprey 500 [0070:ff02]
card=91 Osprey 540 [0070:ff04]
card=92 Osprey 2000 [0070:ff03]
card=93 IDS Eagle
card=94 Pinnacle PCTV Sat [11bd:001c]
card=95 Formac ProTV II (bt878)
card=96 MachTV
card=97 Euresys Picolo
card=98 ProVideo PV150 [aa00:1460,aa01:1461,aa02:1462,aa03:1463,aa04:1464, aa05:1465,aa06:1466,aa07:1467]
card=99 AD-TVK503
card=100 Hercules Smart TV Stereo
card=101 Pace TV & Radio Card
card=102 IVC-200 [0000:a155,0001:a155,0002:a155,0003:a155,0100:a155, 0101:a155,0102:a155,0103:a155]
card=103 Grand X-Guard / Trust 814PCI [0304:0102]
card=104 Nebula Electronics DigiTV [0071:0101]
card=105 ProVideo PV143 [aa00:1430,aa00:1431,aa00:1432,aa00:1433,aa03:1433]
card=106 PHYTEC VD-009-X1 MiniDIN (bt878)
card=107 PHYTEC VD-009-X1 Combi (bt878)
card=108 PHYTEC VD-009 MiniDIN (bt878)
card=109 PHYTEC VD-009 Combi (bt878)
card=110 IVC-100 [ff00:a132]
card=111 IVC-120G
card=112 pcHDTV HD-2000 TV [7063:2000]
card=113 Twinhan DST + clones [11bd:0026,1822:0001,270f:fc00,1822:0026]
card=114 Winfast VC100 [107d:6607]
card=115 Teppro TEV-560/InterVision IV-560
card=116 SIMUS GVC1100 [aa6a:82b2]
card=117 NGS NGSTV+
card=118 LMLBT4
card=119 Tekram M205 PRO
card=120 Conceptronic CONTVFMi
card=121 Euresys Picolo Tetra [1805:0105,1805:0106,1805:0107,1805:0108]
card=122 Spirit TV Tuner
card=123 AVerMedia AVerTV DVB-T 771 [1461:0771]
card=124 AverMedia AverTV DVB-T 761 [1461:0761]
card=125 MATRIX Vision Sigma-SQ
card=126 MATRIX Vision Sigma-SLC
card=127 APAC Viewcomp 878(AMAX)
card=128 DViCO FusionHDTV DVB-T Lite [18ac:db10,18ac:db11]
card=129 V-Gear MyVCD
card=130 Super TV Tuner
Valores de tuner:
tuner=0 - Temic PAL (4002 FH5)
tuner=1 - Philips PAL_I (FI1246 and compatibles)
tuner=2 - Philips NTSC (FI1236,FM1236 and compatibles)
tuner=3 - Philips (SECAM+PAL_BG) (FI1216MF, FM1216MF, FR1216MF)
tuner=4 - NoTuner
tuner=5 - Philips PAL_BG (FI1216 and compatibles)
tuner=6 - Temic NTSC (4032 FY5)
tuner=7 - Temic PAL_I (4062 FY5)
tuner=8 - Temic NTSC (4036 FY5)
tuner=9 - Alps HSBH1
tuner=10 - Alps TSBE1
tuner=11 - Alps TSBB5
tuner=12 - Alps TSBE5
tuner=13 - Alps TSBC5
tuner=14 - Temic PAL_BG (4006FH5)
tuner=15 - Alps TSCH6
tuner=16 - Temic PAL_DK (4016 FY5)
tuner=17 - Philips NTSC_M (MK2)
tuner=18 - Temic PAL_I (4066 FY5)
tuner=19 - Temic PAL* auto (4006 FN5)
tuner=20 - Temic PAL_BG (4009 FR5) or PAL_I (4069 FR5)
tuner=21 - Temic NTSC (4039 FR5)
tuner=22 - Temic PAL/SECAM multi (4046 FM5)
tuner=23 - Philips PAL_DK (FI1256 and compatibles)
tuner=24 - Philips PAL/SECAM multi (FQ1216ME)
tuner=25 - LG PAL_I+FM (TAPC-I001D)
tuner=26 - LG PAL_I (TAPC-I701D)
tuner=27 - LG NTSC+FM (TPI8NSR01F)
tuner=28 - LG PAL_BG+FM (TPI8PSB01D)
tuner=29 - LG PAL_BG (TPI8PSB11D)
tuner=30 - Temic PAL* auto + FM (4009 FN5)
tuner=31 - SHARP NTSC_JP (2U5JF5540)
tuner=32 - Samsung PAL TCPM9091PD27
tuner=33 - MT20xx universal
tuner=34 - Temic PAL_BG (4106 FH5)
tuner=35 - Temic PAL_DK/SECAM_L (4012 FY5)
tuner=36 - Temic NTSC (4136 FY5)
tuner=37 - LG PAL (newer TAPC series)
tuner=38 - Philips PAL/SECAM multi (FM1216ME MK3)
tuner=39 - LG NTSC (newer TAPC series)
tuner=40 - HITACHI V7-J180AT
tuner=41 - Philips PAL_MK (FI1216 MK)
tuner=42 - Philips FCV1236D ATSC/NTSC dual in
tuner=43 - Philips NTSC MK3 (FM1236MK3 or FM1236/F)
tuner=44 - Philips 4 in 1 (ATI TV Wonder Pro/Conexant)
tuner=45 - Microtune 4049 FM5
tuner=46 - Panasonic VP27s/ENGE4324D
tuner=47 - LG NTSC (TAPE series)
tuner=48 - Tenna TNF 8831 BGFF)
tuner=49 - Microtune 4042 FI5 ATSC/NTSC dual in
tuner=50 - TCL 2002N
tuner=51 - Philips PAL/SECAM_D (FM 1256 I-H3)
tuner=52 - Thomson DTT 7610 (ATSC/NTSC)
tuner=53 - Philips FQ1286
tuner=54 - tda8290+75
tuner=55 - TCL 2002MB
tuner=56 - Philips PAL/SECAM multi (FQ1216AME MK4)
tuner=57 - Philips FQ1236A MK4
tuner=58 - Ymec TVision TVF-8531MF/8831MF/8731MF
tuner=59 - Ymec TVision TVF-5533MF
tuner=60 - Thomson DTT 761X (ATSC/NTSC)
tuner=61 - Tena TNF9533-D/IF/TNF9533-B/DF
tuner=62 - Philips TEA5767HN FM Radio
tuner=63 - Philips FMD1216ME MK3 Hybrid Tuner
tuner=64 - LG TDVS-H06xF
tuner=65 - Ymec TVF66T5-B/DFF
tuner=66 - LG TALN series
tuner=67 - Philips TD1316 Hybrid Tuner
tuner=68 - Philips TUV1236D ATSC/NTSC dual in
tuner=69 - Tena TNF 5335 and similar models
tuner=70 - Samsung TCPN 2121P30A
tuner=71 - Xceive xc3028
tuner=72 - Thomson FE6600
tuner=73 - Samsung TCPG 6121P30A
tuner=75 - Philips TEA5761 FM Radio

Installing Joomla 1.5.x.x and Xampp 1.7 on Ubuntu 11.04

XAMPP
1. Download Xampp de Apache Friends.
2.  After downloading simply type in the following commands:

1. Go to a Linux shell and login as the system administrator root and Extract the downloaded archive file to /opt: sudo tar xvfz xampp-linux-1.7.4.tar.gz -C /opt 
   
   Warning: Please use only this command to install XAMPP. DON'T use any Microsoft Windows tools to extract the archive, it won't work. 
   Warning 2: already installed XAMPP versions get overwritten by this command

That's all. XAMPP is now installed below the /opt/lampp directory.

3. Start Xampp

To start XAMPP simply call this command: /opt/lampp/lampp start
You should now see something like this on your screen:
Starting XAMPP 1.7.4...
LAMPP: Starting Apache...
LAMPP: Starting MySQL...
LAMPP started.

Ready. Apache and MySQL are running.
If you get any error messages please take a look at the Linux FAQ.

4. Test Xampp
OK, that was easy but how can you check that everything really works? Just type in the following URL at your favourite web browser:
http://localhost
Now you should see the start page of XAMPP containing some links to check the status of the installed software and some small programming examples.

 

5. Start and Stop Parameters

START AND STOP PARAMETERS
Parameter	Description
start	Starts XAMPP.
stop	Stops XAMPP.
restart	Stops and starts XAMPP.
startapache	Starts only the Apache.
startssl	Starts the Apache SSL support. This command activates the SSL support permanently, e.g. if you restarts XAMPP in the future SSL will stay activated.
startmysql	Starts only the MySQL database.
startftp	Starts the ProFTPD server. Via FTP you can upload files for your web server (user "nobody", password "lampp"). This command activates the ProFTPD permanently, e.g. if you restarts XAMPP in the future FTP will stay activated.
stopapache	Stops the Apache.
stopssl	Stops the Apache SSL support. This command deactivates the SSL support permanently, e.g. if you restarts XAMPP in the future SSL will stay deactivated.
stopmysql	Stops the MySQL database.
stopftp	Stops the ProFTPD server. This command deactivates the ProFTPD permanently, e.g. if you restarts XAMPP in the future FTP will stay deactivated.
security	Starts a small security check programm.

For example: To start Apache with SSL support simply type in the following command (as root):

/opt/lampp/lampp startssl

You can also access your Apache server via SSL under https://localhost.

Reference: http://www.apachefriends.org/en/xampp-linux.html


MySQL Admin
1. Go to Ubuntu Software Center and look for "My SQL Administrator" in the text area of Get Software.

2.  Click on Install, and that's pretty much it.
3. To run mysql, you have to, first, open Xampp.
4. After that, you should check if the Server Host-name is 127.0.0.1 or localhost (in case your doing it local). That's because, although it sounds lame, I had so much trouble with that installing Joomla. The username is root, and leave blank the password. Click on connect.
5. If everything goes ok, it should appear a window wich says that the server is running. If it doesn't, check again that xampp is ok and the hostname is the right one.
 

JOOMLA 
1. Download Joomla Spanish For English version, click here.
2. Unpack the downloaded file in a console:
    sudo tar xvfz Joomla_1.5.23-Spanish-pack_completo.tar.gz

3. Enter to the lampp file as root, with
       sudo nautilus
4. Go to 
     opt/lampp/htdocs/
    and paste the unpacked files in a new folder called "whatever you like". The new route would be something like 
     opt/lampp/htdocs/joomla
being joomla the name that I gave to the new folder and where I pasted the unpacked files from Joomla 1.5.23.

5. Now we go to the web browser, and type:
http://localhost/joomla
it means that you have to type localhost/ and the name of the folder that you gave in the previous step, to start the installation part. 
Note: remember to start xammp before doing this.

6. It should appear the first page of the installation, and it asks us to choose the language. Next, it appears the Pre-installation Check page, and it show us that the configuration file (configuration.php) appears with error, because it isn't writeable.
To change that, we're going to change the permissions to the folder lampp, because in the installation part, Joomla creates the file called configuration.php and needs to have root permissions. So, in a console, we type

sudo chmod 777 -R /opt/lampp/htdocs/joomla
That should give total permissions to the file and to everything that inside of it.

7. Now, coming back to the installation page, we click next, and we have to fill the database configuration data. 
hostname: localhost or 127.0.0.1 (whichever works for your pc).
username: root
password: NO PASSWORD, leave it blank.
database name: mydatabase
And click next.  
Note: If it doesnt appear normal, it means, after click next it shows you an error kind of "You have an error in your SQL syntax; check the manual that corresponds..." or something like that, you should do the next: 
open a console, type
sudo nautilus
go to opt/lampp/htdocs/joomla/installation/sql/mysql
 and open the file joomla.sql
replace everything that says  TYPE=MyISAM CHARACTER SET `utf8`; with ENGINE=MyISAM CHARACTER SET `utf8`;
It should work. 
8. in the FTP configuration, don't fill anything and click next.
9. In main configuration, type the Name of the site, an e-mail, a password that you remember for the administration part, and next. It appears a window that says something like it's not going to create sample files, but it's ok, you should click next. 
10. Finally, it says that you Finish, but, it remembers you that you should erase the Installation folder. If everything went well, the configuration.php file must be created on the httdocs/joomla file. If it's not,  you have to create it manually inside this route, with the name of configuration.php and the lines that shows the Finish page of the installation part. 
11. Before going to the http://localhost/joomla to check that actually works, we should do this:
in a console, type

sudo gedit /opt/lampp/etc/php.ini

look for the line that says 
error_reporting = E_ALL | E_STRICT and replace it for error_reporting = E_ALL & ~E_NOTICE

Restart  xammp in the console with

sudo /opt/lammp/lammp restart

 
and now, you can go to the web browser and check the main page of joomla http://localhost/joomla (remember to replace joomla for the name that you gave to the folder inside lampp).
It should appear the welcome page of Joomla. 


I hope this works. ;)