PDA

View Full Version : MySQL Port hardcoded


Corsar
31-08-2005, 18:10
Hi developers!

After 2 days installing Zabbix on gentoo I view several problems:
1. Port MySQL - hardcode.
2. SQL commands are running not in ansi a mode.
3. Not full localization (russian) php-frontend.

If it is possible:
1. Out parameter (MySQL/PGSQL port) to configure script or base config?
2. To similarly item 1.
3. To help with localization?

sauron
01-09-2005, 09:02
Hi developers!

After 2 days installing Zabbix on gentoo I view several problems:
1. Port MySQL - hardcode.

You need sql parameters in configure files ? Why you need this ?


3. Not full localization (russian) php-frontend.

Yes. I'm created russian localization. But this localization not full, and still need testing and devolopment.

Corsar
01-09-2005, 09:43
You need sql parameters in configure files ? Why you need this ?


Yes. I'm created russian localization. But this localization not full, and still need testing and devolopment.


My Primary Host working with MySQL running in ANSI mode. Zabbix SQL code dose not support ANSI mode.
I am run another MySQL daemon on port 3307 ... some troubles, but it's working.

After several minutes i am select work with MySQL Socket because Zabbix can't configure SQL server port in .conf file, only in code.
Now ZAbbix working propetly, but configure SQL server port is good future (i think).

L10n: I am glad to help you with localization after 3 week (simple travel at free time) :D

P.S. Why the gentoo portage tree dos not contain .ebuild file of latest version zabbix(12a)? This .ebuild can find on some server (link from this forum).

sauron
01-09-2005, 13:58
After several minutes i am select work with MySQL Socket because Zabbix can't configure SQL server port in .conf file, only in code.
Now ZAbbix working propetly, but configure SQL server port is good future (i think).

I'm think this need feature. ;)


L10n: I am glad to help you with localization after 3 week (simple travel at free time) :D

Now i'm rewrite localization ;) For new CVS version.


P.S. Why the gentoo portage tree dos not contain .ebuild file of latest version zabbix(12a)? This .ebuild can find on some server (link from this forum).

Why it's not portage tree ? Read explain there:
http://bugs.gentoo.org/show_bug.cgi?id=92326

James Wells
01-09-2005, 17:23
Greetings,

1. Port MySQL - hardcode.

--- Cut --- Paste --- Cut --- Paste ---
If it is possible:
1. Out parameter (MySQL/PGSQL port) to configure script or base config?

Instead of making it part of the configure scipt, I have posted a PATCH (http://www.zabbix.com/forum/showthread.php?t=1307) that makes the port number optional and set to port 3306 by default, but is run time configurable in both the zabbix_server.conf file and the php frontend.

Wolfgang
01-09-2005, 20:16
I second that it would be helpful in some cases to have the mysql port configurable.

shalako
07-04-2006, 22:48
I'm running three different versions of mysql simultaneously, with different ports and sockets, so I ran into errors upon initial install. "cannot connect with socket /temp/mysql.sock"

After reading the code I found out I could add the socket in include/db.inc.php
$DB_SERVER ="localhost:/var/lib/mysql/mysql.sock";

AFAIK, mysql_pconnect only supports adding either the port or socket, but not both.

I would like to see support for both port and socket during configuration.

Keep up the good work.

Alexei
11-04-2006, 13:58
ZABBIX already (starting from 1.1beta1) supports configurable DB port number.

shalako
12-04-2006, 21:29
how is the db port configurable?

all i have found is DB_SERVER in db.inc.php and that will only take a port or a socket, but not both.