Virtual server does not give me access to shell mysql commands, only phpMyAdmin

Next topic

Author	Message
Hugo Gallo	Thursday 22 May 2003 12:05:21 am The ensim control panel for linux does the following: While it is reasonably simple to create a new database as a site administrator, experienced appliance administrators or root users will find that they can no longer simply create databases through the standard mysql tools. This loss of functionality occurs because the /var/lib/mysql directory is now owned by the user root, and the directory only has write permission for the root user. The mysql daemon runs as the user mysql, and thus can't write to this directory when it tries to create a database. This affects the ability to run the eZ publish setup since the setup uses the mysql commands. Is there a way around using mysql commands and solely use phpMyAdmin to configure ezPublish?
Tony Wood	Thursday 22 May 2003 12:44:45 am Hugo, You can use phpMyAdmin to do all of this. You will find most people use phpmyadmin anyway even if they have shell access... its alot better and Version 2.5 is very good... Tony Tony Wood : twitter.com/tonywood Vision with Technology Experts in eZ Publish consulting & development Power to the Editor! Free eZ Training : http://www.VisionWT.com/training eZ Future Podcast : http://www.VisionWT.com/eZ-Future
Hugo Gallo	Thursday 22 May 2003 8:57:53 am Very good. Can you point me in the right direction? I am stuck/accustomed to using the eZ publish setup wizard. If I disable the setup, how do I properly set up the database through phpMyAdmin?

Author

Message

Thursday 22 May 2003 12:05:21 am

The ensim control panel for linux does the following:

While it is reasonably simple to create a new database as a site administrator, experienced appliance administrators or root users will find that they can no longer simply create databases through the standard mysql tools. This loss of functionality occurs because the /var/lib/mysql directory is now owned by the user root, and the directory only has write permission for the root user. The mysql daemon runs as the user mysql, and thus can't write to this directory when it tries to create a database.

This affects the ability to run the eZ publish setup since the setup uses the mysql commands.

Is there a way around using mysql commands and solely use phpMyAdmin to configure ezPublish?

Tony Wood

Thursday 22 May 2003 12:44:45 am

Hugo,

You can use phpMyAdmin to do all of this. You will find most people use phpmyadmin anyway even if they have shell access... its alot better and Version 2.5 is very good...

Tony

Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development

Power to the Editor!

Free eZ Training : http://www.VisionWT.com/training
eZ Future Podcast : http://www.VisionWT.com/eZ-Future

Hugo Gallo

Thursday 22 May 2003 8:57:53 am

Very good.

Can you point me in the right direction?

I am stuck/accustomed to using the eZ publish setup wizard. If I disable the setup, how do I properly set up the database through phpMyAdmin?

eZ debug

Timing:	Jan 18 2025 11:09:43
Script start
Timing:	Jan 18 2025 11:09:43
Module start 'layout'
Timing:	Jan 18 2025 11:09:43
Module start 'content'
Timing:	Jan 18 2025 11:09:44
Module end 'content'
Timing:	Jan 18 2025 11:09:44
Script end

Main resources:

Total runtime	0.9064 sec
Peak memory usage	4,096.0000 KB
Database Queries	57

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0058	589.8359	152.6875
Module start 'layout'	0.0058	0.0032	742.5234	39.5547
Module start 'content'	0.0090	0.8958	782.0781	533.1172
Module end 'content'	0.9049	0.0015	1,315.1953	12.2188
Script end	0.9063		1,327.4141

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0030	0.3268	16	0.0002
Check MTime	0.0013	0.1395	16	0.0001
Mysql Total
Database connection	0.0007	0.0787	1	0.0007
Mysqli_queries	0.8631	95.2235	57	0.0151
Looping result	0.0005	0.0558	55	0.0000
Template Total	0.8758	96.6	2	0.4379
Template load	0.0019	0.2104	2	0.0010
Template processing	0.8739	96.4184	2	0.4370
Template load and register function	0.0002	0.0206	1	0.0002
states
state_id_array	0.0011	0.1220	1	0.0011
state_identifier_array	0.0013	0.1472	2	0.0007
Override
Cache load	0.0016	0.1729	16	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0006	0.0659	2	0.0003
Fetch class attribute name	0.0008	0.0932	4	0.0002
XML
Image XML parsing	0.0006	0.0667	2	0.0003
class_abstraction
Instantiating content class attribute	0.0000	0.0009	4	0.0000
General
dbfile	0.0007	0.0804	16	0.0000
String conversion	0.0000	0.0011	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
3	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
3	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 9 Number of unique templates used: 5

Time used to render debug report: 0.0002 secs