Results 1 to 7 of 7

Thread: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

  1. #1

    Default MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    Sorry for English...

    Having to upgrade my pc from the current OpenSuse 13.1 to 42.2 Leap should also install a LAMP server with MySql,

    To do this, I would follow this howto guide:
    https://www.howtoforge.com/installin...suse-13.1-lamp

    and here is the problem and present 'about a month I'm trying to install MySQL 5.7 first using Oracle / Sun repository duly downloaded on the official website, then in the meantime have appeared repositories software.opensuse.org also on site at this link with 1 click install
    https://software.opensuse.org/ymp/se...mmunity-server

    The problem 'that there' towards to run MySql 'cause every time I try to start the service returns to me:
    Code:
    # systemctl start mysql.service
    Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
    typing course journalctl as indicated
    Code:
    # journalctl -xe
    dic 31 16:22:25 linux-2frc systemd[1]: Failed to start MySQL server.
    dic 31 16:22:25 linux-2frc mysql-systemd-helper[9324]: MySQL didn't start, can't continue
    dic 31 16:22:25 linux-2frc systemd[1]: Failed to start MySQL server.
    -- Subject: L'unità mysql.service è fallita
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- L'unità mysql.service è fallita.
    -- 
    -- Il risultato è failed.
    dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Unit entered failed state.
    dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Failed with result 'exit-code'.
    dic 31 16:22:25 linux-2frc systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
    dic 31 16:22:25 linux-2frc systemd[1]: Stopped MySQL server.
    -- Subject: L'unità mysql.service termina la fase di spegnimento
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- L'unità mysql.service ha terminato la fase di spegnimento.
    dic 31 16:22:25 linux-2frc systemd[1]: Starting MySQL server...
    -- Subject: L'unità mysql.service inizia la fase di avvio
    -- Defined-By: systemd
    -- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
    -- 
    -- L'unità mysql.service ha iniziato la fase di avvio.
    dic 31 16:22:25 linux-2frc mysql-systemd-helper[9582]: my_print_defaults: [ERROR] unknown option '--mysqld'
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: my_print_defaults: [ERROR] unknown option '--mysqld'
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Checking MySQL configuration for obsolete options...
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Trying to run upgrade of MySQL databases...
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Stale files from previous upgrade detected, cleaned them
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Running protected MySQL...
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: Waiting for MySQL to start
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.720197Z 0 [Warning] TIMESTAMP with i
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721016Z 0 [Warning] 'NO_AUTO_CREATE_
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721789Z 0 [Warning] Failed to normal
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721808Z 0 [ERROR] Aborting
    dic 31 16:22:26 linux-2frc mysql-systemd-helper[9592]: 2016-12-31T15:22:26.721841Z 0 [Note] Binlog end
    then trying to launch the program secure_installation finding service starts
    Code:
    # mysql_secure_installation 
    
    Securing the MySQL server deployment.
    
    Error: Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)
    looking I basically found the following directives in the network:
    1) stop MySql
    2) to generate a pwd (in this case creates a "/root/.mysql_secret" files that have do)
    3) to recharge the service with the clause mysqld_safe --skip-grant-tables & (but that 'I have not been able to do so because' the command is fine for debian or derivatives but not for OpenSuse)

    4) Assign is blessed PWD to MySQL even if provisionally, and subsequently
    5) mysql_secure_installation launch and continue the LAMP server installation

    Given, however, 'I have many gaps MySql computer is part of these deficiencies, and if there was anyone able to help me I would be grateful, because I do not understand why you create this error in the installation of MySQL 5.7, inter alia, the same problem and 'present with LinuxMint, so it must be a setup problem in MySQL ...

    Thank you...

  2. #2
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,699

    Default Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    Why not install from the normal repos??

  3. #3

    Default Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    Quote Originally Posted by gogalthorp View Post
    Why not install from the normal repos??
    Because use MySql 5.6, and I need of MySql 5.7

  4. #4
    Join Date
    Nov 2009
    Location
    West Virginia Sector 13
    Posts
    15,699

    Default Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap


  5. #5
    Join Date
    Jun 2008
    Location
    San Diego, Ca, USA
    Posts
    11,112
    Blog Entries
    2

    Default Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    As of today,
    MySQL 5.7 is in the special server repository.

    Add the repository by running the following in an elevated console (eg root)
    Code:
    zypper ar -f http://download.opensuse.org/repositories/server:/database/openSUSE_Leap_42.2/ 42.2_Database_Servers
    Then, refresh
    Code:
    zypper --gpg-auto-import-keys ref
    And then install mysql server. You should automatically install the latest from the new repository.

    As always, don't forget to run the following script immediately after install to configure security
    Code:
    mysql_secure_installation
    TSU
    Beginner Wiki Quickstart - https://en.opensuse.org/User:Tsu2/Quickstart_Wiki
    Solved a problem recently? Create a wiki page for future personal reference!
    Learn something new?
    Attended a computing event?
    Post and Share!

  6. #6

    Default Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    Quote Originally Posted by tsu2 View Post
    As of today,
    MySQL 5.7 is in the special server repository.

    Add the repository by running the following in an elevated console (eg root)
    Code:
    zypper ar -f http://download.opensuse.org/repositories/server:/database/openSUSE_Leap_42.2/ 42.2_Database_Servers
    This repository is the one that I posted the link
    https://software.opensuse.org/ymp/se...mmunity-server
    and it does not work !!!

    However I have tried to uninstall and reinstall mysql following your procedures @ TSU2 but we are always at the same point
    when I start the service:

    Code:
    systemctl start mysql.service 
    Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
    no progress for now...

  7. #7

    Thumbs up Re: MySql 5.7.7-1.4 not work on OpenSuse 42.2 Leap

    I like very much. 12.1 after 9.2 that I found it good
    I currently use the 13.1

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •