Please edit this page and replace the content in italic. Remove those instructions too.
Team Name
BLANK PAGE
Infrastructure
Website: ?/../SiteMap
Interacting with the team
Read the FAQ first: ?FAQ replace that link if you already have a FAQ somewhere else
Email contact: <some DOT thing AT debian DOT org>
Request tracker: http://bugs.skolelinux.no
Public IRC channel: #debian-edu on irc.debian.org (OFTC)
Usual roles
Member1 (IRC nick foo) has the following rights and usually handles A
Member2 (IRC nick bar) has the following rights and usually handles B
Task description
Put here a short description of the goal/role of the team.
Get involved
Put here an easy task that can be done to help you. - Put here a task that can be done to help you.
- Put here a difficult task that can be done to help you.
More stuff
If you have no other dedicated place to document stuff concerning your team, then use this place. You can put documentation (with warnings![/!\](/htdocs/debwiki/img/alert.png "/!\"){kind=small}
and infos
), FAQ, TODO list (see "Get Involved" above) , ideas (
) etc.
There used to be a admin interface for the slschools list at http://www.skolelinux.no/admin/ I don't know what happened to that, but it's still in CVS at http://cvs.skolelinux.no/cgi-bin/viewcvs.cgi/skolelinux/www/www.skolelinux.no/admin/ (http://cvs.skolelinux.no/cgi-bin/viewcvs.cgi/skolelinux/www/www.skolelinux.no/admin/9.inc?rev=1.1&content-type=text/vnd.viewcvs-markup)
Access MySql Database
Access possible from Maintainer:
$ mysql -h localhost -u username -psecret skolelinux_no mysql> status -------------- mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386) Connection id: 3905529 Current database: skolelinux_no Current user: username@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 4.1.11-Debian_4sarge7-log Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: latin1 Db characterset: latin1 Client characterset: latin1 Conn. characterset: latin1 UNIX socket: /var/run/mysqld/mysqld.sock Uptime: 61 days 7 hours 33 min 9 sec Threads: 1 Questions: 174884304 Slow queries: 0 Opens: 88032 Flush tables: 62 Open tables: 64 Queries per second avg: 33.012 -------------- mysql> show tables; +-------------------------+ | Tables_in_skolelinux_no | +-------------------------+ | OSS | | OSS_en_GB | | OSS_nb_NO | | bruker | | filer | | filer_en_GB | | filer_nb_NO | | meny | | meny_en_GB | | meny_nb_NO | | nyheter | | nyheter_en_GB | | nyheter_nb_NO | | school | | school_contact | +-------------------------+ 15 rows in set (0.00 sec) mysql> describe school; +---------------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------+----------------------+------+-----+---------+----------------+ | school_id | smallint(5) unsigned | | PRI | NULL | auto_increment | | update_of | smallint(5) unsigned | YES | | NULL | | | school_name | varchar(255) | | | | | | school_postcode | varchar(16) | YES | | NULL | | | school_postlocation | varchar(255) | YES | | NULL | | | school_streetaddr | varchar(255) | YES | | NULL | | | school_comments | text | YES | | NULL | | | school_url | varchar(255) | YES | | NULL | | | school_joined | datetime | YES | | NULL | | | school_updated | datetime | YES | | NULL | | | deleted | char(1) | YES | | 0 | | | longitude | decimal(20,17) | YES | | NULL | | | latitude | decimal(20,17) | YES | | NULL | | | country | varchar(255) | | | no | | | school_reminded | datetime | YES | | NULL | | +---------------------+----------------------+------+-----+---------+----------------+ 15 rows in set (0.00 sec) mysql> describe school_contact; +---------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+----------------------+------+-----+---------+----------------+ | contact_id | smallint(5) unsigned | | PRI | NULL | auto_increment | | school_id | smallint(5) unsigned | YES | | NULL | | | main_contact | char(1) | YES | | NULL | | | contact_name | varchar(255) | YES | | NULL | | | contact_email | varchar(255) | YES | | NULL | | | password | varchar(32) | | | | | | valid | tinyint(1) | YES | | NULL | | +---------------+----------------------+------+-----+---------+----------------+ 7 rows in set (0.00 sec) mysql> select school.school_id,school_contact.school_id,contact_name,contact_email,school_name from school_contact,school where school.deleted=0 AND school.school_id=school_contact.school_id; ...
You can use ?Subpages to structure the content if you have many things to document here.