MRatWork Forum by Mustafa Ramadhan

Sawo Project - Kloxo-MR Discussions => Kloxo-MR Bugs and Requests => Topic started by: Joe on 2014-04-26, 06:28:53

Title: Can't Delete SSL Certificate
Post by: Joe on 2014-04-26, 06:28:53
My SSL Certificate has expired so I need to delete and add a new one. I've deleted it through the control panel and it shows as deleted but the old certificate remains when accessing the web site. I've ran sh /script/cleanup.

Kloxo-MR 6.5.1.b-2014042401
Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-26, 07:07:46
There are still something wrong related to SSL certificate. For your issue, try add ssl certificate and then assign it again to IP and domain.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-26, 07:10:47
That's the other thing I noticed. There is no longer an option to assign to ip address just the domain? There use to be an option to assign the IP here admin — IP Addresses — {SSL Configuration}. Maybe I'm not remembering correctly? I did assign it to the domain though and same issue. Any other suggestions or when this issue will be resolved?
Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-26, 10:48:32
Still exists if enter ssl certificate in 'admin' (remember not in each domain).
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-26, 16:26:27
Yes it still exists under admin. That's what I've been using.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 05:04:43
I've tried deleting it a few times and sometimes this error shows when going to the SSL certificate settings page in Kloxo MR to select delete certificate.

"Post token not match or using get instead post"

Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-27, 05:30:42
Try update your Kloxo-MR and don't forget running cleanup.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 05:33:30
I just tried running yum update and there are dependency problems. How do I resolve?

Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: centos.mirror.ndchost.com
 * extras: mirror-centos.hostingswift.com
 * mratwork-epel: dl.fedoraproject.org
 * mratwork-ius: mirror.symnds.com
 * updates: mirror.nwresd.org
Excluding Packages from MRatWork - centalt - arch
Finished
Excluding Packages from MRatWork - Extra Packages for EL 5 - arch
Finished
Excluding Packages from MRatWork - IUS Community Packages for EL 5 - arch
Finished
0 packages excluded due to repository protections
Setting up Update Process
Resolving Dependencies
--> Running transaction check
---> Package hiawatha.i386 0:9.5-2.mr.el6 set to be updated
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.18) for package: hiawatha
--> Processing Dependency: libxslt.so.1(LIBXML2_1.0.11) for package: hiawatha
--> Processing Dependency: libc.so.6(GLIBC_2.7) for package: hiawatha
--> Finished Dependency Resolution
hiawatha-9.5-2.mr.el6.i386 from mratwork-release-version-arch has depsolving pro
blems
  --> Missing Dependency: libc.so.6(GLIBC_2.7) is needed by package hiawatha-9.5
-2.mr.el6.i386 (mratwork-release-version-arch)
hiawatha-9.5-2.mr.el6.i386 from mratwork-release-version-arch has depsolving pro
blems
  --> Missing Dependency: libxslt.so.1(LIBXML2_1.0.18) is needed by package hiaw
atha-9.5-2.mr.el6.i386 (mratwork-release-version-arch)
hiawatha-9.5-2.mr.el6.i386 from mratwork-release-version-arch has depsolving pro
blems
  --> Missing Dependency: libxslt.so.1(LIBXML2_1.0.11) is needed by package hiaw
atha-9.5-2.mr.el6.i386 (mratwork-release-version-arch)
Error: Missing Dependency: libc.so.6(GLIBC_2.7) is needed by package hiawatha-9.
5-2.mr.el6.i386 (mratwork-release-version-arch)
Error: Missing Dependency: libxslt.so.1(LIBXML2_1.0.11) is needed by package hia
watha-9.5-2.mr.el6.i386 (mratwork-release-version-arch)
Error: Missing Dependency: libxslt.so.1(LIBXML2_1.0.18) is needed by package hia
watha-9.5-2.mr.el6.i386 (mratwork-release-version-arch)
 You could try using --skip-broken to work around the problem
 You could try running: package-cleanup --problems
                        package-cleanup --dupes
                        rpm -Va --nofiles --nodigest
Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-27, 06:24:32
Inform here 'yum list installed php*' and 'php -m'.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 06:34:16

Loaded plugins: fastestmirror, priorities, protectbase, replace
Loading mirror speeds from cached hostfile
 * base: mirror.stanford.edu
 * extras: yum.phx.singlehop.com
 * mratwork-epel: dl.fedoraproject.org
 * mratwork-ius: dl.iuscommunity.org
 * updates: mirrordenver.fdcservers.net
