UDF Shared Library
I am trying to create a User Defined Function (UDF) using mySql 4.1.11 (mysql-max-4.1.11 for Solaris 8).
I am trying to get the examples to work (udf_example.so) I have successfully compiled it and copied the resulting .so file to /usr/lib. The command 'crle' (like ldconfig on Linux) shows that /usr/lib is in the library path, but when I type in mysql:
CREATE FUNCTION metaphon RETURNS STRING SONAME "udf_example.so"
I get the error 1126, Can't open shared library 'udfexample.so'
I've tries renaming the library 'libudf_example.so', but that didn't work either.
I don't know how to check what libraries mysql is looking through. I am just guessing that it uses the library path from 'crle'. Any ideas?
View Complete Forum Thread with Replies
Related Forum Messages:
Mysqlclient Library
i´ve just download mysql 4.0.14 where i can find an mysqlclient.lib for borland c++compilers, the one on windows download page is for version 3.23.xx.
View Replies !
Image Library
I want to design an image library (PHP/MySQL). I have the tables 'images' and 'categories'. Normally an image would have a field called 'categoryID' to link it to a particular category.I want the option to have an image belonging to several categories... what is the best way to do it ?Can I have a list in the field 'categoryID' (i.e. 1,3,5) ? Or should I build a table to associate images with categories ?I think the second solution is the 'proper' way as far as theory goes but my concern is the speed of access (and maybe code for updating)...I am tempted to go with the solution one but what about common queries like SELECT * FROM images WHERE categoryID = x will they retrieve images that have a list instead of a single value in 'categoryID' ?
View Replies !
Library Database
I wan't to make my php-code so that it will check the ISBN-number in the webform against all records in the database to prevent having two rows with the same ISBN-number.
View Replies !
Library Not Loaded Error On Log In
however when i tried to log in with: mysql -u root -p I get the following error message: dyld: Library not loaded: /sw/lib/libreadline.4.dylib Referenced from: /sw/bin/mysql Reason: no suitable image found. Did find: /sw/lib/libreadline.4.dylib: mach-o, but wrong architecture Trace/BPT trap
View Replies !
Mysql Library Question
I wrote an application (visual c#) that write data to an MySQL database. It this application is installed on the server which already mysql.data.dll installed what wokks fine. But I would like to be able to install my application and run from any pc. Now my question: Do I have to get the license for distribute the mysql library (mysql.data.dll) along with my apllication?
View Replies !
C Development On OSX: Library Load Issues
I have code that has been working on OSX [not Intel] for at least two years. We now have an Intel Mac and I am trying to recompile and debug the code for it. I am NOT a Mac expert. The older versions just did whit I hoped they would. I have had two issues so far. I have been able to "fix" one: The following GCC command "works" but the resulting binary can not be debugged. gcc -Wall -ggdb -I/usr/local/mysql/include -o myProgram myProgram.c -L/usr/local/mysql/lib -lmysqlclient -lz GCC says that there are no debugging objects in the executable and that it is "Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found)." I found a web page that talked about adding "-framework CoreServices" to the compile line. That has allowed me to see the debugging info/set breakpoints, etc in my code but there is still a MySQL issue. GDB reports: warning: Unable to read symbols for "/usr/local/mysql/lib/mysql/libmysqlclient.15.dylib" (file not found). This is interesting in that if you look at the compile line I say "-L/usr/local/mysql/lib -lmysqlclient" but gdb is trying to find "/usr/local/mysql/lib/mysql/libmysqlclient". GDB seems to be adding an extra "mysql" dir in the "-L' path.
View Replies !
MySQL Client Library? Where Can I Find It?
I'm trying to get an emailing program to work with mysql using ODBC on Windows and i've run into a couple of issues. I used the installer found on the mysql website and the mysqld-nt.exe process is running. I can also run the "mysql" command to create users, run queries, all the usual stuff. My first issue is that the icewarp email program shows me an error that reads "Mysql client library not found". Does anyone know where this file could be located? I used the default directory during my installation. on the mysql website it said to run "mysql_config --libs" to find where my client library is, but this program is no where to be found in the installation. The mysql website says : "You should be able to solve this problem by adding -Ldir_path -lmysqlclient at the end of your link command, where dir_path represents the pathname of the directory where the client library is located." when i have the path.. do i enter those options in the text field after i right click -> properties mysqld-nt.exe?
View Replies !
Shared Password
I've installed mySQL out of the box and set a new password for the root account, which works in the MySQL monitor but not with the mysqladmin tool. Please can anyone advise whats going on or if I have to do anything else to get access to the admin tool?
View Replies !
Php Startup: Unable To Load Dynamic Library ...
I've been reading some threads with the same problem, so I uncommmented the extension module for php_mysql.dll and I set the extension_dir = "c:phpext" . It still says that its unable to load the dynamic library 'c:phpextphp_mysql.dll' when I KNOW its in that directory along with the root directory as well. I have configured the apache httpd.conf with the LoadModule php5_module C:/php/php5apache2.dll and added #PHP 5 ScriptAlias /php/ "c:/php/" AddType application/x-httpd-php .php Action application/x-httpd-php "/php/php-cgi.exe" at the end. So does anybody have any ideas so that maybe I can connect to mysql with php with one less problem.
View Replies !
Unable To Load Dynamic Library Php_mysql.dll
Unable to load dynamic library 'c:webphpextphp_mysql.dll' is the error. The file blatently is there! How do I get MySQL working :confused: Googled it and most answers say in php.ini set extension-dir correctly (which it is) and copy libmysql.dll and php_mysql.dll to various locations (which I have tried) am I missing the perfect combo? Tried putting them both everywhere at the same time (windows, windowssystem[32], webphp, webphpext).
View Replies !
MySQL And Shared Storage
--=_D38DA341.B3D2A80A Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable I would like to set up a round robin cluster with mysql. The round robin = would be done through the DNS to two different servers. Each of those = servers would have mysql installed and each would reference the same data = directory on our SAN. Are there any problems with doing this? =20
View Replies !
MySQL-shared RPM Install
I'm having problems installing the shaired libraries. This RPM came from the MySQL.com download site. [root@localhost src]# rpm -i MySQL-shared-4.0.17-0.i386.rpm warning: MySQL-shared-4.0.17-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
View Replies !
Replication Using A Shared Fileserver
I thought of a radical way to do replication of MySQL servers. Let's assume two MySQl servers access a shared mapped storage (/mnt/db) which is a local mount to a fileserver on the network. This fileserver is shared between the MySQL servers; which means any writes to /mnt/db appears immediately on /mnt/db on the other MySQL machine. Two MySQL servers may attempt to modify to the same file if we don't use synchronization. My question is, first, can we do this without making patches to MySQL code, and somehow using some synchronization mechanism accross the two machines running MySQL server each. Or we need to patch MySQL code to support such architecture. Second, is it trivial or impossible to do, how much man-time it requires roughly.
View Replies !
Connections On Shared Server
I frequently get the error message: Warning: mysql_connect(): User user1 has already more than 'max_user_connections' active connections in /home/.sites/60/site23/web/Connections/mysite.php on line 9 It's commercial web hosting on a shared server so I have no control over the server side of things. The php scripting has been written using the GUI in Dreamweaver. Is there anything I can do to resolve this? Should I be using mysql_connect or mysql_pconnect, or is this not the problem? Do I need to include somewhere in my scripts a snippet which disconnects from the server? If so where would I put this? I am not all that familiar with php and mySQL, though I understand parts of it when looking at the code. The database connection is made via a connection.php file produced by Dreamweaver which includes the database details etc. My max connections are only 10. Is this the issue? It only seems to appear when I use php to edit or add to the mySQL database.
View Replies !
Find Shared Values
Say I have a one long Table of people and the foods they like. How do I find all the foods that are like by both of two particular people? ie David peas Kate sausages Kate eggs Bill eggs Kate peas Fred sausages Fred peas and i want to find out what both Fred and Fate like:
View Replies !
How To Find Out Values Shared By Some Members
I have a table contains words extracted from documents which are belonging to a number of categories. Each category contains a number of documents. For each category, I want to find out those words which occur at least in N documents belonging to this category. Code:....
View Replies !
Shared Column Data Transfer
I have two tables with one shared column. One other column in table 2 is empty but has to get filled with a value from one column in table 1. select * from tbl1, tbl2 where tbl1.column = tbl2.column; Above query gives me the results that need to be updated. What will the update statement look like?
View Replies !
Multiple Database, 1 Shared Table, Is It Possible?
I Used MySQL for a long time dev under PHP 3, 4 and now 5 now i'm facing a problems that i solved in the past with php, but i wonder if MySQL could do it on it's own, that'll help me a lot. Multiple database, 1 shared table, is it possible? i mean, i already done with 5 install of Xoops CMS and modified it that every install is on the same database, with deifferents prefixes (like db1_ db2_ ...) then i mod Xoops for each time it called for it's users or saved open sessions id in the DB it use the same table on all install... so the users seamlessly wonder about in 5 differents xoops install without disconnect and change username. now i face the same problem, i need a multi-install or a single install of a core system that will act as a multi-install sofware, but with the same set of users, sessions and some other things.
View Replies !
Security For Shared Server.xml Passwords
I have an ISP that has the server.xml in a shared environment. The server.xml file is where my password is available for database access under connection pooling. I really would like to use connection pooling. Does anyone know how I can protect my password from being viewed by others using the same server.xml file? I cannot get the administrator to change the protection of the file because others in the shared environment need to be able to view it.
View Replies !
Cannot Open Shared Object File!
i just upgraded from MySQL 4.1 to MySQL 5.1. But when i try to run a program, i'm getting this error: error while loading shared libraries: libmysqlclient.so.14: cannot open shared object file: No such file or directory
View Replies !
Can A MySQL Database Be Shared Between Windows And Linux?
I've got Windows and Linux running on my computer, on seperate partitions. I also have a shared partition for stroing files, and can be read and written by either system. I also have MySQL installed on both systems. When I make changes to the database in Windows, I have to do a dump of the database (or single tables) to a text file on my shared partition. I then have to switch into Linux and load that file into MySQL there. This is a bit of a hassle. Is it possible to somehow store the database file on the shared partition, and use the same database from both OSes? This would be very convenient, since I wouldn't have to maintain two copies of the same database!
View Replies !
ODBC Connection To MySQL On Shared Hosted Website
I'm trying to connect to a mySQL database that exists in connection w/ my website. I created the database using c-panel. Everything that I use to access the website from my site uses "localhost" as the host name. I installed the ODBC drivers for Windows on my XP machine and am trying to connect from my local machine. I am not sure what I should use for the hostname in that case -- I tried www.mysitename.com as the host but that didn't work. I also tried the IP address, but that didn't work either. I asked my host's support team, but haven't heard back from them yet. It's a shared hosting service. Any ideas on what the hostname should be?
View Replies !
How Often Is Best To Create New Database, Migrate Data With Shared Hosting?
I have got a web site that I have ben working on since March, 2007. It is a news reporting web site. It is replacing an older web site. I created a new database (it uses the MySQL database) last March when I started working on the new web site. I have migrated all of the news content from the old web site database to the new web site database. I have a shared web hosting. It's my understanding that the hosting service provider fills up one server with databases then starts a new server with databases. For example, the IP for the server that is hosting the current database for the new web site is 10.6.166.5 I just created a new database (the hosting allows you to have ten databases per shared hosting). The IP for the server for the recently created database for the new web site hosting is 10.6.166.92 If the servers are ordered sequentially there have been 87 new servers filled up with databases since last March (i.e. 10.6.166.92 recently created IP minus 10.6.166.5 March, 2007 IP equals 87 servers). The problem with migrating the nine-month old database to the new database is that I have got over a thousand news stories and two thousand pictures stored in the database with the 10.6.166.5 IP address. I would have to copy and paste all of the data into the phpMyAdmin program or write a PHP script that would automate the process. Is there any benefit to migrating the 10.6.166.5 March, 2007 IP database over to the more recently created 10.6.166.92 IP database? Would it be reasonable to expect the more recently created database to perform better over the next 12 to 18 months than the one created nine months ago?
View Replies !
Why Dont Shared Hosting Accounts Provide Stored Procedures And Triggers?
i am searching for 3 days now for a reliable, fast hosting company, which supports stored procedures and triggers on mysql5. most of them dont support this, because mysql5 has a design-flaw in which it stores procedures and triggers on a root level-area (tables mysql information_schema). due this logic, most of the hosting companies wont allow you to create/run procedures and triggers. funny, that hosting companies forbid you to use new technologies and methods to build faster.
View Replies !
|
TRACKER
