windows, ruby on rails, sqlite3

---

Download Ruby from:
http://www.ruby-lang.org/es/downloads/

binarios compilados
ftp://ftp.ruby-lang.org/pub/ruby/binaries/mswin32/ruby-1.8.6-i386-mswin32.zip

UnZip:
C:\ruby

PATH=%PATH%;C:\ruby\bin

Download RubyGems from:
http://rubygems.rubyforge.org

http://rubyforge.org/frs/download.php/45906/rubygems-1.3.1.zip

UnZip:
C:\rubygems-1.3.1

C:\rubygems-1.3.1>ruby setup.rb

C:\gem install rails --include-dependencies

Problemas No Encuentra Esto:
zlib.dll
SSLEAY32.dll

A otra cosa,

Eliminar
C:\ruby

Eliminar
C:\rubygems-1.3.1

---

Ahora con One-Click Installer:

http://rubyforge.org/frs/download.php/18566/ruby186-25.exe

C:>gem install rails --include-dependencies

---

C:>mkdir src
C:>cd src
C:\src>mkdir work
C:\src>cd work
C:\src\work>rails demo
C:\src\work>cd demo
C:\src\work\demo>ruby script\server

Rails requires RubyGems >= 1.1.1 (you have 0.9.2). Please `gem update --system`
and try again.

C:\src\work\demo>gem update --system

C:\src\work\demo>ruby script\server

http://localhost:3000/

---

no such file to load -- sqlite3

http://www.sqlite.org/download.html

UnZip and Copy:
C:\ruby\bin\sqlite3.exe

C:\>gem install sqlite3-ruby
checking for fdatasync() in rt.lib... no


from http://groups.google.com/group/comp.lang.ruby/browse_thread/thread/9d5c9ee6167dace4
http://www.sqlite.org/download.html

UnZip and Copy:
C:\ruby\bin\sqlite3.dll
C:\ruby\bin\sqlite3.def

C:\>gem install sqlite3-ruby
checking for fdatasync() in rt.lib... no

from http://www.nabble.com/Beginner-help:-Problem-installing-sqlite3-on-Windows-XP-td19200418.html
Jim Carter

C:\>gem install --version 1.2.3 sqlite3-ruby

http://localhost:3000/rails/info/properties
Perfecto!!!

---

debian, lenny, virtualbox, amd64

---

from http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=502375
thanks to Daniel Baumann

#apt-get update

#apt-get upgrade

#apt-get install virtualbox

#vi /etc/group
...
vboxusers:x:114:maximilianou
...

#apt-get install virtualbox-ose-source

#m-a a-i virtualbox-ose

Restart the system

#modprobe vboxdrv

---

debian, lenny, amd64, mysql

---

Installing MySql Server and Client:

#apt-get install mysql-server

---

#netstat -tap |grep mysql

---

#mysqladmin -u root password xxxx

---

#mysql -u root -p
password:xxxx
mysql>quit

---

Creating a Database and User

MySql Information Schema
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
http://www.xcdsql.org/Misc/MySQL_INFORMATION_SCHEMA.html

#mysql -u root -p
password:xxxx
mysql>create database mvcdb;
mysql>grant all privileges on mvcdb.* to 'mvcuser'@'%' identified by 'mvcuser';
mysql>use mysql;
mysql>show tables;
mysql>select host, user, password from user where user like 'mvcuser%';
mysql>use information_schema;
mysql>show tables;
mysql>select * from user_privileges where grantee like "'mvcuser%'";

---

$mysql -u mvcuser, runs well
but i want
$mysql -u mvcuser -p, and this is not running well
now reading..

---

Reading Agile Web Development with Rails

---

Api installed documentation
use RubyGems to install rails.
$gem help server
$gem server
http://localhost:8808/

---

Agile Manifesto

Source: agilemanifesto.org

I have to remember this:

. Individuals and Interactions over processes and tools.
. Working Software over comprehensive documentation.
. Customer Collaboration over contract negotiation.
. Responding to Change over following a plan.

C#, Existent DataGridView, Add Column

---

Una vez que tenemos las rutas visibles en el DockPanel, y todo funciona perfectamente. Vamos a sumar el campo de Grupo a las rutas.
Pasos para recordar y en un futuro agregado no quedar en el camino.

---

1. Agragar la columna en la base:

ALTER TABLE RUTAS
ADD GRUPO_NOMBRE VARCHAR(50)

---

2. Re-Generar el DataSource en el "RUTASDS.xsd"
.Ir al Solution Explorer > LocalDatasets.DataSources.RUTASDS DobleClick
.Seleccionar el Query GetDataByRutasVisibles() ClickDerecho Properties
.Salvar en un NotePad el CommandText
.SELECT "ID_RUTA", "RUTA_NOMBRE", "RUTA_VISIBLE", "RUTA_COLOR", "GRUPO_NOMBRE" FROM "RUTAS" WHERE RUTA_VISIBLE = 1
.Ir al Solution Explorer > LocalDatasets.Datasources.RUTASDS BORRAR
.Ir al Panel DataSources > ClickDerecho > Add New DataSource
.Crear por default el DataSouces RUTASDS con la tabla Rutas > Finish
.RUTASDS.xsd > RUTASTableAdapter ClickDerecho > Add Query > Use SQL statements >
Select which returns rows > Pegar el Query
SELECT "ID_RUTA", "RUTA_NOMBRE", "RUTA_VISIBLE", "RUTA_COLOR", "GRUPO_NOMBRE" FROM "RUTAS" WHERE RUTA_VISIBLE = 1

---

3. Re-Generar el DataSource de "Object DataSource del DataGridView"
.Build Solution
.Select DockRutas.cs > DataGridView Click > ir al panel DataSources
> Expandir LocalDatasets > RUTASDS > Remove Object
.LocalDatasets > ClickDerecho > Add New DataSource > Object
> LocalDatasets.LocalDatasets.RUTASDS > Next > Finish
.Build Solution

---

4. Re-Generar el DataGridView
.ClickDerecho en el DataGridVew > Delete
.DataSources.LocalDatasets.RUTASDS.RUTAS > Arrastrar y pegar en el DockPanel
.Seleccionar el DataGridView > Panel Propiedades > Propiedad DataSource > Cambiar (rUTASBindingSource1) a rUTASBindingSource
.Eliminar del Panel Bajo del DataGridView > rUTASBindingSource1 y rUTASDS

---

5. Verificar los enganches del Codigo fuente.
.Verificar que seguimos teniendo en DockRutas.cs:

public DockRutas(FormCliente parentForm)
: base(parentForm)
{
InitializeComponent();
this.rUTASBindingSource.DataSource = RutasProcess.GetInstance().Rds;
}

private void DockRutas_Load(object sender, EventArgs e)
{
RutasProcess.GetInstance();
}

. y en RutasProcess.cs

protected RutasProcess()
{
_rutasTA = new RUTASTableAdapter();
_rutasDS = new RUTASDS();
_ruta_puntosTA = new RUTA_PUNTOSTableAdapter();
_ruta_puntosDS = new RUTA_PUNTOSDS();
_rutasTA.Fill(_rutasDS.RUTAS);
_ruta_puntosTA.Fill(_ruta_puntosDS.RUTA_PUNTOS);

}

---

6. Re-Generar el CheckBox del campo RUTA_VISIBLE
.DataGridView > ClickDerecho > Edit Columns > Seleccionar RUTA_VISIBLE
> ColumnType DataGridViewCheckBoxColumn
.Data > TrueValue 1 > FalseValue 0 > OK.

---

7. Correr y Verificar.

---

Catch Exception en asp:SqlDatasource before insert

---

Catch Exception en asp:SqlDatasource before insert

---

1. Clientes.aspx

< asp:SqlDatasource
...
OnInserting="SqlDataSourceClientes_Inserting" >

---

2. Clientes.aspx.cs

protected void SqlDataSourceClientes_Inserting(object sender, SqlDataSourceCommandEventArgs e)
{
try
{
e.Cancel = true;
e.Command.ExecuteNonQuery();
LabelMensaje.Text = "Cliente Ingresado Correctamente";
}
catch
{
LabelMensaje.Text = "Cliente No Ingresado, verifique Nombre no repetido u otro parametro.";
}
}

---

ruby, gem, rails, debian lenny, sqlite3, mysql, Days on Rails.

---

Source
http://www.rubyonrails.org/docs
http://rails.homelinux.org
http://www.rails4days.pwp.blueyonder.co.uk/Rails4Days.pdf
http://www.onlamp.com/pub/a/onlamp/2006/12/14/revisiting-ruby-on-rails-revisited.html

---

( apt-get install rails )

---

( $rails ToDo )

---

( Debug in different terminals:
$tail -f ToDo/log/server.log
$tail -f ToDo/log/development.log )

---

( Edit /etc/apache2/httpd.conf


ServerName todo
DocumentRoot /home/maximilianou/src/ToDo/public

Options ExecCGI FollowSymLinks
AllowOverride all
Allow from all
Order allow,deny

)

---

( Edit /home/maximilianou/src/ToDo/public/.htaccess

RewriteRule ^(.*)$ dispatch.fcgi [QSA,L] )

---

