Koozali.org: home of the SME Server

SME9 and phpmyadmin

Offline waldviertler

  • ***
  • 107
  • +0/-0
SME9 and phpmyadmin
« 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

First enabled the contribs

Code: [Select]
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

Code: [Select]
/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

Code: [Select]
signal-event yum-modify
and

Code: [Select]
yum install --enablerepo=stephdl,epel smeserver-phpmyadmin.

But after that, I got this errors:

Code: [Select]
[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

guest22

Re: SME9 and phpmyadmin
« Reply #1 on: October 10, 2014, 11:05:04 PM »
First enabled the contribs

Code: [Select]
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

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #2 on: October 10, 2014, 11:33:48 PM »
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

guest22

Re: SME9 and phpmyadmin
« Reply #3 on: October 10, 2014, 11:45:31 PM »
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?

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #4 on: October 10, 2014, 11:56:09 PM »
Yes, I installed it from SME9 CD.

This is the output from yum update:

Code: [Select]
[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 ~]#

guest22

Re: SME9 and phpmyadmin
« Reply #5 on: October 10, 2014, 11:59:43 PM »
Ok, definitely a problem.

What is the output from:

db yum_repositories show

please?

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #6 on: October 11, 2014, 12:05:06 AM »
The output from db yum_repositories show:

Code: [Select]
[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!

guest22


guest22

Re: SME9 and phpmyadmin
« Reply #8 on: October 11, 2014, 12:13:33 AM »
Did you use SME Server 9.0 final release? for:

base=repository
    BaseURL=http://vault.centos.org/4.9/os/$basearch

Is completely wrong....

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #9 on: October 11, 2014, 01:04:17 AM »
I have downloaded this:

64 bit version - http://mirror.contribs.org/smeserver/releases/9/iso/x86_64/

Now after your hint
Quote
Try this: http://wiki.contribs.org/Useful_Commands#Restoring_Default_Yum_Repositories

It installs 1 Package, and upgrades 58 Packages. 114 MB.

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #10 on: October 11, 2014, 02:03:54 AM »
Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/

I get the login window over and over again.

And in the error.log are following lines:
Code: [Select]
[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?

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #11 on: October 11, 2014, 11:04:08 AM »
I have downloaded this:

64 bit version - 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
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #12 on: October 11, 2014, 11:12:51 AM »
Hmm.
Now phpmyadmin installs without any problems.
But when I login to https://myurl.com/phpmyadmin/

I get the login window over and over again.

And in the error.log are following lines:
Code: [Select]
[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 :
Code: [Select]
ll /usr/bin/pwauthand
Code: [Select]
cat /etc/group|grep apacheand
Code: [Select]
id apacheand
Code: [Select]
groups apache
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

guest22

Re: SME9 and phpmyadmin
« Reply #13 on: October 11, 2014, 01:57:58 PM »
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)

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #14 on: October 11, 2014, 06:30:15 PM »
I have installed the iso "smeserver-9.0-x86_64.iso " from 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:
Code: [Select]
[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:
Code: [Select]
[root@www e-smith]# cat /etc/group|grep apache
apache:x:48:

id apache:
Code: [Select]
[root@www e-smith]# id apache
uid=102(apache) gid=102 Gruppen=102

groups apache:
Code: [Select]
[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!!

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #15 on: October 11, 2014, 11:06:11 PM »
cat /etc/group|grep apache:
Code: [Select]
[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

Code: [Select]
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
« Last Edit: October 11, 2014, 11:10:35 PM by stephdl »
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: SME9 and phpmyadmin
« Reply #16 on: October 12, 2014, 11:22:12 AM »
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.
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #17 on: October 12, 2014, 09:27:16 PM »
Ok, I have done:

Quote
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:

Code: [Select]
[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:
Code: [Select]
groupmod -g 102 apache
Thanks
Martin

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: SME9 and phpmyadmin
« Reply #18 on: October 12, 2014, 09:38:29 PM »
Ok,

thanks for testing !!

Please follow up on the bug. Stephane has done some more work there.

We'll try and get you fixed :-)
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #19 on: October 12, 2014, 09:54:06 PM »
Can it be, that there must be "admin" as user in mysql?

I tried:
Code: [Select]
[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

guest22

Re: SME9 and phpmyadmin
« Reply #20 on: October 12, 2014, 09:57:53 PM »
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


Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #21 on: October 12, 2014, 10:20:55 PM »
Login with root-privileges work with simply "mysql".

That is ok!

Code: [Select]
[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>

guest22

Re: SME9 and phpmyadmin
« Reply #22 on: October 12, 2014, 10:24:05 PM »
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?

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #23 on: October 12, 2014, 11:00:18 PM »
I have done the same login procedure with SME8.

best regards
Martin

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #24 on: October 12, 2014, 11:56:44 PM »
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:

Code: [Select]
[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:
Code: [Select]
groupmod -g 102 apache
Thanks
Martin
please return
Code: [Select]
cat /etc/group| grep -i apache
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #25 on: October 13, 2014, 01:12:22 AM »
It returns:
Code: [Select]
[root@www ~]# cat /etc/group| grep -i apache
apache:x:102:

Offline stephdl

  • *
  • 1,519
  • +0/-0
    • Linux et Geekeries
Re: SME9 and phpmyadmin
« Reply #26 on: October 13, 2014, 07:32:07 AM »
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:

Code: [Select]
[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:
Code: [Select]
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
See http://wiki.contribs.org/Koozali_Foundation
irc : Freenode #sme_server #sme-fr

!!! Please write your knowledge to the Wiki !!!

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #27 on: October 13, 2014, 02:11:32 PM »
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.

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #28 on: October 14, 2014, 12:36:39 AM »
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
??

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #29 on: October 15, 2014, 10:03:48 PM »
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:

Code: [Select]
[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:

guest22

Re: SME9 and phpmyadmin
« Reply #30 on: October 15, 2014, 10:09:01 PM »
Code: [Select]
[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



Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #31 on: October 15, 2014, 10:22:15 PM »
No, just the same :-(

Code: [Select]
[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:

Code: [Select]
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))
 {

guest22

Re: SME9 and phpmyadmin
« Reply #32 on: October 15, 2014, 10:24:27 PM »
Please post the full events, including command given until back to prompt. Cutting of pieces makes it hard to analyze.

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #33 on: October 15, 2014, 11:06:09 PM »
Hi

In the article above the first line IS the command:
Code: [Select]
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

Offline ReetP

  • *
  • 3,722
  • +5/-0
Re: SME9 and phpmyadmin
« Reply #34 on: October 15, 2014, 11:22:16 PM »
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
...
1. Read the Manual
2. Read the Wiki
3. Don't ask for support on Unsupported versions of software
4. I have a job, wife, and kids and do this in my spare time. If you want something fixed, please help.

Bugs are easier than you think: http://wiki.contribs.org/Bugzilla_Help

If you love SME and don't want to lose it, join in: http://wiki.contribs.org/Koozali_Foundation

guest22

Re: SME9 and phpmyadmin
« Reply #35 on: October 15, 2014, 11:48:56 PM »
Agree, let's see if any dev can assist.

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #36 on: October 16, 2014, 01:38:53 AM »
Ok, now I know how the patches will work.
I'll try it tomorrow.

Thanks
Martin

Offline waldviertler

  • ***
  • 107
  • +0/-0
Re: SME9 and phpmyadmin
« Reply #37 on: October 17, 2014, 02:01:16 AM »
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
Code: [Select]
-rwsr-x--- 1 root apache 6872  5. Jun 2013  /usr/bin/pwauth
cat /etc/group|grep apache
Code: [Select]
apache:x:102:
id apache
Code: [Select]
uid=48(apache) gid=102(apache) Gruppen=102(apache)
groups apache
Code: [Select]
apache : apache


Then I tried to install phpmyadmin.
Same Error as before:

Code: [Select]
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
phpmyadmin installs without any error.

But it is not possible to login to 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