How can i locate and change the php.ini and mysql my.ini file?

[wouterbe]

Hi,

i am a webdesigner with limited knowledge of server technology, I want to increase memory values in the my.ini and php.ini files...

I can't find the folders where they are located in.

i tried the desktop virtualisation software.... on my virtual dedicated server

please help,

regards,

Wouter

 

[JohnnyU]

I got a CentOS 6.5 VPS so both are in: /etc
or you could search for it: find / -name php.ini

/usr/local/psa/admin/conf/php.ini
/root/collect/plesk/php/php.ini
/root/collect/plesk/webmails/horde/horde/php.ini
/root/collect/plesk/cp-server/admin/conf/php.ini
/etc/php.ini
/etc/psa-webmail/roundcube/php.ini
/etc/psa-webmail/horde/horde/php.ini

 

[wouterbe]

thanx for the reply!

I forgot to mention that my server is windows based.
I found the files though.... in the parallels folder.
but when i change the the file my.ini (and replaced the ib_log files in a different folder)
i get an error message:
ERROR: PleskMainDBException
No connection could be made because the target machine actively refused it.


0: common_func.php3:637
reconnect()
1: common_func.php3:600
db_connect()
2: auth.php3:134

i stopped and started mysqlserver and plesk panel stuff...
i get the panel working again, but then when i check in phpmyadmin no values are changed....(i want to increase the innodb_buffer_pool_size!)

please advice.

 

[wouterbe]

140426 0:16:28 [Note] Plugin 'FEDERATED' is disabled.
140426 0:16:28 InnoDB: Initializing buffer pool, size = 2.0G
140426 0:16:28 InnoDB: Error: cannot allocate 2147500032 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 27847500 bytes. Operating system errno: 8
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
140426 0:17:28InnoDB: Fatal error: cannot allocate the memory for the buffer pool
140426 0:17:28 [ERROR] Plugin 'InnoDB' init function returned error.
140426 0:17:28 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140426 0:17:28 [ERROR] Unknown/unsupported table type: INNODB
140426 0:17:28 [ERROR] Aborting