webadmin-list — Webmin users mailing list

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Mon, 2005-11-21 at 10:47 +1100, Jamie Cameron wrote:
> On Mon, 2005-11-21 at 10:36, Craig White wrote:
> > On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> > > Ok .. how about if you run :
> > > 
> > > mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
> > > 
> > ----
> > however this works
> > mysqladmin -u root --password=ROOT_MYSQL_PASSWORD status
> > note extra dash    ^^
> 
> Thanks .. that is the source of the bug!
> An updated module is now available at http://www.webmin.com/updates.html
> that will resolve this issue.
> 
----
BING !

thanks

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

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

Hmm .. 
I presume you replaced MY_ROOT_PASSWORD with your actual MySQL root
password?
Also, which version of MySQL are you using there?

 - Jamei

On Mon, 2005-11-21 at 10:40, Faisal Mehmood wrote:
> This is what i get with BOTH the commans.
> 
> [root@alpha ~]# mysql -u root -password=MY_ROOT_PASSWORD mysql
> ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
> password: YES)
> 
> [root@alpha ~]# mysqladmin -u root --password=ROOT_MYSQL_PASSWORD
> status 
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password:
> YES)'
> 
> 
> Faisal.
> On 11/20/05, Craig White <cra...@az...> wrote:
>         On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
>         > Ok .. how about if you run :
>         >
>         > mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
>         >
>         ----
>         however this works
>         mysqladmin -u root --password=ROOT_MYSQL_PASSWORD status 
>         note extra dash    ^^
>         
>         Craig
>         
>         
>         --
>         This message has been scanned for viruses and
>         dangerous content by MailScanner, and is
>         believed to be clean.
>         
>         
>         
>         ------------------------------------------------------- 
>         This SF.Net email is sponsored by the JBoss Inc.  Get
>         Certified Today
>         Register for a JBoss Training Course.  Free Certification Exam
>         for All Training Attendees Through End of 2005. For more info
>         visit:
>         http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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
> 
> 
> 
> -- 
> ~Dont tell me its hard to contact me~ 
> Faisal Mehmood.
> fa...@gm...
> fa...@st...
> fa...@fa...

Re: [webmin-l] mysql module

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

On Mon, 2005-11-21 at 10:36, Craig White wrote:
> On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> > Ok .. how about if you run :
> > 
> > mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
> > 
> ----
> however this works
> mysqladmin -u root --password=ROOT_MYSQL_PASSWORD status
> note extra dash    ^^

Thanks .. that is the source of the bug!
An updated module is now available at http://www.webmin.com/updates.html
that will resolve this issue.

 - Jamie

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Mon, 2005-11-21 at 10:37 +1100, Jamie Cameron wrote:
> On Mon, 2005-11-21 at 10:31, Craig White wrote:
> > On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> > > Ok .. how about if you run :
> > > 
> > > mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
> > ----
> > yeah - that's a problem
> > 
> > # mysqladmin -u root -password=MY_ROOT_PASSWORD status
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Access denied for user 'root'@'localhost' (using password: YES)'
> 
> Ah, now we are getting somewhere .. Webmin uses that -password option in
> MySQL 4.1 and above, but perhaps it is not valid for the mysqladmin
> command.
> 
> What happens if you run just :
> 
> mysql -u root -password=MY_ROOT_PASSWORD mysql
> 
> Does that login OK?
----
no but with --password, it does login OK

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

This is what i get with BOTH the commans.

[root@alpha ~]# mysql -u root -password=3DMY_ROOT_PASSWORD mysql
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using
password: YES)

[root@alpha ~]# mysqladmin -u root --password=3DROOT_MYSQL_PASSWORD status
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'


Faisal.
On 11/20/05, Craig White <cra...@az...> wrote:
>
> On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> > Ok .. how about if you run :
> >
> > mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status
> >
> ----
> however this works
> mysqladmin -u root --password=3DROOT_MYSQL_PASSWORD status
> note extra dash ^^
>
> Craig
>
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
> Register for a JBoss Training Course. Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> -
> 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
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

Oh Sorry Yeah Youre right.

Figured that thing out. Works fine on IE.

The basic problem still remains.

The full MySQL error message was : connect to server at 'localhost' failed
error: 'Access denied for user 'interlinkage'@'localhost' (using password:
YES)'


It works fine when the password is set to none. It lets the user login.

Thanks.
Faisal.

On 21 Nov 2005 10:32:42 +1100, Jamie Cameron <jca...@we...> wrote:
>
> On Mon, 2005-11-21 at 10:06, Faisal Mehmood wrote:
> > Hi.
> >
> > Ok Jamie. Here is the message generated.
> >
> > The full MySQL error message was : connect to server at 'localhost'
> > failed error: 'Access denied for user 'interlinkage'@'localhost'
> > (using password: YES)'
>
> That's odd ..
> If you login to the MySQL module as root, can you verify that the
> interlinkage user actually exists, and has the correct password?
>
> > Another Problem i noticed in this NEW module is:
> >
> > When i click on a user Under the USer Permissions of the MYSQL module,
> > (logged in as Master Admin) The window that opens up, changes the
> > username to another user on the system. It shows up fine when the page
> > loads for a second then it automatically changes.
> >
> > For example:
> >
> > I have two servers on the virtualmin.
> >
> > xyz.com <http://xyz.com> (user: xyz)
> >
> > and
> >
> > abc.com <http://abc.com> (user: abc)
> >
> > I added xyz.com <http://xyz.com> before abc.com <http://abc.com>
> >
> > So when i click on xyz username, the window opens for the user
> > permissions to change the password and all, for a second it shows xyz
> > under the username field, and this automatically changes to abc
> >
> > I thought this was kind of a wierd behaviour, this is a new behaviour
> > in the current module. I am using Firefox as my browser.
>
> It looks like your browser is automatically filling in the field ..
> This can be annoying sometimes, but is really a browser bug rather than
> a Webmin or Virtualmin problem..
>
> - Jamie
>
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
> Register for a JBoss Training Course. Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> -
> 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
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

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

On Mon, 2005-11-21 at 10:31, Craig White wrote:
> On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> > Ok .. how about if you run :
> > 
> > mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
> ----
> yeah - that's a problem
> 
> # mysqladmin -u root -password=MY_ROOT_PASSWORD status
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Ah, now we are getting somewhere .. Webmin uses that -password option in
MySQL 4.1 and above, but perhaps it is not valid for the mysqladmin
command.

What happens if you run just :

mysql -u root -password=MY_ROOT_PASSWORD mysql

Does that login OK?

 - Jamie

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> Ok .. how about if you run :
> 
> mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
> 
----
however this works
mysqladmin -u root --password=ROOT_MYSQL_PASSWORD status
note extra dash    ^^

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

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

On Mon, 2005-11-21 at 10:06, Faisal Mehmood wrote:
> Hi.
> 
> Ok Jamie. Here is the message generated.
> 
> The full MySQL error message was : connect to server at 'localhost'
> failed error: 'Access denied for user 'interlinkage'@'localhost'
> (using password: YES)' 

That's odd .. 
If you login to the MySQL module as root, can you verify that the
interlinkage user actually exists, and has the correct password? 

> Another Problem i noticed in this NEW module is:
> 
> When i click on a user Under the USer Permissions of the MYSQL module,
> (logged in as Master Admin) The window that opens up, changes the
> username to another user on the system. It shows up fine when the page
> loads for a second then it automatically changes. 
> 
> For example:
> 
> I have two servers on the virtualmin.
> 
> xyz.com (user:  xyz)
> 
> and 
> 
> abc.com (user:  abc)
> 
> I added xyz.com before abc.com
> 
> So when i click on xyz username, the window opens for the user
> permissions to change the password and all, for a second it shows xyz
> under the username field, and this automatically changes to abc 
> 
> I thought this was kind of a wierd behaviour, this is a new behaviour
> in the current module. I am using Firefox as my browser.

It looks like your browser is automatically filling in the field .. 
This can be annoying sometimes, but is really a browser bug rather than
a Webmin or Virtualmin problem..

 - Jamie

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

Hi.

Jamie, there is something wrong with this module. I just deleted a server
i.e. abc.com <http://abc.com>, (as i mentioned in my earlier mail) and now
when i go to the user permissions of the MYSQL module logged in as the
Master Admin, and i click on a server xyz.com <http://xyz.com> ... i see th=
e
username of abc.com <http://abc.com> in the username field ??!???!? how is
that possible ?

Thanks.
Faisal.

On 11/20/05, Faisal Mehmood <fa...@gm...> wrote:
>
> Hi Jamie.
>
> I get a
>
> mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status
>
> mysqladmin: connect to server at 'localhost' failed
> error: 'Access denied for user 'root'@'localhost' (using password: YES)'
>
> Faisal.
>
> On 21 Nov 2005 10:18:46 +1100, Jamie Cameron <jca...@we...> wrote:
> >
> > Ok .. how about if you run :
> >
> > mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status
> >
> > - Jamie
> >
> > On Mon, 2005-11-21 at 10:14, Craig White wrote:
> > > On Mon, 2005-11-21 at 10:06 +1100, Jamie Cameron wrote:
> > > > Hi Craig,
> > > >
> > > > What happens if you run the following at the command line :
> > > >
> > > > mysqladmin -u root -pROOT_MYSQL_PASSWORD status
> > > ----
> > > Uptime: 547079 Threads: 1 Questions: 9959 Slow queries: 0 Opens: 40
> > > Flush tables: 3 Open tables: 15 Queries per second avg: 0.018
> > > ----
> > > >
> > > > That is the command Webmin users to attempt a login.
> > > > BTW, which MySQL version are you using there?
> > > ----
> > > ]# rpm -q mysql-server
> > > mysql-server-4.1.12-3.RHEL4.1
> > >
> > > Craig
> > > ----
> > > >
> > > > On Mon, 2005-11-21 at 09:59, Craig White wrote:
> > > > > Not sure this is going to be much hope
> > > > >
> > > > > Messages presented below login screen...
> > > > > with module config administrator string set to: ""
> > > > > with module config administrator string set to: ""
> > > > > The full MySQL error message was : connect to server at
> > 'localhost'
> > > > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > > > password: NO)'
> > > > >
> > > > > Messages presented below login screen...
> > > > > with module config administrator string set to: "root"
> > > > > with module config administrator string set to:
> > "ROOT_MYSQL_PASSWORD"
> > > > > The full MySQL error message was : connect to server at
> > 'localhost'
> > > > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > > > password: YES)'
> > > > > and after attempt to login...
> > > > > the usual "Login failed : Incorrect administration username or
> > password"
> > > > >
> > > > > from command line (passing everything because I have
> > > > > renamed /root/.my.cnf for the duration of this problem)
> > > > > # mysql mysql -u root -p -h localhost
> > > > > Enter password:
> > > > > Reading table information for completion of table and column name=
s
> > > > > You can turn off this feature to get a quicker startup with -A
> > > > >
> > > > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > > > Your MySQL connection id is 297 to server version: 4.1.12
> > > > >
> > > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > > > >
> > > > > Craig
> > > > >
> > > > > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > > > > > Hi Craig,
> > > > > > Try installing the updated MySQL Webmin module from :
> > > > > > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > > > > >
> > > > > > I have made a small change to display the error message from
> > MySQL if
> > > > > > you cannot connect or login, which should explain what is reall=
y
> > going
> > > > > > wrong ..
> > > > > >
> > > > > > - Jamie
> > > > > >
> > > > > > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > > > > > 'Use DBI to connect if available' set to 'no' doesn't change
> > anything
> > > > > > >
> > > > > > > nor does explicity setting port or socket as opposed to
> > default
> > > > > > >
> > > > > > > Craig
> > > > > > >
> > > > > > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > > > > > Hi Craig,
> > > > > > > > Does it help if you adjust the module configuration option
> > that disables the use of DBI? If it is out of date, this would fix the
> > problem.
> > > > > > > >
> > > > > > > > By the way, the config option for old or new passwords only
> > effects passwords SET by webmin, not those used for logging in (which I=
 have
> > no control over).
> > > > > > > >
> > > > > > > > - Jamie
> > > > > > > >
> > > > > > > > -----Original Message-----
> > > > > > > >
> > > > > > > > From: Craig White < cra...@az...>
> > > > > > > > Subj: Re: [webmin-l] mysql module
> > > > > > > > Date: Sun 20 Nov 2005 2:23 pm
> > > > > > > > Size: 2K
> > > > > > > > To: web...@li...
> > > > > > > >
> > > > > > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > > > > >
> > > > > > > > > > >--
> > > > > > > > > > >I was hoping to get Jamie or someone to pipe in on
> > this.
> > > > > > > > > > >
> > > > > > > > > > >I 'downgraded' to 1.240 and still had the same problem
> > so I went back
> > > > > > > > > > to
> > > > > > > > > > > 1.246 for the benefit of the stuff in LDAP Users and
> > Groups.
> > > > > > > > > > >
> > > > > > > > > > >I did manage to get it to work...as long as there is n=
o
> > password for
> > > > > > > > > > >root...I'm functional. Perhaps I will try to back it
> > all up, use webmin
> > > > > > > > > > >to insert the password for root and then see if webmin
> > can access it but
> > > > > > > > > > >I can't think of a reason why I can't set the password
> > with mysqldadmin
> > > > > > > > > > >and then login via webmin...I used to always do it tha=
t
> > way ( mysql-3.x)
> > > > > > > > > > >
> > > > > > > > > > >Craig
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > >
> > > > > > > > > > Craig -
> > > > > > > > > >
> > > > > > > > > > This last bit lit a light bulb for me. There is
> > something to do with
> > > > > > > > > > long and short passwords in mysql v4.0. The default
> > mysql setting broke
> > > > > > > > > > whatever webmin was doing for a while, but then it was
> > fixed by Jamie
> > > > > > > > > > (not sure when). Is it possible you have some settings
> > out of whack there?
> > > > > > > > > >
> > > > > > > > > > the mysql docs on their web site describe the issue
> > fairly well... this
> > > > > > > > > > drove me nuts for a while too...
> > > > > > > > >
> > > > > > > > > That could be another cause actually.. for MySQL 4.0, the=
y
> > changed the format
> > > > > > > > > uses for encrypted passwords, which means that old client=
s
> > can no longer connect.
> > > > > > > > > To resolve this, you need to upgrade all your mysql
> > packages (client and server), and
> > > > > > > > > possibly the DBD::mysql Perl module as well..
> > > > > > > > ----
> > > > > > > > my rpm module is # rpm -qa|grep DBD
> > > > > > > > perl-DBD-MySQL-2.9004-3.1
> > > > > > > >
> > > > > > > > cpan.org <http://cpan.org> shows 3.0002
> > > > > > > >
> > > > > > > > do you think I need to get that one?
> > > > > > > >
> > > > > > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > > > > > mysql-4.1.12-3.RHEL4.1
> > > > > > > >
> > > > > > > > The client is as up to date as RHEL 4 gets
> > > > > > > >
> > > > > > > > I understood that they changed and that's why in the config
> > - you offer
> > > > > > > > password hashing mode choice of old/default
> > > > > > > >
> > > > > > > > I have a similar setup and the same problem now here at my
> > home server
> > > > > > > > so this is definitely the place to work this issue through.
> > > > > > > >
> > > > > > > > The last thing I tried was Frank's recommendation...
> > > > > > > >
> > > > > > > > mysql> SET PASSWORD FOR 'root'@'localhost' =3D OLD_PASSWORD
> > > > > > > > ('newpassword');
> > > > > > > >
> > > > > > > > That normally allows me to access the MySQL module on Webmi=
n
> > just fine
> > > > > > > > afterwards.
> > > > > > > >
> > > > > > > > I'm still locked out unless I remove root's password
> > altogether - not
> > > > > > > > that big of an issue at home...probably something I don't
> > really don't
> > > > > > > > want to do at clients
> > > > > > > >
> > > > > > > > Craig
> > > > > > > >
> > > > > > > >
> > > > > > > > --
> > > > > > > > This message has been scanned for viruses and
> > > > > > > > dangerous content by MailScanner, and is
> > > > > > > > believed to be clean.
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > > -------------------------------------------------------
> > > > > > > > This SF.Net email is sponsored by the JBoss Inc. Get
> > Certified Today
> > > > > > > > Register for a JBoss Training Course. Free Certification
> > Exam
> > > > > > > > for All Training Attendees Through End of 2005. For more
> > info visit:
> > > > > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dcli=
ck
> > > > > > > > -
> > > > > > > > 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 the JBoss Inc. Get
> > Certified Today
> > > > > > > > Register for a JBoss Training Course. Free Certification
> > Exam
> > > > > > > > for All Training Attendees Through End of 2005. For more
> > info visit:
> > > > > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dcli=
ck
> > > > > > > > -
> > > > > > > > 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 message has been scanned for viruses and
> > > > > > > > dangerous content by MailScanner, and is
> > > > > > > > believed to be clean.
> > > > > > > >
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > -------------------------------------------------------
> > > > > > This SF.Net email is sponsored by the JBoss Inc. Get Certified
> > Today
> > > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > > for All Training Attendees Through End of 2005. For more info
> > visit:
> > > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > > -
> > > > > > 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 the JBoss Inc. Get Certified Toda=
y
> > > > Register for a JBoss Training Course. Free Certification Exam
> > > > for All Training Attendees Through End of 2005. For more info visit=
:
> >
> > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > -
> > > > 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 the JBoss Inc. Get Certified Today
> > Register for a JBoss Training Course. Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > -
> > 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
> >
>
>
>
> --
> ~Dont tell me its hard to contact me~
> Faisal Mehmood.
> fa...@gm...
> fa...@st...
> fa...@fa...
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Mon, 2005-11-21 at 10:18 +1100, Jamie Cameron wrote:
> Ok .. how about if you run :
> 
> mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status
----
yeah - that's a problem

# mysqladmin -u root -password=MY_ROOT_PASSWORD status
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

Hi Jamie.

I get a

mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'root'@'localhost' (using password: YES)'

Faisal.

On 21 Nov 2005 10:18:46 +1100, Jamie Cameron <jca...@we...> wrote:
>
> Ok .. how about if you run :
>
> mysqladmin -u root -password=3DROOT_MYSQL_PASSWORD status
>
> - Jamie
>
> On Mon, 2005-11-21 at 10:14, Craig White wrote:
> > On Mon, 2005-11-21 at 10:06 +1100, Jamie Cameron wrote:
> > > Hi Craig,
> > >
> > > What happens if you run the following at the command line :
> > >
> > > mysqladmin -u root -pROOT_MYSQL_PASSWORD status
> > ----
> > Uptime: 547079 Threads: 1 Questions: 9959 Slow queries: 0 Opens: 40
> > Flush tables: 3 Open tables: 15 Queries per second avg: 0.018
> > ----
> > >
> > > That is the command Webmin users to attempt a login.
> > > BTW, which MySQL version are you using there?
> > ----
> > ]# rpm -q mysql-server
> > mysql-server-4.1.12-3.RHEL4.1
> >
> > Craig
> > ----
> > >
> > > On Mon, 2005-11-21 at 09:59, Craig White wrote:
> > > > Not sure this is going to be much hope
> > > >
> > > > Messages presented below login screen...
> > > > with module config administrator string set to: ""
> > > > with module config administrator string set to: ""
> > > > The full MySQL error message was : connect to server at 'localhost'
> > > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > > password: NO)'
> > > >
> > > > Messages presented below login screen...
> > > > with module config administrator string set to: "root"
> > > > with module config administrator string set to:
> "ROOT_MYSQL_PASSWORD"
> > > > The full MySQL error message was : connect to server at 'localhost'
> > > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > > password: YES)'
> > > > and after attempt to login...
> > > > the usual "Login failed : Incorrect administration username or
> password"
> > > >
> > > > from command line (passing everything because I have
> > > > renamed /root/.my.cnf for the duration of this problem)
> > > > # mysql mysql -u root -p -h localhost
> > > > Enter password:
> > > > Reading table information for completion of table and column names
> > > > You can turn off this feature to get a quicker startup with -A
> > > >
> > > > Welcome to the MySQL monitor. Commands end with ; or \g.
> > > > Your MySQL connection id is 297 to server version: 4.1.12
> > > >
> > > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > > >
> > > > Craig
> > > >
> > > > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > > > > Hi Craig,
> > > > > Try installing the updated MySQL Webmin module from :
> > > > > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > > > >
> > > > > I have made a small change to display the error message from MySQ=
L
> if
> > > > > you cannot connect or login, which should explain what is really
> going
> > > > > wrong ..
> > > > >
> > > > > - Jamie
> > > > >
> > > > > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > > > > 'Use DBI to connect if available' set to 'no' doesn't change
> anything
> > > > > >
> > > > > > nor does explicity setting port or socket as opposed to default
> > > > > >
> > > > > > Craig
> > > > > >
> > > > > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > > > > Hi Craig,
> > > > > > > Does it help if you adjust the module configuration option
> that disables the use of DBI? If it is out of date, this would fix the
> problem.
> > > > > > >
> > > > > > > By the way, the config option for old or new passwords only
> effects passwords SET by webmin, not those used for logging in (which I h=
ave
> no control over).
> > > > > > >
> > > > > > > - Jamie
> > > > > > >
> > > > > > > -----Original Message-----
> > > > > > >
> > > > > > > From: Craig White <cra...@az...>
> > > > > > > Subj: Re: [webmin-l] mysql module
> > > > > > > Date: Sun 20 Nov 2005 2:23 pm
> > > > > > > Size: 2K
> > > > > > > To: web...@li...
> > > > > > >
> > > > > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > > > >
> > > > > > > > > >--
> > > > > > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > > > > > >
> > > > > > > > > >I 'downgraded' to 1.240 and still had the same problem s=
o
> I went back
> > > > > > > > > to
> > > > > > > > > >1.246 for the benefit of the stuff in LDAP Users and
> Groups.
> > > > > > > > > >
> > > > > > > > > >I did manage to get it to work...as long as there is no
> password for
> > > > > > > > > >root...I'm functional. Perhaps I will try to back it all
> up, use webmin
> > > > > > > > > >to insert the password for root and then see if webmin
> can access it but
> > > > > > > > > >I can't think of a reason why I can't set the password
> with mysqldadmin
> > > > > > > > > >and then login via webmin...I used to always do it that
> way (mysql-3.x)
> > > > > > > > > >
> > > > > > > > > >Craig
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > >
> > > > > > > > > Craig -
> > > > > > > > >
> > > > > > > > > This last bit lit a light bulb for me. There is something
> to do with
> > > > > > > > > long and short passwords in mysql v4.0. The default mysql
> setting broke
> > > > > > > > > whatever webmin was doing for a while, but then it was
> fixed by Jamie
> > > > > > > > > (not sure when). Is it possible you have some settings ou=
t
> of whack there?
> > > > > > > > >
> > > > > > > > > the mysql docs on their web site describe the issue fairl=
y
> well... this
> > > > > > > > > drove me nuts for a while too...
> > > > > > > >
> > > > > > > > That could be another cause actually.. for MySQL 4.0, they
> changed the format
> > > > > > > > uses for encrypted passwords, which means that old clients
> can no longer connect.
> > > > > > > > To resolve this, you need to upgrade all your mysql package=
s
> (client and server), and
> > > > > > > > possibly the DBD::mysql Perl module as well..
> > > > > > > ----
> > > > > > > my rpm module is # rpm -qa|grep DBD
> > > > > > > perl-DBD-MySQL-2.9004-3.1
> > > > > > >
> > > > > > > cpan.org <http://cpan.org> shows 3.0002
> > > > > > >
> > > > > > > do you think I need to get that one?
> > > > > > >
> > > > > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > > > > mysql-4.1.12-3.RHEL4.1
> > > > > > >
> > > > > > > The client is as up to date as RHEL 4 gets
> > > > > > >
> > > > > > > I understood that they changed and that's why in the config -
> you offer
> > > > > > > password hashing mode choice of old/default
> > > > > > >
> > > > > > > I have a similar setup and the same problem now here at my
> home server
> > > > > > > so this is definitely the place to work this issue through.
> > > > > > >
> > > > > > > The last thing I tried was Frank's recommendation...
> > > > > > >
> > > > > > > mysql> SET PASSWORD FOR 'root'@'localhost' =3D OLD_PASSWORD
> > > > > > > ('newpassword');
> > > > > > >
> > > > > > > That normally allows me to access the MySQL module on Webmin
> just fine
> > > > > > > afterwards.
> > > > > > >
> > > > > > > I'm still locked out unless I remove root's password
> altogether - not
> > > > > > > that big of an issue at home...probably something I don't
> really don't
> > > > > > > want to do at clients
> > > > > > >
> > > > > > > Craig
> > > > > > >
> > > > > > >
> > > > > > > --
> > > > > > > This message has been scanned for viruses and
> > > > > > > dangerous content by MailScanner, and is
> > > > > > > believed to be clean.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > -------------------------------------------------------
> > > > > > > This SF.Net email is sponsored by the JBoss Inc. Get Certifie=
d
> Today
> > > > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > > > for All Training Attendees Through End of 2005. For more info
> visit:
> > > > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > > > -
> > > > > > > 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 the JBoss Inc. Get Certifie=
d
> Today
> > > > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > > > for All Training Attendees Through End of 2005. For more info
> visit:
> > > > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > > > -
> > > > > > > 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 message has been scanned for viruses and
> > > > > > > dangerous content by MailScanner, and is
> > > > > > > believed to be clean.
> > > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by the JBoss Inc. Get Certified
> Today
> > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > for All Training Attendees Through End of 2005. For more info
> visit:
> > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > -
> > > > > 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 the JBoss Inc. Get Certified Today
> > > Register for a JBoss Training Course. Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > -
> > > 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 the JBoss Inc. Get Certified Today
> Register for a JBoss Training Course. Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> -
> 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
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

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

Ok .. how about if you run :

mysqladmin -u root -password=ROOT_MYSQL_PASSWORD status

 - Jamie

