Koozali.org: home of the SME Server
Obsolete Releases => SME 9.x Contribs => Topic started by: waldviertler on October 10, 2014, 10:12:27 PM
-
Hi
I would like to install "phpmyadmin" and so I followed this instruction:
http://wiki.contribs.org/PHPMyAdmin#tab=For_SME9 (http://wiki.contribs.org/PHPMyAdmin#tab=For_SME9)
First enabled the contribs
db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled
and
/sbin/e-smith/db yum_repositories set epel repository \
Name 'Epel - EL6' \
BaseUrl 'http://download.fedoraproject.org/pub/epel/6/$basearch' \
MirrorList 'http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch' \
EnableGroups no \
GPGCheck yes \
GPGKey http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL \
Visible no \
status disabled
then
signal-event yum-modify
and
yum install --enablerepo=stephdl,epel smeserver-phpmyadmin.
But after that, I got this errors:
[root@www httpd]# yum install --enablerepo=stephdl,epel smeserver-phpmyadmin
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
* epel: fedora.aau.at
* smeaddons: mirror.absolutnet.de
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package smeserver-phpmyadmin.noarch 0:4.0.10.2-2.el6.sme will be installed
--> Processing Dependency: phpMyAdmin >= 4.0.10.1 for package: smeserver-phpmyadmin-4.0.10.2-2.el6.sme.noarch
--> Running transaction check
---> Package phpMyAdmin.noarch 0:4.0.10.4-1.el6 will be installed
--> Processing Dependency: php-mcrypt >= 5.2.0 for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-tcpdf-dejavu-sans-fonts for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-tcpdf for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Processing Dependency: php-php-gettext for package: phpMyAdmin-4.0.10.4-1.el6.noarch
--> Running transaction check
---> Package php-mcrypt.x86_64 0:5.3.3-3.el6 will be installed
--> Processing Dependency: libmcrypt.so.4()(64bit) for package: php-mcrypt-5.3.3-3.el6.x86_64
---> Package php-php-gettext.noarch 0:1.0.11-3.el6 will be installed
---> Package php-tcpdf.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: php-tidy for package: php-tcpdf-6.0.091-1.el6.noarch
--> Processing Dependency: php-bcmath for package: php-tcpdf-6.0.091-1.el6.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: dejavu-sans-fonts for package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch
--> Running transaction check
---> Package libmcrypt.x86_64 0:2.5.8-9.el6 will be installed
---> Package php-tcpdf.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: php-tidy for package: php-tcpdf-6.0.091-1.el6.noarch
--> Processing Dependency: php-bcmath for package: php-tcpdf-6.0.091-1.el6.noarch
---> Package php-tcpdf-dejavu-sans-fonts.noarch 0:6.0.091-1.el6 will be installed
--> Processing Dependency: dejavu-sans-fonts for package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch
--> Finished Dependency Resolution
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
Requires: php-tidy
Error: Package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch (epel)
Requires: dejavu-sans-fonts
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
Requires: php-bcmath
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
[root@www httpd]#
Any help appreciated!!
Thanks!
Martin
-
First enabled the contribs
db yum_repositories set stephdl repository \
BaseURL http://mirror.de-labrusse.fr/smeserver/\$releasever \
EnableGroups no GPGCheck yes \
Name "Mirror de Labrusse" \
GPGKey http://mirror.de-labrusse.fr/RPM-GPG-KEY \
Visible yes status disabled
Hi Martin,
For sanity sake the mentioned 'contribs' repo should be the stephdl repo.
I just checked, the php-tidy rpm is definitely in the epel repo (yum install php-tidy --enablerepo=epel)
That said, PHP had some serious upgrades last week. Did you do a yum update before you applied the how-to? Things may have changed.
I guess we have to wait a bit for the author and other phpmyadmin guru's are in a different TZ then yours.
guest
-
Thanks for your help!
That is what I've done:
I've installed SME9 freshly today.
After that, I tried yum update, but no "No Packages marked for Update".
Then I tried to install phpmyadmin.
Best regards
Martin
-
Then something is wrong. If you've installed from the SME9 CD, then there should be many updates form several official repo's when you perform a 'yum update'.
I guess about 200Mb. Can you post the output from 'yum update' through 'no packages to update' ?
So why is yum not seeing any new updates would be the question.
Anything in the logs?
-
Yes, I installed it from SME9 CD.
This is the output from yum update:
[root@www ~]# yum update
Loaded plugins: fastestmirror, smeserver
Loading mirror speeds from cached hostfile
* smeaddons: mirror.absolutnet.de
Setting up Update Process
No Packages marked for Update
[root@www ~]#
-
Ok, definitely a problem.
What is the output from:
db yum_repositories show
please?
-
The output from db yum_repositories show:
[root@www ~]# db yum_repositories show
base=repository
BaseURL=http://vault.centos.org/4.9/os/$basearch
EnableGroups=no
Exclude=initscripts,libgsf
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=os
Name=CentOS - os
Visible=yes
status=disabled
centosplus=repository
BaseURL=http://vault.centos.org/4.9/centosplus/$basearch
EnableGroups=no
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=centosplus
Name=CentOS - centosplus
Visible=no
status=disabled
contrib=repository
BaseURL=http://vault.centos.org/4.9/contrib/$basearch
EnableGroups=no
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=contrib
Name=CentOS - contrib
Visible=no
status=disabled
epel=repository
BaseUrl=http://download.fedoraproject.org/pub/epel/6/$basearch
EnableGroups=no
GPGCheck=yes
GPGKey=http://dl.fedoraproject.org/pub/epel/RPM-GPG-KEY-EPEL
MirrorList=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-6&arch=$basearch
Name=Epel - EL6
Visible=no
status=disabled
extras=repository
BaseURL=http://vault.centos.org/4.9/extras/$basearch
EnableGroups=no
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=extras
Name=CentOS - extras
Visible=no
status=disabled
fasttrack=repository
EnableGroups=no
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=fasttrack
Name=CentOS - fasttrack
Visible=no
status=disabled
fws=repository
BaseURL=http://repo.firewall-services.com/centos/$releasever
EnableGroups=no
GPGCheck=yes
GPGKey=http://repo.firewall-services.com/RPM-GPG-KEY
Name=Firewall Services
Visible=yes
status=disabled
smeaddons=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeaddons-9
Name=SME Server - addons
Visible=yes
status=enabled
smecontribs=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smecontribs-9
Name=SME Server - contribs
Visible=no
status=disabled
smedev=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smedev-9
Name=SME Server - dev
Visible=no
status=disabled
smeextras=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeextras-9
Name=SME Server - extras
Visible=yes
status=disabled
smeos=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeos-9
Name=SME Server - os
Visible=yes
status=disabled
smetest=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smetest-9
Name=SME Server - test
Visible=no
status=disabled
smeupdates=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeupdates-9
Name=SME Server - updates
Visible=yes
status=disabled
smeupdates-testing=repository
EnableGroups=yes
GPGCheck=yes
MirrorList=http://mirrorlist.contribs.org/mirrorlist/smeupdates-testing-9
Name=SME Server - updates testing
Visible=yes
status=disabled
stephdl=repository
BaseURL=http://mirror.de-labrusse.fr/smeserver/$releasever
EnableGroups=no
GPGCheck=yes
GPGKey=http://mirror.de-labrusse.fr/RPM-GPG-KEY
Name=Mirror de Labrusse
Visible=yes
status=disabled
testing=repository
BaseURL=http://mirror.centos.org/centos/4/testing/$basearch
EnableGroups=no
GPGCheck=yes
Name=CentOS - testing
Visible=no
status=disabled
updates=repository
BaseURL=http://vault.centos.org/4.9/updates/$basearch
EnableGroups=no
Exclude=initscripts,libgsf
GPGCheck=yes
MirrorList=http://mirrorlist.centos.org/?release=$releasever&arch=$basearch&repo=updates
Name=CentOS - updates
Visible=yes
status=disabled
[root@www ~]#
Thanks!
-
Try this: http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories
-
Did you use SME Server 9.0 final release? for:
base=repository
BaseURL=http://vault.centos.org/4.9/os/$basearch
Is completely wrong....
-
I have downloaded this:
64 bit version - http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/ (http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/)
Now after your hint
Try this: http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories
It installs 1 Package, and upgrades 58 Packages. 114 MB.
-
Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/ (https://myurl.com/phpmyadmin/)
I get the login window over and over again.
And in the error.log are following lines:
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
So I changed the System-Admin Password and tried it again.
But no success.
Should I start from the scratch?
-
I have downloaded this:
64 bit version - http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/ (http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/)
Now after your hint
It installs 1 Package, and upgrades 58 Packages. 114 MB.
I cannot reproduce, I have downloaded an iso of sme964 and my repositories are correctly settled, do other takers can try
-
Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/ (https://myurl.com/phpmyadmin/)
I get the login window over and over again.
And in the error.log are following lines:
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sat Oct 11 01:21:27 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
So I changed the System-Admin Password and tried it again.
But no success.
Should I start from the scratch?
what about :
ll /usr/bin/pwauthand
cat /etc/group|grep apacheand
id apacheand
groups apache
-
Now after your hint
It installs 1 Package, and upgrades 58 Packages. 114 MB.
So what could be the root cause of the fact that your default repo's were replaced?
My best guess would be that you installed an old contrib not suited for SME9. Could that be?
guest
(typo)
-
I have installed the iso "smeserver-9.0-x86_64.iso " from http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/ (http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/).
Then I restored my usb-backup from my 8.0 Server.
ll /usr/bin/pwauth:
[root@www e-smith]# ll /usr/bin/pwauth
-rwsr-x--- 1 root root 11032 5. Jun 2013 /usr/bin/pwauth
cat /etc/group|grep apache:
[root@www e-smith]# cat /etc/group|grep apache
apache:x:48:
id apache:
[root@www e-smith]# id apache
uid=102(apache) gid=102 Gruppen=102
groups apache:
[root@www e-smith]# groups apache
apache : groups: Es ist kein Name zur GruppenâID 102 zu finden
102
Uid=102 seems wrong!?
This could be a result from my usb-backup?
Thanks, I will donate!!
-
cat /etc/group|grep apache:
[root@www e-smith]# cat /etc/group|grep apache
apache:x:48:
Okay you have the bug 8549 : http://bugs.contribs.org/show_bug.cgi?id=8549
That's not a good new even if the way to solve it is easy., we need to find a solution to solve definitively the problem. However I understand better your first issue with the db yum repository since it comes from your usb-backup....quite surely
To answer to your question the correct uid for apache is 102
so please do
groupmod -g 102 apache
You should solve your issue and allow the admin login, please verify the correct password
EDIT: you are welcome to support financially the sme server
-
Not 100% sure but have a look at this
http://bugs.contribs.org/show_bug.cgi?id=8549
Install a clean v9, update, patch and then restore.
Please let us know what happens.
-
Ok, I have done:
Install a clean v9, update, patch and then restore.
I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
Even when I try:
groupmod -g 102 apache
Thanks
Martin
-
Ok,
thanks for testing !!
Please follow up on the bug. Stephane has done some more work there.
We'll try and get you fixed :-)
-
Can it be, that there must be "admin" as user in mysql?
I tried:
[root@www etc]# mysql -uadmin -pmypassword
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
Not sure, but I think that is not ok.
But I have the same password on SME8 as on the new SME9.
Thanks again.
Martin
-
Hi Martin,
good question, please read the SME Server specifics on how MySQL is being managed.
http://wiki.contribs.org/MySQL#MySQL_root_password
guest
-
Login with root-privileges work with simply "mysql".
That is ok!
[root@www ~]# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 307
Server version: 5.1.73 Source distribution
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> GRANT SELECT ON test.* TO 'admin'@'host' IDENTIFIED BY 'mypassword';
Query OK, 0 rows affected (0.00 sec)
mysql>
-
Login with root-privileges work with simply "mysql".
That is ok!
AFAIK there is not other user. Per created database user/users have to be granted privileges. But that user has to be specifically granted access by any webapp.
Maybe your expectations of an admin user are the 'root' user?
-
I have done the same login procedure with SME8.
best regards
Martin
-
Ok, I have done:
I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
Even when I try:
groupmod -g 102 apache
Thanks
Martin
please return
cat /etc/group| grep -i apache
-
It returns:
[root@www ~]# cat /etc/group| grep -i apache
apache:x:102:
-
Ok, I have done:
I got the same result, as the last time.
After the restore and the installation of phpmyadmin, no phpmyadmin logon possible:
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] AuthExtern pwauth [/usr/bin/pwauth]: Failed (255) for user admin
[Sun Oct 12 21:20:42 2014] [error] [client 192.168.1.48] user admin: authentication failure for "/phpmyadmin/": Password Mismatch
Even when I try:
groupmod -g 102 apache
Thanks
Martin
well not sure that the patch could work since it lacks some dependencies, how did you patch, what was the output of the terminal during the patch
-
I will try it tonight again. I don't know the output anymore.
Shall I use both patches:
e-smith-backup apache group patch
and
patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts?
I have done only the "e-smith-backup apache group patch ".
I made a file patch.sh copied the patch into it - chmod 775- and started it.
-
It looks that my way to patch does not work.
How is the correct way to patch the system with
e-smith-backup apache group patch
and
patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
??
-
Ok, I think I figured it out!
patch "e-smith-backup apache group patch" runs without any message.
patch "patch to e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts"
stopps with following message:
[root@www tmp]# patch -p2 <patch2.pm
can't find file to patch at input line 4
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|diff -Nur e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
|--- e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts 2014-10-12 16:28:02.872982921 +0200
|+++ e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts 2014-10-12 17:18:58.748369354 +0200
--------------------------
File to patch:
-
[root@www tmp]# patch -p2 <patch2.pm
can't find file to patch at input line 4
Perhaps you used the wrong -p or --strip option?
Maybe adding a space helps? 'patch -p2 < patch2.pm'
Please read the patch man, it will tell you how to test a patch before really applying it.
Good to see you've figured out 'patch'
guest
-
No, just the same :-(
[root@www tmp]# patch -p2 < patch2.pm
can't find file to patch at input line 4
Perhaps you used the wrong -p or --strip option?
The text leading up to this was:
--------------------------
|diff -Nur e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
|--- e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts 2014-10-12 16:28:02.872982921 +0200
|+++ e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts 2014-10-12 17:18:58.748369354 +0200
--------------------------
File to patch:
The patchfile contains:
diff -Nur e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts
--- e-smith-base-5.6.0.old/root/etc/e-smith/events/actions/init-accounts 2014-10-12 16:28:02.872982921 +0200
+++ e-smith-base-5.6.0/root/etc/e-smith/events/actions/init-accounts 2014-10-12 17:18:58.748369354 +0200
@@ -41,6 +41,17 @@
system("/bin/rpm --setugids --setperms httpd mod_auth_tkt mod_ssl php pwauth 2> /dev/null") == 0
);
+# set the correct 102 GID to apache group if doesn't exist or wrong settled
+ my $apachegidtest = getgrnam("apache");
+ if ( ! getgrnam("apache"))
+ {
+ system(qw(/usr/sbin/groupadd -g 102 -r -o -f apache));
+ }
+ elsif ( $apachegidtest != '102' )
+ {
+ system('/usr/sbin/groupmod -o -g 102 apache');
+ }
+
# delete unwanted user accounts
foreach my $user (qw(halt shutdown sync))
{
-
Please post the full events, including command given until back to prompt. Cutting of pieces makes it hard to analyze.
-
Hi
In the article above the first line IS the command:
patch -p2 < patch2.pm!
Then you find the output from the patch.
After that I wrote the content of the patch.
It stops after "File to patch".
I had to cancel it witch CTRL-X.
Do you need some other informations?
Thanks.
Martin
-
Martin,
I can't help as I am in Germany right now. Stephane will undoubtedly come back to you.
Best place to follow up is on the bug as other devs may be able to help you - not all of them read here !!
B. Rgds
John
-
Agree, let's see if any dev can assist.
-
Ok, now I know how the patches will work.
I'll try it tomorrow.
Thanks
Martin
-
Ok, I tried tonight the fresh install - update - patch - restore procedure.
Everything runs fine, also the two patches.
But after the restore, it is not possible to logon with the /server-manager
And when I try to login at the server console with the "admin" user to get the server options, it jumps back to "login:"
ll /usr/bin/pwauth
-rwsr-x--- 1 root apache 6872 5. Jun 2013 /usr/bin/pwauth
cat /etc/group|grep apache
apache:x:102:
id apache
uid=48(apache) gid=102(apache) Gruppen=102(apache)
groups apache
apache : apache
Then I tried to install phpmyadmin.
Same Error as before:
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
Requires: php-tidy
Error: Package: php-tcpdf-dejavu-sans-fonts-6.0.091-1.el6.noarch (epel)
Requires: dejavu-sans-fonts
Error: Package: php-tcpdf-6.0.091-1.el6.noarch (epel)
Requires: php-bcmath
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
But after restoring default yum repositories http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories (http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories)
phpmyadmin installs without any error.
But it is not possible to login to myserver/phpmyadmin/ (http://myserver/phpmyadmin/)
So, in short, same as before :-((
When I chown /usr/bin/pwauth from root apache to root www - it is possible to login with the server-manager!
Please, please help me.
best regards
Martin