eZPublish MySQL user privileges and search engine

Next topic

Author	Message
Ronnie Garcia	Wednesday 14 April 2004 9:06:12 am Hello, I recently installed 3.3-4, with no default "design" (on Linux). I managed to find that i needed to grant the Create_tmp_table_priv to the MySQL user to be able to use the search engine. On a local installation (3.2-3, on Windows) i did not have to add this priv. Is this expected behaviour ? If yes i was not able to find such info in the doc and we could contribute a notice. Rgds, Ronnie.
Lazaro Ferreira	Wednesday 14 April 2004 10:19:22 am Hi, AFAIK, the search engine code actually create and uses MYSQL tmp tables, so it seems normal that you need this MYSQL permission Regardind the Windows version, are you sure that you are doing it without actually having the privileges to do this ? Lazaro Lazaro http://www.mzbusiness.com
Ronnie Garcia	Wednesday 14 April 2004 10:34:59 am <i>Regardind the Windows version, are you sure that you are doing it without actually having the privileges to do this ?</i> My bad, the ezpublish user was there but the site.ini.append was set to use the root user =) Thanks, Ronnie.

Author

Message

Wednesday 14 April 2004 9:06:12 am

Hello,
I recently installed 3.3-4, with no default "design" (on Linux).
I managed to find that i needed to grant the Create_tmp_table_priv to the MySQL user to be able to use the search engine.

On a local installation (3.2-3, on Windows) i did not have to add this priv.

Is this expected behaviour ? If yes i was not able to find such info in the doc and we could contribute a notice.

Rgds,
Ronnie.

Lazaro Ferreira

Wednesday 14 April 2004 10:19:22 am

Hi,

AFAIK, the search engine code actually create and uses MYSQL tmp tables, so it seems normal that you need this MYSQL permission

Regardind the Windows version, are you sure that you are doing it without actually having the privileges to do this ?

Lazaro

Lazaro
http://www.mzbusiness.com

Ronnie Garcia

Wednesday 14 April 2004 10:34:59 am

<i>Regardind the Windows version, are you sure that you are doing it without actually having the privileges to do this ?</i>

My bad, the ezpublish user was there but the site.ini.append was set to use the root user =)

Thanks,
Ronnie.

eZ debug

Timing:	Jan 18 2025 18:40:54
Script start
Timing:	Jan 18 2025 18:40:54
Module start 'layout'
Timing:	Jan 18 2025 18:40:54
Module start 'content'
Timing:	Jan 18 2025 18:40:54
Module end 'content'
Timing:	Jan 18 2025 18:40:54
Script end

Main resources:

Total runtime	0.0315 sec
Peak memory usage	2,048.0000 KB
Database Queries	3

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0061	589.5938	152.6563
Module start 'layout'	0.0061	0.0036	742.2500	39.5078
Module start 'content'	0.0098	0.0196	781.7578	89.2891
Module end 'content'	0.0293	0.0021	871.0469	30.3047
Script end	0.0314		901.3516

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0023	7.3578	14	0.0002
Check MTime	0.0011	3.4808	14	0.0001
Mysql Total
Database connection	0.0012	3.8058	1	0.0012
Mysqli_queries	0.0032	10.0510	3	0.0011
Looping result	0.0000	0.0568	1	0.0000
Template Total	0.0016	5.0	1	0.0016
Template load	0.0009	2.7598	1	0.0009
Template processing	0.0007	2.2266	1	0.0007
Override
Cache load	0.0006	1.7571	1	0.0006
General
dbfile	0.0009	2.8394	8	0.0001
String conversion	0.0000	0.0280	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	Edit	Override
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs