Comments for BBStatus
Re: mysql support
> there r few more steps :P did u
> heard about apsx? no? u will & u
> will learn to use it if don't wanna
> learn & install: PHP+APACHE (+SSL).
> next apache modul auth 4 apache, u will
> also need (if is not there) to specify
> postgresql lib in ldconfig & reload
> it. i think it's time to stop here, even
> if there is at least one more thing that
> u will have to set... a suexec apache
> wrapper. GOOD LUCK. but onestly
> personaly i think if u will need it you
> will install it...
Thanks for your thoughts.
The INSTALL file covers the installation process completely, and if you read carefully the instructions you will see that it's pretty easy to install, so you don't need luck for this. Of course, you need to have some knowledge about apache, perl, etc. The INSTALL how-to does not cover the installation steps and instructions for using other packages and tools you may need (apache, apache suexec, postgres, perl, rrdtool, iptables, kernel - patching and compiling etc). If I'd try to cover these as well probably the next step would be to write a howto about installing various linux/unix distros, etc:) Anyway, anybody who asked for my help to complete the installation steps (for BBStatus or some other additional software like apache/suexec, PERL modules, etc) got all the necessary help. So feel free to ask me if you need help installing BBStatus.
Why do I need mysql: personally I don't, but I also don't have to many needs, and it's not only me I wrote this useful piece of software for. So I have to think about the other users as well. Moreover, there are many users which prefer MySQL (or something else) instead, or prefer to maintain only one RDBMS on their server(s) instead of two. Also, there are many goodies introduced by Mysql 4.1 and 5.0, why not use them?!:)
Re: mysql support
> u will have to set... a suexec apache
> wrapper. GOOD LUCK. but onestly
> personaly i think if u will need it you
> will install it...
Maybe I'm missing your point, but I have to tell you that the installation guide for a particular application does not cover the installation notes for the other applications needed for ours to work. It just covers its needs (we need you to create a database and a user, we need you to get rrdtool, we need to setup this up, and that... etc).
The installation process for BBStatus is not a click-click-bang one (but also it's not a complicated one), you need to have knowledge about how some other applications work (apache configuration and eventually suexec setup, vixie or dillon cron, maybe some CPAN perl modules installation will be required at some point, etc).
And as a system administrator that configures Linux routers and needs traffic accounting, IP database management, SNMP and ICMP monitoring, some basic firewall management, etc the author (in this case that's me) assumes that you already know what is it all about.
P.S.: beginning with 2.48 multiport is used instead of mport. So now you don't have to rebuild your kernel and iptables anymore:)
Re: Need mysql support
ohh .. The Documentation of the project could be improved, also ... The install part at least :D
Re: Need mysql support
I'll be happy to test out some mysql implementations ..
mysql support
nor quite... in fact the question is why u need mysql?
at last post or my are both SQL. if u know to use one of them u may both. also if u are a rpm wizard alias Fedora distro & family u are solved (there is already installed o pgsql) for you all the rest, you newbies out there sound the message. Let's try to see what's happen' if u r usin' another distro like slack. first of all u will learn to play with p-o-m (not quite easy to install "mport" option), than u will rebuild kernel & iptables (get the sources first!!!). & don't even think to rebuild iptables 1.3.3 sources (in fc4, where default is 1.3.0) with k-2.6.13.4. good... now we have a point of view, i think i could write a HOWTO 4it. the easyst part is your problem: postgreSQL (./configure, gmake, gmake install from sources). NOW U HAVE IT!!! not quite sure. there r few more steps :P did u heard about apsx? no? u will & u will learn to use it if don't wanna learn & install: PHP+APACHE (+SSL). next apache modul auth 4 apache, u will also need (if is not there) to specify postgresql lib in ldconfig & reload it. i think it's time to stop here, even if there is at least one more thing that u will have to set... a suexec apache wrapper. GOOD LUCK. but onestly personaly i think if u will need it you will install it...
mysql support
I'd like to have support for mysql - at least to maintain only one database backend on my server :-)
Re: Need mysql support
> MySQL is faster, Postgres handles higher
> load better, but slower, and has support
> for transactions, advanced subqueries,
> and some other things. PgSQL also has a
> higher chance of corrupting your
> databases.
> I'd use MySQL for your app.
>
Maybe PgSQL is slower but my opinion is that is has less chances than mysql to currupt databases. Whatever, to start a flame now and here is pointless, everyone of us that uses both mysql and pgsql (and maybe also something else) has varios (bad and good) experiences with it.
In the next version (probably BBStatus 2.5) the queryes will be more compatible with MySQL (4.x). My goal is that before 2.8 or at 2.8 to have a version that works both with mysql and pgsql. The problem for me now is that I optimized the queries for Pg and I have to find a way to make them work (as they are or with small modifications) both on mysql or pgsql. Anyway if the queries will work fine on these both rdbms than it will work ok on many other rdbms. At that point I'll have to ask you, users of BBstatus, to help me with tests for different implementations usind different rdbms.
Re: Need mysql support
>
> % It's a shame this is so Postgres
> % specific... It looks like a great
> app,
> %
>
>
> Right after i'll finish it i'll add
> mysql support. Probably the users may be
> able to choose between postgresql and
> mysql from the conf file. Personaly I
> consider Postgres better than MySQL, but
> there are lots of people considering
> MySQL better. I have to think about
> them, too.
>
MySQL is faster, Postgres handles higher load better, but slower, and has support for transactions, advanced subqueries, and some other things. PgSQL also has a higher chance of corrupting your databases.
I'd use MySQL for your app.
Re: Need mysql support
> It's a shame this is so Postgres
> specific... It looks like a great app,
>
Right after i'll finish it i'll add mysql support. Probably the users may be able to choose between postgresql and mysql from the conf file. Personaly I consider Postgres better than MySQL, but there are lots of people considering MySQL better. I have to think about them, too.
Re: Need mysql support
Hello, I looking for a network clients traffic counter program, but my server is running mysql with mambo etc. webpages.
Can you tell me, about when will be out the mysql version of BBStatus? Or PostgeSQL can run together with Mysql in a same server? thankss