Koozali.org: home of the SME Server

Obsolete Releases => SME Server 9.x => Topic started by: AusMounty on March 23, 2014, 11:01:00 PM

Title: smeserver-phpmyadmin
Post by: AusMounty on March 23, 2014, 11:01:00 PM
Hello all,
I have been wondering if anyone has had any luck installing smeserver-phpmyadmin on release 9b3? I have been trying to find someone who has it successfully running and if so, provide a HOWTO.

I have a couple of CMS packages which require MySQL and the easiest method for creating the database is via the web-interface.

Any assistance would be appreciated.

Regards,
David
(aka AusMounty)
Title: Re: smeserver-phpmyadmin
Post by: janet on March 24, 2014, 04:21:50 AM
AusMounty

Did you try installing it following this wiki article
http://wiki.contribs.org/PHPMyAdmin

You will have to setup a smecontribs-8 repo on your sme 9 server which points at the sme8 smecontribs repo location, & refer to that when installing phpmyadmin

eg
yum --enablerepo=smecontribs-8 install smeserver-phpmyadmin
etc etc

Let us know how you go & we can look at any issues you come across.

IMO it will probably work OK.
Many sme8 contribs will work on sme9 OK.

Edit: Based on advice from stephdl, contribs with server manger panels will not work correctly.
Back to testing.
Title: Re: smeserver-phpmyadmin
Post by: stephdl on March 24, 2014, 08:48:46 PM
Quote from: janet on March 24, 2014, 04:21:50 AM
Many sme8 contribs will work on sme9 OK.

Just for your informations janet, contribs which have a panel in the server-manager can't work on sme9 mainly because the path to the perl library is not good.

For sme8
/usr/lib/perl5/site_perl/esmith/FormMagick/Panel/

For sme9
/usr/share/perl5/vendor_perl/esmith/FormMagick/Panel/

The file.pm of the contribs (raidstatus.pm for example) has to be moved to the new destination in sme9
Title: Re: smeserver-phpmyadmin
Post by: janet on March 24, 2014, 09:08:26 PM
stephdl

Thanks, lesson learnt.
Title: Re: smeserver-phpmyadmin
Post by: janet on March 24, 2014, 10:02:16 PM
I tried installing phpmyadmin from sme8 smecontribs repo but get dependency errors.

Can anyone advise what repo has the required dependencies
ie
php53-mbstring
php53-mysql
php53-gd
php53
php53-common

Here is the install log:
yum install --enablerepo=smecontribs-8 smeserver-phpmyadmin           

Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:3.5.2.2-6.el5.sme will be installed
--> Processing Dependency: phpMyAdmin3 >= 3.5.2.2 for package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch
--> Running transaction check
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-php-gettext for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mcrypt for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Running transaction check
---> Package php53-mcrypt.i386 0:5.3.3-1.el5 will be installed
--> Processing Dependency: libmcrypt.so.4 for package: php53-mcrypt-5.3.3-1.el5.i386
---> Package php53-php-gettext.noarch 0:1.0.11-3.el5 will be installed
--> Processing Dependency: php53-mbstring for package: php53-php-gettext-1.0.11-3.el5.noarch
--> Processing Dependency: php53-common for package: php53-php-gettext-1.0.11-3.el5.noarch
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Running transaction check
---> Package libmcrypt.i386 0:2.5.8-4.el5.centos will be installed
---> Package php53-php-gettext.noarch 0:1.0.11-3.el5 will be installed
--> Processing Dependency: php53-mbstring for package: php53-php-gettext-1.0.11-3.el5.noarch
--> Processing Dependency: php53-common for package: php53-php-gettext-1.0.11-3.el5.noarch
---> Package phpMyAdmin3.noarch 0:3.5.8.1-1.el5 will be installed
--> Processing Dependency: php53-mysql for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-mbstring for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53-gd for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Processing Dependency: php53 for package: phpMyAdmin3-3.5.8.1-1.el5.noarch
--> Finished Dependency Resolution
Error: Package: php53-php-gettext-1.0.11-3.el5.noarch (smecontribs-8)
           Requires: php53-mbstring
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-mbstring
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-mysql
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53-gd
Error: Package: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
           Requires: php53
Error: Package: php53-php-gettext-1.0.11-3.el5.noarch (smecontribs-8)
           Requires: php53-common
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest
Title: Re: smeserver-phpmyadmin
Post by: janet on March 24, 2014, 10:07:21 PM
Then I added the remi repo & get the following
Can anybody suggest what's going on here.
Does it suggest that smeserver-phpmyadmin should be rewritten to use phpMyAdmin rather than phpMyAdmin3, & should these changes go into the sme repos.


/sbin/e-smith/db yum_repositories set remi repository \
> Name 'Remi - EL6' \
> BaseURL 'http://rpms.famillecollet.com/enterprise/6/remi/$basearch/' \
> EnableGroups no \
> GPGCheck yes \
> GPGKey http://rpms.famillecollet.com/RPM-GPG-KEY-remi \
> Visible no \
> status disabled

signal-event yum-modify

yum install --enablerepo=smecontribs-8 --enablerepo=remi smeserver-phpmyadmin

Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:3.5.2.2-6.el5.sme will be installed
--> Processing Dependency: phpMyAdmin3 >= 3.5.2.2 for package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch
Package phpMyAdmin3 is obsoleted by phpMyAdmin, but obsoleting package does not provide for requirements
--> Finished Dependency Resolution
Error: Package: smeserver-phpmyadmin-3.5.2.2-6.el5.sme.noarch (smecontribs-8)
           Requires: phpMyAdmin3 >= 3.5.2.2
           Available: phpMyAdmin3-3.5.8.1-1.el5.noarch (smecontribs-8)
               phpMyAdmin3 = 3.5.8.1-1.el5
 You could try using --skip-broken to work around the problem
 You could try running: rpm -Va --nofiles --nodigest



Title: Re: smeserver-phpmyadmin
Post by: janet on March 27, 2014, 07:03:37 AM
AusMounty

Until a suitable contrib package is available, you can manually install using generic instructions from
http://www.phpmyadmin.net/home_page/index.php

Just check which version is compatible with your sme OS & other pkgs eg php & mysql versions.
Title: Re: smeserver-phpmyadmin
Post by: Xavier.A on March 28, 2014, 12:18:49 PM
@AusMounty
or if you could install SME, may-be you could try to learn SQL   :P
and may-be you should try to use professionnal tools :
Debian
Code: [Select]
sudo apt-get install mysql-workbenchCentOS
Code: [Select]
yum install mysql-workbench
but may-be it's easier to try to install phpmyadmin  :lol:
Title: Re: smeserver-phpmyadmin
Post by: janet on March 29, 2014, 06:13:16 AM
kid_of_leognan

Quote
CentOS
yum install mysql-workbench

That will not & does not work as the default repos do not contain that pkg.
You must also specify a suitable repo (reponame), & have that repo configured on your sme server eg
yum install mysql-workbench --enablerepo=reponame
Title: Re: smeserver-phpmyadmin
Post by: magwm on May 19, 2014, 12:33:17 PM
I am seeing the same problems trying to install phpmyadmin.

entered bug http://bugs.contribs.org/show_bug.cgi?id=8387
Title: Re: smeserver-phpmyadmin
Post by: stephdl on May 19, 2014, 01:02:01 PM
I will take a look...on your bug report.
You are welcome to test and report all contribs for sme9....we need a lot of testers....
Title: Re: smeserver-phpmyadmin
Post by: Stefano on May 19, 2014, 02:20:35 PM
Quote from: kid_of_leognan on March 28, 2014, 12:18:49 PM
@AusMounty
or if you could install SME, may-be you could try to learn SQL   :-P
  • https://en.wikipedia.org/wiki/SQL (https://en.wikipedia.org/wiki/SQL)
  • https://en.wikipedia.org/wiki/MySQL (https://en.wikipedia.org/wiki/MySQL)
  • https://en.wikipedia.org/wiki/MariaDB (https://en.wikipedia.org/wiki/MariaDB)
and may-be you should try to use professionnal tools :
  • https://en.wikipedia.org/wiki/MySQL_Workbench (https://en.wikipedia.org/wiki/MySQL_Workbench)
  • http://mysqlworkbench.org/ (http://mysqlworkbench.org/)
  • http://blog.famillecollet.com/en?q=mysql-workbench (http://blog.famillecollet.com/en?q=mysql-workbench)
Debian
Code: [Select]
sudo apt-get install mysql-workbenchCentOS
Code: [Select]
yum install mysql-workbench
but may-be it's easier to try to install phpmyadmin  :lol:

mysql-workbench will not work without a G.U.I... so it will be unusable on SME
Title: Re: smeserver-phpmyadmin
Post by: stephdl on May 19, 2014, 07:25:39 PM
Quote from: magwm on May 19, 2014, 12:33:17 PM
I am seeing the same problems trying to install phpmyadmin.

entered bug http://bugs.contribs.org/show_bug.cgi?id=8387
please report to bugzilla, a new version of smeserver-phpmyadmin is waiting you