( #a2enmod rewrite )

---

( /etc/init.d/apache2 restart )

---

( View in iceweasel http://localhost:3000/ Ok.
View in iceweasel http://localhost:3000/rails/info/properties Ok.
View in iceweasel http://todo Ok. )

---

( Not Found .. http://todo/rails/info/properties )

---

( #apt-get install libapache2-mod-fcgid libfcgi-ruby1.8

#a2enmod ssl
#a2enmod suexec
#a2enmod include
#/etc/init.d/apache2 restart )

---

( Not Found .. http://todo/rails/info/properties )

---

now reading..

---

Ok!!, Thanks to Oficial Communities like rubyonrails.org, www.debian-administration.org

This is going to be better
http://wiki.rubyonrails.org/rails/pages/RailsOnDebian
( It's up to date [Updated on October 09, 2008 21:55 by Ben Carpenter] )
And
http://www.debian-administration.org/articles/329

I have a new installation of my debian now.
You have to make previous steps remove the software installed.

---

#aptitude update
#aptitude upgrade

---

#aptitude install rubygems
#aptitude install build-essential

Now gem is running from everywhere, # or $.

---

( RubyInstaller http://rubyinstaller.rubyforge.org, but not now. )

gem install rails --include-dependencies ( so similar to debian apt-get, perfect!! )

---

( Just to see: MySql Ruby Driver http://www.tmtm.org/en/mysql/ruby/, but it is in gem )
( Just to see something else: Ruby::DBI http://ruby-dbi.rubyforge.org/
http://ruby-dbi.rubyforge.org/rdoc/index.html
#gem install dbi
#gem install dbd-mysql )

---

Keeping Rails Up-To-Date
#gem update rails

---

now installing mysql in lenny.
http://maximilianou.blogspot.com/2008/10/debian-lenny-amd64-mysql.html

---

#aptitude install libmysql-ruby
#aptitude install ruby

This have to return true:
#ruby -e 'puts require "mysql"'

This have to return error:
#ruby -e 'puts require "postgres"'

---

$mkdir src
$cd src
$mkdir work
$cd work
$rails demo
bash: rails: command not found

---

$gem list

*** LOCAL GEMS ***

actionmailer (2.1.2)
actionpack (2.1.2)
activerecord (2.1.2)
activeresource (2.1.2)
activesupport (2.1.2)
rails (2.1.2)
rake (0.8.3)

---

$ls /var/lib/gems/1.8/bin
rails rake

#vi /etc/bash.bashrc
export PATH=$PATH:/var/lib/gems/1.8/bin

$exit

Open a new terminal

$rails -v
Rails 2.1.2

---

$cd src/work
$rails demo

---

( Just to see something else
to use mongrel:
gem install mongrel
http://mongrel.rubyforge.org,

but the faster is lighttpd:
http://www.lighttpd.net )

---

$cd demo
$vi README
...
== Apache .htaccess example
...

---

Well, in two different terminals run:

$cd src/demo
$tail -f log/development.log

$cd src/demo
$tail -f log/server.log

More log and debug info in README
( script/dbconsole
script/dbconsole production
)

---

$ruby script/server
=> Booting WEBrick...
/var/lib/gems/1.8/gems/rails-2.1.2/lib/initializer.rb:229:in `require_frameworks': no such file to load -- openssl (RuntimeError)

I don't want to recompile anything, like some blogs wrote. I want default things, the simplest way, for continuous upgrading.

so..
from http://www.nabble.com/Webrick-%27require_frameworks%27-message-td14527746.html
message from Carl Anderson

#gem update rails -y
#apt-get install libopenssl-ruby

..and, everything is fine again.

http://localhost:3000/ OK!!

---

$./script/generate controller Say

$vi app/controller/say_controller.rb
..
def hello
end
..

Where the server is running [Ctrl-c]
$./script/server

http://localhost:3000/say/hello

MissingSourceFile in SayController#hello

no such file to load -- sqlite3

( from http://weblog.rubyonrails.org/2007/12/17/rails-2-0-2-some-new-defaults-and-a-few-fixes
$rails -d mysql myapp
to use mysql in the new app )

( from http://www.ruby-forum.com/topic/136133
$gem install sqlite3-ruby
Where the server is running [Ctrl-c]
$./script/server
Not a solution )

from http://www.nabble.com/%22no-such-file-to-load----sqlite3%22-Rails-td15808271.html
$apt-get install sqlite3
Where the server is running [Ctrl-c]
$./script/server
Not a solution

from http://www.nabble.com/%22no-such-file-to-load----sqlite3%22-Rails-td15808271.html
Message from Shandy Nantz-2

$apt-get install libsqlite3-ruby
Where the server is running [Ctrl-c]
$./script/server

http://localhost:3000/say/hello
Template is missing, Ok!!!!

---

$vi app/views/say/hello.rhtml
< html >< body >< h1 >Hello from Rails< /h1 >< /body >< /html >

http://localhost:3000/say/hello

$vi app/controller/say_controller.rb
...
def goodbye
end
...

---

$vi app/views/say/hello.rhtml

Say < %= link_to "GoodBye", :action => "goodbye" % >

---

Short Iterations, and system's evolution .

It's easier to throw something away if you didn't spend a long time creating it.

---

$cd src/work
$rails -d mysql depot
$cd depot
$mysql -u root -p
mysql>create database depot_development
mysql>create database depot_test
mysql>create database depot_production
mysql>grant all on depot_development.* to 'dave'@'localhost';
mysql>grant all on depot_test.* to 'dave'@'localhost';
mysql>grant all on depot_production.* to 'dave'@'localhost' identified by 'wibble';
mysql>exit;
$vi db/create.sql

drop table if exists products;
create table products (
id int not null auto_increment,
title varchar(100) not null,
description text not null,
image_url varchar(200) not null,
price decimal(10,2) not null,
primary key (id)
);

$mysql -u dave -p depot_development < db/create.sql
password:wibble

$vi config/database.yml
username: dave
password: wibble

$ruby script/generate scaffold Product Admin
...
wrong number of arguments (1 for 2)

---

now Jumping!! where to go?
Problem with the instructions and de version of rails.
I'm not going to work with older versions.
So let's read Web Development.. fast and search other solutions after that.

---

( from: http://www.b-simple.de/documents
REST, RESTfull

>curl -H "Accept: application/xml" -i -X GET http://localhost:3000/projects/1
>curl -X DELETE http://localhost:3000/projects/1
http://localhost:3000/projects/1.xml
link_to "New", new_project_path
link_to "Edit", edit_project_path(project)

<% form_for :project, @project, :url => { :action => "create" } do |f| %>
...
<% end %>

New Form
form_for(:project, :url => projects_path) do |f| ...

Edit Form
form_for(:project, :url => projects_path(@project),
:html => { :method => :put }) do |f| ...

Destroy
link_to "Show", project_path(project)
link_to "Destroy", project_path(project), :method => :delete

project_url(1)
project_url


No REST:
redirect_to :controller => "project", :action => "show", :id => @project.id

REST:
redirect_to project_url(@project)

REST Routing
map.resources :projects
=>
projects projects_url, projects_path
project project_url(id), project_path(id)
new_project new_project_url, new_project_path
edit_project edit_project_url(id), edit_project_path(id)

map.resources :sprints,
:controller => "ontrack",
:path_prefix => "/ontrack/:project_id",
:name_prefix => "ontrack_"


REST Rails try to reflect the belong to of URLs, replace:

config/routes.rb
map.resources :iterations
with
map.resources :projects do |projects|
projects.resources :iterations
end

link_to "Iterations", iterations_path(project)

<%= button_to "Close", close_project_path(project) %>

Ajax
link_to_remote "Destroy", :url => project_path(project), :method => :delete

<%= javascript_include_tag :defaults %>
in the project.rhtml of the ProjectController

ontrack/app/views/projects/destroy.rjs
page.remove "project_#{@project.id}"

)

---

$rails -d mysql depot4
$mysql -u root -p
password:*****
mysql>create database depot4_development;
mysql>use depot4_development;
mysql>grant all privileges on depot4_development.* to 'mvcuser'@'localhost' identifiec by 'mvcuser';
mysql>quit
$vi db/create.sql
drop table if exists products;
create table products (
id int not null auto_increment,
title varchar(100) not null,
description text not null,
image_url varchar(200) not null,
price decimal(10,2) not null,
primary key (id)
);
$mysql -u mvcuser -p depot4_development < db/create.sql
password: mvcuser
$vi config/database.yml
username: mvcuser
password: mvcuser

$script/generate scaffold Product id:int title:string description:text image_url:string price:decimal
or
$script/generate scaffold Product title:string description:text image_url:string price:decimal

$script/server
http://localhost:3000/products
http://localhost:3000/products/new
http://localhost:3000/products/1
http://localhost:3000/products/1/edit

---

$vi db/create.sql
...
date_available datetime not null,
...
$mysql -u mvcuser -p depot5_development < db/create.sql
password:mvcuser
$script/generate scaffold Product
The name 'ProductsHelper' is either already used in your application

---

from http://www.ruby-forum.com/topic/156303
Let's generate de forms, from de table product, in the database, in one command.

#gem install scaffold_form_generator
$rails -d mysql depot7
$mysql -u root -p
mysql>create database depot7_development;
mysql>grant all privileges on depot7_development.* to 'mvcuser'@'localhost';
mysql>quit
$mysql -u mvcuser -p depot7_development < db/create.sql
$script/generate scaffold Product
$script/generate scaffold_form Product products
The name 'ProductsHelper' is either already used in your application

---

$rails -d mysql depot9
$cd depot9
$mysql -u root -p
password:*****
mysql>create database depot9_development;
mysql>grant all privileges on depot9_development to 'mvcuser'@'localhost';
mysql>quit
$cp ../depot7/db/create.sql db
$mysql -u mvcuser -p depot9_development < db/create.sql
password: mvcuser
$vi config/database.yml
username: mvcuser
password: mvcuser
$script/generate scaffold_form Product products
$script/server
http://localhost:3000/products
No route matches "/products" with {:method=>:get}

---

(plugin gettext_localize)
(plugin will_paginate)

---

Reading References from:
Luis Guardiola (Gasper) [http://www.wbs.com.ar/]
Martin Aceto [http://www.backing-online.com.ar/]

DONE: Read. Git Magic

DONE: Read. Agile Web Development - Chapter 15 and go on.
DONE: Read. Agile Web Development - Chapter 16 and go on.
DONE: Read. Agile Web Development - Chapter 17 and go on.
DONE: Read. Agile Web Development - Chapter 18 and go on.
DONE: Read. Agile Web Development - Chapter 19 and go on.
DONE: Read. Agile Web Development - Chapter 20 and go on.
DONE: Read. Agile Web Development - Chapter 21 and go on.
DONE: Read. Agile Web Development - Chapter 22 and go on.
DONE: Read. Agile Web Development - Chapter 23 and go on.

DONE: Read. The Rails Way - Chapter 1 - Bootstraping
DONE: Read. The Rails Way - Chapter 2
DONE: Read. The Rails Way - Chapter 3
DONE: Read. The Rails Way - Chapter 4
DONE: Read. The Rails Way - Chapter 5
DONE: Read. The Rails Way - Chapter 6
DONE: Read. The Rails Way - Chapter 7
DONE: Read. The Rails Way - Chapter 8
DONE: Read. The Rails Way - Chapter 9
DONE: Read. The Rails Way - Chapter 10
DONE: Read. The Rails Way - Chapter 11
DONE: Read. The Rails Way - Chapter 12
DONE: Read. The Rails Way - Chapter 13
DONE: Read. The Rails Way - Chapter 14
DONE: Read. The Rails Way - Chapter 15
DONE: Read. The Rails Way - Chapter 16
DONE: Read. The Rails Way - Chapter 17
DONE: Read. The Rails Way - Chapter 18
DONE: Read. The Rails Way - Chapter 19

---

Firefox Plugins
.Firebug
.Web Developer Tools

---

.irbrc

# load libraries
require 'rubygems'
require 'logger'
require 'wirble'

if ENV.include?('RAILS_ENV') && !Object.const_defined?('RAILS_DEFAULT_LOGGER')
Object.const_set('RAILS_DEFAULT_LOGGER', Logger.new(STDOUT))
end

# start wirble (with color)
Wirble.init
Wirble.colorize

---

script/generate migration AddColumnDisabledToRationType disabled:boolean

class AddColumnDisabledToRationType < ActiveRecord::Migration
def self.up
add_column :ration_types, :disabled, :boolean
end

def self.down
remove_column :ration_types, :disabled
end
end

---

TODO: Read. Design.Patterns.In.Ruby

TODO: Video: PeepCode 001 rjs

TODO: Video: Railscasts 1

---

(
bigdecimal, comma separator, decimal point, sqlserver adapter

C:\Ruby\lib\ruby\gems\1.8\gems\activerecord-2.1.2\lib\active_record\connection_adapters\abstract

../connection_adapter/../schema_definition.rb

# convert something to a BigDecimal
def value_to_decimal(value)
# Using .class is faster than .is_a? and
# subclasses of BigDecimal will be handled
# in the else clause
#print "value_to_decimal" + value +"\n"
if value.class == BigDecimal
#print "value_to_decimal value \n"
value
elsif value.respond_to?(:to_d)
#print "value_to_decimal value.to_d\n"
value = value.sub(/,/, '.')
#TODO:: value = value.sub(/,/, '.')
value.to_d
else
# print "value_to_decimal value.to_s.to_d\n"
value.to_s.to_d
end
end
)

---

debian, lenny, Desktop, kde, first day.

---

After an installation of a default base system:

Edit

/etc/apt/sources.list
deb http://debian.torredehanoi.org/debian lenny main contrib non-free

---

apt-get install kde

---

Insert a Data the .net way.. (today). Just work.

---

Inserting Data, the .net way... .
// firebird, id_ruta pk autoinc(generator and trigger before insert), ruta_nombre varchar
// Insert ruta.
RUTASDataSet.RUTASRow ruta = _rutasDataSet.RUTAS.NewRUTASRow();
ruta.RUTA_NOMBRE = nombre;

// Add ruta to DataSource.
_rutasDataSet.RUTAS.AddRUTASRow(ruta);

// Commit ruta to Database Table.
_rutasTableAdapter.Update(ruta);

// Update Visual DataGridView
Set RUTASDataSet.xsd > ID_RUTA "Delete Primary Key" !!
Set RUTASDataSet.xsd > ID_RUTA "AUTOINCREMENT" !!

( This is not the best solution, there could be inconcistances Database.ID_RUTA vs. Datagridview.ID_RUTA )

---

( Other solution is to use a Fill() in some place, after de commit )

---

java, web, netbeans, lenny

---

/etc/apt/sources.list
deb http://debian.torredehanoi.org/debian lenny main contrib non-free

---

#aptitude install netbeans

---

Download Netbeans 6.5 and execute from:
http://download.netbeans.org/netbeans/6.5/beta/bundles/netbeans-6.5beta-linux.sh

$netbeans-6.5beta-linux.sh

---

lenny, iceweasel = firefox, flash, i386 (amd64:no;)

---

/etc/apt/sources.list
deb http://debian.torredehanoi.org/debian lenny main contrib non-free

---

aptitude install iceweasel

---

/etc/apt/sources.list
...
deb http://www.backports.org/debian etch-backports main contrib non-free

---

#aptitude -t etch-backports install flushplugin-nonfree

---

debian, lenny, ethernet card rtl8139D = sc92031, kernel 2.6.24

---

Edit /etc/rc.local:

ifconfig eth0 192.168.1.110 broadcast 192.168.1.255 netmask 255.255.255.0
route add default gw 192.168.1.1
exit 0

---

Edit/Create /etc/resolv.conf

search cpe.telecentro.com.ar
nameserver 200.63.155.59
nameserver 200.63.155.187

---

#ping www.google.com.ar

---

http://www.debian.org/mirror/mirrors_full

Argentina:Edit /etc/apt/sources.list

deb http://debian.torredehanoi.org/debian lenny main contrib non-free
deb http://ftp.ccc.uba.ar/pub/linux/debian/debian lenny main contrib non-free

---

#apt-get update

---

Packages list:

http://packages.debian.org/testing/
http://packages.debian.org/testing/allpackages

---

Debian etch amd64 flash iceweasel

Debian etch amd64 flash iceweasel

Agregar en /etc/apt/source.list

deb http://www.backports.org/debian etch-backports main contrib non-free

luego ejecutar

#apt-get update

#apt-get -t etch-backports install flashplugin-nonfree

y listo.
Probar si funcionan los videos de youtube.

Por trabajo, no por gusto, C#. Web, Ambiente - Instalacion de ASP.NET 2.0, C#, .NET Framework 3.5, Firebird 2.1, ibexpert.

---

Web, Ambiente - Instalación de ASP.NET 2.0, C#, .NET Framework 3.5, Firebird 2.1, ibexpert

( sin necesidad de internet en instalación, para este cliente )

---

1. Instalar Framework 3.5, con Idioma Hispano.

1.1. Iniciar Instalación de dotnetfx35.exe, y cancelar a los 5 segundos.

1.2. Copiar el dotnetfx35langpack_x86es.exe en el directorio generado por el instalador:

C:\Documents and Settings\Administrador\Configuración local\Temp\dotnetfx3530729.01\1033\dotnetfx35\x86

1.3. Reiniciar la instalacion de dotnetfx35.exe

1.4. Si por algun motivo se puede desconfiar que se haya cerrado la instalacion sin completar, ejecutar nuevamente el dotnetfx35.exe

( me ha pasado que a veces no crea el usuario ASPNET )

---

2. IIS - Verificar instalaciond e IIS o Instalarlo.

2.1. Insertar el CD de Windows XP ( o montar el .iso si es una maquina virtual )

2.2. Panel de control > Agregar o quitar programas > Agregar o quitar componentes de Windows > IIS

---

3. Firebird

3.1. Firebird-2.1.1.17910-0_Win32.exe

---

4. Bases de datos, copiar archivos.

4.1. Copiar archivos de base de datos ( en este caso crm )

c:\taocrm\GPSVENDEDORES.fdb

c:\taocrm\USUARIOS.fdb

4.2. Modificar el archivo alias.conf, agregar nombres y archivos.

C:\Archivos de programa\Firebird\Firebird_2_1\alias.conf

TrackVendedores = c:\taocrm\gpsvendedores.fdb

Usuarios = c:\taocrm\Usuarios.fdb

---

5. ibexpert

5.1. Instalar setup_personal.exe

---

6. Generar el Proveedor de Conexiones a Base de Datos (DbProvider)

6.1. Editar machine.config, Agregar..:

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\CONFIG\machine.config

< add name="FirebirdClient Data Provider" invariant="FirebirdSql.Data.FirebirdClient" description=".Net Framework Data Provider for Firebird" type="FirebirdSql.Data.FirebirdClient.FirebirdClientFactory, FirebirdSql.Data.FirebirdClient, Version=2.0.1.0, Culture=neutral, PublicKeyToken=3750abcc3150b00c" / >

---

7. Aplicación ( en este caso crm )

7.1. Copiar archivos de aplicación en C:\Inetpub\wwwroot (crm)

7.2. Crear Directirio Virtual en el IIS (crm)

Panel de Control > Herramientas Administrativas > Servicios de Internet Information Server > Sitios Web > Sitios Web predeterminado > ClickDerecho > Nuevo > Directorio Virtual

7.3. Asociar Default.aspx como posible pagina de inicio.

Panel de Control > Herramientas Administrativas > Servicios de Internet Information Server > Sitios Web > Sitios Web predeterminado > crm > ClickDerecho > Propiedades > Documentos > Agregar > Default.aspx

Mi PC > Herramientas > Opciones de Carpeta > Ver > Utilizar uso compartido simple de archivos False

Mi PC > C:\Inetpub\wwwroot > crm ClickDerecho > Propiedades > Seguridad > Agregar > ASPNET > Comprobar Nombres > Aceptar.

---

En windows XP no es necesario hacer esto:
En windows 2003 Server Buscar en Administracion de IIS > Extenciones de Servicio Web > habilitar ejecucion de ASP

From: http://forums.asp.net/p/896237/1124239.aspx#1124239

Problema:
Parser Error Message: Unrecognized attribute 'xmlns'.
configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"

Solucion:
go to the properties page for the application in IIS, pick the "Asp.net" tab, and change the target framework to 2.0

OOooootro problema,
Contexto Windows 2003 Server version en Ingles!!

Problema:
Exception Details: System.FormatException: String was not recognized as a valid DateTime.
[FormatException: String was not recognized as a valid DateTime.]
...
FirebirdSql.Data.Client.Gds.GdsStatement.Execute() +108
...
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +92
...
System.Web.UI.WebControls.GridView.DataBind() +4

Solucion:...
( C:\Windows\system32\logfiles [w3svc1 | httperr] )
select * from rdb$character_sets
select * from rdb$relations
select * from rdb$triggers
select * from rdb$collations
select * from rdb$types
select * from rdb$database
select * from rdb$fields
select * from rdb$relation_fields
Tenemos windows 2003 server A y windows 2003 server B
en A funciona
en B tira el error
ambos estan en ingles, y tienen configuraciones regionales iguales
mismas bases de datos (calculo que puede cambiar una propiedad de contexto de la base de datos, intuyo..)
... leyendo...

---

8. Usar la web:

http://localhost/crm/

---

Recordar modificar las URL del sistema de registracion.

---