webadmin-list — Webmin users mailing list

RE: [webmin-l] How to empty databases? What SQL command to use?

[<pr...@pr...>]

From: Prodos
To: Kris Deugau 

Dear Kris,

Good morning.

Me:
> > I would like to empty the databases on one of my sites.
> > 
> > Could someone please tell me how to format the SQL command?
> 


KGD:
> That depends on what you mean by "empty the databases".
> 
> Do you mean "clear out all data from all tables in this database"?
> 
> Do you mean "delete all tables from this database"?
> 
> Do you mean "delete this database entirely"?
> 


Sorry for not being clearer.

I meant "clear out all data from all tables in this database"


Me:
> > I've searched the webmin site and Google but haven't been
> > able to find the answer. Maybe I'm using the wrong terminology.
> 

KGD:
> Try searching for "SQL tutorial".  Adding "MySQL" as a search term as 
> well may produce some results that are more specific to MySQL;  there 
> *are* differences in how some tasks like this can be accomplished in 
> different database systems.
> 
> Also, IIRC Webmin has a fairly good interface to deal with MySQL (and 
> several other DBMS's);  you should be able to delete data, tables, or 
> whole databases without writing any SQL.  I think you'd look for this 
> functionality under the Servers->MySQL section.
> 

Thanks for those suggestions! I'll check them out.


Best Wishes,

PRODOS

http://prodos.thinkertothinker.com

"Boring updates on exciting projects."

Re: [webmin-l] New to MySQL

[<da...@so...>]

Thanks John,
That's what I figured but was trying to find an easier way out ;-)
This has been from the get go, so I imagine it's the package.

From:           	John Hinton <web...@ew...>
To:             	web...@li...
Subject:        	Re: [webmin-l] New to MySQL
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=unsubscribe>
	<mailto:web...@li...?subject=subscribe>
Date sent:      	Thu, 23 Feb 2006 11:07:57 -0500

[ Double-click this line for list subscription options ] 

da...@so... wrote:
> Hi Jamie,
> Actually MySQL isn't running, it shuts down even on system reboot. 
> Below are the last two error log entries. The second is after I 
> deleted the databases as in a new start. This is a new install so 
> MySQL hasn't run yet.
You have deleted or not created the master 'mysql' database which 
contains all the connection information for any other existing 
databases. The line, 'mysql.host' would be the host table in the 
mysql 
database. This one contains info about what host are allowed to 
connect 
to mysql. So there's no method for mysql to connect to itself. This 
database holds host, user, db, and most of the time columns_priv, 
func, 
tables_priv. Each of these instruct mysql as to what databases exist 
and 
what who can do from where with them. The basic addressing and 
permission system.

I don't think there are any direct methods within Webmin to create 
this 
database. I'm thinking you're going to need to go back through your 
installation of mysql and find out where/how this database gets 
created 
based on your particular installation method (packaged, compiled, 
etc.). 
Sounds like a mysql question instead of a Webmin question at this 
point 
as this would be a botched install of mysql or at least an incomplete 
install.

Best,
John Hinton
>
> ******************************************************************************
> 060223 08:36:00  mysqld started
> 060223  8:36:01  InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 060223  8:36:01  InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 43634.
> InnoDB: Doing recovery: scanned up to log sequence number 0 43634
> 060223  8:36:02  InnoDB: Flushing modified pages from the buffer pool...
> 060223  8:36:02  InnoDB: Started; log sequence number 0 43634
> 060223  8:36:02 [ERROR] Fatal error: Can't open privilege tables: 
> Table 'mysql.host' doesn't exist
> 060223 08:36:02  mysqld ended
>
> 060223 08:59:38  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 060223  8:59:39  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 060223  8:59:39  InnoDB: Log file ./ib_logfile0 did not exist: new to 
> be created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 060223  8:59:39  InnoDB: Log file ./ib_logfile1 did not exist: new to 
> be created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 060223  8:59:40  InnoDB: Started; log sequence number 0 0
> 060223  8:59:40 [ERROR] Fatal error: Can't open privilege tables: 
> Table 'mysql.host' doesn't exist
> 060223 08:59:40  mysqld ended
>
> ************************************************************************************************
>
> To:                    web...@li...
> *Subject:                    **Re: [webmin-l] New to MySQL*
> From:                         "Jamie Cameron" <jca...@we...>
> Send reply to:            web...@li...
>                                  <mailto:web...@li...?subject=unsubscribe>
>                                  <mailto:web...@li...?subject=subscribe>
> Date sent:                  Thu, 23 Feb 2006 15:47:00 1100
>
> _[ Double-click this line for list subscription options ]_
>
> Hi Dan,
> You should check if MySQL actually gets started or not.. The problem 
> may be that it really is running, but Webmin doesn't detect it 
> properly. If it is running, you should see a
> process called 'mysqld'.
>
> - Jamie
>
> -----Original Message-----
>
> From:  da...@so...
> Subj:  Re: [webmin-l] New to MySQL
> Date:  Thu 23 Feb 2006 9:22 am
> Size:  2K
> To:  da...@so..., web...@li...
>
> I forgot to include this is a new install, webmin 1.260 on Slackware
> 10.2 with MySQL 4.1.14
>
> From:               da...@so...
> To:                    web...@li...
> Priority:             normal
> Subject:            [webmin-l] New to MySQL
> Send reply to:   web...@li...
> <mailto:web...@li...?subject=unsubscribe>
> <mailto:web...@li...?subject=subscribe>
> Date sent:         Wed, 22 Feb 2006 16:48:40 -0600
>
>
> Hi,
> Probably something simple. I can't seem to get MySQL server to
> run. When I click the start server button it grinds for a short bit then
> comes back to the start server.
>
> I feel like a chicken or egg problem here as the start button refers
> "Click this button to start the MySQL database server on your
> system with the command cd /usr ;
> (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &.
> This Webmin module cannot administer the database until it is
> started. "
> **************************************************
> The host error log reads:
> 060222 16:33:18 mysqld started
> 060222 16:33:18 InnoDB: Database was not shut down
> normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the
> doublewrite
> InnoDB: buffer...
> 060222 16:33:18 InnoDB: Starting log scan based on
> checkpoint at
> InnoDB: log sequence number 0 43634.
> InnoDB: Doing recovery: scanned up to log sequence number
> 0 43634
> 060222 16:33:18 InnoDB: Flushing modified pages from the
> buffer pool...
> 060222 16:33:18 InnoDB: Started; log sequence number 0
> 43634
> 060222 16:33:18 [ERROR] Fatal error: Can't open privilege
> tables: Table 'mysql.host' doesn't exist
> 060222 16:33:18 mysqld ended
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding 
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> -
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>
>
> --- message truncated ---
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding 
> territory!
> http://sel.as-us.falkag.net/sel?cmd-
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
> !DSPAM:43fdd01a147262127750296! 



-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking 
scripting language
that extends applications into web and mobile media. Attend the live 
webcast
and join the prime developer group breaking into this new coding 
territory!
http://sel.as-
us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
-
Forwarded by the Webmin mailing list at webadmin-
li...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list

Re: [webmin-l] virtual interface and SSL

[<da...@so...>]

To follow up on this I use this quote, " and Junior, DON'T TOUCH 
ANY BUTTONS".  

I have both normal http and SSL working now. My initial problem 
was, in  the networking module, telling Apache to listen to port 443 
but forgeting to tell it to listen to port 80.

Most importantly is not to use any Webmin configuration buttons 
after that. At least the Slackware install only works with the 
php4.conf and mod_ssl.conf files exclusivly. Clicking the enable ssl 
or any of the module config setting when applied only causes a host 
of errors seen below. A word to the wise, although I think I'm the 
only Slackware user.

Jamie I've attached the php4.conf and mod_ssl.conf files.

Thanks for patience,
Dan


From:           	da...@so...
To:             	Jamie Cameron <jca...@we...>, web...@li...
Subject:        	Re: [webmin-l] virtual interface and SSL
Priority:       	normal
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=unsubscribe>
	<mailto:web...@li...?subject=subscribe>
Date sent:      	Wed, 22 Feb 2006 21:35:21 -0600


I wanted to revisit this now that I have set up a new pristine box. I 
did a clean install of slackware 10.2 manually so as to make sure 
that php4, mod_ssl and Mysql were successfully installed. I let 
slackware install Apache 1.3.33.

The clean http.conf does not contain the load or add modules for 
PhP or mod_ssl but at the end of the file contain INCLUDES:
*********************************************************************
# ==> mod_php configuration settings <==

#
# PACKAGES REQUIRED: openssl-solibs (A series) and/or 
openssl (N series),
# mysql (AP series), gmp (L series), mhash (L series),
# and apache (N series)
#
Include /etc/apache/mod_php.conf

# ==> mod_ssl configuration settings <==
#
# PACKAGES REQUIRED: apache (N series) and openssl (N 
series)
#
Include /etc/apache/mod_ssl.conf
***********************************************************************
this causes php4 and apachessl to appear in the 
apache modules module unchecked, but the server 
still runs. If I check the two mods and try to 
APPLY CHANGES I get:

Syntax error on line 282 of 
/etc/apache/httpd.conf:
Cannot add module via name 'mod_php4.c': not in 
list of loaded modules
***********************************************
Now if I add both php4 and mod_ssl to the loaded 
modules then apply changes things are fine without 
the boxes checked in the apache modules, but there 
is no SSL running. But if I check the php4 and 
apachessl (that keeps appearing) and save, it 
inserts php4 and apachessl into the addmodule in 
http.conf. When I then try to APPLY CHANGES I get:
Syntax error on line 284 of /etc/apache/httpd.conf: Cannot add 
module via name 'mod_apachessl.c': not in list of loaded 
modules
If I modify http.conf load module to apachessl 
then I get:
Syntax error on line 239 of /etc/apache/httpd.conf: Can't locate 
API module structure `apachessl_module' in file 
/usr/libexec/apache/libssl.so: /usr/libexec/apache/libssl.so: 
undefined symbol: apachessl_module

Where does this apachessl come from?

If I remove the apache from the ssl directive the 
server will start fine.

**************************************************
Now when I create a virtual domain through 
virtualmin, with IP address and ssl enabled it 
creates fine. But when I enable ssl for the 
virtual server in the Apache module and restart 
Apache I get: 


Warning: User directive in requires SUEXEC 
wrapper.
Warning: Group directive in requires SUEXEC 
wrapper.
Warning: User directive in requires SUEXEC 
wrapper.
Warning: Group directive in requires SUEXEC 
wrapper.
Syntax error on line 1082 of 
/etc/apache/httpd.conf:
Invalid command 'SSLEnable', perhaps mis-spelled 
or defined by a module not included in the server 
configuration
/usr/sbin/apachectl start: httpd could not be 
started

These are the virtual host directives:

<VirtualHost 69.128.106.188:80>
User "#500"
Group "#500"
ServerName testagain.com
ServerAlias www.testagain.com
DocumentRoot /home/testagain/public_html
ErrorLog /home/testagain/logs/error_log
CustomLog /home/testagain/logs/access_log common
ScriptAlias /cgi-bin/ /home/testagain/cgi-bin/
<Directory /home/testagain/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
</Directory>
</VirtualHost>
<VirtualHost 69.128.106.188:443>
User "#500"
Group "#500"
ServerName testagain.com
ServerAlias www.testagain.com
DocumentRoot /home/testagain/public_html
ErrorLog /home/testagain/logs/error_log
CustomLog /home/testagain/logs/access_log common
ScriptAlias /cgi-bin/ /home/testagain/cgi-bin/
<Directory /home/testagain/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
</Directory>
SSLEngine on
SSLCertificateFile /home/testagain/ssl.cert
SSLCertificateKeyFile /home/testagain/ssl.key
SSLEnable 
</VirtualHost>


Any clue to all this?


Dan





Subject: Re: [webmin-l] virtual interface and SSL
From: Jamie Cameron <jca...@we...>
To: web...@li...
Organization: 
Send reply to: web...@li...
<mailto:webadmin-list-
re...@li...?subject=unsubscribe>
<mailto:webadmin-list-
re...@li...?subject=subscribe>
Date sent: 29 Jan 2006 09:57:53 +1100

[ Double-click this line for list subscription options ] 

On Sun, 2006-01-29 at 01:55, da...@so... wrote:
> What a wonderful work you guys are doing with webmin, it's power 
> continues to grow. Now I don't get into trouble until I experiment 
with 
> undocumented changes ;)
> 
> Problem:
> 
> In my first attempt to set up SSL virtual websites I failed. Jamie's 
> book pointed out that SSL won't work on namebased shared IP. 
So I 
> used Virtualmin to create a virtual IP interface and establish SSL. 
> Apache then created another virtual server with port 443 access 
> giving two virtual servers ( port 80 and 443) both with the new IP. 
> The SSL works great, but port 80 access gives page can't be 
> displayed. Mail seems to work fine. I can't find a way to remove 
the 
> virtual Interface from the virtual server and return it to shared as it 
> was so that the web at least has access for now.
> 
> I then upgraded Virtualmin to 2.610 to no avail. With this 
exception. 
> Now the servers created on Apache show up with a * in the 
address 
> field showing any. I know I shouldn't have experimented on the 
"live" 
> website.
> 
> Questions:
> 
> --Obviously, why doesn't the port 80 access work?
> --How does one remove or change the private IP setting on the 
> server? Virtualmin seems to clamp up once it goes private. And 
> using network interface module to remove it just shuts the entire 
> virtual server down as virtualmin retains the private IP address to 
> the server
> 
> I'm running Webmin 1.250 and Virtualmin 2.610 on a Slackware 
> 10.0 server with Apache 1.3.31

Port 80 certainly should work, so it is probably best to try to solve
that problem .. especially since Virtualmin cannot yet convert a 
server
from private IP back to shared.

What exact error message are you getting when you try the port 80 
URL?
Or is it just displaying the wrong website? Also, what does the
<Virtualhost> section header look like?

- Jamie




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through 
log files
for problems? Stop! Download the new AJAX search engine that 
makes
searching your log files as easy as surfing the web. DOWNLOAD 
SPLUNK!
http://sel.as- 
us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
-
Forwarded by the Webmin mailing list at webadmin- 
li...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list

Re: [webmin-l] virtual interface and SSL

[<da...@so...>]

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  mod_ssl_conf.txt
     Date:  23 Feb 2006, 10:34
     Size:  11377 bytes.
     Type:  Text

Re: [webmin-l] virtual interface and SSL

[<da...@so...>]

The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.

   ---- File information -----------
     File:  mod_php_conf.txt
     Date:  23 Feb 2006, 10:34
     Size:  355 bytes.
     Type:  Text

Re: [webmin-l] New to MySQL

[John H. <web...@ew...>]

da...@so... wrote:
> Hi Jamie,
> Actually MySQL isn't running, it shuts down even on system reboot. 
> Below are the last two error log entries. The second is after I 
> deleted the databases as in a new start. This is a new install so 
> MySQL hasn't run yet.
You have deleted or not created the master 'mysql' database which 
contains all the connection information for any other existing 
databases. The line, 'mysql.host' would be the host table in the mysql 
database. This one contains info about what host are allowed to connect 
to mysql. So there's no method for mysql to connect to itself. This 
database holds host, user, db, and most of the time columns_priv, func, 
tables_priv. Each of these instruct mysql as to what databases exist and 
what who can do from where with them. The basic addressing and 
permission system.

I don't think there are any direct methods within Webmin to create this 
database. I'm thinking you're going to need to go back through your 
installation of mysql and find out where/how this database gets created 
based on your particular installation method (packaged, compiled, etc.). 
Sounds like a mysql question instead of a Webmin question at this point 
as this would be a botched install of mysql or at least an incomplete 
install.

Best,
John Hinton
>
> ******************************************************************************
> 060223 08:36:00  mysqld started
> 060223  8:36:01  InnoDB: Database was not shut down normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the doublewrite
> InnoDB: buffer...
> 060223  8:36:01  InnoDB: Starting log scan based on checkpoint at
> InnoDB: log sequence number 0 43634.
> InnoDB: Doing recovery: scanned up to log sequence number 0 43634
> 060223  8:36:02  InnoDB: Flushing modified pages from the buffer pool...
> 060223  8:36:02  InnoDB: Started; log sequence number 0 43634
> 060223  8:36:02 [ERROR] Fatal error: Can't open privilege tables: 
> Table 'mysql.host' doesn't exist
> 060223 08:36:02  mysqld ended
>
> 060223 08:59:38  mysqld started
> InnoDB: The first specified data file ./ibdata1 did not exist:
> InnoDB: a new database to be created!
> 060223  8:59:39  InnoDB: Setting file ./ibdata1 size to 10 MB
> InnoDB: Database physically writes the file full: wait...
> 060223  8:59:39  InnoDB: Log file ./ib_logfile0 did not exist: new to 
> be created
> InnoDB: Setting log file ./ib_logfile0 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> 060223  8:59:39  InnoDB: Log file ./ib_logfile1 did not exist: new to 
> be created
> InnoDB: Setting log file ./ib_logfile1 size to 5 MB
> InnoDB: Database physically writes the file full: wait...
> InnoDB: Doublewrite buffer not found: creating new
> InnoDB: Doublewrite buffer created
> InnoDB: Creating foreign key constraint system tables
> InnoDB: Foreign key constraint system tables created
> 060223  8:59:40  InnoDB: Started; log sequence number 0 0
> 060223  8:59:40 [ERROR] Fatal error: Can't open privilege tables: 
> Table 'mysql.host' doesn't exist
> 060223 08:59:40  mysqld ended
>
> ************************************************************************************************
>
> To:                    web...@li...
> *Subject:                    **Re: [webmin-l] New to MySQL*
> From:                         "Jamie Cameron" <jca...@we...>
> Send reply to:            web...@li...
>                                  <mailto:web...@li...?subject=unsubscribe>
>                                  <mailto:web...@li...?subject=subscribe>
> Date sent:                  Thu, 23 Feb 2006 15:47:00 1100
>
> _[ Double-click this line for list subscription options ]_
>
> Hi Dan,
> You should check if MySQL actually gets started or not.. The problem 
> may be that it really is running, but Webmin doesn't detect it 
> properly. If it is running, you should see a
> process called 'mysqld'.
>
> - Jamie
>
> -----Original Message-----
>
> From:  da...@so...
> Subj:  Re: [webmin-l] New to MySQL
> Date:  Thu 23 Feb 2006 9:22 am
> Size:  2K
> To:  da...@so..., web...@li...
>
> I forgot to include this is a new install, webmin 1.260 on Slackware
> 10.2 with MySQL 4.1.14
>
> From:               da...@so...
> To:                    web...@li...
> Priority:             normal
> Subject:            [webmin-l] New to MySQL
> Send reply to:   web...@li...
> <mailto:web...@li...?subject=unsubscribe>
> <mailto:web...@li...?subject=subscribe>
> Date sent:         Wed, 22 Feb 2006 16:48:40 -0600
>
>
> Hi,
> Probably something simple. I can't seem to get MySQL server to
> run. When I click the start server button it grinds for a short bit then
> comes back to the start server.
>
> I feel like a chicken or egg problem here as the start button refers
> "Click this button to start the MySQL database server on your
> system with the command cd /usr ;
> (/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &.
> This Webmin module cannot administer the database until it is
> started. "
> **************************************************
> The host error log reads:
> 060222 16:33:18 mysqld started
> 060222 16:33:18 InnoDB: Database was not shut down
> normally!
> InnoDB: Starting crash recovery.
> InnoDB: Reading tablespace information from the .ibd files...
> InnoDB: Restoring possible half-written data pages from the
> doublewrite
> InnoDB: buffer...
> 060222 16:33:18 InnoDB: Starting log scan based on
> checkpoint at
> InnoDB: log sequence number 0 43634.
> InnoDB: Doing recovery: scanned up to log sequence number
> 0 43634
> 060222 16:33:18 InnoDB: Flushing modified pages from the
> buffer pool...
> 060222 16:33:18 InnoDB: Started; log sequence number 0
> 43634
> 060222 16:33:18 [ERROR] Fatal error: Can't open privilege
> tables: Table 'mysql.host' doesn't exist
> 060222 16:33:18 mysqld ended
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding 
> territory!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
> -
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>
>
> --- message truncated ---
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting 
> language
> that extends applications into web and mobile media. Attend the live 
> webcast
> and join the prime developer group breaking into this new coding 
> territory!
> http://sel.as-us.falkag.net/sel?cmd-
> Forwarded by the Webmin mailing list at 
> web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
> !DSPAM:43fdd01a147262127750296! 

Re: [webmin-l] How to empty databases? What SQL command to use?

[Kris D. <kd...@vi...>]

pr...@pr... wrote:
> I would like to empty the databases on one of my sites.
> 
> Could someone please tell me how to format the SQL command?

That depends on what you mean by "empty the databases".

Do you mean "clear out all data from all tables in this database"?

Do you mean "delete all tables from this database"?

Do you mean "delete this database entirely"?

> In the text area under "Enter an SQL command to execute on database
> [nameofdatabase]"
> I enter a command or querie for each "table". Correct?
> 
> But what is the format of each of the commands, please?
> 
> I've searched the webmin site and Google but haven't been
> able to find the answer. Maybe I'm using the wrong terminology.

Try searching for "SQL tutorial".  Adding "MySQL" as a search term as 
well may produce some results that are more specific to MySQL;  there 
*are* differences in how some tasks like this can be accomplished in 
different database systems.

Also, IIRC Webmin has a fairly good interface to deal with MySQL (and 
several other DBMS's);  you should be able to delete data, tables, or 
whole databases without writing any SQL.  I think you'd look for this 
functionality under the Servers->MySQL section.

-kgd

Re: [webmin-l] New to MySQL

[<da...@so...>]

Hi Jamie,
Actually MySQL isn't running, it shuts down even on system reboot. Below are the 
last two error log entries. The second is after I deleted the databases as in a new 
start. This is a new install so MySQL hasn't run yet.

******************************************************************************
060223 08:36:00  mysqld started
060223  8:36:01  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
060223  8:36:01  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
060223  8:36:02  InnoDB: Flushing modified pages from the buffer pool...
060223  8:36:02  InnoDB: Started; log sequence number 0 43634
060223  8:36:02 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060223 08:36:02  mysqld ended

060223 08:59:38  mysqld started
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
060223  8:59:39  InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
060223  8:59:39  InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
060223  8:59:39  InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
060223  8:59:40  InnoDB: Started; log sequence number 0 0
060223  8:59:40 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060223 08:59:40  mysqld ended

************************************************************************************************

To:             	web...@li...
Subject:        	Re: [webmin-l] New to MySQL
From:           	"Jamie Cameron" <jca...@we...>
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=unsubscribe>
	<mailto:web...@li...?subject=subscribe>
Date sent:      	Thu, 23 Feb 2006 15:47:00 1100

[ Double-click this line for list subscription options ] 

Hi Dan,
You should check if MySQL actually gets started or not.. The problem may be that it 
really is running, but Webmin doesn't detect it properly. If it is running, you should 
see a
process called 'mysqld'.

 - Jamie

-----Original Message-----

From:  da...@so...
Subj:  Re: [webmin-l] New to MySQL
Date:  Thu 23 Feb 2006 9:22 am
Size:  2K
To:  da...@so..., web...@li...

I forgot to include this is a new install, webmin 1.260 on Slackware 
10.2 with MySQL 4.1.14

From:           	da...@so...
To:             	web...@li...
Priority:       	normal
Subject:        	[webmin-l] New to MySQL
Send reply to:  	web...@li...
 <mailto:web...@li...?subject=unsubscribe>
 <mailto:web...@li...?subject=subscribe>
Date sent:      	Wed, 22 Feb 2006 16:48:40 -0600


Hi,
Probably something simple. I can't seem to get MySQL server to 
run. When I click the start server button it grinds for a short bit then 
comes back to the start server. 

I feel like a chicken or egg problem here as the start button refers 
"Click this button to start the MySQL database server on your 
system with the command cd /usr ; 
(/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. 
This Webmin module cannot administer the database until it is 
started. "
**************************************************
The host error log reads:
060222 16:33:18 mysqld started 
060222 16:33:18 InnoDB: Database was not shut down 
normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the 
doublewrite
InnoDB: buffer... 
060222 16:33:18 InnoDB: Starting log scan based on 
checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 
0 43634
060222 16:33:18 InnoDB: Flushing modified pages from the 
buffer pool... 
060222 16:33:18 InnoDB: Started; log sequence number 0 
43634 
060222 16:33:18 [ERROR] Fatal error: Can't open privilege 
tables: Table 'mysql.host' doesn't exist 
060222 16:33:18 mysqld ended 




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list


--- message truncated ---




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list

[webmin-l] How to empty databases? What SQL command to use?

[<pr...@pr...>]

From: Prodos

Good evening.

I would like to empty the databases on one of my sites.

Could someone please tell me how to format the SQL command?

I go to the MySQL database. Correct?

I use Execute SQL. Correct?

In the text area under "Enter an SQL command to execute on database
[nameofdatabase]"
I enter a command or querie for each "table". Correct?

But what is the format of each of the commands, please?

I've searched the webmin site and Google but haven't been
able to find the answer. Maybe I'm using the wrong terminology.

Any assistance would be appreciated.

PS: Is there a comprehensive list of SQL commands
available somewhere that I can look up and study?

Thanks!

Best Wishes,

PRODOS

[webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing user directive

[samnang C. <sam...@gm...>]

ok thank u for ur time to share with me.
i will try more.

* hey sir, when i used fedora core 3 nothing problem but the problem
occur after i update core to fedora core 4.

On Thu, 23 Feb 2006 20:29:00 1100, Jamie Cameron <jca...@we...> wrot=
e:
> I am out of ideas then, sorry. Perhaps you should ask the proftpd develop=
ers
> about this, as it doesn't appear to be a Webmin problem.
>
>  - Jamie
>
> -----Original Message-----
>
> From:  "samnang Chheng" <sam...@gm...>
> Subj:  [webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing use=
r
> directive
> Date:  Thu 23 Feb 2006 6:12 pm
> Size:  3K
> To:  web...@li...
>
> Yes, there are many  files in my user's directory.
> i tried to find the solution a week ago from the google search but no
> have the solution that can help my problem.
>
> On 2/23/06, Jamie Cameron <jca...@we...> wrote:
> > Are you sure that the user's directory actually has any files in it?
> > If not, when you use the 'dir' or 'ls' commands they will not return
> > anything..
> >
> >  - Jamie
> >
> > On 22/Feb/2006 23:01 samnang Chheng wrote ..
> > > Thanks ur reply. yes i aslo tried the command "dir" and also remove
> > > and reinstall it. But it still doesn't work. please help me.
> > >
> > > On Thu, 23 Feb 2006 15:52:00 1100, Jamie Cameron <jca...@we...=
>
> > > wrote:
> > > > Have you tried just using the command 'dir' instead of 'ls -l' ? I
> don't
> > > > think that ls options are officially supported by the FTP protocol,
> even
> > > > though some servers allow them.
> > > >
> > > >  - Jamie
> > > >
> > > > -----Original Message-----
> > > >
> > > > From:  "samnang Chheng" <sam...@gm...>
> > > > Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing u=
ser
> > > > directive
> > > > Date:  Thu 23 Feb 2006 2:41 pm
> > > > Size:  1K
> > > > To:  web...@li...
> > > >
> > > > Dear all,
> > > > I have a problem with Proftpd Server  and  Virtualmin in fedora cor=
e
> > > 4.
> > > > when i use ftp connect to my virtual user like :
> > > >
> > > > [root@localhost ~]# ftp localhost
> > > > Connected to localhost.localdomain.
> > > > 220 FTP Server ready.
> > > > 500 AUTH not understood
> > > > 500 AUTH not understood
> > > > KERBEROS_V4 rejected as an authentication type
> > > > Name (localhost:root): test
> > > > 331 Password required for test.
> > > > Password:
> > > > 230 User test logged in.
> > > > Remote system type is UNIX.
> > > > Using binary mode to transfer files.
> > > >
> > > > Then i use command ls --al to show all my file list, but the result=
 it
> > > > doesn't show anything:
> > > > ftp> ls --al
> > > > 227 Entering Passive Mode (127,0,0,1,128,32).
> > > > 150 Opening ASCII mode data connection for file list
> > > > 226 Transfer complete.
> > > > ftp>
> > > >
> > > > Usually, it show like this :
> > > > ftp> ls --al
> > > > 227 Entering Passive Mode (127,0,0,1,128,33).
> > > > 150 Opening ASCII mode data connection for file list
> > > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
> > > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
> > > > -rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthorit=
y
> > > > -rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
> > > > -rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_histor=
y
> > > > -rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
> > > > -rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profil=
e
> > > > -rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
> > > > .................
> > > > 226 Transfer complete.
> > > > ftp>
> > > >
> > > > How can i solve this problem?
> > > >
> > > > Yours Sincerly,
> > > >
> > > >
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by xPML, a groundbreaking scripting
>
> --- message truncated ---
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> -
> Forwarded by the Webmin mailing list at web...@li....n=
et
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>

Re: [webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing user directive

[Jamie C. <jca...@we...>]

I am out of ideas then, sorry. Perhaps you should ask the proftpd develop=
ers about this, as it doesn't appear to be a Webmin problem.

 - Jamie

-----Original Message-----

From:  "samnang Chheng" <sam...@gm...>
Subj:  [webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing use=
r directive
Date:  Thu 23 Feb 2006 6:12 pm
Size:  3K
To:  web...@li...

Yes, there are many  files in my user's directory.
i tried to find the solution a week ago from the google search but no
have the solution that can help my problem.

On 2/23/06, Jamie Cameron <jca...@we...> wrote:
> Are you sure that the user's directory actually has any files in it?
> If not, when you use the 'dir' or 'ls' commands they will not return
> anything..
>
>  - Jamie
>
> On 22/Feb/2006 23:01 samnang Chheng wrote ..
> > Thanks ur reply. yes i aslo tried the command "dir" and also remove
> > and reinstall it. But it still doesn't work. please help me.
> >
> > On Thu, 23 Feb 2006 15:52:00 1100, Jamie Cameron <jca...@we...=
>
> > wrote:
> > > Have you tried just using the command 'dir' instead of 'ls -l' ? I =
don't
> > > think that ls options are officially supported by the FTP protocol,=
 even
> > > though some servers allow them.
> > >
> > >  - Jamie
> > >
> > > -----Original Message-----
> > >
> > > From:  "samnang Chheng" <sam...@gm...>
> > > Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing u=
ser
> > > directive
> > > Date:  Thu 23 Feb 2006 2:41 pm
> > > Size:  1K
> > > To:  web...@li...
> > >
> > > Dear all,
> > > I have a problem with Proftpd Server  and  Virtualmin in fedora cor=
e
> > 4.
> > > when i use ftp connect to my virtual user like :
> > >
> > > [root@localhost ~]# ftp localhost
> > > Connected to localhost.localdomain.
> > > 220 FTP Server ready.
> > > 500 AUTH not understood
> > > 500 AUTH not understood
> > > KERBEROS_V4 rejected as an authentication type
> > > Name (localhost:root): test
> > > 331 Password required for test.
> > > Password:
> > > 230 User test logged in.
> > > Remote system type is UNIX.
> > > Using binary mode to transfer files.
> > >
> > > Then i use command ls --al to show all my file list, but the result=
 it
> > > doesn't show anything:
> > > ftp> ls --al
> > > 227 Entering Passive Mode (127,0,0,1,128,32).
> > > 150 Opening ASCII mode data connection for file list
> > > 226 Transfer complete.
> > > ftp>
> > >
> > > Usually, it show like this :
> > > ftp> ls --al
> > > 227 Entering Passive Mode (127,0,0,1,128,33).
> > > 150 Opening ASCII mode data connection for file list
> > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
> > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
> > > -rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthorit=
y
> > > -rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
> > > -rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_histor=
y
> > > -rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
> > > -rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profil=
e
> > > -rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
> > > .................
> > > 226 Transfer complete.
> > > ftp>
> > >
> > > How can i solve this problem?
> > >
> > > Yours Sincerly,
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by xPML, a groundbreaking scripting

--- message truncated ---

[webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing user directive

[samnang C. <sam...@gm...>]

Yes, there are many  files in my user's directory.
i tried to find the solution a week ago from the google search but no
have the solution that can help my problem.

On 2/23/06, Jamie Cameron <jca...@we...> wrote:
> Are you sure that the user's directory actually has any files in it?
> If not, when you use the 'dir' or 'ls' commands they will not return
> anything..
>
>  - Jamie
>
> On 22/Feb/2006 23:01 samnang Chheng wrote ..
> > Thanks ur reply. yes i aslo tried the command "dir" and also remove
> > and reinstall it. But it still doesn't work. please help me.
> >
> > On Thu, 23 Feb 2006 15:52:00 1100, Jamie Cameron <jca...@we...>
> > wrote:
> > > Have you tried just using the command 'dir' instead of 'ls -l' ? I do=
n't
> > > think that ls options are officially supported by the FTP protocol, e=
ven
> > > though some servers allow them.
> > >
> > >  - Jamie
> > >
> > > -----Original Message-----
> > >
> > > From:  "samnang Chheng" <sam...@gm...>
> > > Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing use=
r
> > > directive
> > > Date:  Thu 23 Feb 2006 2:41 pm
> > > Size:  1K
> > > To:  web...@li...
> > >
> > > Dear all,
> > > I have a problem with Proftpd Server  and  Virtualmin in fedora core
> > 4.
> > > when i use ftp connect to my virtual user like :
> > >
> > > [root@localhost ~]# ftp localhost
> > > Connected to localhost.localdomain.
> > > 220 FTP Server ready.
> > > 500 AUTH not understood
> > > 500 AUTH not understood
> > > KERBEROS_V4 rejected as an authentication type
> > > Name (localhost:root): test
> > > 331 Password required for test.
> > > Password:
> > > 230 User test logged in.
> > > Remote system type is UNIX.
> > > Using binary mode to transfer files.
> > >
> > > Then i use command ls --al to show all my file list, but the result i=
t
> > > doesn't show anything:
> > > ftp> ls --al
> > > 227 Entering Passive Mode (127,0,0,1,128,32).
> > > 150 Opening ASCII mode data connection for file list
> > > 226 Transfer complete.
> > > ftp>
> > >
> > > Usually, it show like this :
> > > ftp> ls --al
> > > 227 Entering Passive Mode (127,0,0,1,128,33).
> > > 150 Opening ASCII mode data connection for file list
> > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
> > > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
> > > -rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthority
> > > -rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
> > > -rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_history
> > > -rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
> > > -rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profile
> > > -rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
> > > .................
> > > 226 Transfer complete.
> > > ftp>
> > >
> > > How can i solve this problem?
> > >
> > > Yours Sincerly,
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > > that extends applications into web and mobile media. Attend the live
> > webcast
> > > and join the prime developer group breaking into this new coding
> territory!
> > > http://sel.as-us.falkag.net/sel?cmd
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > > that extends applications into web and mobile media. Attend the live
> > webcast
> > > and join the prime developer group breaking into this new coding
> territory!
> > > http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> > > -
> > > Forwarded by the Webmin mailing list at
> web...@li...
> > > To remove yourself from this list, go to
> > > http://lists.sourceforge.net/lists/listinfo/webadmin-list
> > >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting
> language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding
> territory!
> > http://sel.as-us.falkag.net/sel?cmd
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=
=3D121642
> -
> Forwarded by the Webmin mailing list at web...@li....n=
et
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>

Re: [webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing user directive

[Jamie C. <jca...@we...>]

Are you sure that the user's directory actually has any files in it?
If not, when you use the 'dir' or 'ls' commands they will not return anything..

 - Jamie

On 22/Feb/2006 23:01 samnang Chheng wrote ..
> Thanks ur reply. yes i aslo tried the command "dir" and also remove
> and reinstall it. But it still doesn't work. please help me.
> 
> On Thu, 23 Feb 2006 15:52:00 1100, Jamie Cameron <jca...@we...>
> wrote:
> > Have you tried just using the command 'dir' instead of 'ls -l' ? I don't
> > think that ls options are officially supported by the FTP protocol, even
> > though some servers allow them.
> >
> >  - Jamie
> >
> > -----Original Message-----
> >
> > From:  "samnang Chheng" <sam...@gm...>
> > Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing user
> > directive
> > Date:  Thu 23 Feb 2006 2:41 pm
> > Size:  1K
> > To:  web...@li...
> >
> > Dear all,
> > I have a problem with Proftpd Server  and  Virtualmin in fedora core
> 4.
> > when i use ftp connect to my virtual user like :
> >
> > [root@localhost ~]# ftp localhost
> > Connected to localhost.localdomain.
> > 220 FTP Server ready.
> > 500 AUTH not understood
> > 500 AUTH not understood
> > KERBEROS_V4 rejected as an authentication type
> > Name (localhost:root): test
> > 331 Password required for test.
> > Password:
> > 230 User test logged in.
> > Remote system type is UNIX.
> > Using binary mode to transfer files.
> >
> > Then i use command ls --al to show all my file list, but the result it
> > doesn't show anything:
> > ftp> ls --al
> > 227 Entering Passive Mode (127,0,0,1,128,32).
> > 150 Opening ASCII mode data connection for file list
> > 226 Transfer complete.
> > ftp>
> >
> > Usually, it show like this :
> > ftp> ls --al
> > 227 Entering Passive Mode (127,0,0,1,128,33).
> > 150 Opening ASCII mode data connection for file list
> > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
> > drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
> > -rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthority
> > -rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
> > -rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_history
> > -rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
> > -rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profile
> > -rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
> > .................
> > 226 Transfer complete.
> > ftp>
> >
> > How can i solve this problem?
> >
> > Yours Sincerly,
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding territory!
> > http://sel.as-us.falkag.net/sel?cmd
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> > that extends applications into web and mobile media. Attend the live
> webcast
> > and join the prime developer group breaking into this new coding territory!
> > http://sel.as-us.falkag.net/sel?cmdlnk&kid0944&bid$1720&dat1642
> > -
> > Forwarded by the Webmin mailing list at web...@li...
> > To remove yourself from this list, go to
> > http://lists.sourceforge.net/lists/listinfo/webadmin-list
> >
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd

[webmin-l] Re: Problem with ProFTP Server & Virtualmin Missing user directive

[samnang C. <sam...@gm...>]

Thanks ur reply. yes i aslo tried the command "dir" and also remove
and reinstall it. But it still doesn't work. please help me.

On Thu, 23 Feb 2006 15:52:00 1100, Jamie Cameron <jca...@we...> wrot=
e:
> Have you tried just using the command 'dir' instead of 'ls -l' ? I don't
> think that ls options are officially supported by the FTP protocol, even
> though some servers allow them.
>
>  - Jamie
>
> -----Original Message-----
>
> From:  "samnang Chheng" <sam...@gm...>
> Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing user
> directive
> Date:  Thu 23 Feb 2006 2:41 pm
> Size:  1K
> To:  web...@li...
>
> Dear all,
> I have a problem with Proftpd Server  and  Virtualmin in fedora core 4.
> when i use ftp connect to my virtual user like :
>
> [root@localhost ~]# ftp localhost
> Connected to localhost.localdomain.
> 220 FTP Server ready.
> 500 AUTH not understood
> 500 AUTH not understood
> KERBEROS_V4 rejected as an authentication type
> Name (localhost:root): test
> 331 Password required for test.
> Password:
> 230 User test logged in.
> Remote system type is UNIX.
> Using binary mode to transfer files.
>
> Then i use command ls --al to show all my file list, but the result it
> doesn't show anything:
> ftp> ls --al
> 227 Entering Passive Mode (127,0,0,1,128,32).
> 150 Opening ASCII mode data connection for file list
> 226 Transfer complete.
> ftp>
>
> Usually, it show like this :
> ftp> ls --al
> 227 Entering Passive Mode (127,0,0,1,128,33).
> 150 Opening ASCII mode data connection for file list
> drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
> drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
> -rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthority
> -rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
> -rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_history
> -rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
> -rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profile
> -rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
> .................
> 226 Transfer complete.
> ftp>
>
> How can i solve this problem?
>
> Yours Sincerly,
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmd
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> -
> Forwarded by the Webmin mailing list at web...@li....n=
et
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
>

Re: [webmin-l] Problem with ProFTP Server & Virtualmin Missing user directive

[Jamie C. <jca...@we...>]

Have you tried just using the command 'dir' instead of 'ls -l' ? I don't =
think that ls options are officially supported by the FTP protocol, even =
though some servers allow them.

 - Jamie

-----Original Message-----

From:  "samnang Chheng" <sam...@gm...>
Subj:  [webmin-l] Problem with ProFTP Server & Virtualmin Missing user di=
rective
Date:  Thu 23 Feb 2006 2:41 pm
Size:  1K
To:  web...@li...

Dear all,
I have a problem with Proftpd Server  and  Virtualmin in fedora core 4.
when i use ftp connect to my virtual user like :

[root@localhost ~]# ftp localhost
Connected to localhost.localdomain.
220 FTP Server ready.
500 AUTH not understood
500 AUTH not understood
KERBEROS_V4 rejected as an authentication type
Name (localhost:root): test
331 Password required for test.
Password:
230 User test logged in.
Remote system type is UNIX.
Using binary mode to transfer files.

Then i use command ls --al to show all my file list, but the result it
doesn't show anything:
ftp> ls --al
227 Entering Passive Mode (127,0,0,1,128,32).
150 Opening ASCII mode data connection for file list
226 Transfer complete.
ftp>

Usually, it show like this :
ftp> ls --al
227 Entering Passive Mode (127,0,0,1,128,33).
150 Opening ASCII mode data connection for file list
drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
-rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthority
-rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
-rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_history
-rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
-rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profile
-rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
.................
226 Transfer complete.
ftp>

How can i solve this problem?

Yours Sincerly,


-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
that extends applications into web and mobile media. Attend the live webc=
ast
and join the prime developer group breaking into this new coding territor=
y!
http://sel.as-us.falkag.net/sel?cmd

Re: [webmin-l] New to MySQL

[Jamie C. <jca...@we...>]

Hi Dan,
You should check if MySQL actually gets started or not.. The problem may =
be that it really is running, but Webmin doesn't detect it properly. If i=
t is running, you should see a process called 'mysqld'.

 - Jamie

-----Original Message-----

From:  da...@so...
Subj:  Re: [webmin-l] New to MySQL
Date:  Thu 23 Feb 2006 9:22 am
Size:  2K
To:  da...@so..., web...@li...

I forgot to include this is a new install, webmin 1.260 on Slackware=20
10.2 with MySQL 4.1.14

From:           	da...@so...
To:             	web...@li...
Priority:       	normal
Subject:        	[webmin-l] New to MySQL
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=3Dunsubscrib=
e>
	<mailto:web...@li...?subject=3Dsubscribe>
Date sent:      	Wed, 22 Feb 2006 16:48:40 -0600


Hi,
Probably something simple. I can't seem to get MySQL server to=20
run. When I click the start server button it grinds for a short bit then=20
comes back to the start server.=20

I feel like a chicken or egg problem here as the start button refers=20
"Click this button to start the MySQL database server on your=20
system with the command cd /usr ;=20
(/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &.=20
This Webmin module cannot administer the database until it is=20
started. "
**************************************************
The host error log reads:
060222 16:33:18 mysqld started=20
060222 16:33:18 InnoDB: Database was not shut down=20
normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the=20
doublewrite
InnoDB: buffer...=20
060222 16:33:18 InnoDB: Starting log scan based on=20
checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number=20
0 43634
060222 16:33:18 InnoDB: Flushing modified pages from the=20
buffer pool...=20
060222 16:33:18 InnoDB: Started; log sequence number 0=20
43634=20
060222 16:33:18 [ERROR] Fatal error: Can't open privilege=20
tables: Table 'mysql.host' doesn't exist=20
060222 16:33:18 mysqld ended=20




-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
that extends applications into web and mobile media. Attend the live webc=
ast
and join the prime developer group breaking into this new coding territor=
y!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D110944&bid=3D241720&dat=3D=
121642
-
Forwarded by the Webmin mailing list at web...@li....n=
et
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list


--- message truncated ---

[webmin-l] Problem with ProFTP Server & Virtualmin Missing user directive

[samnang C. <sam...@gm...>]

Dear all,
I have a problem with Proftpd Server  and  Virtualmin in fedora core 4.
when i use ftp connect to my virtual user like :

[root@localhost ~]# ftp localhost
Connected to localhost.localdomain.
220 FTP Server ready.
500 AUTH not understood
500 AUTH not understood
KERBEROS_V4 rejected as an authentication type
Name (localhost:root): test
331 Password required for test.
Password:
230 User test logged in.
Remote system type is UNIX.
Using binary mode to transfer files.

Then i use command ls --al to show all my file list, but the result it
doesn't show anything:
ftp> ls --al
227 Entering Passive Mode (127,0,0,1,128,32).
150 Opening ASCII mode data connection for file list
226 Transfer complete.
ftp>

Usually, it show like this :
ftp> ls --al
227 Entering Passive Mode (127,0,0,1,128,33).
150 Opening ASCII mode data connection for file list
drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 .
drwxr-xr-x  22 samnang  samnang      4096 Feb 13 08:15 ..
-rw-------   1 samnang  samnang         0 Jan 18 03:27 .ICEauthority
-rw-------   1 samnang  samnang         0 Jan  5 01:23 .autorun.lck
-rw-------   1 samnang  samnang       304 Jan  5 09:26 .bash_history
-rw-r--r--   1 samnang  samnang        24 Jan  4 10:35 .bash_logout
-rw-r--r--   1 samnang  samnang       191 Jan  4 10:35 .bash_profile
-rw-r--r--   1 samnang  samnang       124 Jan  4 10:35 .bashrc
.................
226 Transfer complete.
ftp>

How can i solve this problem?

Yours Sincerly,

Re: [webmin-l] virtual interface and SSL

[<da...@so...>]

I wanted to revisit this now that I have set up a new pristine box. I 
did a clean install of slackware 10.2 manually so as to make sure 
that php4, mod_ssl and Mysql were successfully installed. I let 
slackware install Apache 1.3.33.

The clean http.conf does not contain the load or add modules for 
PhP or mod_ssl but at the end of the file contain INCLUDES:
*********************************************************************
# ==> mod_php configuration settings <==

#
# PACKAGES REQUIRED:  openssl-solibs (A series) and/or 
openssl (N series),
#                     mysql (AP series), gmp (L series), mhash (L series),
#                     and apache (N series)
#
Include /etc/apache/mod_php.conf

# ==> mod_ssl configuration settings <==
#
# PACKAGES REQUIRED:  apache (N series) and openssl (N 
series)
#
Include /etc/apache/mod_ssl.conf
***********************************************************************
this causes php4 and apachessl to appear in the 
apache modules module unchecked, but the server 
still runs. If I check the two mods and try to 
APPLY CHANGES I get:

 Syntax error on line 282 of 
/etc/apache/httpd.conf:
Cannot add module via name 'mod_php4.c': not in 
list of loaded modules
***********************************************
Now if I add both php4 and mod_ssl to the loaded 
modules then apply changes things are fine without 
the boxes checked in the apache modules, but there 
is no SSL running. But if I check the php4 and 
apachessl (that keeps appearing) and save, it 
inserts php4 and apachessl into the addmodule in 
http.conf. When I then try to APPLY CHANGES I get:
Syntax error on line 284 of /etc/apache/httpd.conf: Cannot add 
module via name 'mod_apachessl.c': not in list of loaded 
modules
If I modify http.conf load module to apachessl 
then I get:
Syntax error on line 239 of /etc/apache/httpd.conf: Can't locate 
API module structure `apachessl_module' in file 
/usr/libexec/apache/libssl.so: /usr/libexec/apache/libssl.so: 
undefined symbol: apachessl_module

Where does this apachessl come from?

If I remove the apache from the ssl directive the 
server will start fine.

**************************************************
Now when I create a virtual domain through 
virtualmin, with IP address and ssl enabled it 
creates fine. But when I enable ssl for the 
virtual server in the Apache module and restart 
Apache I get: 


Warning: User directive in  requires SUEXEC 
wrapper.
Warning: Group directive in  requires SUEXEC 
wrapper.
Warning: User directive in  requires SUEXEC 
wrapper.
Warning: Group directive in  requires SUEXEC 
wrapper.
Syntax error on line 1082 of 
/etc/apache/httpd.conf:
Invalid command 'SSLEnable', perhaps mis-spelled 
or defined by a module not included in the server 
configuration
/usr/sbin/apachectl start: httpd could not be 
started

These are the virtual host directives:

<VirtualHost 69.128.106.188:80>
User "#500"
Group "#500"
ServerName testagain.com
ServerAlias www.testagain.com
DocumentRoot /home/testagain/public_html
ErrorLog /home/testagain/logs/error_log
CustomLog /home/testagain/logs/access_log common
ScriptAlias /cgi-bin/ /home/testagain/cgi-bin/
<Directory /home/testagain/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
</Directory>
</VirtualHost>
<VirtualHost 69.128.106.188:443>
User "#500"
Group "#500"
ServerName testagain.com
ServerAlias www.testagain.com
DocumentRoot /home/testagain/public_html
ErrorLog /home/testagain/logs/error_log
CustomLog /home/testagain/logs/access_log common
ScriptAlias /cgi-bin/ /home/testagain/cgi-bin/
<Directory /home/testagain/public_html>
Options Indexes IncludesNOEXEC FollowSymLinks
allow from all
</Directory>
SSLEngine on
SSLCertificateFile /home/testagain/ssl.cert
SSLCertificateKeyFile /home/testagain/ssl.key
SSLEnable 
</VirtualHost>


Any clue to all this?


Dan





Subject:        	Re: [webmin-l] virtual interface and SSL
From:           	Jamie Cameron <jca...@we...>
To:             	web...@li...
Organization:   	
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=unsubscribe>
	<mailto:web...@li...?subject=subscribe>
Date sent:      	29 Jan 2006 09:57:53 +1100

[ Double-click this line for list subscription options ] 

On Sun, 2006-01-29 at 01:55, da...@so... wrote:
> What a wonderful work you guys are doing with webmin, it's power 
> continues to grow. Now I don't get into trouble until I experiment with 
> undocumented changes ;)
> 
> Problem:
> 
> In my first attempt to set up SSL virtual websites I failed. Jamie's 
> book pointed out that SSL won't work on namebased shared IP. So I 
> used Virtualmin to create a virtual IP interface and establish SSL. 
> Apache then created another virtual server with port 443 access 
> giving two virtual servers ( port 80 and 443) both with the new IP. 
> The SSL works great, but port 80 access gives page can't be 
> displayed. Mail seems to work fine. I can't find a way to remove the 
> virtual Interface from the virtual server and return it to shared as it 
> was so that the web at least has access for now.
> 
> I then upgraded Virtualmin to 2.610 to no avail. With this exception. 
> Now the servers created on Apache show up with a * in the address 
> field showing any. I know I shouldn't have experimented on the "live" 
> website.
> 
> Questions:
> 
> --Obviously, why doesn't the port 80 access work?
> --How does one remove or change the private IP setting on the 
> server? Virtualmin seems to clamp up once it goes private. And 
> using network interface module to remove it just shuts the entire 
> virtual server down as virtualmin retains the private IP address to 
> the server
> 
> I'm running Webmin 1.250 and Virtualmin 2.610 on a Slackware 
> 10.0 server with Apache 1.3.31

Port 80 certainly should work, so it is probably best to try to solve
that problem .. especially since Virtualmin cannot yet convert a 
server
from private IP back to shared.

What exact error message are you getting when you try the port 80 
URL?
Or is it just displaying the wrong website? Also, what does the
<Virtualhost> section header look like?

 - Jamie




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through 
log files
for problems?  Stop!  Download the new AJAX search engine that 
makes
searching your log files as easy as surfing the  web.  DOWNLOAD 
SPLUNK!
http://sel.as-
us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
-
Forwarded by the Webmin mailing list at webadmin-
li...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list

Re: [webmin-l] New to MySQL

[<da...@so...>]

I forgot to include this is a new install, webmin 1.260 on Slackware 
10.2 with MySQL 4.1.14

From:           	da...@so...
To:             	web...@li...
Priority:       	normal
Subject:        	[webmin-l] New to MySQL
Send reply to:  	web...@li...
	<mailto:web...@li...?subject=unsubscribe>
	<mailto:web...@li...?subject=subscribe>
Date sent:      	Wed, 22 Feb 2006 16:48:40 -0600


Hi,
Probably something simple. I can't seem to get MySQL server to 
run. When I click the start server button it grinds for a short bit then 
comes back to the start server. 

I feel like a chicken or egg problem here as the start button refers 
"Click this button to start the MySQL database server on your 
system with the command cd /usr ; 
(/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. 
This Webmin module cannot administer the database until it is 
started. "
**************************************************
The host error log reads:
060222 16:33:18 mysqld started 
060222 16:33:18 InnoDB: Database was not shut down 
normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the 
doublewrite
InnoDB: buffer... 
060222 16:33:18 InnoDB: Starting log scan based on 
checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 
0 43634
060222 16:33:18 InnoDB: Flushing modified pages from the 
buffer pool... 
060222 16:33:18 InnoDB: Started; log sequence number 0 
43634 
060222 16:33:18 [ERROR] Fatal error: Can't open privilege 
tables: Table 'mysql.host' doesn't exist 
060222 16:33:18 mysqld ended 

RE: [webmin-l] Webmin Servers, Broadcast/scan

[Jamie C. <jca...@we...>]

If changing the password at the command line works, give this a try :

1) Go to the Usermin Configuration module
2) Click on Usermin Module Configuration
3) Click on Change Password
4) Set the 'Change with' option to 'Use command', and enter /usr/bin/passwd
   into the adjacent text box.
5) Click Save.

 - Jamie

On 22/Feb/2006 16:51 Khan, Mohammed [SMO] wrote ..
> Changing password using command line works fine.  Only problem I have is
> changing password using usermin.  It is giving error
> Feb 22 14:45:02 dublx09 l/usermin/changepass/changepass.cgi: pam_ldap:
> error trying t
>  as user "uid=mkhan,ou=People, dc=noam,dc=corp,dc=frk,dc=com" (Invalid
> credentials)
> 
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Craig
> White
> Sent: Friday, February 17, 2006 5:19 PM
> To: web...@li...
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> 
> 
> That's sort of an unfair request.
> 
> I doubt he's using FDS.
> 
> If I was going to take a guess...it would be these lines
> in /etc/ldap.conf
> 
> #nss_base_passwd         ou=People,dc=noam,dc=corp,dc=frk,dc=com
> #nss_base_shadow         ou=People,dc=noam,dc=corp,dc=frk,dc=com
> #nss_base_passwd        ou=People,dc=example,dc=com?one
> 
> I don't think that they should be commented out but should probably be
> 
> nss_base_passwd         ou=People,dc=noam,dc=corp,dc=frk,dc=com?one
> nss_base_shadow         ou=People,dc=noam,dc=corp,dc=frk,dc=com?one
> nss_base_passwd         ou=People,dc=noam,dc=corp,dc=frk,dc=com?one
> 
> but that could be ou=Users - it all depends upon how you have Directory
> Server set up.
> 
> and I'm guessing that you are using something like RHEL 4 by the ldap.conf
> below and I have never set up pam_ldap and thus am not qualified to give
> you an opinion on how it works.
> 
> I do use FDS and OpenLDAP on various servers all RHEL and have never used
> pam_ldap and can change passwords from the command line which is what Jamie
> asked you.
> 
> i.e.
> 
> # passwd craig
> Changing password for user craig.
> New UNIX password:
> Retype new UNIX password:
> LDAP password information changed for craig
> passwd: all authentication tokens updated successfully.
> 
> and then to verify that the password change actually worked...
> # ssh craig@localhost
> craig@localhost's password:
> Last login: Fri Jan 27 22:16:45 2006
> 
> because what Jamie is suggesting is that if you can do what I just demonstrated,
> he believes Usermin would authenticate a user.
> 
> perhaps you should spend a little more time learning how to do handle your
> own administration because once you can do you own administration, configuring
> a client tool such as Webmin or Usermin becomes much easier.
> 
> Craig
> ----
> > 
> On Fri, 2006-02-17 at 15:54 -0800, Khan, Mohammed [SMO] wrote:
> > Jamie, Please can you please check my file.  And let me know what I am
> doing wrong.
> > 
> > -----Original Message-----
> > From: Khan, Mohammed [SMO] 
> > Sent: Friday, February 17, 2006 10:55 AM
> > To: 'web...@li...'
> > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> > 
> > 
> > Morning Jamie,
> > I am attaching my ldap.conf file please check and let me know what I
> am  doing wrong.  If I an able the bindpw  I am not able to login to usermin.
> Please check if the way I have set it up is correct.  Do I create a file
> /etc/ldap.secret and copy the line from ldap.conf file.  Please let me
> know
> > # @(#)$Id: ldap.conf,v 1.27 2003/01/17 21:37:12 lukeh Exp $
> > #
> > # This is the configuration file for the LDAP nameservice
> > # switch library and the LDAP PAM module.
> > #
> > # PADL Software
> > # http://www.padl.com
> > #
> > 
> > # Your LDAP server. Must be resolvable without using LDAP.
> > # Multiple hosts may be specified, each separated by a
> > # space. How long nss_ldap takes to failover depends on
> > # whether your LDAP client library supports configurable
> > # network or connect timeouts (see bind_timelimit).
> > #host 127.0.0.1
> > host dublx06.noam.corp.frk.com
> > 
> > # The distinguished name of the search base.
> > #base dc=example,dc=com
> > #base dc=people,dc=noam,dc=corp,dc=frk,dc=com
> > base dc=noam,dc=corp,dc=frk,dc=com
> > 
> > # Another way to specify your LDAP server is to provide an
> > # uri with the server name. This allows to use
> > # Unix Domain Sockets to connect to a local LDAP Server.
> > #uri ldap://127.0.0.1/
> > #uri ldaps://127.0.0.1/
> > #uri ldapi://%2fvar%2frun%2fldapi_sock/
> > # Note: %2f encodes the '/' used as directory separator
> > 
> > # The LDAP version to use (defaults to 3
> > # if supported by client library)
> > ldap_version 3
> > 
> > # The distinguished name to bind to the server with.
> > # Optional: default is to bind anonymously.
> > #binddn cn=proxyuser,dc=example,dc=com
> > #binddn cn=Directory Manager
> > 
> > # The credentials to bind with.
> > # Optional: default is no credential.
> > bindpw secret
> > # The distinguished name to bind to the server with
> > # if the effective user ID is root. Password is
> > # stored in /etc/ldap.secret (mode 600)
> > #rootbinddn cn=manager,dc=example,dc=com
> > rootbinddn cn=Directory Manager
> > 
> > # The port.
> > # Optional: default is 389.
> > #port 389
> > 
> > # The search scope.
> > #scope sub
> > #scope one
> > #scope base
> > 
> > # Search timelimit
> > #timelimit 30
> > 
> > # Bind timelimit
> > #bind_timelimit 30
> > 
> > # Idle timelimit; client will close connections
> > # (nss_ldap only) if the server has not been contacted
> > # for the number of seconds specified below.
> > #idle_timelimit 3600
> > 
> > # Filter to AND with uid=%s
> > #pam_filter objectclass=account
> > pam_filter objectclass=posixAccount
> > 
> > # The user ID attribute (defaults to uid)
> > pam_login_attribute uid
> > 
> > # Search the root DSE for the password policy (works
> > # with Netscape Directory Server)
> > #pam_lookup_policy yes
> > 
> > # Check the 'host' attribute for access control
> > # Default is no; if set to yes, and user has no
> > # value for the host attribute, and pam_ldap is
> > # configured for account management (authorization)
> > # then the user will not be allowed to login.
> > #pam_check_host_attr yes
> > 
> > # Group to enforce membership of
> > #pam_groupdn cn=PAM,ou=Groups,dc=example,dc=com
> > pam_groupdn cn=TestGroup,ou=Groups,dc=noam,dc=corp,dc=frk,dc=com
> > #pam_groupdn cn=dublx09,ou=Groups,dc=noam,dc=corp,dc=frk,dc=com
> > 
> > # Group member attribute
> > #pam_member_attribute uniquemember
> > pam_member_attribute memberUid
> > 
> > # Specify a minium or maximum UID number allowed
> > #pam_min_uid 0
> > #pam_max_uid 0
> > 
> > # Template login attribute, default template user
> > # (can be overriden by value of former attribute
> > # in user's entry)
> > #pam_login_attribute userPrincipalName
> > #pam_template_login_attribute uid
> > #pam_template_login nobody
> > 
> > # HEADS UP: the pam_crypt, pam_nds_passwd,
> > # and pam_ad_passwd options are no
> > # longer supported.
> > 
> > # Do not hash the password at all; presume
> > # the directory server will do it, if
> > # necessary. This is the default.
> > #pam_password clear
> > 
> > # Hash password locally; required for University of
> > # Michigan LDAP server, and works with Netscape
> > # Directory Server if you're using the UNIX-Crypt
> > # hash mechanism and not using the NT Synchronization
> > # service.
> > #pam_password crypt
> > 
> > # Remove old password first, then update in
> > # cleartext. Necessary for use with Novell
> > # Directory Services (NDS)
> > #pam_password nds
> > 
> > # Update Active Directory password, by
> > # creating Unicode password and updating
> > # unicodePwd attribute.
> > #pam_password ad
> > 
> > # Use the OpenLDAP password change
> > # extended operation to update the password.
> > #pam_password exop
> > #pam_password crypt
> > 
> > # Redirect users to a URL or somesuch on password
> > # changes.
> > #pam_password_prohibit_message Please visit http://internal to change
> your password.
> > 
> > # RFC2307bis naming contexts
> > # Syntax:
> > # nss_base_XXX          base?scope?filter
> > # where scope is {base,one,sub}
> > # and filter is a filter to be &'d with the
> > # default filter.
> > # You can omit the suffix eg:
> > # nss_base_passwd       ou=People,
> > # to append the default base DN but this
> > # may incur a small performance impact.
> > #nss_base_passwd         ou=People,dc=noam,dc=corp,dc=frk,dc=com
> > #nss_base_shadow         ou=People,dc=noam,dc=corp,dc=frk,dc=com
> > #nss_base_passwd        ou=People,dc=example,dc=com?one
> > #nss_base_shadow        ou=People,dc=example,dc=com?one
> > #nss_base_group         ou=Group,dc=example,dc=com?one
> > #nss_base_group         ou=Groups,dc=noam,dc=corp,dc=frk,dc=com
> > #nss_base_hosts         ou=Hosts,dc=example,dc=com?one
> > #nss_base_services      ou=Services,dc=example,dc=com?one
> > #nss_base_networks      ou=Networks,dc=example,dc=com?one
> > #nss_base_protocols     ou=Protocols,dc=example,dc=com?one
> > #nss_base_rpc           ou=Rpc,dc=example,dc=com?one
> > #nss_base_ethers        ou=Ethers,dc=example,dc=com?one
> > #nss_base_netmasks      ou=Networks,dc=example,dc=com?ne
> > #nss_base_bootparams    ou=Ethers,dc=example,dc=com?one
> > #nss_base_aliases       ou=Aliases,dc=example,dc=com?one
> > #nss_base_netgroup      ou=Netgroup,dc=example,dc=com?one
> > 
> > # attribute/objectclass mapping
> > # Syntax:
> > #nss_map_attribute      rfc2307attribute        mapped_attribute
> > #nss_map_objectclass    rfc2307objectclass      mapped_objectclass
> > 
> > # configure --enable-nds is no longer supported.
> > # For NDS now do:
> > #nss_map_attribute uniqueMember member
> > 
> > # configure --enable-mssfu-schema is no longer supported.
> > # For MSSFU now do:
> > #nss_map_objectclass posixAccount User
> > #nss_map_attribute uid msSFUName
> > #nss_map_attribute uniqueMember posixMember
> > #nss_map_attribute userPassword msSFUPassword
> > #nss_map_attribute homeDirectory msSFUHomeDirectory
> > #nss_map_objectclass posixGroup Group
> > #pam_login_attribute msSFUName
> > #pam_filter objectclass=User
> > #pam_password ad
> > 
> > # configure --enable-authpassword is no longer supported
> > # For authPassword support, now do:
> > #nss_map_attribute userPassword authPassword
> > #pam_password nds
> > 
> > # For IBM SecureWay support, do:
> > #nss_map_objectclass posixAccount aixAccount
> > #nss_map_attribute uid userName
> > #nss_map_attribute gidNumber gid
> > #nss_map_attribute uidNumber uid
> > #nss_map_attribute userPassword passwordChar
> > #nss_map_objectclass posixGroup aixAccessGroup
> > #nss_map_attribute cn dublx09
> > #nss_map_attribute memberUid member
> > #pam_login_attribute userName
> > #pam_filter objectclass=aixAccount
> > #pam_password clear
> > 
> > # Netscape SDK LDAPS
> > #ssl on
> > 
> > # Netscape SDK SSL options
> > #sslpath /etc/ssl/certs/cert7.db
> > 
> > # OpenLDAP SSL mechanism
> > # start_tls mechanism uses the normal LDAP port, LDAPS typically 636
> > #ssl start_tls
> > #ssl on
> > 
> > # OpenLDAP SSL options
> > # Require and verify server certificate (yes/no)
> > # Default is "no"
> > #tls_checkpeer yes
> > 
> > # CA certificates for server certificate verification
> > # At least one of these are required if tls_checkpeer is "yes"
> > #tls_cacertfile /etc/ssl/ca.cert
> > #tls_cacertdir /etc/ssl/certs
> > 
> > # Seed the PRNG if /dev/urandom is not provided
> > #tls_randfile /var/run/egd-pool
> > 
> > # SSL cipher suite
> > # See man ciphers for syntax
> > #tls_ciphers TLSv1
> > 
> > # Client certificate and key
> > # Use these, if your server requires client authentication.
> > #tls_cert
> > #tls_key
> > ssl no
> > 
> > -----Original Message-----
> > From: web...@li...
> > [mailto:web...@li...]On Behalf Of Jamie
> > Cameron
> > Sent: Friday, February 17, 2006 9:02 AM
> > To: web...@li...
> > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> > 
> > 
> > That file should already exist somewhere under /etc on your system. It
> may be called something different too, like pam_ldap.conf
> > 
> >  - Jamie
> > 
> > -----Original Message-----
> > 
> > From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> > Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> > Date:  Fri 17 Feb 2006 4:21 pm
> > Size:  2K
> > To:  <web...@li...>
> > 
> > I don't have that file so shall I create these files, just fyi my server
> linux AS2.1.  If I do what shall I put in the file.
> > 
> > -----Original Message-----
> > From: web...@li...
> > [mailto:web...@li...]On Behalf Of Jamie
> > Cameron
> > Sent: Thursday, February 16, 2006 5:26 PM
> > To: web...@li...
> > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> > 
> > 
> > Make sure that in your PAM LDAP config file (/etc/pam_ldap/auth_ldap.conf
> > on my system) that the binddn and rootbinddn parameters are set to your
> > LDAP administration user, and that the passwords in the bindpw parameter
> and
> > /etc/ldap.secret file are set to match. Otherwise PAM will connect to
> LDAP
> > as the user who is changing his password, which will generally not be
> allowed.
> > 
> >  - Jamie
> > 
> > On 17/Feb/2006 11:43 Khan, Mohammed [SMO] wrote ..
> > > Jamie, now i am  getting this error:
> > > Feb 16 16:36:29 dublx09 l/usermin/changepass/changepass.cgi: pam_ldap:
> > > error trying to bind as user "uid=mkhan,ou=People, dc=noam,dc=corp,dc=frk,dc=com"
> > > (Invalid credentials)
> > > 
> > > -----Original Message-----
> > > From: web...@li...
> > > [mailto:web...@li...]On Behalf Of Jamie
> > > Cameron
> > > Sent: Friday, February 17, 2006 2:10 AM
> > > To: web...@li...
> > > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> > > 
> > > 
> > > Hi,
> > > That looks OK..
> > > Can LDAP users use the command-line passwd command to change their
> passwords?
> > > 
> > >  - Jamie
> > > 
> > > -----Original Message-----
> > > 
> > > From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> > > Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> > > Date:  Fri 17 Feb 2006 10:07 am
> > > Size:  2K
> > > To:  <web...@li...>
> > > 
> > > Hi Jamie,
> > > Here is my passwd file:  Pls tell me what I am doing worng.
> > > #%PAM-1.0
> > > password    required      pam_cracklib.so
> > > password    sufficient    pam_ldap.so
> > > password    sufficient    pam_unix.so
> > > password    required      pam_deny.so
> > > 
> > > 
> > > 
> > > Thanks
> > > Mohammed
> > > 
> > > -----Original Message-----
> > > From: web...@li...
> > > [mailto:web...@li...]On Behalf Of Jamie
> > > Cameron
> > > Sent: Thursday, February 16, 2006 2:46 PM
> > > To: web...@li...
> > > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> > > 
> > > 
> > > Just make sure that /etc/pam.d/passwd is setup to talk to LDAP, and
> that
> > > Usermin's
> > > Change Password module is setup to use PAM.
> > > 
> > >  - Jamie
> > > 
> > > On 17/Feb/2006 09:42 Khan, Mohammed [SMO] wrote ..
> > > > Hello Jamie, 
> > > > Do you know how can I use usermin to change my ldap password.  Please
> > > need
> > > > your help.
> > > > 
> > > > Thanks
> > > > Mohammed
> > > > 
> 
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log
> files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
> -
> Forwarded by the Webmin mailing list at web...@li...
> To remove yourself from this list, go to
> http://lists.sourceforge.net/lists/listinfo/webadmin-list
> Notice:  All email and instant messages (including attachments) sent to
> or from Franklin Templeton Investments (FTI) personnel may be retained,
> monitored and/or reviewed by FTI and its agents, or authorized
> law enforcement personnel, without further notice or consent.
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting language
> that extends applications into web and mobile media. Attend the live webcast
> and join the prime developer group breaking into this new coding territory!
> http://sel.as-us.falkag.net/sel?cmd

