Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-07, 21:31:26

Author Topic: Could not connect to MySQL  (Read 2172 times)

0 Members and 1 Guest are viewing this topic.

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Could not connect to MySQL
« on: 2016-03-14, 06:43:26 »
Selamat siang
Izin bertanya dikit :
OS : Centos 6 64, Kloxo-mr7, nginxproxy, mariadb
1. Created satu akun untuk testcase teman, lalu dia login dan upload data web dan database (sesuaikan file config tentunya dia pakai cms joomla),
Hasil : Could not connect to MySQL

2. Saya coba test manual dari cli dgn perintah : mysql -u user_ams -ppassworddb
Bs login.
Lalu saya coba test buat db biasa saja lalu file connect db biasa dan coba panggil kejadiannya sama,

Coba fixall dan restart all sama jg (kondisi masih default blm diutak atik),
Yang ingin saya tanyakan apakah ada step saya yg kelewat sehingga tdk bs terkoneksi dgn databasenya ?

Apakah karena ini? karena selain ini tdk ada error/warning lain di log
Quote
160313 11:44:39 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'

Sebelumnya sdh saya coba switch ke sh /script/mysql-convert --engine=MyISAM

Pertanyaan bonus  ;D :
Kira2 untuk maks upload file di file manager bisa dinaikan ? (saya upload 200MB lebih ga bs dan diarahkan ke display.php)
Jadinya upload melalui url


Thanks
« Last Edit: 2016-03-14, 06:45:08 by pluto01 »
WHO AM I

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #1 on: 2016-03-14, 06:56:47 »
Jika pakai Kloxo-MR 7.0, coba 'sh /script/mysql-optimize --select=upgrade'. Ini diperlukan karena kadangkala database dari mysql tidak match di mariadb.

Masalah uplaod file besar, bisa jadi masalahnya di hiawatha dan atau php.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #2 on: 2016-03-14, 07:22:19 »
Pastikan '#skip-innodb' jika database pakai innodb.

Kadangkala convert ke myisam ke innodb gagal sehingga perlu direboot dan ulangi 'sh /script/mysql-convert --engine=myisam' sampai 2x.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Re: Could not connect to MySQL
« Reply #3 on: 2016-03-14, 07:31:01 »
Sudah coba :
Quote
sh /script/mysql-optimize --select=upgrade
Masih sama juga pak ga bs konek ke dbnya

Baik pak akan saya coba2 nanti, sekilas untuk upload_max_filesize sdh dicoba 230M tp gagal jg

WHO AM I

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #4 on: 2016-03-14, 07:41:07 »
Coba infokan 'sh /script/sysinfo'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Re: Could not connect to MySQL
« Reply #5 on: 2016-03-14, 07:52:31 »
1. Sudah dipastikan #skip-innodb (saya coba2 balik ke innodb dan myisam tetap sama ga bs konek ke databasenya)
2. Setiap setelah diconvert selalu direboot

3. [root@panel ~]# sh /script/sysinfo
Quote
A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016030202
   - Web: hiawatha-10.1.0-f.6.mr.el6.x86_64
   - PHP: php54s-5.4.45-1.ius.el6 (fpm mode)
B. Plateform:
   - OS: CentOS release 6.7 (Final) x86_64
   - Hostname: panel.albenet.web.id
C. Services:
   1. MySQL: MariaDB-server-10.0.24-1.el6.x86_64
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el6.x86_64
      - Multiple:
        * php52m-5.2.17-102.mr.el6
        * php53m-5.3.29-1.ius.el6
        * php54m-5.4.45-1.ius.el6
        * php55m-5.5.32-1.ius.el6
        * php56m-5.6.18-1.ius.el6
        * php70m-7.0.3-1.w6
      - Used: php70m
   3. Web Used: nginxproxy
     - Hiawatha: --unused--
     - Lighttpd: --uninstalled--
     - Nginx: nginx-1.9.12-1.el6.ngx.x86_64
     - Httpd: httpd-2.2.31-1.mr.el6.x86_64
       - PHP Type: php-fpm_event
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.7-3.el6.x86_64
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el6.x86_64
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.18.mr.el6.x86_64
      - spam: spamassassin
WHO AM I

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #6 on: 2016-03-14, 07:56:14 »
Bisa jadi karena anda pakai php 7.0. Yang jelas, mysql_connect sudah di-hapus dari php 7.0. Kalau php 5.6, mysql_connect masih deprecated.

Coba ubah php70m ke php56m pada 'php used'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Re: Could not connect to MySQL
« Reply #7 on: 2016-03-14, 08:11:08 »
Bisa jadi karena anda pakai php 7.0. Yang jelas, mysql_connect sudah di-hapus dari php 7.0. Kalau php 5.6, mysql_connect masih deprecated.

