mysqli extension is missing

[jbakshi]

Hello,

I have managed to use the inbuilt apache shipped with zimbra, running at port 7780.
I have placed the phpmyadmin there, but when call it, I get error as

The mysqli extension is missing. Please check your PHP configuration.

How can I install the required extension within zimbra ?

Thanks

[phoenix]

Originally Posted by jbakshi

I have managed to use the inbuilt apache shipped with zimbra, running at port 7780.

Not a good idea.

Originally Posted by jbakshi

I have placed the phpmyadmin there, but when call it, I get error as

I'm not surprised.

Originally Posted by jbakshi

How can I install the required extension within zimbra ?

Do not do this. It's not intended that users modify any components of Zimbra, you may break your ZCS installation and none of the changes you make will survive an upgrade. Any modification of ZCS components is totally unsupported and if you do modify them you will not be able to file bugs for them and you will receive no support, you're on your own.

[jbakshi]

Thanks for your kind attention and information. Then I think the better way is just to add a remote user to zimbra mysql and call it from a phpmyadmin running on local PC.
What is your opinion ?

Thnaks

[phoenix]

Originally Posted by jbakshi

Thanks for your kind attention and information. Then I think the better way is just to add a remote user to zimbra mysql and call it from a phpmyadmin running on local PC.
What is your opinion ?

I've already said that you should not modify any Zimbra components, that also includes the MySQL database - you may break your server by doing this and any changes will not survive an upgrade of Zimbra.

[jbakshi]

hmmm ... then what will be the alternative to use a phpmyadmin ?
Should I just install the apache and mysql on the same server ?
Though I hesitate to do such if it breaks zimbra.....

[phoenix]

Originally Posted by jbakshi

hmmm ... then what will be the alternative to use a phpmyadmin ?

Don't use it and leave the MySQL database alone. Perhaps if you gave some information about what you're trying to do someone may be able to advise you.

[jbakshi]

Understanding the risk, I have not modified anything but like to browse the mysql through phpmyadmin only. I have already found user zimbra is a remote user from mysql user table

% | zimbra | *2D43FEBAD723A8260359BC3CB18BB1AE48DFB385 |

I have collected it's password from *zmlocalconfig -s* and successfully log into the mysql server within zimbra

mysql -u zimbra -p -h localhost -P 7306

But from my local box when I gtry the same with -h / -h
I get

ERROR 2003 (HY000): Can't connect to MySQL server

What am I missing here ? Should I need to install mysql-client on the zimbra server and modify it's sockect ?

Thanks

[jbakshi]

solved..
have to comment bind-address=localhost at my.cnf and restart mysql