Koozali.org: home of the SME Server

Obsolete Releases => SME 7.x Contribs => Topic started by: MasterSleepy on July 03, 2006, 08:31:03 AM

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: MasterSleepy on July 03, 2006, 08:31:03 AM

Hello all,

Following a thead on a french forum, I update phpmyadmin version used in multiuser contribs. Now it used version 2.8.2 of phpmyadmin.
There is some big change in install script of this new rpms, so it's better to uninstall older before.

smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm (http://www.vanhees.cc/modules.php?op=modload&name=CmodsDownload&file=index&req=viewdownloaddetails&lid=296&ttitle=smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm)
smeserver-phpmyadmin-multiuser-2.1-1.src.rpm (http://www.vanhees.cc/modules.php?op=modload&name=CmodsDownload&file=index&req=viewdownloaddetails&lid=297&ttitle=smeserver-phpmyadmin-multiuser-2.1-1.src.rpm)

Regards.

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: mytime on July 08, 2006, 02:31:37 PM

Hi MasterSleepy,

Works Great,

I just installed it!

Mytime

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: arnoldob on July 11, 2006, 08:24:42 PM

Thanks for the great contrib to the SME community. I noticed a there was a message to change the default password at the end of the install. Where is the password changed?

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: MasterSleepy on July 12, 2006, 10:12:58 AM

Hello,

It's admin password for mysql, so you can use phpmyadmin to change it in privileges option on the first page.

Regards.

Title: ARGH!! Deleted the Admin users priviliges!!!!
Post by: zach_flem on July 14, 2006, 02:50:26 AM

hi there,
i tried to change the admin password and have somehow deleted the privileges for the admin user.

how do i got about getting these privileges back?

is it as simple as re-installing phpmyadmin-multiuser??

feedback is appreciated!

Cheers

Zach Fleming

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: MasterSleepy on July 14, 2006, 08:25:13 AM

Hello,

normally by removing and reinstalling after should solve your problem.
Otherwise you can try the following command at root prompt :

Code: [Select]

 mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
  mysql --execute="flush privileges"


Regards.

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: Teviot on August 27, 2006, 08:22:48 AM

Hi All

Have just installed this contrib after uninstalling the contrib by DMay.

I have the following error and don't kknow where to go to fix this.

Quote

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

Can anyone help?

Regard
Teviot

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: jmripert on October 09, 2006, 03:02:38 PM

Hi,

For configuring your phpmyadmin from a simple user archive to a cookie authentification (without download, go directly at the second point), do that :


1/ install
If you have downloaded the archive : rpm -Uvh smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm

or

rpm -Uvh http://mirror.contribs.org/smeserver/contribs/dmay/smeserver/7.x/smeserver-phpmyadmin-2.6.4-pl4.dmay.noarch.rpm


2/ configure apache (dialog box)
- copy /etc/e-smith/templates/etc/httpd/conf/httpd.conf/86PhpmyadminAlias in /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
- edit /etc/e-smith/templates-custom/etc/httpd/conf/httpd.conf/86PhpmyadminAlias
- comments require user

3/ configure phpmyadmin (access to mysql)
- copy /etc/e-smith/templates/opt/phpmyadmin/config.inc.php/10config in /etc/e-smith/templates-custom/opt/phpmyadmin/config.inc.php/10config
- édit /etc/e-smith/templates-custom/opt/phpmyadmin/config.inc.php/10config
- insert in blowfish_secret a continuation of character capital and/or tiny letter and number (46 max)
- modify in auth_type http by cookie
- delete the information in Servers’user’ and Servers’password’

You have now a page with a demand of login and password, user is in mysql with the right order...

Title: Re: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: MasterSleepy on October 09, 2006, 05:20:55 PM

Hello,

That's exactly what smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm (http://www.vanhees.cc/modules.php?op=modload&name=CmodsDownload&file=index&req=viewdownloaddetails&lid=296&ttitle=smeserver-phpmyadmin-multiuser-2.1-1.noarch.rpm) made.
Without manual change, of course ;-)

Regards.

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: chrislaurie on October 09, 2006, 10:30:58 PM

I am also having the admin password problem described earlier by teviot. The install ran fine and when I need to logon it shows user admin but the admin password does not work I keep getting this error message:

Code: [Select]

#1045 - Access denied for user 'admin'@'localhost' (using password: YES)

What am I doing wrong?

Cheers

Chris

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: william_syd on October 10, 2006, 03:14:56 AM

Which admin password are you using?

Linux or MySQL ?

Title: [ANNOUNCE] phpmyadmin-multiuser for sme server 7
Post by: MasterSleepy on October 10, 2006, 09:00:05 AM

Hello,

If you have problem with password, you can reinitialised it.

You have to been connected as root at command line and type the following command:

Code: [Select]

mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' with grant option"
mysql --execute="flush privileges"

After that command you can log with
login : admin
password : admin

Regards.