Excluding Packages from MRatWork - centalt - arch
Finished
Excluding Packages from MRatWork - Extra Packages for EL 5 - arch
Finished
Excluding Packages from MRatWork - IUS Community Packages for EL 5 - arch
Finished
0 packages excluded due to repository protections
Installed Packages
php.i386                            5.1.6-44.el5_10                    installed
php-bcmath.i386                     5.1.6-44.el5_10                    installed
php-cli.i386                        5.1.6-44.el5_10                    installed
php-common.i386                     5.1.6-44.el5_10                    installed
php-devel.i386                      5.1.6-44.el5_10                    installed
php-gd.i386                         5.1.6-44.el5_10                    installed
php-mbstring.i386                   5.1.6-44.el5_10                    installed
php-mcrypt.i386                     5.1.6-15.el5.centos.1              installed
php-mysql.i386                      5.1.6-44.el5_10                    installed
php-pdo.i386                        5.1.6-44.el5_10                    installed
php-pear.noarch                     1:1.4.9-8.el5                      installed
php-pecl-geoip.i386                 1.0.8-3.el5                        installed
php-pgsql.i386                      5.1.6-44.el5_10                    installed
php-xml.i386                        5.1.6-44.el5_10                    installed
php52s.i386                         5.2.17-12.mr.el5                   installed
php54-pecl-imagick.i386             3.1.2-1.ius.el5                    installed



[PHP Modules]
bcmath
bz2
calendar
ctype
curl
date
dbase
dom
exif
ftp
gd
geoip
gettext
gmp
hash
iconv
libxml
mbstring
mcrypt
mime_magic
mysql
mysqli
openssl
pcntl
pcre
PDO
pdo_mysql
pdo_pgsql
pdo_sqlite
pgsql
posix
pspell
Reflection
session
shmop
SimpleXML
sockets
SPL
standard
sysvmsg
sysvsem
sysvshm
tokenizer
wddx
xml
xmlreader
xmlwriter
xsl
zlib

[Zend Modules]
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 06:35:10
php 5.1.6 is the only version that I can get working with Drupal5 site.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 06:46:00
I used yum update --exclude=hiawatha* just so I could update Kloxo MR to latest version. The SSL certificate I installed is now finally found with the latest version.

Hopefully, I can resolve hiawatha dependency issue with my older version of PHP? If not, oh well for now, just glad SSL is working again!
Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-27, 06:52:18
Look like something wrong with your mratwork-release/-testing.repo.

Because try update hiawatha for el6 (aka Centos 6) but your OS is Centos 5.

This issue sometimes appear in OpenVZ VPS.

Try rename all '$releasever' to '5' (for using Centos 5) or '6' (for using Centos 6) in /etc/yum.repos.d/mratwork.repo.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 07:05:08
Here's what the file looks like now. Which lines should be changed?

[mratwork-release-neutral-noarch]
name=MRatWork - release-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/noarch/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-release-neutral-noarch-mirrors.txt
enabled=1
gpgcheck=0

#[mratwork-release-neutral-arch]
#name=MRatWork - release-neutral-arch
#baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/neutral/$basearch/
##mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-release-neutral-$basearch-mirrors.txt
#enabled=0
#gpgcheck=0

#[mratwork-release-version-noarch]
#name=MRatWork - release-version-noarch
#baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos$releasever/noarch/
##mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-release-centos$releasever-noarch-mirrors.txt
#enabled=0
#gpgcheck=0

[mratwork-release-version-arch]
name=MRatWork - release-version-arch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/release/centos$releasever/$basearch/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-release-centos$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[mratwork-testing-neutral-noarch]
name=MRatWork - testing-neutral-noarch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/noarch/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-testing-neutral-noarch-mirrors.txt
enabled=1
gpgcheck=0

#[mratwork-testing-neutral-arch]
#name=MRatWork - testing-neutral-arch
#baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/neutral/$basearch/
##mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-testing-neutral-$basearch-mirrors.txt
#enabled=0
#gpgcheck=0

#[mratwork-testing-version-noarch]
#name=MRatWork - testing-version-noarch
#baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos$releasever/noarch/
##mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-testing-centos$releasever-noarch-mirrors.txt
#enabled=0
#gpgcheck=0

[mratwork-testing-version-arch]
name=MRatWork - testing-version-arch
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos$releasever/$basearch/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-testing-centos$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0

[mratwork-srpms]
name=MRatWork - srpms
baseurl=https://github.com/mustafaramadhan/kloxo/raw/rpms/SRPMS/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/mratwork-SRPMS-mirrors.txt
enabled=0
gpgcheck=0

# ==================================

[mratwork-centalt]
name=MRatWork - centalt - arch
baseurl=http://centos.alt.ru/repository/centos/$releasever/$basearch/
#mirrorlist=http://rpms.mratwork.com/repo/mirrors/centalt-centos-$releasever-$basearch-mirrors.txt
enabled=1
gpgcheck=0
exclude=openssh* perl* mariadb* php* postfix* exim* ssmtp*

# ==================================

[mratwork-ius]
name=MRatWork - IUS Community Packages for EL $releasever - arch
baseurl=http://dl.iuscommunity.org/pub/ius/stable/Redhat/$releasever/$basearch
mirrorlist=http://dmirr.iuscommunity.org/mirrorlist/?repo=ius-el$releasever&arch=$basearch
enabled=1
gpgcheck=0
exclude=php52* mysql51*

# ==================================

[mratwork-epel]
name=MRatWork - Extra Packages for EL $releasever - arch
baseurl=http://download.fedoraproject.org/pub/epel/$releasever/$basearch
mirrorlist=http://mirrors.fedoraproject.org/mirrorlist?repo=epel-$releasever&arch=$basearch
enabled=1
gpgcheck=0
exclude=postfix* exim* ssmtp*

# ==================================

# for varnish
[mratwork-varnish-3.0]
name=MRatWork - Varnish 3.0 for EL $releasever - arch
baseurl=http://repo.varnish-cache.org/redhat/varnish-3.0/el$releasever/$basearch
enabled=1
gpgcheck=0

# ==================================

# for hiawatha
[mratwork-centosec]
name=MRatWork - CentOS $releasever Packages from CentOS.EC
baseurl=http://centos$releasever.ecualinux.com/$basearch
enabled=0
gpgcheck=0
exclude=cairo*

# ==================================

# for nginx-stable
[mratwork-nginx]
name=Kloxo-MR - nginx repo
baseurl=http://nginx.org/packages/centos/$releasever/$basearch/
gpgcheck=0
enabled=0

# ==================================

# for mariadb
[mratwork-mariadb-32]
name=Kloxo-MR - mariadb 32bit repo
baseurl=http://yum.mariadb.org/10.0/centos$releasever-x86
enabled=0
gpgcheck=0

[mratwork-mariadb-64]
name=Kloxo-MR - mariadb 64bit repo
baseurl=http://yum.mariadb.org/10.0/centos$releasever-amd64
enabled=0
gpgcheck=0

# ==================================

# for atrpms
[mratwork-atrpms]
name=Kloxo-MR - Fedora Core $releasever -  - ATrpms
baseurl=http://dl.atrpms.net/el$releasever-$basearch/atrpms/stable
gpgcheck=0
enabled=0

# ==================================

# for litespeed
[mratwork-litespeed]
name=MRatWork - LiteSpeed Tech Repository for CentOS $releasever - $basearch
baseurl=http://rpms.litespeedtech.com/centos/$releasever/$basearch/
#failovermethod=priority
enabled=1
gpgcheck=0

[mratwork-litespeed-update]
name=MRatWork - LiteSpeed Tech Repository for CentOS $releasever - $basearch
baseurl=http://rpms.litespeedtech.com/centos/$releasever/update/$basearch/
#failovermethod=priority
enabled=1
gpgcheck=0

# ==================================

# for mod-pagespeed
[mratwork-google-mod-pagespeed]
name=MRatWork - google-mod-pagespeed
baseurl=http://dl.google.com/linux/mod-pagespeed/rpm/stable/$basearch
enabled=1
gpgcheck=0

Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 07:24:39
I am running OpenVZ on VPS.
Title: Re: Can't Delete SSL Certificate
Post by: MRatWork on 2014-04-27, 07:36:55
Change all '$releasever' to '5' (for using Centos 5) or '6' (for using Centos 6) in /etc/yum.repos.d/mratwork.repo.
Title: Re: Can't Delete SSL Certificate
Post by: Joe on 2014-04-27, 07:52:15
I now get this error. 'Metadata file does not match checksum'. Ran yum clean all.

https://github.com/mustafaramadhan/kloxo/raw/rpms/testing/centos5/i386/repodata/
primary.xml.gz: [Errno -1] Metadata file does not match checksum
Trying other mirror.
Error: failure: repodata/primary.xml.gz from mratwork-testing-version-arch: [Err
no 256] No more mirrors to try.
Title: Re: Can't Delete SSL Certificate
Post by: Kloxo-DR on 2014-04-27, 08:50:27
Hi,

Details of SSL cettificates are stored in kloxo database in sslcert table.

Just login this table through any webinterface for mysql and simply delete the certificate you want.

Thereafter, it will not appear in the listing.

After you add or create a new one, it will be generated again and stored under the home dir where ssl dir is.