Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread G. Matthew Rice
On Tue, Feb 10, 2015 at 8:57 AM, Harald Maaßen har...@nwa-net.de wrote:
 Probably basic database management (dump/backup/restore) can be a junior
 sysadmin task, but at least up to now is not covered in LPI 1. When it
 will we will have to look at database engine popularity.
 We have much time until version 4.5 of LPIC-1.  ;-)

Or put it in v4.5 of LPIC-2 :)

Or my favourite option, punt on the whole issue and create DBA
certification exams.  This is what LPI-Japan did:

http://www.oss-db.jp/

(Un)fortunately, it hasn't made it outside of Japan.  BTW, these certs
are based on PostgreSQL due to its popularity there.

Regards,

-- 
G. Matthew Rice m...@starnix.com gpg id: EF9AAD20
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread G. Matthew Rice
On Tue, Feb 10, 2015 at 9:58 AM, Harald Maaßen har...@nwa-net.de wrote:
 There are only funny looking characters and pictures on that page. ;-)

This doesn't get all of those thingies but it helps:


https://translate.google.com/translate?sl=jatl=enjs=yprev=_thl=enie=UTF-8u=http%3A%2F%2Fwww.oss-db.jp%2Fedit-text=

-- 
G. Matthew Rice m...@starnix.com gpg id: EF9AAD20
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen

Am 10.02.2015 um 15:32 schrieb G. Matthew Rice:
 Or put it in v4.5 of LPIC-2 :)
This is a really good idea! mysqldump would fit well under 206.2 Backup 
operations.  :-)


 Or my favourite option, punt on the whole issue and create DBA
 certification exams.  This is what LPI-Japan did:

  http://www.oss-db.jp/
There are only funny looking characters and pictures on that page. ;-)
 (Un)fortunately, it hasn't made it outside of Japan.  BTW, these certs
 are based on PostgreSQL due to its popularity there.

 Regards,

Best Regards
Harald
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Simone Piccardi
On 10/02/2015 14:57, Harald Maaßen wrote:
 That's right! Topic 105.3 is named SQL data management. That does not
 include backup or restoring of data. But no law stops us from changing
 the name of this topic. It's also possible to increase the weight to 3,
 so we can put an additional question on the exam about this. This one
 point for weight can be taken from 106.2 Setup a display manager for
 example.

That's right, it does not include backup of data, neither the editor 
section does for files. Anyway backup is an LPI 2 argument, it has to 
stay there.

I'm totally against changing the topic or raising it weight, in my 
opinion 2 question on SQL are already too much, I'd prefer 0, like it 
was. LPI should be a Linux Sysadmin Certification, this is a generic 
argument, it tell almost nothing about you are proficient in Linux.

If you want to cover database server administration on Linux, I can 
agree, but that's more a topic for a dedicated level 3 exam.

Simone
-- 
Simone Piccardi Truelite Srl
picca...@truelite.it (email/jabber) Via Monferrato, 6
Tel. +39-347-103243350142 Firenze
http://www.truelite.it  Tel. +39-055-7879597Fax. +39-055-736
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Fwd: Re: Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen

Am 10.02.2015 um 15:14 schrieb Anselm Lingnau:

 I think that would be a terrible idea. Should we force candidates to
 familiarise themselves with the administration tools of several SQL
 database servers (which tend to be huge and complicated programs) just
 so we can ask 1 (one) question about this in the LPIC-1 exam? I say over
 my dead body.
O.k. I relinquish on mysqldump. It would be a little overacted to kill 
someone only because of one command.

 Harald, nobody prevents you from teaching your students how to dump
 MySQL databases even if that isn't actually an exam topic.
There are lots of things that students have to learn out of the scope 
from certifications.

Regards
Harald
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] suid

2015-02-10 Thread G. Matthew Rice
On Sat, Feb 7, 2015 at 4:10 PM, Alan McKinnon alan.mckin...@gmail.com wrote:
 Possibly the original intent of the objective is to highlight that
 suid-bits do nothing on scripts. As opposed to what they do on compiled
 binaries.

Hey guys,

I should point out that, in some markets, the LPIC certifications are
not only marketed as Linux certifications.  They market them as
general Unix certifications, as well.

IIRC, the suid-edness of scripts on Linux section of the objectives
was added when it did matter and it's been retained for the above
reason.

However, a quick search about the subject has lots of people
mentioning that other Unixes are following suit.  Can anyone verify
this on some of the popular Unixes?  I haven't had access to those
guys for years.

Regards,
--matt
-- 
G. Matthew Rice m...@starnix.com gpg id: EF9AAD20
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Fwd: [lpi-discuss] OpenLDAP server coverage in LPIC2-v4

2015-02-10 Thread G. Matthew Rice
On Mon, Feb 9, 2015 at 4:05 AM, Éric Deschamps erd...@free.fr wrote:
 The summary of major changes describes it as:

hi Eric,

As Reinier mentioned, it is a lot to cover for a weighting of 4.
However, if you include 210.3 LDAP client usage, you're up to 6
weights which makes it 10% of the exam.

That said and don't hold me to this, but


 - LDIF format and changetype: do my attendee need to know every
 changetype as it was in 301.1?

There's only 4 of them right?  Covering CRUD operations and moddn.
This doesn't seem to onerous yet. :)


 - loglevel: do my attendee need to know that loglevel 256 means stats,
 or do they just need to know the keyword and that you can add the values?

I think that you're safe covering it as a keyword and that the values
can be ORed together.  If I was writing courseware, I'd point out some
of the more useful values, too.


 - slapd.conf and or cn=config? Transition from slapd.conf to cn=config?
 slaptest command?

Yes.  Yes.
And, it wouldn't hurt.  slaptest isn't explicitly mentioned in the
objectives but knowledge of it is useful.


 - which version of OpenLDAP? The ones on CentOS/RedHat6 and Debian 7?

I think that's fine.

 - whitepages: schemas needed or more?

I think that's fine, too.


 - Directories: LDAP concepts, history with X.500, ports, different
 models, URL formats, types of DIT, major attributes?

You should be safe with sticking with the Key Knowledge Areas that
are mentioned in the objectives.


 - ACL with slapacl? (in this case, we should add it to the list of
 utilities).

Up to you.  I don't think that it's mentioned in the exam content and
we are trying to keep the overall coverage as light as possible.

HTH,
--matt
-- 
G. Matthew Rice m...@starnix.com gpg id: EF9AAD20
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

[lpi-examdev] SQL in LPIC 1

2015-02-10 Thread Hendrik Jan Thomassen
Dear listers,

I fully agree with Simone Piccardi who wrote:

 I'm totally against changing the topic or raising it weight, in my
 opinion 2 question on SQL are already too much, I'd prefer 0, like it
 was. LPI should be a Linux Sysadmin Certification, this is a generic
 argument, it tell almost nothing about you are proficient in Linux.

To me, SQL is just another application domain.

I have spent decades of my career as a full time UNIX administrator
in a technical environment without ever touching SQL.
If you argue that many administrators get involved in SQL, the same
is true for HTML, or colour theory, or version control systems, or ..

There are many more reasons to examine XML basics, because that really
is a topic that any modern Linux administrator needs a basic grasp of.

Hendrik-Jan Thomassen
-- 
Hendrik-Jan Thomassen h...@atcomputing.nl
AT Computing
Linux/UNIXperts,
opleiders  oplossers Tel +31 24 352 72 82
Kerkenbos 1238Tel cursussecretariaat: +31 24 352 72 72
6546 BE  Nijmegen Fax +31 24 352 72 92
i...@atcomputing.nl   www.atcomputing.nl

'If you think education is expensive, try ignorance.'

___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Marc Baudoin
Harald Maaßen har...@nwa-net.de écrit :
 
 while working on topic 105.3 sometimes students ask me, how to backup a 
 mysql database.
 I think we should add mysqldump to topic 105.3 because IMHO everybody 
 should be able to backup a database.

The way it is now, objective 105.3 is database-agnostic and only
deals with generic SQL.  Moreover, for only 2 questions, the
spectrum of knowledge is already very large so I don't think
adding more stuff is necessary.  And, for the sake of neutrality,
if dealing with MySQL, one should also speak of MariaDB,
PostgreSQL (which is, IMHO, a much better RDBMS) and SQLite.

Anyway you're free to add extra topics to your teachings, such as
mysqldump.  In my teachings, I use SQLite, because it's much
easier to set up than a full-featured RDBMS and I explain
students how to use it, even if it's not in the objectives.

-- 
Marc Baudoin
Linagora formation - responsable pédagogique
http://formation.linagora.com/

La présente transmission contient des informations
confidentielles appartenant à Linagora, exclusivement destinées
au(x) destinataire(s) identifié(s) ci-dessus. Si vous n'en faites
pas partie, toute reproduction, distribution ou divulgation de
tout ou partie des informations de cette transmission, ou toute
action effectuée sur la base de celles-ci vous sont formellement
interdites. Si vous avez reçu cette transmission par erreur, nous
vous remercions de nous en avertir et de la détruire de votre
système d'information.

The present transmission contains privileged and confidential
information belonging to Linagora, exclusively intended for the
recipient(s) thereabove identified. If you are not one of these
aforementioned recipients, any reproduction, distribution,
disclosure of said information in whole or in part, as well as
any action undertaken on the basis of said information are
strictly prohibited. If you received the present transmission by
mistake, please inform us and destroy it from your messenging and
information systems.
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Anselm Lingnau
Harald Maaßen har...@nwa-net.de wrote:

 I think we should add mysqldump to topic 105.3 because IMHO everybody 
 should be able to backup a database.

Exactly where does topic 105.3 talk about MySQL in the first place? If
everybody should be able to backup a MySQL database, shouldn't everybody
be able to restore one, too, so shouldn't we also add the commands to do
that? Do we then also add pg_dump and pg_restore because some people may
be using PostgreSQL instead?  What about other SQL databases?

IMHO one of the strengths of 105.3 is that so far we have managed to
avoid tying it to a specific database implementation. Let's try to keep
it that way. Adding mysqldump to the exam would drag in all sorts of
other MySQL bits and pieces (mysqladmin? mysql?) and would expose us to
criticism from people who don't like MySQL and prefer PostgreSQL, or for
that matter Sqlite or DB2 or Oracle or other popular database server of
the week. We would end up in yet another situation where we would have
to include the rudiments of all of them just to avoid offending people.
(We used to be in a similar place with respect to MTAs, and fortunately
that has sorted itself out to some degree.)

The other thing is that 105.3 is a weight-2 topic. Asking 2 questions
about rudimentary SQL makes sense as far as I'm concerned; asking 2
questions about rudimentary SQL and the administration of half a dozen
different SQL servers doesn't.

Anselm

Disclaimer: This is my own personal opinion and not that of my employer.
-- 
Anselm Lingnau ... Linup Front GmbH ... Linux-, Open-Source-  Netz-Schulungen
anselm.ling...@linupfront.de, +49(0)6151-9067-103, Fax -299, www.linupfront.de
Linup Front GmbH, Postfach 100121, 64201 Darmstadt, Germany
Sitz: Weiterstadt (AG Darmstadt, HRB7705), Geschäftsführer: Oliver Michel
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Anselm Lingnau
Marc Baudoin mbaud...@linagora.com wrote:

 Anyway you're free to add extra topics to your teachings, such as
 mysqldump.  In my teachings, I use SQLite, because it's much
 easier to set up than a full-featured RDBMS and I explain
 students how to use it, even if it's not in the objectives.

Exactly. That's what we do, too, because SQLite is part of all major
Linux distributions and comes with the least amount of baggage
attached. Anyone can type “sqlite3 foobar.db” and be in business,
without having to set up a database server, user accounts, etc.

Which is not to say that the database servers are bad (I personally
prefer PostgreSQL over MySQL) but as far as I'm concerned their
specifics aren't exactly standard fare for junior system administrators.

Anselm
-- 
Anselm Lingnau ... Linup Front GmbH ... Linux-, Open-Source-  Netz-Schulungen
anselm.ling...@linupfront.de, +49(0)6151-9067-103, Fax -299, www.linupfront.de
Linup Front GmbH, Postfach 100121, 64201 Darmstadt, Germany
Sitz: Weiterstadt (AG Darmstadt, HRB7705), Geschäftsführer: Oliver Michel
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 10:19 schrieb Anselm Lingnau:
 Exactly where does topic 105.3 talk about MySQL in the first place?

This is a good question. It doesn't. But I see it on a hight position in 
this logarithmic(!) ranking. The ranking shows the importance of mysql: 
http://db-engines.com/en/ranking_trend

 If everybody should be able to backup a MySQL database, shouldn't everybody
 be able to restore one, too, so shouldn't we also add the commands to do
 that? Do we then also add pg_dump and pg_restore because some people may
 be using PostgreSQL instead?  What about other SQL databases?

Of course everybody should also be able to restore a database. As 
mysqldump does the backup and the restore as well I didn't mention it 
explicit.

 IMHO one of the strengths of 105.3 is that so far we have managed to
 avoid tying it to a specific database implementation. Let's try to keep
 it that way.
I agree with this argument.

Best Regards
Harald

___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen

Am 10.02.2015 um 12:28 schrieb Simone Piccardi
 As I understood 105.3 is not about database server management, but about
 using SQL to manage basic operation on the data stored in a database.
That's right! Topic 105.3 is named SQL data management. That does not 
include backup or restoring of data. But no law stops us from changing 
the name of this topic. It's also possible to increase the weight to 3, 
so we can put an additional question on the exam about this. This one 
point for weight can be taken from 106.2 Setup a display manager for 
example.

 Probably basic database management (dump/backup/restore) can be a junior
 sysadmin task, but at least up to now is not covered in LPI 1. When it
 will we will have to look at database engine popularity.
We have much time until version 4.5 of LPIC-1.  ;-)


Best Regards
Harald
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] SQL in LPIC 1

2015-02-10 Thread Dave Utso
I agree, let's stay with LINUX.



Dave Utso
Byte Knowledge





-Original Message-
From: Hendrik Jan Thomassen h...@atcomputing.nl
To: lpi-examdev lpi-examdev@lpi.org
Sent: Tue, Feb 10, 2015 9:39 am
Subject: [lpi-examdev] SQL in LPIC 1


Dear listers,

I fully agree with Simone Piccardi who wrote:

 I'm totally against changing the topic or raising it weight, in my
 opinion 2 question on SQL are already too much, I'd prefer 0, like it
 was. LPI should be a Linux Sysadmin Certification, this is a generic
 argument, it tell almost nothing about you are proficient in Linux.

To me, SQL is just another application domain.

I have spent decades of my career as a full time UNIX administrator
in a technical environment without ever touching SQL.
If you argue that many administrators get involved in SQL, the same
is true for HTML, or colour theory, or version control systems, or ..

There are many more reasons to examine XML basics, because that really
is a topic that any modern Linux administrator needs a basic grasp of.

Hendrik-Jan Thomassen
-- 
Hendrik-Jan Thomassen h...@atcomputing.nl
AT Computing
Linux/UNIXperts,
opleiders  oplossers Tel +31 24 352 72 82
Kerkenbos 1238Tel cursussecretariaat: +31 24 352 72 72
6546 BE  Nijmegen Fax +31 24 352 72 92
i...@atcomputing.nl   www.atcomputing.nl

'If you think education is expensive, try ignorance.'

___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

 
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 15:59 schrieb G. Matthew Rice:
 On Tue, Feb 10, 2015 at 9:58 AM, Harald Maaßen har...@nwa-net.de wrote:
 There are only funny looking characters and pictures on that page. ;-)
 This doesn't get all of those thingies but it helps:

  
 https://translate.google.com/translate?sl=jatl=enjs=yprev=_thl=enie=UTF-8u=http%3A%2F%2Fwww.oss-db.jp%2Fedit-text=


Thanks Matt. Like this looks much better for me.  :-)
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Harald Maaßen
Am 10.02.2015 um 16:01 schrieb Simone Piccardi:
 I'm totally against changing the topic or raising it weight, in my
 opinion 2 question on SQL are already too much, I'd prefer 0, like it
 was. LPI should be a Linux Sysadmin Certification, this is a generic
 argument, it tell almost nothing about you are proficient in Linux.
I would not be sad, if SQL would be removed from the exams completely. 
But if there are databases, they need to be backed up.

Regards
Harald
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Fwd: [lpi-discuss] OpenLDAP server coverage in LPIC2-v4

2015-02-10 Thread Éric Deschamps
Ok, it seems clearer. I'll try to manage with that, many thanks for your
answers, Reineier, Bryan and Matt!

Kind Regards,

Éric

Le 10/02/2015 16:30, G. Matthew Rice a écrit :
 On Mon, Feb 9, 2015 at 4:05 AM, Éric Deschamps erd...@free.fr wrote:
 The summary of major changes describes it as:
 
 hi Eric,
 
 As Reinier mentioned, it is a lot to cover for a weighting of 4.
 However, if you include 210.3 LDAP client usage, you're up to 6
 weights which makes it 10% of the exam.
 
 That said and don't hold me to this, but
 
 
 - LDIF format and changetype: do my attendee need to know every
 changetype as it was in 301.1?
 
 There's only 4 of them right?  Covering CRUD operations and moddn.
 This doesn't seem to onerous yet. :)
 
 
 - loglevel: do my attendee need to know that loglevel 256 means stats,
 or do they just need to know the keyword and that you can add the values?
 
 I think that you're safe covering it as a keyword and that the values
 can be ORed together.  If I was writing courseware, I'd point out some
 of the more useful values, too.
 
 
 - slapd.conf and or cn=config? Transition from slapd.conf to cn=config?
 slaptest command?
 
 Yes.  Yes.
 And, it wouldn't hurt.  slaptest isn't explicitly mentioned in the
 objectives but knowledge of it is useful.
 
 
 - which version of OpenLDAP? The ones on CentOS/RedHat6 and Debian 7?
 
 I think that's fine.
 
 - whitepages: schemas needed or more?
 
 I think that's fine, too.
 
 
 - Directories: LDAP concepts, history with X.500, ports, different
 models, URL formats, types of DIT, major attributes?
 
 You should be safe with sticking with the Key Knowledge Areas that
 are mentioned in the objectives.
 
 
 - ACL with slapacl? (in this case, we should add it to the list of
 utilities).
 
 Up to you.  I don't think that it's mentioned in the exam content and
 we are trying to keep the overall coverage as light as possible.
 
 HTH,
 --matt
 

___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

[lpi-examdev] My reasons for including SQL knowledge for Junior Linux Sysadm students.

2015-02-10 Thread Martin Møller Skarbiniks Pedersen
My 102 students often asks me why SQL is needed for a Linux sysadm.

I give the reason that they might need to install some software eg. a CMS,
that
requires a SQL database and a SQL user.
And they shouldn't just give the MySQL root-password to the developers.

I also tell them that MySQL is much more used than other RDBS on Linux so
they should focus on MySQL.
Then I teach them how to create a MySQL user, a little bit about grants and
how to create an database.

I think that a Junior Linux Sysadm. should be able to create a MySQL user
and database.
However he/she doesn't need to understand group by, subqueries etc.

I know that PostgreSQL is much better for programming but for a Junior
Level
Sysadm. specific MySQL knowledge is important.

So move the focus away from the SQL language to more sysadm. task based
items eg. create a MySQL user, database, backup/restore etc.

/Martin
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev

Re: [lpi-examdev] Fwd: Re: Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Alessandro Selli
On 10/02/2015 at 15:14, Anselm Lingnau wrote:

[...]

 Should we force candidates to
 familiarise themselves with the administration tools of several SQL
 database servers (which tend to be huge and complicated programs) just
 so we can ask 1 (one) question about this in the LPIC-1 exam? I say over
 my dead body.

  I surely do *not* want you to die, Anselm, but I do back you on this line.
:-)


-- 
Alessandro Selli
Tel: 340.839.73.05
VOIP: sip:dhatarat...@ekiga.net
Chiave firma PGP/GPG signing key: B7FD89FD
Chiave crittografia PGP/GPG encrypting key: A6023DD5
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] SQL in LPIC 1

2015-02-10 Thread Fabian Thorns
Hi there,

I would vote for removing SQL from LPIC-1 during the next objective
update too. Unfortunately this will be somewhere far away in the future
as we're just switching to version 4.

As Martin points out, user management and security are important for
database administrators -- as they are for plenty of services, like an
XMPP service or restrictive VPN access. Also, as Harald mentioned, all
data needs to be backed up. But again, this is application specific.

However, these aspects change the focus of the objective (specific
server management/operation (dealing with the database process) vs.
DDL/SQL (dealing with the database content)) as well as its position
on the LPIC-track (should be somewhere near Apache as an own topic,
which means LPIC-2, as it is no core system service). And this not only
opens up the discussion of MySQL vs. PostgreSQL, it may also attract one
or the other NoSQL guy waiting around the corner... so where to put an
end to all those possibilities to be included or not?

I'm not sure why we have SQL on the exams right not, t may have come
from the LAMP term, but than I'd suggest reconsidering its relevance
in case we HOPEFULLY one day get to work on the pending LPIC-3 exams (a
long long time ago people thought about having an exam 306 Web
Services). IMHO for sysadmins even LDAP has a higher relevance than SQL,
which is why it was moved to LPIC-2. Also, in 304 we don't specifically
test database HA, although it has some specific aspects. But is just
considered one application next to others with our focus not being those
applications but the general infrastructure. I'd like to do the same
regarding SQL in LPIC-1.

As we just had a large review of the LPIC-1 objectives I added the SQL
issue to the Future Change Consideration section of the wiki page so
that we can come back to that discussion once we get the change to
reevaluate the objectives again. We *may* consider placing database
servers in the next LPIC-2 JTA as well, but I personally would like to
see it being part of a Web server administrator exam that includes the
whole LAMP-stack in all its derivations. But this is yet nothing to even
dream about :(

Regards,

Fabian


On 02/10/2015 06:39 PM, Hendrik Jan Thomassen wrote:
 Dear listers,

 I fully agree with Simone Piccardi who wrote:

 I'm totally against changing the topic or raising it weight, in my
 opinion 2 question on SQL are already too much, I'd prefer 0, like it
 was. LPI should be a Linux Sysadmin Certification, this is a generic
 argument, it tell almost nothing about you are proficient in Linux.
 To me, SQL is just another application domain.

 I have spent decades of my career as a full time UNIX administrator
 in a technical environment without ever touching SQL.
 If you argue that many administrators get involved in SQL, the same
 is true for HTML, or colour theory, or version control systems, or ..

 There are many more reasons to examine XML basics, because that really
 is a topic that any modern Linux administrator needs a basic grasp of.

 Hendrik-Jan Thomassen

___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Alessandro Selli
On 10/02/2015 at 16:01, Simone Piccardi wrote:

[...]

 I'm totally against changing the topic or raising it weight, in my 
 opinion 2 question on SQL are already too much, I'd prefer 0, like it 
 was. LPI should be a Linux Sysadmin Certification, this is a generic 
 argument, it tell almost nothing about you are proficient in Linux.

  I agree.  The only databases that I can think of that are truly
Linux-related are rpm's Berkley database files /var/lib/rpm/__db.00? or GNU
locate db file /var/lib/mlocate/mlocate.db.  Also the aliasdb file that is
created by the newaliases command, maybe.  I cannot make up my mind what the
/var/log/{w,b}tmp files ought to be called, perhaps they're more like a
mashed-up bit-broth than a real database.  But I would not recommend adding
any of them to the LPIC-1 objectives.



-- 
Alessandro Selli
Tel: 340.839.73.05
VOIP: sip:dhatarat...@ekiga.net
Chiave firma PGP/GPG signing key: B7FD89FD
Chiave crittografia PGP/GPG encrypting key: A6023DD5
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


Re: [lpi-examdev] Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Ingo Wichmann
Am 10.02.2015 um 16:01 schrieb Simone Piccardi:

 I'm totally against changing the topic or raising it weight, in my 
 opinion 2 question on SQL are already too much, I'd prefer 0, like it 
 was. LPI should be a Linux Sysadmin Certification, this is a generic 
 argument, it tell almost nothing about you are proficient in Linux.

+1

Ingo


-- 
Linuxhotel GmbH, Geschäftsführer Dipl.-Ing. Ingo Wichmann
HRB 20463 Amtsgericht Essen, UStID DE 814 943 641
Antonienallee 1, 45279 Essen, Tel.: 0201 8536-600, http://www.linuxhotel.de
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev


[lpi-examdev] Fwd: Re: Suggestion for 105.3 (Exam 101) mysqldump

2015-02-10 Thread Anselm Lingnau
Harald Maaßen har...@nwa-net.de wrote:

 That's right! Topic 105.3 is named SQL data management. That does not 
 include backup or restoring of data. But no law stops us from changing 
 the name of this topic. It's also possible to increase the weight to 3, 
 so we can put an additional question on the exam about this.

I think that would be a terrible idea. Should we force candidates to
familiarise themselves with the administration tools of several SQL
database servers (which tend to be huge and complicated programs) just
so we can ask 1 (one) question about this in the LPIC-1 exam? I say over
my dead body.

Harald, nobody prevents you from teaching your students how to dump
MySQL databases even if that isn't actually an exam topic. I teach my
students not to touch MySQL with a long pole, and would like to keep
things that way.

Also, if you want MySQL certification you know where to find that.

Anselm
-- 
Anselm Lingnau ... Linup Front GmbH ... Linux-, Open-Source-  Netz-Schulungen
anselm.ling...@linupfront.de, +49(0)6151-9067-103, Fax -299, www.linupfront.de
Linup Front GmbH, Postfach 100121, 64201 Darmstadt, Germany
Sitz: Weiterstadt (AG Darmstadt, HRB7705), Geschäftsführer: Oliver Michel
___
lpi-examdev mailing list
lpi-examdev@lpi.org
http://list.lpi.org/cgi-bin/mailman/listinfo/lpi-examdev