phpMyAdmin Issues!! (SOLVED! - THANKS!!! :) )

Questions about applications and software
Forum rules
Before you post please read how to get help
Post Reply
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

phpMyAdmin Issues!! (SOLVED! - THANKS!!! :) )

Post by michellebrooks »

I installed phpMyAdmin and getting some strange error when I click the link or enter through the browser:

Code: Select all

addJSON( 'list', PMA_RecentFavoriteTable::getInstance('recent')->getHtmlList() ); exit; } if ($GLOBALS['PMA_Config']->isGitRevision()) { if (isset($_REQUEST['git_revision']) && $GLOBALS['is_ajax_request'] == true) { PMA_printGitRevision(); exit; } echo '
'; } // Handles some variables that may have been sent by the calling script $GLOBALS['db'] = ''; $GLOBALS['table'] = ''; $show_query = '1'; // Any message to display? if (! empty($message)) { echo PMA_Util::getMessage($message); unset($message); } $common_url_query = PMA_URL_getCommon(); $mysql_cur_user_and_host = ''; // when $server > 0, a server has been chosen so we can display // all MySQL-related information if ($server > 0) { include 'libraries/server_common.inc.php'; include 'libraries/StorageEngine.class.php'; // Use the verbose name of the server instead of the hostname // if a value is set $server_info = ''; if (! empty($cfg['Server']['verbose'])) { $server_info .= htmlspecialchars($cfg['Server']['verbose']); if ($GLOBALS['cfg']['ShowServerInfo']) { $server_info .= ' ('; } } if ($GLOBALS['cfg']['ShowServerInfo'] || empty($cfg['Server']['verbose'])) { $server_info .= $GLOBALS['dbi']->getHostInfo(); } if (! empty($cfg['Server']['verbose']) && $GLOBALS['cfg']['ShowServerInfo']) { $server_info .= ')'; } $mysql_cur_user_and_host = $GLOBALS['dbi']->fetchValue('SELECT USER();'); // should we add the port info here? $short_server_info = (!empty($GLOBALS['cfg']['Server']['verbose']) ? $GLOBALS['cfg']['Server']['verbose'] : $GLOBALS['cfg']['Server']['host']); } echo '
' . "\n"; // Anchor for favorite tables synchronization. echo PMA_RecentFavoriteTable::getInstance('favorite')->getHtmlSyncFavoriteTables(); echo '
'; if ($server > 0 || count($cfg['Servers']) > 1 ) { if ($cfg['DBG']['demo']) { echo '
'; echo '

' . __('phpMyAdmin Demo Server') . '
'; echo '

'; printf( __( 'You are using the demo server. You can do anything here, but ' . 'please do not change root, debian-sys-maint and pma users. ' . 'More information is available at %s.' ), 'demo.phpmyadmin.net' ); echo '
'; echo '
'; } echo '
'; echo '
There is more but will leave it at this so this does not get too big. How do I fix this? I have used phpMyAdmin for a while and have never seen this before.

Please help!!!

PS - I uninstalled, deleted all the files the uninstall did not remove and I am still getting this error.
Last edited by michellebrooks on Sun Jul 24, 2016 1:42 pm, edited 1 time in total.
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

Re: phpMyAdmin Issues!!

Post by michellebrooks »

I just noticed that php7 was installed, that would cause this. How do I get php5 installed? There is no option for this anywhere, it is all php7. Or how can I get phpMyAdmin to work with php7?

Thanks :)
User avatar
phd21
Level 19
Level 19
Posts: 9677
Joined: Thu Jan 09, 2014 9:42 pm
Location: Florida

Re: phpMyAdmin Issues!!

Post by phd21 »

Hi "michellebrooks",

Welcome to the wonderful world of Linux Mint and its excellent forum !

It would help to know more about your system setup. If you run "inxi -Fxzd" from the console terminal prompt, highlight the results, copy and paste them back here, that should provide enough information. What edition and version of Linux Mint are you using?

How did you install php and or phpmyadmin? Did you install "LAMP" first?

Step 1: Install LAMP: Apache2, PHP and MySQL
sudo apt-get install apache2 php5 mysql-server

Step 2: Install phpMyAdmin
sudo apt-get install phpmyadmin
Select Apache for server

Step 3: Configure Apache2 for phpMyAdmin
sudo ln -s /etc/phpmyadmin/apache.conf /etc/apache2/conf-available/phpmyadmin.conf
sudo a2enconf phpmyadmin


After updating above entry, restart Apache2 service using following command
sudo service apache2 restart

Step 4: Access "phpMyAdmin" web based control interface, click link below or copy and paste link below
I recommend bookmarking in your toolbar.
http://localhost/phpmyadmin/



How to Install phpMyAdmin in Ubuntu 16.04, 14.04 & LinuxMint
http://tecadmin.net/install-phpmyadmin-in-ubuntu/

How to Install and Configure phpMyAdmin on Ubuntu 14.04 (Linux Mint 17.x or less)
https://www.liquidweb.com/kb/how-to-ins ... ntu-14-04/

How To Install and Secure phpMyAdmin on Ubuntu 16.04 (Linux Mint 18)
https://www.digitalocean.com/community/ ... untu-16-04

phpMyAdmin - official ubuntu documentation
https://help.ubuntu.com/community/phpMyAdmin


Hope this helps ...
Phd21: Mint 20 and 19.2 Cinnamon & xKDE (Mint Xfce + Kubuntu KDE) & KDE Neon 64-bit (new based on Ubuntu 20.04) Awesome OS's, Dell Inspiron I5 7000 (7573) 2 in 1 touch screen, Dell OptiPlex 780 Core2Duo E8400 3GHz,4gb Ram, Intel 4 Graphics.
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

Re: phpMyAdmin Issues!!

Post by michellebrooks »

Hi, Thanks for your response.

Here is the info you requested:

Code: Select all

System:    Host: Purgatory Kernel: 4.4.0-31-generic i686 (32 bit gcc: 5.3.1)
           Desktop: MATE 1.14.1 (Gtk 3.18.9-1ubuntu3.1)
           Distro: Linux Mint 18 Sarah