RE: [webmin-l] Webmin Servers, Broadcast/scan

[Khan, M. [SMO] <MK...@fr...>]

Changing password using command line works fine.  Only problem I have is ch=
anging password using usermin.  It is giving error
Feb 22 14:45:02 dublx09 l/usermin/changepass/changepass.cgi: pam_ldap: erro=
r trying t
 as user "uid=3Dmkhan,ou=3DPeople, dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom" (=
Invalid credentials)

-----Original Message-----
From: web...@li...
[mailto:web...@li...]On Behalf Of Craig
White
Sent: Friday, February 17, 2006 5:19 PM
To: web...@li...
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


That's sort of an unfair request.

I doubt he's using FDS.

If I was going to take a guess...it would be these lines
in /etc/ldap.conf

#nss_base_passwd         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
#nss_base_shadow         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
#nss_base_passwd        ou=3DPeople,dc=3Dexample,dc=3Dcom?one

I don't think that they should be commented out but should probably be

nss_base_passwd         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom?o=
ne
nss_base_shadow         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom?o=
ne
nss_base_passwd         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom?o=
ne

but that could be ou=3DUsers - it all depends upon how you have Directory S=
erver set up.

and I'm guessing that you are using something like RHEL 4 by the ldap.conf =
below and I have never set up pam_ldap and thus am not qualified to give yo=
u an opinion on how it works.

I do use FDS and OpenLDAP on various servers all RHEL and have never used p=
am_ldap and can change passwords from the command line which is what Jamie =
asked you.

i=2Ee.

# passwd craig
Changing password for user craig.
New UNIX password:
Retype new UNIX password:
LDAP password information changed for craig
passwd: all authentication tokens updated successfully.

and then to verify that the password change actually worked...
# ssh craig@localhost
craig@localhost's password:
Last login: Fri Jan 27 22:16:45 2006

because what Jamie is suggesting is that if you can do what I just demonstr=
ated, he believes Usermin would authenticate a user.

perhaps you should spend a little more time learning how to do handle your =
own administration because once you can do you own administration, configur=
ing a client tool such as Webmin or Usermin becomes much easier.

Craig
----
>=20
On Fri, 2006-02-17 at 15:54 -0800, Khan, Mohammed [SMO] wrote:
> Jamie, Please can you please check my file.  And let me know what I am do=
ing wrong.
>=20
> -----Original Message-----
> From: Khan, Mohammed [SMO]=20
> Sent: Friday, February 17, 2006 10:55 AM
> To: 'web...@li...'
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
>=20
>=20
> Morning Jamie,
> I am attaching my ldap.conf file please check and let me know what I am  =
doing wrong.  If I an able the bindpw  I am not able to login to usermin.  =
Please check if the way I have set it up is correct.  Do I create a file /e=
tc/ldap.secret and copy the line from ldap.conf file.  Please let me know
> # @(#)$Id: ldap.conf,v 1.27 2003/01/17 21:37:12 lukeh Exp $
> #
> # This is the configuration file for the LDAP nameservice
> # switch library and the LDAP PAM module.
> #
> # PADL Software
> # http://www.padl.com
> #
>=20
> # Your LDAP server. Must be resolvable without using LDAP.
> # Multiple hosts may be specified, each separated by a
> # space. How long nss_ldap takes to failover depends on
> # whether your LDAP client library supports configurable
> # network or connect timeouts (see bind_timelimit).
> #host 127.0.0.1
> host dublx06.noam.corp.frk.com
>=20
> # The distinguished name of the search base.
> #base dc=3Dexample,dc=3Dcom
> #base dc=3Dpeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> base dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
>=20
> # Another way to specify your LDAP server is to provide an
> # uri with the server name. This allows to use
> # Unix Domain Sockets to connect to a local LDAP Server.
> #uri ldap://127.0.0.1/
> #uri ldaps://127.0.0.1/
> #uri ldapi://%2fvar%2frun%2fldapi_sock/
> # Note: %2f encodes the '/' used as directory separator
>=20
> # The LDAP version to use (defaults to 3
> # if supported by client library)
> ldap_version 3
>=20
> # The distinguished name to bind to the server with.
> # Optional: default is to bind anonymously.
> #binddn cn=3Dproxyuser,dc=3Dexample,dc=3Dcom
> #binddn cn=3DDirectory Manager
>=20
> # The credentials to bind with.
> # Optional: default is no credential.
> bindpw secret
> # The distinguished name to bind to the server with
> # if the effective user ID is root. Password is
> # stored in /etc/ldap.secret (mode 600)
> #rootbinddn cn=3Dmanager,dc=3Dexample,dc=3Dcom
> rootbinddn cn=3DDirectory Manager
>=20
> # The port.
> # Optional: default is 389.
> #port 389
>=20
> # The search scope.
> #scope sub
> #scope one
> #scope base
>=20
> # Search timelimit
> #timelimit 30
>=20
> # Bind timelimit
> #bind_timelimit 30
>=20
> # Idle timelimit; client will close connections
> # (nss_ldap only) if the server has not been contacted
> # for the number of seconds specified below.
> #idle_timelimit 3600
>=20
> # Filter to AND with uid=3D%s
> #pam_filter objectclass=3Daccount
> pam_filter objectclass=3DposixAccount
>=20
> # The user ID attribute (defaults to uid)
> pam_login_attribute uid
>=20
> # Search the root DSE for the password policy (works
> # with Netscape Directory Server)
> #pam_lookup_policy yes
>=20
> # Check the 'host' attribute for access control
> # Default is no; if set to yes, and user has no
> # value for the host attribute, and pam_ldap is
> # configured for account management (authorization)
> # then the user will not be allowed to login.
> #pam_check_host_attr yes
>=20
> # Group to enforce membership of
> #pam_groupdn cn=3DPAM,ou=3DGroups,dc=3Dexample,dc=3Dcom
> pam_groupdn cn=3DTestGroup,ou=3DGroups,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3D=
com
> #pam_groupdn cn=3Ddublx09,ou=3DGroups,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dc=
om
>=20
> # Group member attribute
> #pam_member_attribute uniquemember
> pam_member_attribute memberUid
>=20
> # Specify a minium or maximum UID number allowed
> #pam_min_uid 0
> #pam_max_uid 0
>=20
> # Template login attribute, default template user
> # (can be overriden by value of former attribute
> # in user's entry)
> #pam_login_attribute userPrincipalName
> #pam_template_login_attribute uid
> #pam_template_login nobody
>=20
> # HEADS UP: the pam_crypt, pam_nds_passwd,
> # and pam_ad_passwd options are no
> # longer supported.
>=20
> # Do not hash the password at all; presume
> # the directory server will do it, if
> # necessary. This is the default.
> #pam_password clear
>=20
> # Hash password locally; required for University of
> # Michigan LDAP server, and works with Netscape
> # Directory Server if you're using the UNIX-Crypt
> # hash mechanism and not using the NT Synchronization
> # service.
> #pam_password crypt
>=20
> # Remove old password first, then update in
> # cleartext. Necessary for use with Novell
> # Directory Services (NDS)
> #pam_password nds
>=20
> # Update Active Directory password, by
> # creating Unicode password and updating
> # unicodePwd attribute.
> #pam_password ad
>=20
> # Use the OpenLDAP password change
> # extended operation to update the password.
> #pam_password exop
> #pam_password crypt
>=20
> # Redirect users to a URL or somesuch on password
> # changes.
> #pam_password_prohibit_message Please visit http://internal to change you=
r password.
>=20
> # RFC2307bis naming contexts
> # Syntax:
> # nss_base_XXX          base?scope?filter
> # where scope is {base,one,sub}
> # and filter is a filter to be &'d with the
> # default filter.
> # You can omit the suffix eg:
> # nss_base_passwd       ou=3DPeople,
> # to append the default base DN but this
> # may incur a small performance impact.
> #nss_base_passwd         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> #nss_base_shadow         ou=3DPeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> #nss_base_passwd        ou=3DPeople,dc=3Dexample,dc=3Dcom?one
> #nss_base_shadow        ou=3DPeople,dc=3Dexample,dc=3Dcom?one
> #nss_base_group         ou=3DGroup,dc=3Dexample,dc=3Dcom?one
> #nss_base_group         ou=3DGroups,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> #nss_base_hosts         ou=3DHosts,dc=3Dexample,dc=3Dcom?one
> #nss_base_services      ou=3DServices,dc=3Dexample,dc=3Dcom?one
> #nss_base_networks      ou=3DNetworks,dc=3Dexample,dc=3Dcom?one
> #nss_base_protocols     ou=3DProtocols,dc=3Dexample,dc=3Dcom?one
> #nss_base_rpc           ou=3DRpc,dc=3Dexample,dc=3Dcom?one
> #nss_base_ethers        ou=3DEthers,dc=3Dexample,dc=3Dcom?one
> #nss_base_netmasks      ou=3DNetworks,dc=3Dexample,dc=3Dcom?ne
> #nss_base_bootparams    ou=3DEthers,dc=3Dexample,dc=3Dcom?one
> #nss_base_aliases       ou=3DAliases,dc=3Dexample,dc=3Dcom?one
> #nss_base_netgroup      ou=3DNetgroup,dc=3Dexample,dc=3Dcom?one
>=20
> # attribute/objectclass mapping
> # Syntax:
> #nss_map_attribute      rfc2307attribute        mapped_attribute
> #nss_map_objectclass    rfc2307objectclass      mapped_objectclass
>=20
> # configure --enable-nds is no longer supported.
> # For NDS now do:
> #nss_map_attribute uniqueMember member
>=20
> # configure --enable-mssfu-schema is no longer supported.
> # For MSSFU now do:
> #nss_map_objectclass posixAccount User
> #nss_map_attribute uid msSFUName
> #nss_map_attribute uniqueMember posixMember
> #nss_map_attribute userPassword msSFUPassword
> #nss_map_attribute homeDirectory msSFUHomeDirectory
> #nss_map_objectclass posixGroup Group
> #pam_login_attribute msSFUName
> #pam_filter objectclass=3DUser
> #pam_password ad
>=20
> # configure --enable-authpassword is no longer supported
> # For authPassword support, now do:
> #nss_map_attribute userPassword authPassword
> #pam_password nds
>=20
> # For IBM SecureWay support, do:
> #nss_map_objectclass posixAccount aixAccount
> #nss_map_attribute uid userName
> #nss_map_attribute gidNumber gid
> #nss_map_attribute uidNumber uid
> #nss_map_attribute userPassword passwordChar
> #nss_map_objectclass posixGroup aixAccessGroup
> #nss_map_attribute cn dublx09
> #nss_map_attribute memberUid member
> #pam_login_attribute userName
> #pam_filter objectclass=3DaixAccount
> #pam_password clear
>=20
> # Netscape SDK LDAPS
> #ssl on
>=20
> # Netscape SDK SSL options
> #sslpath /etc/ssl/certs/cert7.db
>=20
> # OpenLDAP SSL mechanism
> # start_tls mechanism uses the normal LDAP port, LDAPS typically 636
> #ssl start_tls
> #ssl on
>=20
> # OpenLDAP SSL options
> # Require and verify server certificate (yes/no)
> # Default is "no"
> #tls_checkpeer yes
>=20
> # CA certificates for server certificate verification
> # At least one of these are required if tls_checkpeer is "yes"
> #tls_cacertfile /etc/ssl/ca.cert
> #tls_cacertdir /etc/ssl/certs
>=20
> # Seed the PRNG if /dev/urandom is not provided
> #tls_randfile /var/run/egd-pool
>=20
> # SSL cipher suite
> # See man ciphers for syntax
> #tls_ciphers TLSv1
>=20
> # Client certificate and key
> # Use these, if your server requires client authentication.
> #tls_cert
> #tls_key
> ssl no
>=20
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Jamie
> Cameron
> Sent: Friday, February 17, 2006 9:02 AM
> To: web...@li...
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
>=20
>=20
> That file should already exist somewhere under /etc on your system. It ma=
y be called something different too, like pam_ldap.conf
>=20
>  - Jamie
>=20
> -----Original Message-----
>=20
> From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> Date:  Fri 17 Feb 2006 4:21 pm
> Size:  2K
> To:  <web...@li...>
>=20
> I don't have that file so shall I create these files, just fyi my server =
linux AS2.1.  If I do what shall I put in the file.
>=20
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Jamie
> Cameron
> Sent: Thursday, February 16, 2006 5:26 PM
> To: web...@li...
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
>=20
>=20
> Make sure that in your PAM LDAP config file (/etc/pam_ldap/auth_ldap.conf
> on my system) that the binddn and rootbinddn parameters are set to your
> LDAP administration user, and that the passwords in the bindpw parameter =
and
> /etc/ldap.secret file are set to match. Otherwise PAM will connect to LDAP
> as the user who is changing his password, which will generally not be all=
owed.
>=20
>  - Jamie
>=20
> On 17/Feb/2006 11:43 Khan, Mohammed [SMO] wrote ..
> > Jamie, now i am  getting this error:
> > Feb 16 16:36:29 dublx09 l/usermin/changepass/changepass.cgi: pam_ldap:
> > error trying to bind as user "uid=3Dmkhan,ou=3DPeople, dc=3Dnoam,dc=3Dc=
orp,dc=3Dfrk,dc=3Dcom"
> > (Invalid credentials)
> >=20
> > -----Original Message-----
> > From: web...@li...
> > [mailto:web...@li...]On Behalf Of Jamie
> > Cameron
> > Sent: Friday, February 17, 2006 2:10 AM
> > To: web...@li...
> > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> >=20
> >=20
> > Hi,
> > That looks OK..
> > Can LDAP users use the command-line passwd command to change their pass=
words?
> >=20
> >  - Jamie
> >=20
> > -----Original Message-----
> >=20
> > From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> > Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> > Date:  Fri 17 Feb 2006 10:07 am
> > Size:  2K
> > To:  <web...@li...>
> >=20
> > Hi Jamie,
> > Here is my passwd file:  Pls tell me what I am doing worng.
> > #%PAM-1.0
> > password    required      pam_cracklib.so
> > password    sufficient    pam_ldap.so
> > password    sufficient    pam_unix.so
> > password    required      pam_deny.so
> >=20
> >=20
> >=20
> > Thanks
> > Mohammed
> >=20
> > -----Original Message-----
> > From: web...@li...
> > [mailto:web...@li...]On Behalf Of Jamie
> > Cameron
> > Sent: Thursday, February 16, 2006 2:46 PM
> > To: web...@li...
> > Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
> >=20
> >=20
> > Just make sure that /etc/pam.d/passwd is setup to talk to LDAP, and that
> > Usermin's
> > Change Password module is setup to use PAM.
> >=20
> >  - Jamie
> >=20
> > On 17/Feb/2006 09:42 Khan, Mohammed [SMO] wrote ..
> > > Hello Jamie,=20
> > > Do you know how can I use usermin to change my ldap password.  Please
> > need
> > > your help.
> > >=20
> > > Thanks
> > > Mohammed
> > >=20




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D1=
21642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list
Notice:  All email and instant messages (including attachments) sent to
or from Franklin Templeton Investments (FTI) personnel may be retained,
monitored and/or reviewed by FTI and its agents, or authorized
law enforcement personnel, without further notice or consent.

