PHP Warning: Invalid library

[Jan Prieser]

hello,

finally i got all required libraries and compiled sql2.4.6 with MySQL Support as well as the php module.
MySQL is version 3.23.53-max and PHP is version 4.2.3 (cli).
my apache php modul is still 4.2.2
both tell me:
"PHP Warning:  Invalid library (maybe not a PHP library) 'sqlb.so'"
my phpize came with php 4.2.3

does anyone know, how to get this cool stuff runnning?

thanky you
sneak

[Frédéric RUAUDEL]

First, you must have the last sqlb PHP module V1.5 that normaly fix this problem when you compile sqlb PHP module in shared mode.

Now if you have the last version, maybe it could be a problem with the new PHP version. This module was tested with PHP 4.2.2. If so, tell me and I will make some tests.

thanks for using SQLB,

good luck

GrumZ

[Jan Prieser]

i use V1.5 but compiled it again php 4.2.3. but this sqlb.so didn't work with php 4.2.3 or 4.2.2.
i will try to build php 4.2.2 and then test it again, if i've some time.

sneak

[Frédéric RUAUDEL]

Ok, I will test it too probably next week.

But for information, the built-in mode work very well. The shared mode is not very well tested yet as I began to test it from V1.4.
If you find anything that could help to fix the problem you are welcome to inform me.

thx

GrumZ

[Jan Prieser]

i just tried it again with php 4.2.2 (cli version) as shared library and also built-in.
It's the same error:
"PHP Warning:  Invalid library (maybe not a PHP library) 'sqlb.so'  in Unknown on line 0"

sqlb is compiled with mysql-support, but for php i use the build in mysql support.
is there any other way to test sqlb.so or the sqlb installation?

I really need sqlb, because my MySQL Server hangs every few minutes due to high server load and lots of connections from the webservers.

[Frédéric RUAUDEL]

Don't panic, the answer is always 42 ;)

First, when you use built-in mode, you musn't have any sqlb.so file, so I advice  you to delete it. Then try to check if the sqlb module has been enabled successfully, using a script like the following :

<?
phpinfo()
?>

and check you have a line saying something like "sqlb support enable".

Note: you don't need to enable mysql support in PHP if you intend to use sqlb your all your DB queries.

Second, have you read the following PHP module install doc :

http://sourceforge.net/docman/display_doc.php?docid=9897&group_id=28058

You will find in it the way to compile and install the module in both built-in and shared mode.

Third, check that your sqlb program has the mysql support with the command "sqlb --version".

Important: your apache users (generally "nobody") and your user "sqlb", must have the same group (by default, sqlb is compiled with the group "nobody"). To change it use the option --with-group="apache_group" when you compile sqlb (the deamon, not the PHP module ;)

Finally, I recommend to use the wrapper describe in the following docs when writing your scripts, because they are more usable than the native function of the module :

http://sourceforge.net/docman/display_doc.php?docid=9896&group_id=28058

And if you have any other problems, don't hesitate to ask me again, I will be happy to satisfy you with SQLB ;)

Good luck,

GrumZ

[Jan Prieser]

ok, `php -m` shows me sqlb now and php -i says, it is enabled. build-in works now ;)
but if i run `sqlb --version` it gives me this error:
"init_default_config : getpwnam: No such file or directory
Error during init of the default config"

where do i find the default config and what does this error mean?

thanks for you patience ;)

[Frédéric RUAUDEL]

Ok,

  so, now check you have done all the things describe in the following doc :
 
http://sourceforge.net/docman/display_doc.php?docid=4992&group_id=28058

Another important note : You must launch SQLB with the user "sqlb" like this :

root@localhost# su -l sqlb
sqlb@localhost$ sqlb start (or stop or --version ;)

For the config, default parameter should be ok, but if you want to tweak your config read this doc :

http://sourceforge.net/docman/display_doc.php?docid=5426&group_id=28058

For your DB config, you must fill a Mysql config section like this one :

<mysql@my_db_id>
   DB_HOST=
   DB_PORT=
   DB_UNIX_SOCK=/tmp/mysql.sock   # or something like that ;)
   DB_LOGIN=my_user
   DB_PWD=my_pass
   DB_NAME=my_db
</mysql@tmpl>

or

<mysql@my_db_id>
   DB_HOST=my_db_server.mydomain
   DB_PORT=3306
   DB_UNIX_SOCK=
   DB_LOGIN=my_user
   DB_PWD=my_pass
   DB_NAME=my_db
</mysql@tmpl>

the parameters are stricly the same as the ones required for the mysql connect() function as describe in the Mysql API.

the "my_db_id" is a uniq name that you will use when calling sqlb functions in your scripts. With this you can have, for example, multiple config for the same DB but with different user who have different rights on your DB.

You can put as many section as you need with different or same DB, different or same kind of DB (Mysql, PostgreSQL, etc). The only limit is your memory, because sqlb will launch for each section N sqlbquery deamon where N correspond to the parameter "sqlbquery_min". Each of these deamon will create a permanent connection to your databases.

Hope it will help you !

GrumZ

[Frédéric RUAUDEL]

Sorry, I made a mistake (damned copy/paste errors ;)

the end of the section must have the same name as the start one. Must read :

</mysql@my_db_id>

instead of :

</mysql@tmpl>

GrumZ