Machine:   System: Hewlett-Packard product: HP Compaq nc6220 (PU982AW#ABA) v: F.13
           Mobo: Hewlett-Packard model: 308A v: KBC Version 40.22
           Bios: Hewlett-Packard v: 68DTU Ver. F.13 date: 02/27/2007
CPU:       Single core Intel Pentium M (-UP-) cache: 2048 KB
           flags: (nx pae sse sse2) bmips: 3458 speed: 1733 MHz (max)
Graphics:  Card: Intel Mobile 915GM/GMS/910GML Express Graphics Controller
           bus-ID: 00:02.0
           Display Server: X.Org 1.18.3 drivers: intel (unloaded: fbdev,vesa)
           Resolution: 1024x768@60.00hz
           GLX Renderer: Mesa DRI Intel 915GM x86/MMX/SSE2
           GLX Version: 1.4 Mesa 11.2.0 Direct Rendering: Yes
Audio:     Card Intel 82801FB/FBM/FR/FW/FRW (ICH6 Family) AC'97 Audio Controller
           driver: snd_intel8x0 ports: 2100 2200 bus-ID: 00:1e.2
           Sound: Advanced Linux Sound Architecture v: k4.4.0-31-generic
Network:   Card-1: Intel PRO/Wireless 2200BG [Calexico2] Network Connection
           driver: ipw2200 v: 1.2.2kmprq bus-ID: 02:04.0
           IF: wlp2s4 state: up mac: <filter>
           Card-2: Broadcom NetXtreme BCM5751M Gigabit Ethernet PCI Express
           driver: tg3 v: 3.137 bus-ID: 10:00.0
           IF: enp16s0 state: down mac: <filter>
Drives:    HDD Total Size: 40.0GB (23.0% used)
           ID-1: /dev/sda model: ST9408114A size: 40.0GB
           Optical: /dev/sr0 model: MATSHITA UJDA765aDVD/CDRW
           rev: 1.02 dev-links: cdrom,cdrw,dvd
           Features: speed: 24x multisession: yes
           audio: yes dvd: yes rw: cd-r,cd-rw state: running
Partition: ID-1: / size: 36G used: 7.6G (23%) fs: ext4 dev: /dev/dm-1
           ID-2: /boot size: 472M used: 106M (24%) fs: ext2 dev: /dev/sda1
           ID-3: swap-1 size: 1.07GB used: 0.22GB (21%) fs: swap dev: /dev/dm-2
RAID:      No RAID devices: /proc/mdstat, md_mod kernel module present
Sensors:   System Temperatures: cpu: 70.0C mobo: 54.0C
           Fan Speeds (in rpm): cpu: N/A
Info:      Processes: 178 Uptime: 55 min Memory: 383.9/992.0MB
           Init: systemd runlevel: 5 Gcc sys: 5.4.0
           Client: Shell (bash 4.3.421) inxi: 2.2.35 
When I installed this I just used the software manager. Like I have with ubuntu and openSuse. Someone told me to try Mint and to get this version so here I am LOL. No, I did not install LAMP, I have no idea what that is, I never installed it before or if it was installed it was installed as part of the package.

I will try to add that and see if that helps. Everything else is working well from what I can tell, this is my only problem. Unfortunately I really like phpMyAdmin and not having this work is troublesome for me :(

I will try what you have suggested, please look over the info I provided and see if there is any quick fix I can do short of reinstalling Mint..... that is how I usually solve problems, I don't know Linux very well.

:)

EDIT:

I ran the 1st command in terminal and this is what I got:

Code: Select all

 ~ $ sudo apt-get install apache2 php5 mysql-server
[sudo] password for michelle: 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
Package php5 is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or
is only available from another source

E: Package 'php5' has no installation candidate
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

Re: phpMyAdmin Issues!!

Post by michellebrooks »

Update: I ran all those commands.... Still nothing.

Also, what is LAMP? I cannot find that anywhere when I search the packages in Synaptic.

I am pretty sure the problem is php7. Unfortunately, there is no way to downgrade to php5 with this version of Mint. It's the new version, Sarah with Mate Desktop. Although so far, all the packages are from ubuntu so not sure the difference between the two besides the look. I really like phpMyAdmin, I have used it for years when I was still on Windows. I would really like to get that working.
User avatar
Dngrsone
Level 5
Level 5
Posts: 576
Joined: Thu Nov 29, 2012 12:18 pm

Re: phpMyAdmin Issues!!

Post by Dngrsone »

An excerpt from a tutorial I wrote forever ago (I usually update it every time I move to a new platform, I haven't gone to 18 yet, so this is based on Mint KDE 17.2)
LAMP is an acronym standing for Linux, Apache, MySQL and PHP. The LAMP package will install the Apache2 webserver, MySQL database, and the Hypertext Preprocessor PHP.

Installing LAMP is as easy as this: open up a Terminal and type in the following, hitting the Enter (or Return) key when you are done:

Code: Select all

sudo apt-get install lamp-server^
The first command, sudo, switches the user command to root, which has all privileges. This means you will have to provide your password before the terminal will finish processing the rest of the command (by default, the terminal will remember your password for about fifteen minutes, so subsequent sudo commands won't ask for your password again until the fifteen minutes is up).

The command apt-get is the Advanced Packaging Tool that we use in Ubuntu to install and remove programs and packages. It is followed by the sub-command install, which tells apt to install the named package (lamp-server). The caret symbol (^) is required; it essentially calls on apt-get to install a set of packages-- instead of one package named lamp-server, there are actually several related packages. The caret invokes a function similar to another command called tasksel, which installs multiple related packages as part of a task-list.

Apt will list the packages that will need to be downloaded and wait for you to hit the Enter key again to begin installing. There may be notes from apt in there, telling you, for instance, that there are unnecessary files on your drive that can be unloaded by using the command apt-get auto-remove, but that isn't necessary at this moment. Be sure to research the effects of this command on your particular flavor and version of Linux before trying out that command later.

Once installation of the LAMP package begins, you will be asked to provide a password for MySQL root. You should be prompted to re-enter the password again, to make sure you know the password you just entered.

You must remember this password-- during this process you will be asked to provide several passwords, some of which you will rarely need to use, if at all (if you have need to move your blog using the procedures I outline in the third part of this series, then you will certainly need to know these passwords). If you ever have to access MySQL, you will need to know this root password, so be sure to record it somewhere safe. I use a Keyring program on my smartphone to keep track of all my passwords and such. It's separate from my laptop in case my hard drive fails, and I have encrypted backups for when the phone dies.

Once LAMP installation is complete, you can verify that Apache2 is working by opening up your Internet browser and typing http://localhost/ in the navigation bar. If you do not get a web page that says something along the lines of “It Works!” then something went wrong and you will be spending some time online trying to troubleshoot the issue.

'Out of the box' as it were, Apache2 will look in the /var/www folder for localhost applications, so we could test the PHP function by creating a quick test page. The fastest way to do this is by using the built-in text editor gedit (or Kate, in my case, since I am running KDE) as root. In your terminal, type:

Code: Select all

gksudo gedit /var/www/html/testpage.php
The command gksudo is similar to sudo, which we used earlier. This time, we are executing the command as root, but specifies that it's a graphical-interface application we are calling up. The first difference you might notice between the two is that gksudo will open up a separate window asking for your password where sudo makes its request from the terminal. When gedit comes up, enter the following line, save it and exit.

You'll need to restart Apache2 by entering this in the terminal:

Code: Select all

sudo /etc/init.d/apache2 restart
Once that is done, you can go to your browser and enter http://localhost/testpage.php in the navigation bar. If everything is working correctly, you should get a page that shows the version of your PHP installation (and a bunch of other stuff). If not, then you'll be spending some quality time with Mister Google, I'm afraid.

There are a few different ways for dealing with MySQL. Of the the methods I have tried, I have found phpMyAdmin to be the easiest application to work with. Install it with the following command in the terminal:

Code: Select all

sudo apt-get install libapache2-mod-auth-mysql phpmyadmin
You will want to select Apache2 as your webserver: make sure Apache2 is highlighted and hit the spacebar and then the Enter key. Next, phpMyAdmin will want to set up the dbconfig-common database. Select Yes using the Tab key and hit Enter.

The installer will ask you for the password you gave for MySQL root. It will then ask you to either assign your own password for phpMyAdmin or hit Enter to obtain an auto-generated one. Either way, be sure to record that password for later.

It's a good idea to add your username to the server group by typing the following (substituting your username in place of the term username) into the terminal and hitting Enter:

Code: Select all

sudo adduser username www-data
By default, Apache2 runs as user www-data in group www-data, we're just adding your username to the group that Apache2 runs under.

Once installation is complete, you can access phpMyAdmin by typing http://localhost/phpmyadmin in your browser navigation window. Use the password from the previous step to log in as root.


Problems installing


One problem I encountered with this install when invoking sudo apt-get install lamp-server^ on 12.04-beta2-desktop-amd64 was the error:

debconf: DbDriver "config": /var/cache/debconf/config.dat is locked by another process: Resource temporarily unavailable

After checking out Bug #349469 for this, I managed to get around the problem this way:

Code: Select all

sudo rm -rf /var/cache/debconf/*
sudo apt-get install -f
This is not a recommended action-- the command rm actually deleted all the files in the /var/cache/debconf folder, which, while being a cache, can still contribute to problems further down the road.
Try politeness; people will like you for it.
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

Re: phpMyAdmin Issues!!

Post by michellebrooks »

Not sure the name of the text editor in Mint, but the gedit code didn't work. Then I ran the next code and got this.

Code: Select all

michelle@Purgatory ~ $ sudo apt-get install libapache2-mod-auth-mysql phpmyadmin
Reading package lists... Done
Building dependency tree       
Reading state information... Done
E: Unable to locate package libapache2-mod-auth-mysql
PHP is working under this server, I have placed a php script on the server and it works. MySql Workbench works as well. So the problem lies with php7. I tried using php7 in opensuse and phpmyadmin did the same thing, however it cleared up once I downgraded back to php5.

I have tried everything to downgrade php to version 5 in Mint and there is nothing available for version 5 and version 7 keeps installing.

I downloaded php5 and the newest versions of phpMyAdmin from their web sites but don't know how to properly install them from their tar files.

This may not be an issue as I have another isue in the hardware section that is a little more important with regard to the internal speakers not shutting off when headphones are plugged in. I had this issue with ubuntu as well and went back to openSuse because of it. I may have to do that again if I cannot get that and this working.
michellebrooks
Level 2
Level 2
Posts: 80
Joined: Sat Jul 23, 2016 6:12 pm
Location: Minnesota

Re: phpMyAdmin Issues!!

Post by michellebrooks »

Dngrsone, Thank you!

You helped a lot with that information. I had to modify it a bit as I was getting that error above..... Since i could not get phpmyadmin all the way out from the fail, short of reinstalling Mint I don't know how to get it all out, I just downloaded phpMyAdmin from their site, copied the files to my server and it worked. I am assuming that the error stopped the files that needed to be copied to the server part of apache.

May not be a pretty fix but it worked lol!!! :)

Thanks, I appreciate the help!!
User avatar
Dngrsone
Level 5
Level 5
Posts: 576
Joined: Thu Nov 29, 2012 12:18 pm

Re: phpMyAdmin Issues!! (SOLVED! - THANKS!!! :) )

Post by Dngrsone »

Always happy to be of service.
Try politeness; people will like you for it.
Post Reply

Return to “Software & Applications”