[webmin-l] New to MySQL

[<da...@so...>]

Hi,
Probably something simple. I can't seem to get MySQL server to 
run. When I click the start server button it grinds for a short bit then 
comes back to the start server. 

I feel like a chicken or egg problem here as the start button refers 
"Click this button to start the MySQL database server on your 
system with the command cd /usr ; 
(/usr/bin/safe_mysqld || /usr/bin/mysqld_safe) &. 
This Webmin module cannot administer the database until it is 
started. "
**************************************************
The host error log reads:
060222 16:33:18 mysqld started 
060222 16:33:18 InnoDB: Database was not shut down 
normally!
 InnoDB: Starting crash recovery.
 InnoDB: Reading tablespace information from the .ibd files...
 InnoDB: Restoring possible half-written data pages from the 
doublewrite
 InnoDB: buffer... 
060222 16:33:18 InnoDB: Starting log scan based on 
checkpoint at
 InnoDB: log sequence number 0 43634.
 InnoDB: Doing recovery: scanned up to log sequence number 
0 43634
 060222 16:33:18 InnoDB: Flushing modified pages from the 
buffer pool... 
060222 16:33:18 InnoDB: Started; log sequence number 0 
43634 
060222 16:33:18 [ERROR] Fatal error: Can't open privilege 
tables: Table 'mysql.host' doesn't exist 
060222 16:33:18 mysqld ended 

RE: [webmin-l] Webmin Servers, Broadcast/scan

[Khan, M. [SMO] <MK...@fr...>]

Jamie why I am getting this error when changing password.

Feb 22 14:09:19 dublx09 l/usermin/changepass/changepass.cgi: pam_ldap: erro=
r try
ing to bind as user "uid=3Dmkhan,ou=3DPeople, dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,=
dc=3Dcom" (Invali
d credentials)

-----Original Message-----
From: Khan, Mohammed [SMO]=20
Sent: Wednesday, February 22, 2006 1:14 PM
To: 'web...@li...'
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


Jamie, Pls any update.

-----Original Message-----
From: Khan, Mohammed [SMO]=20
Sent: Tuesday, February 21, 2006 4:16 PM
To: 'web...@li...'
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


Jamie, any update please.

-----Original Message-----
From: Khan, Mohammed [SMO]=20
Sent: Monday, February 20, 2006 10:20 PM
To: 'web...@li...'
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


RedHat AS2.1


-----Original Message-----
From: web...@li...
[mailto:web...@li...]On Behalf Of Jamie
Cameron
Sent: Monday, February 20, 2006 9:10 PM
To: web...@li...
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


Which Linux distributon are you using there?

 - Jamie

On 20/Feb/2006 23:37 Khan, Mohammed [SMO] wrote ..
> I not able to find the file in my server, I can you pls send me the file
> and I can put it in my server.  Thanks.
>=20
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Jamie
> Cameron
> Sent: Sunday, February 19, 2006 6:39 AM
> To: web...@li...
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
>=20
>=20
> Hi Mohammed,
> That is not the correct file, sorry. The one you attached is for the NSS-=
LDAP
> configuration, but there is also a separate file for PAM-LDAP configurati=
on.
> I am not sure where it would be located on your system though - it varies
> from one Linux distribution to another.
>=20
>  - Jamie
>=20
> -----Original Message-----
>=20
> From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> Date:  Sat 18 Feb 2006 5:55 am
> Size:  2K
> To:  <web...@li...>
>=20
> Morning Jamie,
> I am attaching my ldap.conf file please check and let me know what I am
> doing wrong.  If I an able the bindpw  I am not able to login to usermin.
> Please check if the way I have set it up is correct.  Do I create a file
> /etc/ldap.secret and copy the line from ldap.conf file.  Please let me
> know
> # @(#)$Id: ldap.conf,v 1.27 2003/01/17 21:37:12 lukeh Exp $
> #
> # This is the configuration file for the LDAP nameservice
> # switch library and the LDAP PAM module.
> #
> # PADL Software
> # http://www.padl.com
> #
>=20
> # Your LDAP server. Must be resolvable without using LDAP.
> # Multiple hosts may be specified, each separated by a
> # space. How long nss_ldap takes to failover depends on
> # whether your LDAP client library supports configurable
> # network or connect timeouts (see bind_timelimit).
> #host 127.0.0.1
> host dublx06.noam.corp.frk.com
>=20
> # The distinguished name of the search base.
> #base dc=3Dexample,dc=3Dcom
> #base dc=3Dpeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> base dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
>=20
> # Another way to specify your LDAP server is to provide an
> # uri with the server name. This allows to use
> # Unix Domain Sockets to connect to a local LDAP Server.
> #uri ldap://127.0.0.1/
> #uri ldaps://127.0.0.1/
> #uri ldapi://%2fvar%2frun%2fldapi_sock/
> # Note: %2f encodes the '/' used as directory separator
>=20
> # The LDAP version to use (defaults to 3
> # if supported by client library)
> ldap_version 3
>=20
> # The distinguished name to bind to the server with.
> # Optional: default is to bind anonymously.
> #binddn cn=3Dproxyuser,dc=3Dexample,dc=3Dcom
> #binddn cn=3DDirectory Manager
>=20
> # The credentials to bind with.
> # Optional: default is no credential.
> bindpw secret
> # The distinguished name to bind to the server with
> # if the effective user ID is root. Password is
> # stored in /etc/ldap.secret (mode 600)
> #rootbinddn cn=3Dmanager,dc=3Dexample,dc=3Dcom
> rootbinddn cn=3DDirectory Manager
>=20
> # The port.
> # Optional: default is 389.
> #port 389
>=20
> # The search scope.
> #scope sub
> #scope one
> #scope base
>=20
> # Search timelimit
> #timelimit 30
>=20
> # Bind timelimit
> #bind_timelimit 30
>=20
> # Idle timelimit; client will close connections
> # (nss_ldap only) if the server has not been contacted
> # for the number of seconds specified below.
> #idle_timelimit 3600
>=20
> # Filter to AND with uid=3D%s
> #pam_filter objectclass=3Daccount
> pam_filter objectclass=3DposixAccount
>=20
> # The user ID attribute (defaults to uid)
> pam_login_attribute uid
>=20
> # Search the root DSE for the password policy (works
> # with Netscape Directory Server)
> #pam_lookup_policy yes
>=20
> # Check the 'host' attribute for access control
> # Default is no; if set to yes, and user has no
> # value for the host attribute, and pam_ldap is
> # configured for account management (authorization)
>=20
> --- message truncated ---


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D1=
21642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list
Notice:  All email and instant messages (including attachments) sent to
or from Franklin Templeton Investments (FTI) personnel may be retained,
monitored and/or reviewed by FTI and its agents, or authorized
law enforcement personnel, without further notice or consent.