On Mon, 2005-11-21 at 10:14, Craig White wrote:
> On Mon, 2005-11-21 at 10:06 +1100, Jamie Cameron wrote:
> > Hi Craig,
> > 
> > What happens if you run the following at the command line :
> > 
> > mysqladmin -u root -pROOT_MYSQL_PASSWORD status
> ----
> Uptime: 547079  Threads: 1  Questions: 9959  Slow queries: 0  Opens: 40
> Flush tables: 3  Open tables: 15  Queries per second avg: 0.018
> ----
> > 
> > That is the command Webmin users to attempt a login.
> > BTW, which MySQL version are you using there?
> ----
> ]# rpm -q mysql-server
> mysql-server-4.1.12-3.RHEL4.1
> 
> Craig
> ----
> > 
> > On Mon, 2005-11-21 at 09:59, Craig White wrote:
> > > Not sure this is going to be much hope
> > > 
> > > Messages presented below login screen...
> > > with module config administrator string set to: ""
> > > with module config administrator string set to: ""
> > > The full MySQL error message was : connect to server at 'localhost'
> > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > password: NO)'
> > > 
> > > Messages presented below login screen...
> > > with module config administrator string set to: "root"
> > > with module config administrator string set to: "ROOT_MYSQL_PASSWORD"
> > > The full MySQL error message was : connect to server at 'localhost'
> > > failed error: 'Access denied for user 'root'@'localhost' (using
> > > password: YES)'
> > > and after attempt to login...
> > > the usual "Login failed : Incorrect administration username or password"
> > > 
> > > from command line (passing everything because I have
> > > renamed /root/.my.cnf for the duration of this problem)
> > > # mysql mysql -u root -p -h localhost
> > > Enter password:
> > > Reading table information for completion of table and column names
> > > You can turn off this feature to get a quicker startup with -A
> > > 
> > > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > > Your MySQL connection id is 297 to server version: 4.1.12
> > > 
> > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > > 
> > > Craig
> > > 
> > > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > > > Hi Craig,
> > > > Try installing the updated MySQL Webmin module from :
> > > > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > > > 
> > > > I have made a small change to display the error message from MySQL if
> > > > you cannot connect or login, which should explain what is really going
> > > > wrong ..
> > > > 
> > > >  - Jamie
> > > > 
> > > > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > > > 'Use DBI to connect if available' set to 'no' doesn't change anything
> > > > > 
> > > > > nor does explicity setting port or socket as opposed to default
> > > > > 
> > > > > Craig
> > > > > 
> > > > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > > > Hi Craig,
> > > > > > Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> > > > > > 
> > > > > > By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> > > > > > 
> > > > > >  - Jamie
> > > > > > 
> > > > > > -----Original Message-----
> > > > > > 
> > > > > > From:  Craig White <cra...@az...>
> > > > > > Subj:  Re: [webmin-l] mysql module
> > > > > > Date:  Sun 20 Nov 2005 2:23 pm
> > > > > > Size:  2K
> > > > > > To:  web...@li...
> > > > > > 
> > > > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > > > 
> > > > > > > > >--
> > > > > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > > > > >
> > > > > > > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > > > > > > to
> > > > > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > > > > >
> > > > > > > > >I did manage to get it to work...as long as there is no password for
> > > > > > > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > > > > > > >to insert the password for root and then see if webmin can access it but
> > > > > > > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > > > > > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > > > > > > >
> > > > > > > > >Craig
> > > > > > > > >
> > > > > > > > >
> > > > > > > > >  
> > > > > > > > >
> > > > > > > > Craig -
> > > > > > > > 
> > > > > > > > This last bit lit a light bulb for me. There is something to do with
> > > > > > > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > > > > > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > > > > > > (not sure when). Is it possible you have some settings out of whack there?
> > > > > > > > 
> > > > > > > > the mysql docs on their web site describe the issue fairly well... this
> > > > > > > > drove me nuts for a while too...
> > > > > > > 
> > > > > > > That could be another cause actually.. for MySQL 4.0, they changed the format
> > > > > > > uses for encrypted passwords, which means that old clients can no longer connect.
> > > > > > > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > > > > > > possibly the DBD::mysql Perl module as well..
> > > > > > ----
> > > > > > my rpm module is # rpm -qa|grep DBD
> > > > > > perl-DBD-MySQL-2.9004-3.1
> > > > > > 
> > > > > > cpan.org shows 3.0002
> > > > > > 
> > > > > > do you think I need to get that one?
> > > > > > 
> > > > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > > > mysql-4.1.12-3.RHEL4.1
> > > > > > 
> > > > > > The client is as up to date as RHEL 4 gets
> > > > > > 
> > > > > > I understood that they changed and that's why in the config - you offer
> > > > > > password hashing mode choice of old/default
> > > > > > 
> > > > > > I have a similar setup and the same problem now here at my home server
> > > > > > so this is definitely the place to work this issue through.
> > > > > > 
> > > > > > The last thing I tried was Frank's recommendation...
> > > > > > 
> > > > > > mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> > > > > > ('newpassword');
> > > > > >  
> > > > > > That normally allows me to access the MySQL module on Webmin just fine
> > > > > > afterwards.
> > > > > > 
> > > > > > I'm still locked out unless I remove root's password altogether - not
> > > > > > that big of an issue at home...probably something I don't really don't
> > > > > > want to do at clients
> > > > > > 
> > > > > > Craig
> > > > > > 
> > > > > > 
> > > > > > -- 
> > > > > > This message has been scanned for viruses and
> > > > > > dangerous content by MailScanner, and is
> > > > > > believed to be clean.
> > > > > > 
> > > > > > 
> > > > > > 
> > > > > > -------------------------------------------------------
> > > > > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > > > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> > > > > > dangerous content by MailScanner, and is
> > > > > > believed to be clean.
> > > > > > 
> > > > > 
> > > > 
> > > > 
> > > > 
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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] mysql module

[Craig W. <cra...@az...>]

On Mon, 2005-11-21 at 10:06 +1100, Jamie Cameron wrote:
> Hi Craig,
> 
> What happens if you run the following at the command line :
> 
> mysqladmin -u root -pROOT_MYSQL_PASSWORD status
----
Uptime: 547079  Threads: 1  Questions: 9959  Slow queries: 0  Opens: 40
Flush tables: 3  Open tables: 15  Queries per second avg: 0.018
----
> 
> That is the command Webmin users to attempt a login.
> BTW, which MySQL version are you using there?
----
]# rpm -q mysql-server
mysql-server-4.1.12-3.RHEL4.1

Craig
----
> 
> On Mon, 2005-11-21 at 09:59, Craig White wrote:
> > Not sure this is going to be much hope
> > 
> > Messages presented below login screen...
> > with module config administrator string set to: ""
> > with module config administrator string set to: ""
> > The full MySQL error message was : connect to server at 'localhost'
> > failed error: 'Access denied for user 'root'@'localhost' (using
> > password: NO)'
> > 
> > Messages presented below login screen...
> > with module config administrator string set to: "root"
> > with module config administrator string set to: "ROOT_MYSQL_PASSWORD"
> > The full MySQL error message was : connect to server at 'localhost'
> > failed error: 'Access denied for user 'root'@'localhost' (using
> > password: YES)'
> > and after attempt to login...
> > the usual "Login failed : Incorrect administration username or password"
> > 
> > from command line (passing everything because I have
> > renamed /root/.my.cnf for the duration of this problem)
> > # mysql mysql -u root -p -h localhost
> > Enter password:
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> > 
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > Your MySQL connection id is 297 to server version: 4.1.12
> > 
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > 
> > Craig
> > 
> > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > > Hi Craig,
> > > Try installing the updated MySQL Webmin module from :
> > > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > > 
> > > I have made a small change to display the error message from MySQL if
> > > you cannot connect or login, which should explain what is really going
> > > wrong ..
> > > 
> > >  - Jamie
> > > 
> > > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > > 'Use DBI to connect if available' set to 'no' doesn't change anything
> > > > 
> > > > nor does explicity setting port or socket as opposed to default
> > > > 
> > > > Craig
> > > > 
> > > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > > Hi Craig,
> > > > > Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> > > > > 
> > > > > By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> > > > > 
> > > > >  - Jamie
> > > > > 
> > > > > -----Original Message-----
> > > > > 
> > > > > From:  Craig White <cra...@az...>
> > > > > Subj:  Re: [webmin-l] mysql module
> > > > > Date:  Sun 20 Nov 2005 2:23 pm
> > > > > Size:  2K
> > > > > To:  web...@li...
> > > > > 
> > > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > > 
> > > > > > > >--
> > > > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > > > >
> > > > > > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > > > > > to
> > > > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > > > >
> > > > > > > >I did manage to get it to work...as long as there is no password for
> > > > > > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > > > > > >to insert the password for root and then see if webmin can access it but
> > > > > > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > > > > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > > > > > >
> > > > > > > >Craig
> > > > > > > >
> > > > > > > >
> > > > > > > >  
> > > > > > > >
> > > > > > > Craig -
> > > > > > > 
> > > > > > > This last bit lit a light bulb for me. There is something to do with
> > > > > > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > > > > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > > > > > (not sure when). Is it possible you have some settings out of whack there?
> > > > > > > 
> > > > > > > the mysql docs on their web site describe the issue fairly well... this
> > > > > > > drove me nuts for a while too...
> > > > > > 
> > > > > > That could be another cause actually.. for MySQL 4.0, they changed the format
> > > > > > uses for encrypted passwords, which means that old clients can no longer connect.
> > > > > > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > > > > > possibly the DBD::mysql Perl module as well..
> > > > > ----
> > > > > my rpm module is # rpm -qa|grep DBD
> > > > > perl-DBD-MySQL-2.9004-3.1
> > > > > 
> > > > > cpan.org shows 3.0002
> > > > > 
> > > > > do you think I need to get that one?
> > > > > 
> > > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > > mysql-4.1.12-3.RHEL4.1
> > > > > 
> > > > > The client is as up to date as RHEL 4 gets
> > > > > 
> > > > > I understood that they changed and that's why in the config - you offer
> > > > > password hashing mode choice of old/default
> > > > > 
> > > > > I have a similar setup and the same problem now here at my home server
> > > > > so this is definitely the place to work this issue through.
> > > > > 
> > > > > The last thing I tried was Frank's recommendation...
> > > > > 
> > > > > mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> > > > > ('newpassword');
> > > > >  
> > > > > That normally allows me to access the MySQL module on Webmin just fine
> > > > > afterwards.
> > > > > 
> > > > > I'm still locked out unless I remove root's password altogether - not
> > > > > that big of an issue at home...probably something I don't really don't
> > > > > want to do at clients
> > > > > 
> > > > > Craig
> > > > > 
> > > > > 
> > > > > -- 
> > > > > This message has been scanned for viruses and
> > > > > dangerous content by MailScanner, and is
> > > > > believed to be clean.
> > > > > 
> > > > > 
> > > > > 
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> > > > > dangerous content by MailScanner, and is
> > > > > believed to be clean.
> > > > > 
> > > > 
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > Register for a JBoss Training Course.  Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

I am using MYSQL ver. 4.1.12

On 21 Nov 2005 10:06:28 +1100, Jamie Cameron <jca...@we...> wrote:
>
> Hi Craig,
>
> What happens if you run the following at the command line :
>
> mysqladmin -u root -pROOT_MYSQL_PASSWORD status
>
> That is the command Webmin users to attempt a login.
> BTW, which MySQL version are you using there?
>
> - Jamie
>
> On Mon, 2005-11-21 at 09:59, Craig White wrote:
> > Not sure this is going to be much hope
> >
> > Messages presented below login screen...
> > with module config administrator string set to: ""
> > with module config administrator string set to: ""
> > The full MySQL error message was : connect to server at 'localhost'
> > failed error: 'Access denied for user 'root'@'localhost' (using
> > password: NO)'
> >
> > Messages presented below login screen...
> > with module config administrator string set to: "root"
> > with module config administrator string set to: "ROOT_MYSQL_PASSWORD"
> > The full MySQL error message was : connect to server at 'localhost'
> > failed error: 'Access denied for user 'root'@'localhost' (using
> > password: YES)'
> > and after attempt to login...
> > the usual "Login failed : Incorrect administration username or password=
"
> >
> > from command line (passing everything because I have
> > renamed /root/.my.cnf for the duration of this problem)
> > # mysql mysql -u root -p -h localhost
> > Enter password:
> > Reading table information for completion of table and column names
> > You can turn off this feature to get a quicker startup with -A
> >
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 297 to server version: 4.1.12
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > Craig
> >
> > On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > > Hi Craig,
> > > Try installing the updated MySQL Webmin module from :
> > > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > >
> > > I have made a small change to display the error message from MySQL if
> > > you cannot connect or login, which should explain what is really goin=
g
> > > wrong ..
> > >
> > > - Jamie
> > >
> > > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > > 'Use DBI to connect if available' set to 'no' doesn't change
> anything
> > > >
> > > > nor does explicity setting port or socket as opposed to default
> > > >
> > > > Craig
> > > >
> > > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > > Hi Craig,
> > > > > Does it help if you adjust the module configuration option that
> disables the use of DBI? If it is out of date, this would fix the problem=
.
> > > > >
> > > > > By the way, the config option for old or new passwords only
> effects passwords SET by webmin, not those used for logging in (which I h=
ave
> no control over).
> > > > >
> > > > > - Jamie
> > > > >
> > > > > -----Original Message-----
> > > > >
> > > > > From: Craig White <cra...@az...>
> > > > > Subj: Re: [webmin-l] mysql module
> > > > > Date: Sun 20 Nov 2005 2:23 pm
> > > > > Size: 2K
> > > > > To: web...@li...
> > > > >
> > > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > >
> > > > > > > >--
> > > > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > > > >
> > > > > > > >I 'downgraded' to 1.240 and still had the same problem so I
> went back
> > > > > > > to
> > > > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > > > >
> > > > > > > >I did manage to get it to work...as long as there is no
> password for
> > > > > > > >root...I'm functional. Perhaps I will try to back it all up,
> use webmin
> > > > > > > >to insert the password for root and then see if webmin can
> access it but
> > > > > > > >I can't think of a reason why I can't set the password with
> mysqldadmin
> > > > > > > >and then login via webmin...I used to always do it that way =
(
> mysql-3.x)
> > > > > > > >
> > > > > > > >Craig
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > > Craig -
> > > > > > >
> > > > > > > This last bit lit a light bulb for me. There is something to
> do with
> > > > > > > long and short passwords in mysql v4.0. The default mysql
> setting broke
> > > > > > > whatever webmin was doing for a while, but then it was fixed
> by Jamie
> > > > > > > (not sure when). Is it possible you have some settings out of
> whack there?
> > > > > > >
> > > > > > > the mysql docs on their web site describe the issue fairly
> well... this
> > > > > > > drove me nuts for a while too...
> > > > > >
> > > > > > That could be another cause actually.. for MySQL 4.0, they
> changed the format
> > > > > > uses for encrypted passwords, which means that old clients can
> no longer connect.
> > > > > > To resolve this, you need to upgrade all your mysql packages
> (client and server), and
> > > > > > possibly the DBD::mysql Perl module as well..
> > > > > ----
> > > > > my rpm module is # rpm -qa|grep DBD
> > > > > perl-DBD-MySQL-2.9004-3.1
> > > > >
> > > > > cpan.org <http://cpan.org> shows 3.0002
> > > > >
> > > > > do you think I need to get that one?
> > > > >
> > > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > > mysql-4.1.12-3.RHEL4.1
> > > > >
> > > > > The client is as up to date as RHEL 4 gets
> > > > >
> > > > > I understood that they changed and that's why in the config - you
> offer
> > > > > password hashing mode choice of old/default
> > > > >
> > > > > I have a similar setup and the same problem now here at my home
> server
> > > > > so this is definitely the place to work this issue through.
> > > > >
> > > > > The last thing I tried was Frank's recommendation...
> > > > >
> > > > > mysql> SET PASSWORD FOR 'root'@'localhost' =3D OLD_PASSWORD
> > > > > ('newpassword');
> > > > >
> > > > > That normally allows me to access the MySQL module on Webmin just
> fine
> > > > > afterwards.
> > > > >
> > > > > I'm still locked out unless I remove root's password altogether -
> not
> > > > > that big of an issue at home...probably something I don't really
> don't
> > > > > want to do at clients
> > > > >
> > > > > Craig
> > > > >
> > > > >
> > > > > --
> > > > > This message has been scanned for viruses and
> > > > > dangerous content by MailScanner, and is
> > > > > believed to be clean.
> > > > >
> > > > >
> > > > >
> > > > > -------------------------------------------------------
> > > > > This SF.Net email is sponsored by the JBoss Inc. Get Certified
> Today
> > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > for All Training Attendees Through End of 2005. For more info
> visit:
> > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > -
> > > > > 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 the JBoss Inc. Get Certified
> Today
> > > > > Register for a JBoss Training Course. Free Certification Exam
> > > > > for All Training Attendees Through End of 2005. For more info
> visit:
> > > > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > > > -
> > > > > 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 message has been scanned for viruses and
> > > > > dangerous content by MailScanner, and is
> > > > > believed to be clean.
> > > > >
> > > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
> > > Register for a JBoss Training Course. Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > -
> > > 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 the JBoss Inc. Get Certified Today
> Register for a JBoss Training Course. Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> -
> 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
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

[Faisal M. <fa...@gm...>]

Hi.

Ok Jamie. Here is the message generated.

The full MySQL error message was : connect to server at 'localhost' failed
error: 'Access denied for user 'interlinkage'@'localhost' (using password:
YES)'

Another Problem i noticed in this NEW module is:

When i click on a user Under the USer Permissions of the MYSQL module,
(logged in as Master Admin) The window that opens up, changes the username
to another user on the system. It shows up fine when the page loads for a
second then it automatically changes.

For example:

I have two servers on the virtualmin.

xyz.com <http://xyz.com> (user: xyz)

and

abc.com <http://abc.com> (user: abc)

I added xyz.com <http://xyz.com> before abc.com <http://abc.com>

So when i click on xyz username, the window opens for the user permissions
to change the password and all, for a second it shows xyz under the usernam=
e
field, and this automatically changes to abc

I thought this was kind of a wierd behaviour, this is a new behaviour in th=
e
current module. I am using Firefox as my browser.

Thanks.
Faisal.

On 21 Nov 2005 09:22:52 +1100, Jamie Cameron <jca...@we...> wrote:
>
> Hi Craig,
> Try installing the updated MySQL Webmin module from :
> http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
>
> I have made a small change to display the error message from MySQL if
> you cannot connect or login, which should explain what is really going
> wrong ..
>
> - Jamie
>
> On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > 'Use DBI to connect if available' set to 'no' doesn't change anything
> >
> > nor does explicity setting port or socket as opposed to default
> >
> > Craig
> >
> > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > Hi Craig,
> > > Does it help if you adjust the module configuration option that
> disables the use of DBI? If it is out of date, this would fix the problem=
.
> > >
> > > By the way, the config option for old or new passwords only effects
> passwords SET by webmin, not those used for logging in (which I have no
> control over).
> > >
> > > - Jamie
> > >
> > > -----Original Message-----
> > >
> > > From: Craig White <cra...@az...>
> > > Subj: Re: [webmin-l] mysql module
> > > Date: Sun 20 Nov 2005 2:23 pm
> > > Size: 2K
> > > To: web...@li...
> > >
> > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > >
> > > > > >--
> > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > >
> > > > > >I 'downgraded' to 1.240 and still had the same problem so I went
> back
> > > > > to
> > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > >
> > > > > >I did manage to get it to work...as long as there is no password
> for
> > > > > >root...I'm functional. Perhaps I will try to back it all up, use
> webmin
> > > > > >to insert the password for root and then see if webmin can acces=
s
> it but
> > > > > >I can't think of a reason why I can't set the password with
> mysqldadmin
> > > > > >and then login via webmin...I used to always do it that way (
> mysql-3.x)
> > > > > >
> > > > > >Craig
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > Craig -
> > > > >
> > > > > This last bit lit a light bulb for me. There is something to do
> with
> > > > > long and short passwords in mysql v4.0. The default mysql setting
> broke
> > > > > whatever webmin was doing for a while, but then it was fixed by
> Jamie
> > > > > (not sure when). Is it possible you have some settings out of
> whack there?
> > > > >
> > > > > the mysql docs on their web site describe the issue fairly well..=
.
> this
> > > > > drove me nuts for a while too...
> > > >
> > > > That could be another cause actually.. for MySQL 4.0, they changed
> the format
> > > > uses for encrypted passwords, which means that old clients can no
> longer connect.
> > > > To resolve this, you need to upgrade all your mysql packages (clien=
t
> and server), and
> > > > possibly the DBD::mysql Perl module as well..
> > > ----
> > > my rpm module is # rpm -qa|grep DBD
> > > perl-DBD-MySQL-2.9004-3.1
> > >
> > > cpan.org <http://cpan.org> shows 3.0002
> > >
> > > do you think I need to get that one?
> > >
> > > # rpm -q --whatprovides /usr/bin/mysql
> > > mysql-4.1.12-3.RHEL4.1
> > >
> > > The client is as up to date as RHEL 4 gets
> > >
> > > I understood that they changed and that's why in the config - you
> offer
> > > password hashing mode choice of old/default
> > >
> > > I have a similar setup and the same problem now here at my home serve=
r
> > > so this is definitely the place to work this issue through.
> > >
> > > The last thing I tried was Frank's recommendation...
> > >
> > > mysql> SET PASSWORD FOR 'root'@'localhost' =3D OLD_PASSWORD
> > > ('newpassword');
> > >
> > > That normally allows me to access the MySQL module on Webmin just fin=
e
> > > afterwards.
> > >
> > > I'm still locked out unless I remove root's password altogether - not
> > > that big of an issue at home...probably something I don't really don'=
t
> > > want to do at clients
> > >
> > > Craig
> > >
> > >
> > > --
> > > This message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
> > > Register for a JBoss Training Course. Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > -
> > > 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 the JBoss Inc. Get Certified Today
> > > Register for a JBoss Training Course. Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> > > -
> > > 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 message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
> > >
> >
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc. Get Certified Today
> Register for a JBoss Training Course. Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=3D7628&alloc_id=3D16845&op=3Dclick
> -
> 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
>



--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...

Re: [webmin-l] mysql module

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

Hi Craig,

What happens if you run the following at the command line :

mysqladmin -u root -pROOT_MYSQL_PASSWORD status

That is the command Webmin users to attempt a login.
BTW, which MySQL version are you using there?

 - Jamie

On Mon, 2005-11-21 at 09:59, Craig White wrote:
> Not sure this is going to be much hope
> 
> Messages presented below login screen...
> with module config administrator string set to: ""
> with module config administrator string set to: ""
> The full MySQL error message was : connect to server at 'localhost'
> failed error: 'Access denied for user 'root'@'localhost' (using
> password: NO)'
> 
> Messages presented below login screen...
> with module config administrator string set to: "root"
> with module config administrator string set to: "ROOT_MYSQL_PASSWORD"
> The full MySQL error message was : connect to server at 'localhost'
> failed error: 'Access denied for user 'root'@'localhost' (using
> password: YES)'
> and after attempt to login...
> the usual "Login failed : Incorrect administration username or password"
> 
> from command line (passing everything because I have
> renamed /root/.my.cnf for the duration of this problem)
> # mysql mysql -u root -p -h localhost
> Enter password:
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
> 
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 297 to server version: 4.1.12
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> Craig
> 
> On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> > Hi Craig,
> > Try installing the updated MySQL Webmin module from :
> > http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> > 
> > I have made a small change to display the error message from MySQL if
> > you cannot connect or login, which should explain what is really going
> > wrong ..
> > 
> >  - Jamie
> > 
> > On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > > 'Use DBI to connect if available' set to 'no' doesn't change anything
> > > 
> > > nor does explicity setting port or socket as opposed to default
> > > 
> > > Craig
> > > 
> > > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > > Hi Craig,
> > > > Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> > > > 
> > > > By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> > > > 
> > > >  - Jamie
> > > > 
> > > > -----Original Message-----
> > > > 
> > > > From:  Craig White <cra...@az...>
> > > > Subj:  Re: [webmin-l] mysql module
> > > > Date:  Sun 20 Nov 2005 2:23 pm
> > > > Size:  2K
> > > > To:  web...@li...
> > > > 
> > > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > > 
> > > > > > >--
> > > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > > >
> > > > > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > > > > to
> > > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > > >
> > > > > > >I did manage to get it to work...as long as there is no password for
> > > > > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > > > > >to insert the password for root and then see if webmin can access it but
> > > > > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > > > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > > > > >
> > > > > > >Craig
> > > > > > >
> > > > > > >
> > > > > > >  
> > > > > > >
> > > > > > Craig -
> > > > > > 
> > > > > > This last bit lit a light bulb for me. There is something to do with
> > > > > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > > > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > > > > (not sure when). Is it possible you have some settings out of whack there?
> > > > > > 
> > > > > > the mysql docs on their web site describe the issue fairly well... this
> > > > > > drove me nuts for a while too...
> > > > > 
> > > > > That could be another cause actually.. for MySQL 4.0, they changed the format
> > > > > uses for encrypted passwords, which means that old clients can no longer connect.
> > > > > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > > > > possibly the DBD::mysql Perl module as well..
> > > > ----
> > > > my rpm module is # rpm -qa|grep DBD
> > > > perl-DBD-MySQL-2.9004-3.1
> > > > 
> > > > cpan.org shows 3.0002
> > > > 
> > > > do you think I need to get that one?
> > > > 
> > > > # rpm -q --whatprovides /usr/bin/mysql
> > > > mysql-4.1.12-3.RHEL4.1
> > > > 
> > > > The client is as up to date as RHEL 4 gets
> > > > 
> > > > I understood that they changed and that's why in the config - you offer
> > > > password hashing mode choice of old/default
> > > > 
> > > > I have a similar setup and the same problem now here at my home server
> > > > so this is definitely the place to work this issue through.
> > > > 
> > > > The last thing I tried was Frank's recommendation...
> > > > 
> > > > mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> > > > ('newpassword');
> > > >  
> > > > That normally allows me to access the MySQL module on Webmin just fine
> > > > afterwards.
> > > > 
> > > > I'm still locked out unless I remove root's password altogether - not
> > > > that big of an issue at home...probably something I don't really don't
> > > > want to do at clients
> > > > 
> > > > Craig
> > > > 
> > > > 
> > > > -- 
> > > > This message has been scanned for viruses and
> > > > dangerous content by MailScanner, and is
> > > > believed to be clean.
> > > > 
> > > > 
> > > > 
> > > > -------------------------------------------------------
> > > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > > > Register for a JBoss Training Course.  Free Certification Exam
> > > > for All Training Attendees Through End of 2005. For more info visit:
> > > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> > > > dangerous content by MailScanner, and is
> > > > believed to be clean.
> > > > 
> > > 
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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] mysql module

