Scheduled Maintenance: We are aware of an issue with Google, AOL, and Yahoo services as email providers which are blocking new registrations. We are trying to fix the issue and we have several internal and external support tickets in process to resolve the issue. Please see: viewtopic.php?t=158230

 

 

 

phpmyadmin on debian 8

Linux Kernel, Network, and Services configuration.
Post Reply
Message
Author
johans
Posts: 4
Joined: 2018-01-26 17:40

phpmyadmin on debian 8

#1 Post by johans »

Hello, I would really appreciate your help!

We have a debian server at our work, Debian 8, for our library program, Koha. But I ran into an error with Koha and I need to install phpmyadmin to fix it.

I followed some ubuntu instructions.

sudo apt install phpmyadmin

and i added thee line /etc/phpmyadmin/apache.conf at the end of this config file nano /etc/apache2/apache2.conf

but when i ran sudo service apache2 restart, i just got errors and no web interface as well.

I am sure, I am doing something silly wrong, i just dont know what. any help will be appreciated it!!!

Johan Seyfferdt

User avatar
debiman
Posts: 3063
Joined: 2013-03-12 07:18

Re: phpmyadmin on debian 8

#2 Post by debiman »

johans wrote:But I ran into an error with Koha and I need to install phpmyadmin to fix it.
why?
phpadmin is an admin interface.
it does not fix errors.
maybe better to tell us what is actually wrong?
I followed some ubuntu instructions.
which?
and i added thee line /etc/phpmyadmin/apache.conf at the end of this config file nano /etc/apache2/apache2.conf
i'm sorry i did not understand that at all.
show us the file you edited.
but when i ran sudo service apache2 restart, i just got errors
what errors? you need to show us.

please have a read on the first link in my signature.

johans
Posts: 4
Joined: 2018-01-26 17:40

Re: phpmyadmin on debian 8

#3 Post by johans »

Hi!

Thanks for your reply.

Here is a blog on what I am trying to do http://kohageek.blogspot.ru/2017/09/del ... e.html?m=1

As you see they are fixing an error in Koha with phpmyadmin

I tried it, and when I ran into errors I looked everywhere on the web with the errors I get.

I can sadly not show you the exact errors now as the server is at work and I will only be there again on Monday.

But as I basically just need access to the mysql database, my knowledge of mysql terminal commands are very limited, I decided just to install mysql workbench and see if it will do the trick.

Once again thanks for the help!

User avatar
GarryRicketson
Posts: 5644
Joined: 2015-01-20 22:16
Location: Durango, Mexico

Re: phpmyadmin on debian 8

#4 Post by GarryRicketson »

You don't need phpmyadmin, but besides that, logical and obvious, with out seeing the error messages, how can you possibly expect anyone to be able help? The error messages are for telling the admin there is a error, and what caused it, on php they are usually pretty clear, usually solutions to the errors can be found simply by copy/paste the message into a good search engine (google is not what I consider good, but that is another topic). With out the error messages, nobody can know what the problem is.
johans »my knowledge of mysql terminal commands are very limited,

Well, that is normal when we start out with something new, but what amazes me, the solution to that, is not in trying to use something else that you are not very knowledgeable about either, obviously since you can not install it,... the solution is simple, start learning about the terminal commands and increase your knowledge. I do admit, and realize Mysql can be rather difficult , and even with phpmyadmin, it is confusing (to me ,as well), later I did find that, actually using the terminal commands is considerably easier, and more straight forward, but either way, one has to start trying to increase the limited knowledge.
Again, search engine to the rescue:
Copy paste key words into your search engine:

Code: Select all

How to access to the mysql database in a terminal 
One of many excellent results:
https://dev.mysql.com/doc/mysql-getting-started/en/
This is just a small part, you really need to start at the beginning, and read it all, assuming you know how.
Deleting a record from a table. Use a DELETE statement to delete a record from a table, specifying the criterion for deletion with the WHERE clause:

Code: Select all

mysql> DELETE FROM cats WHERE name='Cookie';
Query OK, 1 row affected (0.05 sec)

mysql> SELECT * FROM cats;
+----+---------+--------+------------+
| id | name    | owner  | birth      |
+----+---------+--------+------------+
|  1 | Sandy   | Lennon | 2015-01-03 |
|  3 | Charlie | River  | 2016-05-21 |
+----+---------+--------+------------+
2 rows in set (0.00 sec) 
Here is another tutorial: My simply MySQL Command Line Cheatsheet
https://gist.github.com/hofmannsven/9164408

And then there all ways is the good old:

Code: Select all

man mysql
MYSQL(1) MariaDB Database System MYSQL(1)

NAME
mysql - the MariaDB command-line tool

SYNOPSIS
mysql [options] db_name

DESCRIPTION
mysql is a simple SQL shell (with GNU readline capabilities).
===================
Using mysql is very easy. Invoke it from the prompt of your command
interpreter as follows:

shell> mysql db_name

Or:

shell> mysql --user=user_name --password=your_password db_name

Then type an SQL statement, end it with ";", \g, or \G and press Enter.

Typing Control-C causes mysql to attempt to kill the current statement.
If this cannot be done, or Control-C is typed again before the
statement is killed, mysql exits.----snip---
VERY IMPORTANT to know:
MYSQL OPTIONS
mysql supports the following options, which can be specified on the
command line or in the [mysql], [client], [client-server] or [client-
mariadb] option file groups. mysql also supports the options for
processing option files.

o --help, -?, -I

Display a help message and exit.
When ever you can not remember a command, or if you are not sure, simply
type help at the prompt, and get educated.

User avatar
debiman
Posts: 3063
Joined: 2013-03-12 07:18

Re: phpmyadmin on debian 8

#5 Post by debiman »

johans wrote:Here is a blog on what I am trying to do http://kohageek.blogspot.ru/2017/09/del ... e.html?m=1
is this your blog? i assume not.
this is not good enough.
YOU have to tell us what YOUR problem is.
I can sadly not show you the exact errors now as the server is at work and I will only be there again on Monday.
that's ok, i'm not in a hurry with this.

johans
Posts: 4
Joined: 2018-01-26 17:40

Re: phpmyadmin on debian 8

#6 Post by johans »

thanks for your help! i appreciated your time!

johans
Posts: 4
Joined: 2018-01-26 17:40

Re: phpmyadmin on debian 8

#7 Post by johans »

Hi, thank you for your help.

I installed MySQL Workbench and I was able to fix the problem I had.

Thank you so much for your help and keep up the great work!!!

Post Reply