** Description changed: OS: ubuntu 14.04LTS 1. installed mariadb v10.2 2. running python django -> got error OSError: /usr/lib/libgdal.so.1: symbol my_init, version libmysqlclient_18 not defined in file libmysqlclient.so.18 with link time reference 3. removed and purged mariadb v10.2, service might still be running, as described in below points further. 4. install mysql-server, still getting dependecies not met, due to mariadb instance still found 5. apt-get autoremove and autoclean done 6. mariadb removed 7. mysql got installed after configuring mysql-dpkg 8. django runserver issue(pt.2) still remains unsolved package mysql-server-5.5 5.5.59-0ubuntu0.14.04.1 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 ProblemType: Package DistroRelease: Ubuntu 14.04 Package: mysql-server-5.5 5.5.59-0ubuntu0.14.04.1 ProcVersionSignature: Ubuntu 3.13.0-143.192-generic 3.13.11-ckt39 Uname: Linux 3.13.0-143-generic x86_64 NonfreeKernelModules: nvidia ApportVersion: 2.14.1-0ubuntu3.27 Architecture: amd64 Date: Thu Mar 29 08:51:41 2018 DistributionChannelDescriptor: # This is a distribution channel descriptor # For more information see http://wiki.ubuntu.com/DistributionChannelDescriptor canonical-oem-somerville-trusty-amd64-20140620-0 ErrorMessage: subprocess new pre-installation script returned error exit status 1 InstallationDate: Installed on 2018-02-20 (36 days ago) InstallationMedia: Ubuntu 14.04 "Trusty" - Build amd64 LIVE Binary 20140620-04:25 Logs.var.log.daemon.log: MySQLConf.etc.mysql.conf.d..keepme: MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf: [mysqld_safe] syslog MySQLVarLibDirListing: ['multi-master.info', 'herog_jsp_cp', 'aria_log.00000001', 'ib_buffer_pool', 'mysql_upgrade_info', 'ib_logfile1', 'aria_log_control', 'performance_schema', 'ib_logfile0', 'debian-5.5.flag', 'ibdata1', 'mysql'] ProcCmdline: BOOT_IMAGE=/boot/vmlinuz-3.13.0-143-generic root=UUID=6da57803-1492-43f0-9b75-d726e63e62c4 ro quiet splash radeon.modeset=0 nouveau.modeset=0 video.use_native_backlight=1 vt.handoff=7 RelatedPackageVersions: dpkg 1.17.5ubuntu5.8 apt 1.0.1ubuntu2.17 SourcePackage: mysql-5.5 Title: package mysql-server-5.5 5.5.59-0ubuntu0.14.04.1 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1 UpgradeStatus: No upgrade log present (probably fresh install) - ============================ solved ============================ Solved. a gis plugin was being used in my project postgis and postgres used in project. for that the very initial postgres installation must have put libmysqlclient_18 version defined by its own customizations. after mariadb installation, the libmysqlclient.so.18 should have been updated, hindering the older linkage and setups. ran the mysql/mariadb cleaning with this post https://askubuntu.com/a/172516/735971 installed mariadb again, got the gis support and issue is resolved. link to gis support libraries: http://scigeo.org/articles/howto-install-latest-geospatial-software-on-linux.html + -------------update----------- + got another error during running django server with postgresql==9.5 and postgis==2.2 + Could not find the GEOS library (tried "geos_c", "GEOS"). Try setting GEOS_LIBRARY_PATH in your settings. + + traced to evidence that mariadb-common files and libmysqlclient/libmariadblclient was still cached in apt-get + evertime I installed postgresql or any of its extension now, it used the cached copy of libmysqlclient.so.18 from mariadb. + so I removed all the unused dpkg configs + `sudo dpkg --purge `COLUMNS=300 dpkg -l "*" | egrep "^rc" | cut -d\ -f3` + ` + CAUTION: it can remove all the unused package, for only mariadb related files you can do + `sudo dpkg --purge `COLUMNS=300 dpkg -l "maria*" | egrep "^rc" | cut -d\ -f3` + ` + Also removed postgresql for the next clean installation overriding any traces of compiled libmysqlclient if any. + then removed any apt-repo related to mariadb from /etc/apt/sources.list followed by `sudo apt-get update`. + then apt-get autoremove and apt-get clean to clean everything. + then `sudo apt-get install -y postgresql-9.5 postgresql-9.5-postgis-2.2 postgresql-9.5-pgrouting postgresql-contrib-9.5` + everything works fine now. + + but i must say mariadb V10.2 still clashes with other installations and + system libraries like it clashed in prior versions for libmysqlclient.so + + ~Now i don't know how to install mariadb and postgres together. + ============================ solved ============================
-- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1759751 Title: mysql not downgrading to v5.5 after installing mariadbv10.2 and then purging it completely, mariadb service instance still clashing To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.5/+bug/1759751/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
