webadmin-list — Webmin users mailing list

[webmin-l] Re: Xen VM Management Module

[Mark P. <mt...@ti...>]

Looking through the archives I've found that Chuck and Jamie were 
talking about working on a module for Xen.  Was there any 
progress?  I'm interested in helping finish the project or get it off 
the ground if there's still interest.

Thanks,
mark

Re: [webmin-l] Virtualmin wish and broken link

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

Jamie Cameron wrote:

>On Fri, 2005-12-30 at 14:12, John Hinton wrote:
>  
>
>>Hey Jamie... one other thing sort of related. In Virtualmin when a new 
>>virtual server is created and also when a new alias to a virtual server 
>>is added, once the updates are finished there is only a link back to 
>>virtualmin and no link back to the virtual server just created. Not such 
>>a big deal until you have more than you wish to display.. sending you 
>>through the search for virtual server with this name system.
>>
>>I've been using the back button in the browser for the latter situation, 
>>but there isn't a direct way in otherwise. It would be one of those 
>>little interface niceities!
>>    
>>
>
>Nice idea .. I will add this in the next release.
>  
>
Thanks! I nice timesaver.

>  
>
>>Also, in the anal category.. :) the help links when choosing what to 
>>create for a alias server seem gives this error on the directory link.
>>
>>
>>    Error
>>
>>------------------------------------------------------------------------
>>
>>*Failed to read help file /usr/libexec/webmin/virtual-server/help/dir.html*
>>    
>>
>
>Hmm .. I am pretty sure this is fixed in the 2.610 version.
>If not, it will be fixed in the next release.
>  
>
You are right. It is fixed. I was on 2.601. Did the update and it works 
now and the help info was exactly what I was assuming this did.. nice to 
have the handy reassurance.

John Hinton

Re: [webmin-l] Clicking BROADCAST FOR SERVERS - 4 unfamiliar items

[Alan D. <We...@Om...>]

On 12/30/2005 9:44 AM, pr...@pr... wrote:
> I went into a section called "Webmin Servers" where
> there is a button called "Broadcast for servers".
>
> I clicked on that button and 4 items appeared:
>
> districthost.com:10000
> server4.vectrahost.net:10000
> gamelinkage.com:10000
> deranet.com:47482
>
> Can anyone tell me what these are?
> Are these supposed to be part of my server?
> They are not domain names I'm familiar with.

Is your server in a co-location or data center facility?  If so, these
are probably other customers' Webmin servers running on the same
network.  The broadcast searches your local network for other Webmin
servers, and apparently it found some.  If you are not supposed to have
access to them (and you probably won't be able to log into them anyway),
then you should delete them from your Webmin Servers list.

Alan

[webmin-l] Scarry bug in Webmin users

[MWS <we...@ro...>]

It seems that when I switch users back to individual preferences for modules for each user, they can now see all users info and listings.

i.e.

1)I switch a user to a group.

2)I switch the user back to 'None' for group, and select individual module preferences.

3)In any module dealing with more than one user, the user can now see ALL users in that module.  'Read Mail' for example, now shows all users, not just the one associated with that username.  And that user can now read the mail of each and every user listed as well (I checked).

-Mike

Re: [webmin-l] Changing Available Modules

[MWS <we...@ro...>]

And here is a 'bug':

When changing a user back from a group to 'none', I selected 'None' from the drop-down for groups and clicked on the modules I want the user to see.  While the group is changed, the modules preferences were not saved.  What I have had to do is select the new group preference, save, and go back in and change the module preferences.

:)

-Mike



MWS wrote ..
> Here are a couple of things that happen when I do that:
> 
> 1) When using webalizer or awstats as part of the group, each member of
> the group can see ALL other webalizer or awstats listings, not just their
> own (i.e. they see everyone on the server listed).
> 
> 2) Is there a way to mass-add users to group, or can it be done only one
> user at a time?
> 
> -Mike
> 
> 
> Jamie Cameron wrote ..
> > Ah .. in that case, you need to create a Webmin group, and the assign
> > all your users to it. This can also be done in the Webmin Users module.
> > 
> > Once this is done, any module changes made to the group will apply to
> > all the member users as well.
> > 
> >  - Jamie
> > 
> > On Fri, 2005-12-30 at 18:36, MWS wrote:
> > > Sorry - I guess I should be more specific.
> > > 
> > > I know that module can do it, but what do you do when you want many
> users
> > to all use the same module (like maybe a new one)?  I don't want to have
> > to change dozens of users one at a time!  :)
> > > 
> > > -Mike
> > > 
> > > 
> > > 
> > > Jamie Cameron wrote ..
> > > > The Webmin Users module can be used to edit which modules each user
> > has
> > > > access to, and what they can do using those modules.
> > > > 
> > > >  - Jamie
> > > > 
> > > > -----Original Message-----
> > > > 
> > > > From:  "MWS" <we...@ro...>
> > > > Subj:  [webmin-l] Changing Available Modules
> > > > Date:  Fri 30 Dec 2005 1:13 pm
> > > > Size:  602 bytes
> > > > To:  web...@li...
> > > > 
> > > > 
> > > > How does one change the available modules for webmin users other
> than
> > root?
> > > > 
> > > > Thanks,
> > > > 
> > > > -Mike
> > > > 
> > > > 
> > > > -------------------------------------------------------
> > > > 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > > > -
> > > > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > > > -
> > > > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > > -
> > > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > -
> > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> -
> 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] Clicking BROADCAST FOR SERVERS - 4 unfamiliar items

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

From: Prodos (Melbourne, Australia)

Greetings!

One of my sites was subjected to a DoS (Denial of Service)
attack a few days ago and this crashed my server.

A colleague, who is a Linux expert - but I don't know how
experienced he is with WEBMIN - has helped me get things
back to normal.

I've been going through my WEBMIN settings/configurations
and checking things. Unfortunately, this is not something
I'm particularly good at.

Anyway, I went into a section called "Webmin Servers" where
there is a button called "Broadcast for servers".

I clicked on that button and 4 items appeared:

districthost.com:10000
server4.vectrahost.net:10000
gamelinkage.com:10000
deranet.com:47482

Can anyone tell me what these are?
Are these supposed to be part of my server?
They are not domain names I'm familiar with.

I don't understand what they have to do with my server.

Thanks for any help or advice about this.

Happy New Year,

PRODOS

http://prodos.thinkertothinker.com

"Boring updates on exciting projects."

Re: [webmin-l] Changing Available Modules

[MWS <we...@ro...>]

Here are a couple of things that happen when I do that:

1) When using webalizer or awstats as part of the group, each member of the group can see ALL other webalizer or awstats listings, not just their own (i.e. they see everyone on the server listed).

2) Is there a way to mass-add users to group, or can it be done only one user at a time?

-Mike


Jamie Cameron wrote ..
> Ah .. in that case, you need to create a Webmin group, and the assign
> all your users to it. This can also be done in the Webmin Users module.
> 
> Once this is done, any module changes made to the group will apply to
> all the member users as well.
> 
>  - Jamie
> 
> On Fri, 2005-12-30 at 18:36, MWS wrote:
> > Sorry - I guess I should be more specific.
> > 
> > I know that module can do it, but what do you do when you want many users
> to all use the same module (like maybe a new one)?  I don't want to have
> to change dozens of users one at a time!  :)
> > 
> > -Mike
> > 
> > 
> > 
> > Jamie Cameron wrote ..
> > > The Webmin Users module can be used to edit which modules each user
> has
> > > access to, and what they can do using those modules.
> > > 
> > >  - Jamie
> > > 
> > > -----Original Message-----
> > > 
> > > From:  "MWS" <we...@ro...>
> > > Subj:  [webmin-l] Changing Available Modules
> > > Date:  Fri 30 Dec 2005 1:13 pm
> > > Size:  602 bytes
> > > To:  web...@li...
> > > 
> > > 
> > > How does one change the available modules for webmin users other than
> root?
> > > 
> > > Thanks,
> > > 
> > > -Mike
> > > 
> > > 
> > > -------------------------------------------------------
> > > 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > > -
> > > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > > -
> > > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > -
> > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> -
> 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

Re: [webmin-l] Problems with postgresql module and granted privileges on CentOS 4

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

On Fri, 2005-12-30 at 09:59, Roland Pope wrote:
> Hi guys,
> 
> I am getting the following error when accessing the "Granted Privileges' 
> option in the Postgresql module:
> <snip>
> select 
> relname,relacl,pg_namespace.nspname,reltype,relkind,relhasrules,'current' 
> from pg_class, pg_namespace where relnamespace = pg_namespace.oid and 
> (relkind = 'r' OR relkind = 'S') and relname !~ '^pg_' order by relname : 
> Unknown DBI error
> </snip>
> CentOS 4 runs postgresql-7.4.8, and it worked fine under CentOS 3 and 
> postgresql-7.3.10, so maybe it is to do with changes between 7.3 and 7.4?

I think I ran into this one when doing Virtualmin development for CentOS
.. and it turned out to be an un-avoidable PostgreSQL bug :( The only
work-around was to disable the use of DBI, which can be done on the
Module Config page of the PostgreSQL module.

 - Jamie

Re: [webmin-l] Usermin & Virtualmin Suggestions

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

On Fri, 2005-12-30 at 13:36, MWS wrote:
> I have a few suggestions:
> 
> 1) In Usermin - the list of mailboxes in the drop down is not in alphabetical order when you are in the window reading an email (i.e. you go to file it and the drop-down is in the order the files or directories were created, not in alphabetical order).

Good point .. I will fix that in the next Usermin release.

> 2) In Virtualmin - maybe we could be able to sort the list of domains by the domain name instead of the username?  Or an option for that?

Nice idea .. I'll add a Module Config option for this.

 - Jamie

Re: [webmin-l] Virtualmin wish and broken link

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

On Fri, 2005-12-30 at 14:12, John Hinton wrote:
> Hey Jamie... one other thing sort of related. In Virtualmin when a new 
> virtual server is created and also when a new alias to a virtual server 
> is added, once the updates are finished there is only a link back to 
> virtualmin and no link back to the virtual server just created. Not such 
> a big deal until you have more than you wish to display.. sending you 
> through the search for virtual server with this name system.
> 
> I've been using the back button in the browser for the latter situation, 
> but there isn't a direct way in otherwise. It would be one of those 
> little interface niceities!

Nice idea .. I will add this in the next release.

> Also, in the anal category.. :) the help links when choosing what to 
> create for a alias server seem gives this error on the directory link.
> 
> 
>     Error
> 
> ------------------------------------------------------------------------
> 
> *Failed to read help file /usr/libexec/webmin/virtual-server/help/dir.html*

Hmm .. I am pretty sure this is fixed in the 2.610 version.
If not, it will be fixed in the next release.

 - Jamie

Re: [webmin-l] Changing Available Modules

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

Ah .. in that case, you need to create a Webmin group, and the assign
all your users to it. This can also be done in the Webmin Users module.

Once this is done, any module changes made to the group will apply to
all the member users as well.

 - Jamie

On Fri, 2005-12-30 at 18:36, MWS wrote:
> Sorry - I guess I should be more specific.
> 
> I know that module can do it, but what do you do when you want many users to all use the same module (like maybe a new one)?  I don't want to have to change dozens of users one at a time!  :)
> 
> -Mike
> 
> 
> 
> Jamie Cameron wrote ..
> > The Webmin Users module can be used to edit which modules each user has
> > access to, and what they can do using those modules.
> > 
> >  - Jamie
> > 
> > -----Original Message-----
> > 
> > From:  "MWS" <we...@ro...>
> > Subj:  [webmin-l] Changing Available Modules
> > Date:  Fri 30 Dec 2005 1:13 pm
> > Size:  602 bytes
> > To:  web...@li...
> > 
> > 
> > How does one change the available modules for webmin users other than root?
> > 
> > Thanks,
> > 
> > -Mike
> > 
> > 
> > -------------------------------------------------------
> > 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > -
> > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> > -
> > 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> -
> 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

Re: [webmin-l] Changing Available Modules

[MWS <we...@ro...>]

Sorry - I guess I should be more specific.

I know that module can do it, but what do you do when you want many users to all use the same module (like maybe a new one)?  I don't want to have to change dozens of users one at a time!  :)

-Mike



Jamie Cameron wrote ..
> The Webmin Users module can be used to edit which modules each user has
> access to, and what they can do using those modules.
> 
>  - Jamie
> 
> -----Original Message-----
> 
> From:  "MWS" <we...@ro...>
> Subj:  [webmin-l] Changing Available Modules
> Date:  Fri 30 Dec 2005 1:13 pm
> Size:  602 bytes
> To:  web...@li...
> 
> 
> How does one change the available modules for webmin users other than root?
> 
> Thanks,
> 
> -Mike
> 
> 
> -------------------------------------------------------
> 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> -
> 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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> -
> 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

Re: [webmin-l] Changing Available Modules

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

The Webmin Users module can be used to edit which modules each user has access to, and what they can do using those modules.

 - Jamie

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

From:  "MWS" <we...@ro...>
Subj:  [webmin-l] Changing Available Modules
Date:  Fri 30 Dec 2005 1:13 pm
Size:  602 bytes
To:  web...@li...


How does one change the available modules for webmin users other than root?

Thanks,

-Mike


-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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

Re: [webmin-l] Custom Mysql

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

No, you can't use parameters for field names either, sorry ... mainly because MySQL doesn't support it.

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  Re: [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 1:21 pm
Size:  2K
To:  <web...@li...>

:-)

Sorry Jamie, not the table name ...


this part:

WHERE ? LIKE ?;

the first ? would not work. (to select the field or column name.).

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 1:10 PM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
Unfortunately you can't use table names as parameters like that. Only values 
in the SQL expressions can be parameters, like in my original example..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  Re: [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 10:32 am
Size:  2K
To:  <web...@li...>

Kewl, -thanks!

should this work?

SELECT user, ip, domain FROM tbl_name

When I replace the first ? with a real field name (ie 'domain') it works
fine. But when I run the above, it just shows the column names with no data.

-Grant

P.S. I have a local copy of the Mysql handbook, and am reading :-)

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 9:14 AM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard
with SQL. The first parameter in the command will replace the first ? and so
on ..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user,
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every
escape sequence I can think of.




--- message truncated ---

[webmin-l] Virtualmin wish and broken link

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

Hey Jamie... one other thing sort of related. In Virtualmin when a new 
virtual server is created and also when a new alias to a virtual server 
is added, once the updates are finished there is only a link back to 
virtualmin and no link back to the virtual server just created. Not such 
a big deal until you have more than you wish to display.. sending you 
through the search for virtual server with this name system.

I've been using the back button in the browser for the latter situation, 
but there isn't a direct way in otherwise. It would be one of those 
little interface niceities!

Also, in the anal category.. :) the help links when choosing what to 
create for a alias server seem gives this error on the directory link.


    Error

------------------------------------------------------------------------

*Failed to read help file /usr/libexec/webmin/virtual-server/help/dir.html*



Thanks,
John Hinton

[webmin-l] Usermin & Virtualmin Suggestions

[MWS <we...@ro...>]

I have a few suggestions:

1) In Usermin - the list of mailboxes in the drop down is not in alphabetical order when you are in the window reading an email (i.e. you go to file it and the drop-down is in the order the files or directories were created, not in alphabetical order).

2) In Virtualmin - maybe we could be able to sort the list of domains by the domain name instead of the username?  Or an option for that?

Thanks,

-Mike

Re: [webmin-l] Custom Mysql

[Grant P. <gp...@th...>]

:-)

Sorry Jamie, not the table name ...


this part:

WHERE ? LIKE ?;

the first ? would not work. (to select the field or column name.).

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 1:10 PM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
Unfortunately you can't use table names as parameters like that. Only values 
in the SQL expressions can be parameters, like in my original example..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  Re: [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 10:32 am
Size:  2K
To:  <web...@li...>

Kewl, -thanks!

should this work?

SELECT user, ip, domain FROM tbl_name

When I replace the first ? with a real field name (ie 'domain') it works
fine. But when I run the above, it just shows the column names with no data.

-Grant

P.S. I have a local copy of the Mysql handbook, and am reading :-)

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 9:14 AM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard
with SQL. The first parameter in the command will replace the first ? and so
on ..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user,
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every
escape sequence I can think of.



-GRant






-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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

Re: [webmin-l] Custom Mysql

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

Hi Grant,
Unfortunately you can't use table names as parameters like that. Only values in the SQL expressions can be parameters, like in my original example..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  Re: [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 10:32 am
Size:  2K
To:  <web...@li...>

Kewl, -thanks!

should this work?

SELECT user, ip, domain FROM tbl_name WHERE ? LIKE ?;

When I replace the first ? with a real field name (ie 'domain') it works 
fine. But when I run the above, it just shows the column names with no data.

-Grant

P.S. I have a local copy of the Mysql handbook, and am reading :-)

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 9:14 AM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard 
with SQL. The first parameter in the command will replace the first ? and so 
on ..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user,
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every
escape sequence I can think of.



-GRant






-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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 ---

[webmin-l] Changing Available Modules

[MWS <we...@ro...>]

How does one change the available modules for webmin users other than root?

Thanks,

-Mike

Re: [webmin-l] Custom Mysql

[Grant P. <gp...@th...>]

Kewl, -thanks!

should this work?

SELECT user, ip, domain FROM tbl_name WHERE ? LIKE ?;

When I replace the first ? with a real field name (ie 'domain') it works 
fine. But when I run the above, it just shows the column names with no data.

-Grant

P.S. I have a local copy of the Mysql handbook, and am reading :-)

----- Original Message ----- 
From: "Jamie Cameron" <jca...@we...>
To: <web...@li...>
Sent: Friday, December 30, 2005 9:14 AM
Subject: Re: [webmin-l] Custom Mysql


Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard 
with SQL. The first parameter in the command will replace the first ? and so 
on ..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user,
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every
escape sequence I can think of.



-GRant






-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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: 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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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] Problems with postgresql module and granted privileges on CentOS 4

[Roland P. <rp...@ja...>]

Hi guys,

I am getting the following error when accessing the "Granted Privileges' 
option in the Postgresql module:
<snip>
select 
relname,relacl,pg_namespace.nspname,reltype,relkind,relhasrules,'current' 
from pg_class, pg_namespace where relnamespace = pg_namespace.oid and 
(relkind = 'r' OR relkind = 'S') and relname !~ '^pg_' order by relname : 
Unknown DBI error
</snip>
CentOS 4 runs postgresql-7.4.8, and it worked fine under CentOS 3 and 
postgresql-7.3.10, so maybe it is to do with changes between 7.3 and 7.4?

Thanks
Roland 

Re: [webmin-l] Unable to start Webmin

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

On Fri, 2005-12-30 at 05:13, Paul Cubbage wrote:
> Jamie Cameron wrote:
> > On Thu, 2005-12-29 at 10:41, Paul Cubbage wrote:
> > 
> >>Jamie Cameron wrote:
> >>
> >>>Hi Gerard,
> >>>I have seen this problem reported once or twice before, always on FreeBSD. I beleive the solution is to make sure you are running the latest version of Perl, and that any modules that Webmin uses (like Net::SSLeay and Authen::PAM) are up to date.
> >>>
> >>> - Jamie
> >>
> >>Jamie,
> >>Is there a webmin FAQ?  Items like this are ideal for it.
> >>Paul
> > 
> > 
> > Yes, there is a FAQ at http://www.webmin.com/faq.html .
> > However, I'm not sure yet if this solution actually works .. I have
> > never actually seen it myself, only heard of it from users.
> > 
> >  - Jamie
> How does one find the FAQ from the top level of webmin.com?

You need to click on the Documentation category at the top of the page,
and then on the FAQ icon.

 - Jamie

Re: [webmin-l] Custom Mysql

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

Hi Grant,
The SQL custom commands use a ? to indicate a parameter, which is standard with SQL. The first parameter in the command will replace the first ? and so on ..

 - Jamie

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

From:  "Grant Peel" <gp...@th...>
Subj:  [webmin-l] Custom Mysql
Date:  Fri 30 Dec 2005 3:16 am
Size:  1017 bytes
To:  <web...@li...>

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use 
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user, 
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every 
escape sequence I can think of.



-GRant






-------------------------------------------------------
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://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
-
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

Re: [webmin-l] Unable to start Webmin

[Paul C. <pcu...@op...>]

Jamie Cameron wrote:
> On Thu, 2005-12-29 at 10:41, Paul Cubbage wrote:
> 
>>Jamie Cameron wrote:
>>
>>>Hi Gerard,
>>>I have seen this problem reported once or twice before, always on FreeBSD. I beleive the solution is to make sure you are running the latest version of Perl, and that any modules that Webmin uses (like Net::SSLeay and Authen::PAM) are up to date.
>>>
>>> - Jamie
>>
>>Jamie,
>>Is there a webmin FAQ?  Items like this are ideal for it.
>>Paul
> 
> 
> Yes, there is a FAQ at http://www.webmin.com/faq.html .
> However, I'm not sure yet if this solution actually works .. I have
> never actually seen it myself, only heard of it from users.
> 
>  - Jamie
How does one find the FAQ from the top level of webmin.com?

[webmin-l] Custom Mysql

[Grant P. <gp...@th...>]

Hi all,

FOrgive me if this has been covered somewhere else, but how does one use 
parameters in the custom->sql commands section?

I keep getting errore like these:

Executing SQL command SET par1=$INPUT; SET par2=$FIELD; SELECT user, 
password, domain, ip, host_machine FROM clients WHERE domain LIKE @par1; ..
.. execution error : called with 1 bind variables when 0 are needed



I get them even if I don't use the 'set' variables parm. I have tried every 
escape sequence I can think of.



-GRant