Coba ubah php70m ke php56m pada 'php used'.

Iya benar sdh solved setelah rubah ke 5.6,
thanks pak
Tapi yg dibuat untuk test manual td harusnya sich pakai mysqli_connect
WHO AM I

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #8 on: 2016-03-14, 08:20:55 »
Coba 'php70m-cli -m' apakah mysqli masuk dalam daftar.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Re: Could not connect to MySQL
« Reply #9 on: 2016-03-14, 08:27:06 »
Masuk pak,

Terimakasih banyak pak atas bantuannya, untuk ini sudah aman, ini saya coab2 dulu
WHO AM I

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #10 on: 2016-03-14, 08:49:35 »
Coba anda rename mysqli.ini ke mysqli.nonini dan pdo_mysql.ini ke pdo_mysql.nonini di /opt/php70m/etc/php.d. Jika anda pilih php70m di 'php used', lakukan 'sh /script/restart-web -y'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline pluto01

  • Junior Member
  • *
  • Posts: 17
  • Karma: +0/-0
  • Gender: Male
  • Siapakah Saya ?
    • View Profile
    • Web Hosting
Re: Could not connect to MySQL
« Reply #11 on: 2016-03-14, 10:14:14 »
Coba anda rename mysqli.ini ke mysqli.nonini dan pdo_mysql.ini ke pdo_mysql.nonini di /opt/php70m/etc/php.d. Jika anda pilih php70m di 'php used', lakukan 'sh /script/restart-web -y'.
Baik pak, sudah dicoba
Ini akan saya coba check pastikan dulu script webnya, takutnya ada kendala dari sisi scriptnya jg (penyesuaian dgn versi php [yg mysqli] )
WHO AM I

Offline hostrator

  • Valuable Member
  • *
  • Posts: 53
  • Karma: +0/-0
    • View Profile
Re: Could not connect to MySQL
« Reply #12 on: 2016-04-23, 14:16:42 »
halo master2 semua

saya juga mengalami tidak bisa create database dengan keterangan :
Alert: Could not connect to DB [Access denied for user 'root'@'localhost' (using password: YES)]

sudah saya coba untuk ganti versi php  dari 5.4  ke 5.5 dan lakukan 'sh /script/restart-web -y' kemudian 'sh /script/mysql-convert --engine=myisam'

kemudian : sh /script/mysql-optimize --select=upgrade

berikut ini sysinfo :

A. Control Panel:
   - Kloxo-MR: 7.0.0.b-2016040705
   - Web: hiawatha-10.1.0-f.6.mr.el5
   - PHP: php54s-5.4.45-1.ius.el5 (fpm mode)
B. Plateform:
   - OS: CentOS release 5.11 (Final) i686
   - Hostname: hostrator.net
C. Services:
   1. MySQL: MariaDB-server-10.0.24-1
   2. PHP:
      - Branch: php54-cli-5.4.45-1.ius.el5
      - Multiple:
        * php52m-5.2.17-102.mr.el5
        * php53m-5.3.29-1.ius.el5
        * php54m-5.4.45-1.ius.el5
        * php55m-5.5.33-1.w5
        * php56m-
        * php70m-
      - Used: php55m
   3. Web Used: hiawathaproxy
     - Hiawatha: --used--
     - Lighttpd: --uninstalled--
     - Nginx: --uninstalled--
     - Httpd: httpd-2.2.31-1.mr.el5
       - PHP Type: php-fpm_event
   4. WebCache: none
     - ATS: --uninstalled--
     - Squid: --uninstalled--
     - Varnish: --uninstalled--
   5. Dns: nsd
     - Bind: --uninstalled--
     - DJBDns: --uninstalled--
     - NSD: nsd-4.1.9-1.mr.el5
     - PowerDNS: --uninstalled--
     - Yadifa: --uninstalled--
   6. Mail: qmail-toaster-1.03-1.3.55.mr.el5
      - pop3/imap4: courier-imap-toaster-4.1.2-1.3.18.mr.el5
      - spam: bogofilter
D. Memory:
                total       used       free     shared    buffers     cached
   Mem:           512        242        269          0          0         93
   -/+ buffers/cache:        149        362
   Swap:          256          0        256



Cara perbaikinya gmn ya master2.

salam

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: Could not connect to MySQL
« Reply #13 on: 2016-04-25, 02:20:51 »
Jalankan 'sh /script/reset-mysql-root-password PASSWORDBARUANDA'. Setelah itu jalankan 'sh /script/cleanup' untuk memastikan vpopmail juga terupdate.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

 


MRatWork Affiliates:    BIGRAF(R) Inc.    House of LMAR    EFARgrafix
Click Here

Page created in 0.044 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM