[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: Gambas II Frontend for User Administration?



El dom, 04-02-2007 a las 16:29 +0100, RalfGesellensetter escribió:
> Am Mittwoch 31 Januar 2007 19:04 schrieb José L. Redrejo Rodríguez:
> > You are missing the package  gambas2-gb-db,
> > and  gambas2-gb-db-sqlite, or gambas2-gb-db-mysql if you use the
> > database administrator inside the ide.
> > You've also detected a bug in the Debian packages: gambas2-gb-db must
> > be a dependency for the gambas2-ide package. I'll fix it.
> 
> Hi José, thank you very much, meanwhile I managed to install Gambas II 
> on all my systems ;)
> 

Great, I pretend to upload version 1.9.47 to Debian sid after Badajoz
Congress, when I get a time slot to fix the dependencies bugs you
discovered in the gambas2-ide package.

> As there are many nice bindings to Qt and different networking/database 
> applications,

There are bindings for mysql, firebird, postgresql, sqlite , sqlite3 and
odbc.  At http://www.gambasdoc.org/help/comp you can get a list and
description of all the available components (a "component" is a binding
following the activex/ocx way, what means that they all share the same
interfaz when they are related. For example, sqlite or mysql have the
same interfaz, or gtk and qt bindings have the same interfaz).
There are also some database bound controls at the
http://www.gambasdoc.org/help/comp/gb.db.form component, but I've never
used it.


>  I wonder under what premises we could create a Gambas II 
> frontend for user administration? 
> 


In fact, I've already done it. But it's very tight to the authentication
method we use in our schools and high schools. It uses sqlite and ldap,
and the users are only two kind of users: "alumno" that are inside their
"aula" group (1B, 2ESO, etc.) , and "profesor" that are inside their
"departamento" group (maths, physics, etc.) . The tool is called
"usuarioscentros"  http://forjamari.linex.org/projects/usuarioscentros/
I don't think it could be useful for anybody else now, as it uses the
data from the old administrative windows tool to get the information
about the students, teachers, etc. So most of its work is connecting to
an old paradox database, get the data, export them to sqlite and do the
needed sql consults to get the data. After that it add the users and
groups to the server, and use migrationtools and ldapdiff to build the
needed ldif files and upload them to the ldap server. Its a total mess,
but has worked so far. Next course, we're going to use a new
administrative tool in the schools, so I'll have to change the
"usuarioscentros" core. 
There is also a gb.web component that makes trivial doing a cgi
application. So, I think it would be affordable doing a backend and,
then a qt, gtk and web frontend quite easily . (Between qt and gtk there
are no differences, just checking an option before compiling). 

> In Germany, many schools use CiPUX [1] user administration on their main 
> servers, because it offers many nice features. It has shell scripts for 
> most operations, and also has an RPC API. As most tjeners lack any X 
> libraries, the frontend needs to run on another machine. What 
> approach/base layout would you suggest here?

I know Cipux, and have been following its development for the last
months. I like the fact it's web based, and don't think X libraries are
needed if the frontend is easy to use. I'm afraid I can not say too much
right now, because I don't really know what the needs of those users
are. I know very deeply what my users need, but think my high-schools
don't have any computer classroom, every classroom has computers. The
approach could be really different if  you only have 3 ó 4 computer
classrooms in the school. I need to create massive (more than 1000 in
many schools) accounts in the beginning of the course, and need to keep
the teachers accounts. And those data are taken from the current tools
used to administer the school. I don't know the similarities or
differences with the schools that are using cipux. One of the purposes I
have in my contacts next week with DebianEdu people is arranging a trip
to a country where DebianEdu is working now (I don't know: Germany,
Norway, wherever they suggests) to see it in an everyday environment,
and being able to know the diferences between DebianEdu and LinEx to do
a rational roadmap. If you have any suggestion about where to go and
schools to visit or developpers to meet, you're welcome.

Regards,
José L.

Attachment: signature.asc
Description: Esta parte del mensaje =?ISO-8859-1?Q?est=E1?= firmada digitalmente


Reply to: