webadmin-list

[webmin-l] mysql module

[Allen E. <mi...@pa...>]

I just finshed loading the latest webmin and
everything is working except the mysql module.

I'm on Solaris 9, using sunfreeware's perl and mysql,
and I've made sure that I've got the webmin config
adding in the paths to the libraries.

The module will show me the databases and tables, but
if I go to run a SQL command or change anything, I get
something like:

/mysql/list_dbs.cgi : Perl execution failed : Can't
use an undefined value as a HASH reference at
/usr/local/lib/perl5/site_perl/5.8.0/sun4-solaris/DBD/mysql.pm
line 113.

After poring throuh the mailing lists, docs and
google, I'm at a dead end.  Can anyone set me
straight?

Thanks!

-Allen

[webmin-l] mysql module

[Fred G. <fr...@fr...>]

See:

http://www.swelltech.com/pipermail/webmin-l-archive/2003-October/016458.html

[webmin-l] mysql module

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

Development version 1.246 - New CentOS install - mysql-
server-4.1.12-3.RHEL4.1

this probably has to do with my basic unfamiliarity with mysql

service mysqld start

mysqladmin -u root passwd "password"

no problems...I can login as root with the password I've given it.

I cannot log into mysql module on Webmin

I set the administration login and password in the module config but I
still get access denied with the same login stuff at the login screen.

It's all localhost stuff and I tried explicity setting the socket
to /var/lib/mysql/mysql.sock but to no avail.

Hints?

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 Craig.

I cannot log into mysql module on Webmin
>
> I set the administration login and password in the module config but I
> still get access denied with the same login stuff at the login screen.
>
> It's all localhost stuff and I tried explicity setting the socket
> to /var/lib/mysql/mysql.sock but to no avail.



Did you try the MYSQL moDule Configuration ?



On 11/16/05, Craig White <cra...@az...> wrote:
>
> Development version 1.246 - New CentOS install - mysql-
> server-4.1.12-3.RHEL4.1
>
> this probably has to do with my basic unfamiliarity with mysql
>
> service mysqld start
>
> mysqladmin -u root passwd "password"
>
> no problems...I can login as root with the password I've given it.
>
> I cannot log into mysql module on Webmin
>
> I set the administration login and password in the module config but I
> still get access denied with the same login stuff at the login screen.
>
> It's all localhost stuff and I tried explicity setting the socket
> to /var/lib/mysql/mysql.sock but to no avail.
>
> Hints?
>
> 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

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

On Wed, 2005-11-16 at 07:26 -0700, Craig White wrote:
> Development version 1.246 - New CentOS install - mysql-
> server-4.1.12-3.RHEL4.1
> 
> this probably has to do with my basic unfamiliarity with mysql
> 
> service mysqld start
> 
> mysqladmin -u root passwd "password"
> 
> no problems...I can login as root with the password I've given it.
> 
> I cannot log into mysql module on Webmin
> 
> I set the administration login and password in the module config but I
> still get access denied with the same login stuff at the login screen.
> 
> It's all localhost stuff and I tried explicity setting the socket
> to /var/lib/mysql/mysql.sock but to no avail.
> 
> Hints?
----
this is frustrating...

# cat /etc/webmin/mysql/config
date_subs=0
perpage=25
stop_cmd=/etc/rc.d/init.d/mysqld stop
mysqldump=/usr/bin/mysqldump
nodbi=0
mysql_libs=
max_dbs=50
start_cmd=/etc/rc.d/init.d/mysqld start
mysql_data=/var/lib/mysql
mysqlimport=/usr/bin/mysqlimport
access=*: *
style=0
mysqlshow=/usr/bin/mysqlshow
mysql=/usr/bin/mysql
add_mode=1
passwd_mode=0
blob_mode=0
mysqladmin=/usr/bin/mysqladmin
sock=/var/lib/mysql/mysql.sock
encoding=
pass=REMOVED
port=3306
host=localhost
login=root

# mysql mysql -u root -p
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 84 to server version: 4.1.12

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

mysql> SELECT host, user, password FROM user;
+--------------------------+---------+------------------+
| host                     | user    | password         |
+--------------------------+---------+------------------+
| localhost                | root    | REMOVED          |
| srv1.despinsprinting.com | root    | REMOVED          |
| localhost                |         |                  |
|                          | root    | REMOVED          |
| localhost                | sqlgrey | REMOVED          |
| *                        | root    | REMOVED          |
| ALL                      | root    | REMOVED          |
+--------------------------+---------+------------------+
7 rows in set (0.00 sec)

mysql>

I cannot connect with webmin

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...>]

On Wed, 2005-11-16 at 09:53 -0700, Craig White wrote:
> On Wed, 2005-11-16 at 07:26 -0700, Craig White wrote:
> > Development version 1.246 - New CentOS install - mysql-
> > server-4.1.12-3.RHEL4.1
> > 
> > this probably has to do with my basic unfamiliarity with mysql
> > 
> > service mysqld start
> > 
> > mysqladmin -u root passwd "password"
> > 
> > no problems...I can login as root with the password I've given it.
> > 
> > I cannot log into mysql module on Webmin
> > 
> > I set the administration login and password in the module config but I
> > still get access denied with the same login stuff at the login screen.
> > 
> > It's all localhost stuff and I tried explicity setting the socket
> > to /var/lib/mysql/mysql.sock but to no avail.
> > 
> > Hints?
> ----
> this is frustrating...
> 
> # cat /etc/webmin/mysql/config
> date_subs=0
> perpage=25
> stop_cmd=/etc/rc.d/init.d/mysqld stop
> mysqldump=/usr/bin/mysqldump
> nodbi=0
> mysql_libs=
> max_dbs=50
> start_cmd=/etc/rc.d/init.d/mysqld start
> mysql_data=/var/lib/mysql
> mysqlimport=/usr/bin/mysqlimport
> access=*: *
> style=0
> mysqlshow=/usr/bin/mysqlshow
> mysql=/usr/bin/mysql
> add_mode=1
> passwd_mode=0
> blob_mode=0
> mysqladmin=/usr/bin/mysqladmin
> sock=/var/lib/mysql/mysql.sock
> encoding=
> pass=REMOVED
> port=3306
> host=localhost
> login=root
> 
> # mysql mysql -u root -p
> 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 84 to server version: 4.1.12
> 
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> 
> mysql> SELECT host, user, password FROM user;
> +--------------------------+---------+------------------+
> | host                     | user    | password         |
> +--------------------------+---------+------------------+
> | localhost                | root    | REMOVED          |
> | srv1.despinsprinting.com | root    | REMOVED          |
> | localhost                |         |                  |
> |                          | root    | REMOVED          |
> | localhost                | sqlgrey | REMOVED          |
> | *                        | root    | REMOVED          |
> | ALL                      | root    | REMOVED          |
> +--------------------------+---------+------------------+
> 7 rows in set (0.00 sec)
> 
> mysql>
> 
> I cannot connect with webmin
----
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