[Craig W. <cra...@az...>]

Not sure this is going to be much hope

Messages presented below login screen...
with module config administrator string set to: ""
with module config administrator string set to: ""
The full MySQL error message was : connect to server at 'localhost'
failed error: 'Access denied for user 'root'@'localhost' (using
password: NO)'

Messages presented below login screen...
with module config administrator string set to: "root"
with module config administrator string set to: "ROOT_MYSQL_PASSWORD"
The full MySQL error message was : connect to server at 'localhost'
failed error: 'Access denied for user 'root'@'localhost' (using
password: YES)'
and after attempt to login...
the usual "Login failed : Incorrect administration username or password"

from command line (passing everything because I have
renamed /root/.my.cnf for the duration of this problem)
# mysql mysql -u root -p -h localhost
Enter password:
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 297 to server version: 4.1.12

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Craig

On Mon, 2005-11-21 at 09:22 +1100, Jamie Cameron wrote:
> Hi Craig,
> Try installing the updated MySQL Webmin module from :
> http://www.webmin.com/updates/mysql-1.240-8.wbm.gz
> 
> I have made a small change to display the error message from MySQL if
> you cannot connect or login, which should explain what is really going
> wrong ..
> 
>  - Jamie
> 
> On Mon, 2005-11-21 at 03:04, Craig White wrote:
> > 'Use DBI to connect if available' set to 'no' doesn't change anything
> > 
> > nor does explicity setting port or socket as opposed to default
> > 
> > Craig
> > 
> > On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > > Hi Craig,
> > > Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> > > 
> > > By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> > > 
> > >  - Jamie
> > > 
> > > -----Original Message-----
> > > 
> > > From:  Craig White <cra...@az...>
> > > Subj:  Re: [webmin-l] mysql module
> > > Date:  Sun 20 Nov 2005 2:23 pm
> > > Size:  2K
> > > To:  web...@li...
> > > 
> > > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > > 
> > > > > >--
> > > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > > >
> > > > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > > > to
> > > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > > >
> > > > > >I did manage to get it to work...as long as there is no password for
> > > > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > > > >to insert the password for root and then see if webmin can access it but
> > > > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > > > >
> > > > > >Craig
> > > > > >
> > > > > >
> > > > > >  
> > > > > >
> > > > > Craig -
> > > > > 
> > > > > This last bit lit a light bulb for me. There is something to do with
> > > > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > > > (not sure when). Is it possible you have some settings out of whack there?
> > > > > 
> > > > > the mysql docs on their web site describe the issue fairly well... this
> > > > > drove me nuts for a while too...
> > > > 
> > > > That could be another cause actually.. for MySQL 4.0, they changed the format
> > > > uses for encrypted passwords, which means that old clients can no longer connect.
> > > > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > > > possibly the DBD::mysql Perl module as well..
> > > ----
> > > my rpm module is # rpm -qa|grep DBD
> > > perl-DBD-MySQL-2.9004-3.1
> > > 
> > > cpan.org shows 3.0002
> > > 
> > > do you think I need to get that one?
> > > 
> > > # rpm -q --whatprovides /usr/bin/mysql
> > > mysql-4.1.12-3.RHEL4.1
> > > 
> > > The client is as up to date as RHEL 4 gets
> > > 
> > > I understood that they changed and that's why in the config - you offer
> > > password hashing mode choice of old/default
> > > 
> > > I have a similar setup and the same problem now here at my home server
> > > so this is definitely the place to work this issue through.
> > > 
> > > The last thing I tried was Frank's recommendation...
> > > 
> > > mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> > > ('newpassword');
> > >  
> > > That normally allows me to access the MySQL module on Webmin just fine
> > > afterwards.
> > > 
> > > I'm still locked out unless I remove root's password altogether - not
> > > that big of an issue at home...probably something I don't really don't
> > > want to do at clients
> > > 
> > > Craig
> > > 
> > > 
> > > -- 
> > > This message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
> > > 
> > > 
> > > 
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > > Register for a JBoss Training Course.  Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > > Register for a JBoss Training Course.  Free Certification Exam
> > > for All Training Attendees Through End of 2005. For more info visit:
> > > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
> > > 
> > 
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

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

Hi Craig,
Try installing the updated MySQL Webmin module from :
http://www.webmin.com/updates/mysql-1.240-8.wbm.gz

I have made a small change to display the error message from MySQL if
you cannot connect or login, which should explain what is really going
wrong ..

 - Jamie

On Mon, 2005-11-21 at 03:04, Craig White wrote:
> 'Use DBI to connect if available' set to 'no' doesn't change anything
> 
> nor does explicity setting port or socket as opposed to default
> 
> Craig
> 
> On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> > Hi Craig,
> > Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> > 
> > By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> > 
> >  - Jamie
> > 
> > -----Original Message-----
> > 
> > From:  Craig White <cra...@az...>
> > Subj:  Re: [webmin-l] mysql module
> > Date:  Sun 20 Nov 2005 2:23 pm
> > Size:  2K
> > To:  web...@li...
> > 
> > On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > > On 17/Nov/2005 19:02 Barry wrote ..
> > > > 
> > > > >--
> > > > >I was hoping to get Jamie or someone to pipe in on this.
> > > > >
> > > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > > to
> > > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > > >
> > > > >I did manage to get it to work...as long as there is no password for
> > > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > > >to insert the password for root and then see if webmin can access it but
> > > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > > >
> > > > >Craig
> > > > >
> > > > >
> > > > >  
> > > > >
> > > > Craig -
> > > > 
> > > > This last bit lit a light bulb for me. There is something to do with
> > > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > > (not sure when). Is it possible you have some settings out of whack there?
> > > > 
> > > > the mysql docs on their web site describe the issue fairly well... this
> > > > drove me nuts for a while too...
> > > 
> > > That could be another cause actually.. for MySQL 4.0, they changed the format
> > > uses for encrypted passwords, which means that old clients can no longer connect.
> > > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > > possibly the DBD::mysql Perl module as well..
> > ----
> > my rpm module is # rpm -qa|grep DBD
> > perl-DBD-MySQL-2.9004-3.1
> > 
> > cpan.org shows 3.0002
> > 
> > do you think I need to get that one?
> > 
> > # rpm -q --whatprovides /usr/bin/mysql
> > mysql-4.1.12-3.RHEL4.1
> > 
> > The client is as up to date as RHEL 4 gets
> > 
> > I understood that they changed and that's why in the config - you offer
> > password hashing mode choice of old/default
> > 
> > I have a similar setup and the same problem now here at my home server
> > so this is definitely the place to work this issue through.
> > 
> > The last thing I tried was Frank's recommendation...
> > 
> > mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> > ('newpassword');
> >  
> > That normally allows me to access the MySQL module on Webmin just fine
> > afterwards.
> > 
> > I'm still locked out unless I remove root's password altogether - not
> > that big of an issue at home...probably something I don't really don't
> > want to do at clients
> > 
> > Craig
> > 
> > 
> > -- 
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> > 
> > 
> > 
> > -------------------------------------------------------
> > This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> > Register for a JBoss Training Course.  Free Certification Exam
> > for All Training Attendees Through End of 2005. For more info visit:
> > http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> > 
> 

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Sun, 2005-11-20 at 09:04 -0700, Craig White wrote:
> 'Use DBI to connect if available' set to 'no' doesn't change anything
> 
> nor does explicity setting port or socket as opposed to default
> 
----
one other thing that is even stranger is...

If I remove administrator user and set password to '' and then save, I
am not asked for log in and am passed directly into your module but

MySQL Databases
You do not have access to any MySQL databases.

and I have full access to 'Global Options' and I can add/edit users but
never get access to databases.

I believe this is permitted because of /root/.my.cnf because if I move
that file, I am asked for credentials (and of course, I can then never
get logged in).

Craig




-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

'Use DBI to connect if available' set to 'no' doesn't change anything

nor does explicity setting port or socket as opposed to default

Craig

On Sun, 2005-11-20 at 15:12 +1100, Jamie Cameron wrote:
> Hi Craig,
> Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  
> 
> By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).
> 
>  - Jamie
> 
> -----Original Message-----
> 
> From:  Craig White <cra...@az...>
> Subj:  Re: [webmin-l] mysql module
> Date:  Sun 20 Nov 2005 2:23 pm
> Size:  2K
> To:  web...@li...
> 
> On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> > On 17/Nov/2005 19:02 Barry wrote ..
> > > 
> > > >--
> > > >I was hoping to get Jamie or someone to pipe in on this.
> > > >
> > > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > > to
> > > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > > >
> > > >I did manage to get it to work...as long as there is no password for
> > > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > > >to insert the password for root and then see if webmin can access it but
> > > >I can't think of a reason why I can't set the password with mysqldadmin
> > > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > > >
> > > >Craig
> > > >
> > > >
> > > >  
> > > >
> > > Craig -
> > > 
> > > This last bit lit a light bulb for me. There is something to do with
> > > long and short passwords in mysql v4.0. The default mysql setting broke
> > > whatever webmin was doing for a while, but then it was fixed by Jamie
> > > (not sure when). Is it possible you have some settings out of whack there?
> > > 
> > > the mysql docs on their web site describe the issue fairly well... this
> > > drove me nuts for a while too...
> > 
> > That could be another cause actually.. for MySQL 4.0, they changed the format
> > uses for encrypted passwords, which means that old clients can no longer connect.
> > To resolve this, you need to upgrade all your mysql packages (client and server), and
> > possibly the DBD::mysql Perl module as well..
> ----
> my rpm module is # rpm -qa|grep DBD
> perl-DBD-MySQL-2.9004-3.1
> 
> cpan.org shows 3.0002
> 
> do you think I need to get that one?
> 
> # rpm -q --whatprovides /usr/bin/mysql
> mysql-4.1.12-3.RHEL4.1
> 
> The client is as up to date as RHEL 4 gets
> 
> I understood that they changed and that's why in the config - you offer
> password hashing mode choice of old/default
> 
> I have a similar setup and the same problem now here at my home server
> so this is definitely the place to work this issue through.
> 
> The last thing I tried was Frank's recommendation...
> 
> mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
> ('newpassword');
>  
> That normally allows me to access the MySQL module on Webmin just fine
> afterwards.
> 
> I'm still locked out unless I remove root's password altogether - not
> that big of an issue at home...probably something I don't really don't
> want to do at clients
> 
> Craig
> 
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 the JBoss Inc.  Get Certified Today
> Register for a JBoss Training Course.  Free Certification Exam
> for All Training Attendees Through End of 2005. For more info visit:
> http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
> 


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[webmin-l] suggestions

[cojast <co...@wi...>]

Don=92t know if there already is a module for this but what about having =
a
Frontpage Server Extensions module in webmin.  So you can add and delete
these extensions to the websites you are hosting.

=20

=20

Cojast


--=20
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.1.362 / Virus Database: 267.13.4/175 - Release Date: =
11/18/2005
=20

Re: [webmin-l] mysql module

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

Hi Craig,
Does it help if you adjust the module configuration option that disables the use of DBI? If it is out of date, this would fix the problem.  

By the way, the config option for old or new passwords only effects passwords SET by webmin, not those used for logging in (which I have no control over).

 - Jamie

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

From:  Craig White <cra...@az...>
Subj:  Re: [webmin-l] mysql module
Date:  Sun 20 Nov 2005 2:23 pm
Size:  2K
To:  web...@li...

On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> On 17/Nov/2005 19:02 Barry wrote ..
> > 
> > >--
> > >I was hoping to get Jamie or someone to pipe in on this.
> > >
> > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > to
> > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > >
> > >I did manage to get it to work...as long as there is no password for
> > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > >to insert the password for root and then see if webmin can access it but
> > >I can't think of a reason why I can't set the password with mysqldadmin
> > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > >
> > >Craig
> > >
> > >
> > >  
> > >
> > Craig -
> > 
> > This last bit lit a light bulb for me. There is something to do with
> > long and short passwords in mysql v4.0. The default mysql setting broke
> > whatever webmin was doing for a while, but then it was fixed by Jamie
> > (not sure when). Is it possible you have some settings out of whack there?
> > 
> > the mysql docs on their web site describe the issue fairly well... this
> > drove me nuts for a while too...
> 
> That could be another cause actually.. for MySQL 4.0, they changed the format
> uses for encrypted passwords, which means that old clients can no longer connect.
> To resolve this, you need to upgrade all your mysql packages (client and server), and
> possibly the DBD::mysql Perl module as well..
----
my rpm module is # rpm -qa|grep DBD
perl-DBD-MySQL-2.9004-3.1

cpan.org shows 3.0002

do you think I need to get that one?

# rpm -q --whatprovides /usr/bin/mysql
mysql-4.1.12-3.RHEL4.1

The client is as up to date as RHEL 4 gets

I understood that they changed and that's why in the config - you offer
password hashing mode choice of old/default

I have a similar setup and the same problem now here at my home server
so this is definitely the place to work this issue through.

The last thing I tried was Frank's recommendation...

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
('newpassword');
 
That normally allows me to access the MySQL module on Webmin just fine
afterwards.

I'm still locked out unless I remove root's password altogether - not
that big of an issue at home...probably something I don't really don't
want to do at clients

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.



-------------------------------------------------------
This SF.Net email is sponsored by the JBoss Inc.  Get Certified Today
Register for a JBoss Training Course.  Free Certification Exam
for All Training Attendees Through End of 2005. For more info visit:
http://ads.osdn.com/?ad_id=7628&alloc_id=16845&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 ---

Re: [webmin-l] mysql module

[Craig W. <cra...@az...>]

On Thu, 2005-11-17 at 21:54 +1100, Jamie Cameron wrote:
> On 17/Nov/2005 19:02 Barry wrote ..
> > 
> > >--
> > >I was hoping to get Jamie or someone to pipe in on this.
> > >
> > >I 'downgraded' to 1.240 and still had the same problem so I went back
> > to
> > >1.246 for the benefit of the stuff in LDAP Users and Groups.
> > >
> > >I did manage to get it to work...as long as there is no password for
> > >root...I'm functional. Perhaps I will try to back it all up, use webmin
> > >to insert the password for root and then see if webmin can access it but
> > >I can't think of a reason why I can't set the password with mysqldadmin
> > >and then login via webmin...I used to always do it that way (mysql-3.x)
> > >
> > >Craig
> > >
> > >
> > >  
> > >
> > Craig -
> > 
> > This last bit lit a light bulb for me. There is something to do with
> > long and short passwords in mysql v4.0. The default mysql setting broke
> > whatever webmin was doing for a while, but then it was fixed by Jamie
> > (not sure when). Is it possible you have some settings out of whack there?
> > 
> > the mysql docs on their web site describe the issue fairly well... this
> > drove me nuts for a while too...
> 
> That could be another cause actually.. for MySQL 4.0, they changed the format
> uses for encrypted passwords, which means that old clients can no longer connect.
> To resolve this, you need to upgrade all your mysql packages (client and server), and
> possibly the DBD::mysql Perl module as well..
----
my rpm module is # rpm -qa|grep DBD
perl-DBD-MySQL-2.9004-3.1

cpan.org shows 3.0002

do you think I need to get that one?

# rpm -q --whatprovides /usr/bin/mysql
mysql-4.1.12-3.RHEL4.1

The client is as up to date as RHEL 4 gets

I understood that they changed and that's why in the config - you offer
password hashing mode choice of old/default

I have a similar setup and the same problem now here at my home server
so this is definitely the place to work this issue through.

The last thing I tried was Frank's recommendation...

mysql> SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD
('newpassword');
 
That normally allows me to access the MySQL module on Webmin just fine
afterwards.

I'm still locked out unless I remove root's password altogether - not
that big of an issue at home...probably something I don't really don't
want to do at clients

Craig


-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

[webmin-l] MYSQL management in Virtualmin

[Faisal M. <fa...@gm...>]

Hi.

The management of MYSQL Database under users is Not working.

When you click the MYSQL module in webmin for a user who has been created
using Virtualmin, it asks for a password.

Now this was working fine before, i had checked it, so a recent update has
probably something to do with it. (I have no updated MYSQL)

In the virtualmin, the option to Edit Databases:

User can Create Database fine. It even shows up in the databases list. The
user cannot MANAGE the DB.

Now this is wierd also because the older Databases being accessed by the
Database Username and Password (the same as the users webmin user/pass) are
being accessed fine also.

Ok some updates to this are, that i upgraded the shadow_utils. .... could
that have something to with this ?


I have check the Mysql module as Master Admin. All permissions and
everything seems fine. But management is NOT working.

Thankyou.
Faisal.


--
~Dont tell me its hard to contact me~
Faisal Mehmood.
fa...@gm...
fa...@st...
fa...@fa...