RE: [webmin-l] Webmin Servers, Broadcast/scan

[Khan, M. [SMO] <MK...@fr...>]

Jamie, Pls any update.

-----Original Message-----
From: Khan, Mohammed [SMO]=20
Sent: Tuesday, February 21, 2006 4:16 PM
To: 'web...@li...'
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


Jamie, any update please.

-----Original Message-----
From: Khan, Mohammed [SMO]=20
Sent: Monday, February 20, 2006 10:20 PM
To: 'web...@li...'
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


RedHat AS2.1


-----Original Message-----
From: web...@li...
[mailto:web...@li...]On Behalf Of Jamie
Cameron
Sent: Monday, February 20, 2006 9:10 PM
To: web...@li...
Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan


Which Linux distributon are you using there?

 - Jamie

On 20/Feb/2006 23:37 Khan, Mohammed [SMO] wrote ..
> I not able to find the file in my server, I can you pls send me the file
> and I can put it in my server.  Thanks.
>=20
> -----Original Message-----
> From: web...@li...
> [mailto:web...@li...]On Behalf Of Jamie
> Cameron
> Sent: Sunday, February 19, 2006 6:39 AM
> To: web...@li...
> Subject: RE: [webmin-l] Webmin Servers, Broadcast/scan
>=20
>=20
> Hi Mohammed,
> That is not the correct file, sorry. The one you attached is for the NSS-=
LDAP
> configuration, but there is also a separate file for PAM-LDAP configurati=
on.
> I am not sure where it would be located on your system though - it varies
> from one Linux distribution to another.
>=20
>  - Jamie
>=20
> -----Original Message-----
>=20
> From:  "Khan, Mohammed [SMO]" <MK...@fr...>
> Subj:  RE: [webmin-l] Webmin Servers, Broadcast/scan
> Date:  Sat 18 Feb 2006 5:55 am
> Size:  2K
> To:  <web...@li...>
>=20
> Morning Jamie,
> I am attaching my ldap.conf file please check and let me know what I am
> doing wrong.  If I an able the bindpw  I am not able to login to usermin.
> Please check if the way I have set it up is correct.  Do I create a file
> /etc/ldap.secret and copy the line from ldap.conf file.  Please let me
> know
> # @(#)$Id: ldap.conf,v 1.27 2003/01/17 21:37:12 lukeh Exp $
> #
> # This is the configuration file for the LDAP nameservice
> # switch library and the LDAP PAM module.
> #
> # PADL Software
> # http://www.padl.com
> #
>=20
> # Your LDAP server. Must be resolvable without using LDAP.
> # Multiple hosts may be specified, each separated by a
> # space. How long nss_ldap takes to failover depends on
> # whether your LDAP client library supports configurable
> # network or connect timeouts (see bind_timelimit).
> #host 127.0.0.1
> host dublx06.noam.corp.frk.com
>=20
> # The distinguished name of the search base.
> #base dc=3Dexample,dc=3Dcom
> #base dc=3Dpeople,dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
> base dc=3Dnoam,dc=3Dcorp,dc=3Dfrk,dc=3Dcom
>=20
> # Another way to specify your LDAP server is to provide an
> # uri with the server name. This allows to use
> # Unix Domain Sockets to connect to a local LDAP Server.
> #uri ldap://127.0.0.1/
> #uri ldaps://127.0.0.1/
> #uri ldapi://%2fvar%2frun%2fldapi_sock/
> # Note: %2f encodes the '/' used as directory separator
>=20
> # The LDAP version to use (defaults to 3
> # if supported by client library)
> ldap_version 3
>=20
> # The distinguished name to bind to the server with.
> # Optional: default is to bind anonymously.
> #binddn cn=3Dproxyuser,dc=3Dexample,dc=3Dcom
> #binddn cn=3DDirectory Manager
>=20
> # The credentials to bind with.
> # Optional: default is no credential.
> bindpw secret
> # The distinguished name to bind to the server with
> # if the effective user ID is root. Password is
> # stored in /etc/ldap.secret (mode 600)
> #rootbinddn cn=3Dmanager,dc=3Dexample,dc=3Dcom
> rootbinddn cn=3DDirectory Manager
>=20
> # The port.
> # Optional: default is 389.
> #port 389
>=20
> # The search scope.
> #scope sub
> #scope one
> #scope base
>=20
> # Search timelimit
> #timelimit 30
>=20
> # Bind timelimit
> #bind_timelimit 30
>=20
> # Idle timelimit; client will close connections
> # (nss_ldap only) if the server has not been contacted
> # for the number of seconds specified below.
> #idle_timelimit 3600
>=20
> # Filter to AND with uid=3D%s
> #pam_filter objectclass=3Daccount
> pam_filter objectclass=3DposixAccount
>=20
> # The user ID attribute (defaults to uid)
> pam_login_attribute uid
>=20
> # Search the root DSE for the password policy (works
> # with Netscape Directory Server)
> #pam_lookup_policy yes
>=20
> # Check the 'host' attribute for access control
> # Default is no; if set to yes, and user has no
> # value for the host attribute, and pam_ldap is
> # configured for account management (authorization)
>=20
> --- message truncated ---


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat=3D1=
21642
-
Forwarded by the Webmin mailing list at web...@li...
To remove yourself from this list, go to
http://lists.sourceforge.net/lists/listinfo/webadmin-list
Notice:  All email and instant messages (including attachments) sent to
or from Franklin Templeton Investments (FTI) personnel may be retained,
monitored and/or reviewed by FTI and its agents, or authorized
law enforcement personnel, without further notice or consent.

Re: [webmin-l] LDAP Users Module - /etc/skel contents not copied

[Jamie C. <jca...@we...>]

On 22/Feb/2006 00:39 Murray Trainer wrote ..
> On Wed, 2006-02-22 at 13:33, Jamie Cameron wrote:
> > On 21/Feb/2006 23:18 Murray Trainer wrote ..
> > > Hi Jamie,
> > > 
> > > Another problem I have come across using 1.263.  When I create an LDAP
> > > user the files/dirs in /etc/skel are not copied to their home
> > > directory.  I have tried both putting /etc/skel in the LDAP Users module
> > > or reading the setting from the Users & Groups module and it fails
> in
> > > both cases.  If I create a local Unix user using the Users and Groups
> > > module it works fine.
> > 
> > That's odd, because I just tested this myself with Webmin 1.263, and
> it worked
> > fine. I presume you have the 'Copy files into new home directories from'
> option
> > on the Module Config page set to /etc/skel ?
> > 
> >  - Jamie
> 
> Hi Jamie,
> 
> I think I have finally figured out the cause of all my recent user
> creation problems.  I tried creating a new user with the Samba Login bit
> off and the user got home dir got created fine with files in their home
> directory, no cyrus authentication error, and the post user creation
> script ran fine.  Looks like a problem with my Samba setup - the
> objectclasses have changed in my LDAP config so there might be the
> problem with some of my LDAP groups imported from the old LDAP setup. 
> Not sure why I was having all the errors and issues seemingly unrelated
> to Samba though?  

I can't see why enabling Samba would prevent the home directory from being
populated .. they are really un-connected. Are you sure that turning on
Samba for a user causes the /etc/skel files not to be copied?

 - Jamie