-- 
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 17/Nov/2005 16:49 Craig White wrote ..
> On Wed, 2005-11-16 at 09:53 -0700, Craig White wrote:
> > On Wed, 2005-11-16 at 07:26 -0700, Craig White wrote:
> > > Development version 1.246 - New CentOS install - mysql-
> > > server-4.1.12-3.RHEL4.1
> > > 
> > > this probably has to do with my basic unfamiliarity with mysql
> > > 
> > > service mysqld start
> > > 
> > > mysqladmin -u root passwd "password"
> > > 
> > > no problems...I can login as root with the password I've given it.
> > > 
> > > I cannot log into mysql module on Webmin
> > > 
> > > I set the administration login and password in the module config but
> I
> > > still get access denied with the same login stuff at the login screen.
> > > 
> > > It's all localhost stuff and I tried explicity stting the socket
> > > to /var/lib/mysql/mysql.sock but to no avail.
> > > 
> > > Hints?
> > ----
> > this is frustrating...
> > 
> > # cat /etc/webmin/mysql/config
> > date_subs=0
> > perpage=25
> > stop_cmd=/etc/rc.d/init.d/mysqld stop
> > mysqldump=/usr/bin/mysqldump
> > nodbi=0
> > mysql_libs=
> > max_dbs=50
> > start_cmd=/etc/rc.d/init.d/mysqld start
> > mysql_data=/var/lib/mysql
> > mysqlimport=/usr/bin/mysqlimport
> > access=*: *
> > style=0
> > mysqlshow=/usr/bin/mysqlshow
> > mysql=/usr/bin/mysql
> > add_mode=1
> > passwd_mode=0
> > blob_mode=0
> > mysqladmin=/usr/bin/mysqladmin
> > sock=/var/lib/mysql/mysql.sock
> > encoding=
> > pass=REMOVED
> > port=3306
> > host=localhost
> > login=root
> > 
> > # mysql mysql -u root -p
> > 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 84 to server version: 4.1.12
> > 
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> > 
> > mysql> SELECT host, user, password FROM user;
> > +--------------------------+---------+------------------+
> > | host                     | user    | password         |
> > +--------------------------+---------+------------------+
> > | localhost                | root    | REMOVED          |
> > | srv1.despinsprinting.com | root    | REMOVED          |
> > | localhost                |         |                  |
> > |                          | root    | REMOVED          |
> > | localhost                | sqlgrey | REMOVED          |
> > | *                        | root    | REMOVED          |
> > | ALL                      | root    | REMOVED          |
> > +--------------------------+---------+------------------+
> > 7 rows in set (0.00 sec)
> > 
> > mysql>
> > 
> > I cannot connect with webmin
> ----
> 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)

Hi Craig,
One common cause of MySQL login problems is the anonymous users. Try deleting
them in Webmin, assuming you can connect without a root password. Then try
turning the root password back on, and seeing if Webmin can login..

 - Jamie

Re: [webmin-l] mysql module

[Barry <we...@i1...>]

>--
>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...

Best,

Barry

Re: [webmin-l] mysql module

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

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..

 - Jamie

RE: [webmin-l] mysql module

[Thomas E D. <ed...@al...>]

 

> -----Original Message-----
> From: web...@li... 
> [mailto:web...@li...] On Behalf 
> Of Jamie Cameron
> Sent: Thursday, November 17, 2005 5:54 AM
> To: web...@li...
> Subject: Re: [webmin-l] mysql module
> 
> 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..
> 

I did not pay attention to this thread.  I have now found myself unable to
login the mysql module as well.  I found this out when I recently upgrade
virtualmin (free) to 2.609.  Running webmin 1.246 on a CentOS 4.2 system
with all upgrades.

What do I need to do?  :-(

TIA

Re: [webmin-l] mysql module

[Barry <we...@i1...>]

I think all the advice that was given is below. I say review the Mysql 
documentation - it will give you some guidance that aligns with Jamie's 
suggestions.

Best,

Barry

Thomas E Dukes wrote:

> 
>
>  
>
>>-----Original Message-----
>>From: web...@li... 
>>[mailto:web...@li...] On Behalf 
>>Of Jamie Cameron
>>Sent: Thursday, November 17, 2005 5:54 AM
>>To: web...@li...
>>Subject: Re: [webmin-l] mysql module
>>
>>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..
>>
>>    
>>
>
>I did not pay attention to this thread.  I have now found myself unable to
>login the mysql module as well.  I found this out when I recently upgrade
>virtualmin (free) to 2.609.  Running webmin 1.246 on a CentOS 4.2 system
>with all upgrades.
>
>What do I need to do?  :-(
>
>TIA
>
>
>
>
>-------------------------------------------------------
>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 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.