I have cpanel running and working with mysql. I need to add ODBC so I can get server side action script to connect to mysql also. Will adding ODBC affect anything else? I don't want to affect the way anything else connects?
View 1 Replies
I wish to connect to MySQL using an ODBC connection and I'm using isql to test. On the server connection using isql to local host is sweet however the problem is the client.Okay my set up looks like thisOn the server /etc/odbc.ini is[MySQL-scopus2008]Description = MySQL citation databaseDriver = MySQLServer = localhostDatabase = scopus2008Por
View 4 Replies View RelatedI use ubuntu lucid lynx, LAMP (mysql 5.1 and last php) and tried to install the package from mysql web page (mysql-connector-odbc-5.1.7-linux-glibc2.3-x86-32bit.tar.gz) through alien. Terminal output is as follows:p { margin-bottom: 0.21cm; }
sudo alien -d -c -k -i mysql-connector-odbc-5.1.7-linux-glibc2.3-x86-32bit.tar
dpkg --no-force-overwrite -i mysql-connector-odbc_5.1.7-1_all.deb
(Lendo banco de dados ... 147517 arquivos e diretios atualmente instalados).
[code]....
Howcome mysql by default is only allowing connections from localhost? I want to access it remotely from another account (not root).
View 1 Replies View RelatedI am maintain one site recently i have kept login form and registration pages on my at that time the site was opened. But the within 2 to 3 days after i got below error
#####################################
ERROR 1040 (00000): Too many connections in mysql
#####################################
mysql version 5.0.45
how to solve i thing my mysql database not supported for more members how many users able to connect to my database.
I execute: mysql -u root -p and asks for a password after I put the password and ENTER the following error! ERROR 1040 (00000): Too many connections Can you tell me where is the folder of mysql? For me to edit the my.cnf?
View 12 Replies View RelatedI recently installed Fedora 15 now, and during installation I set the internet connection manually, then did update and after reboot, the internet connection settings have been removed. Now I can not set because the network connection to the Internet Connection is inactive. I mention that before the update was functional internet connection.
View 5 Replies View RelatedI have the following mysql query which works great.
Code:
SELECT msg FROM `logs` WHERE ((`host` = 'aaa.bbb.ccc.ddd') OR (`host` = 'aaa.bbb.ccc.ddd')) AND `msg` REGEXP CONVERT( _utf8 'physical addresses' USING latin1 ) COLLATE latin1_swedish_ci
I need to refine this query so that I can query the last # hours using the `datetime` field in the database. I have researched the DATE_SUB function and can query for example the last 1 hour like this:
[Code]....
I'm interested in finding out, specifically, what causes daemon's to be shutdown when I shutdown Ubuntu? I'm use Ubuntu which is why I'm posting here, but I suppose this knowledge could apply to other Disto's too. Perhaps I'm better off to explain with an example:
I wrote a C++ that queries a Mysql database. I want it to run every time the computer is shutdown. I've verified the program works fine, and I've verified that I can run a program on shutdown of the computer by putting it in /etc/rc0.d. The problem is that by the time rc0.d runs my program, mysql has already been shutoff, and it can't connect.
So what I'm wondering is, is there a script or something at a higher level that goes around turning things like daemons as the System shutdowns, but before any of the scripts in rc0.d are run? (It doesn't look like anything in here is shutting down mysql). Something that actually calls mysql shutdown? How I can add my program to be run before mysql shuts down.
Otherwise, I might end up having to get the source code compile by own /sbin/shutdown and tweak it from there. Granted I might end up doing this anyway because there's more stuff I want to customize during shutdown (e.g. abort it under certain conditions), but I'm hoping not to go that far just yet.
Will deleting dev/sda partition table ( msdos ) affect my windows 7 system? I am trying to install Fedora 15 on Virtual Box.
View 1 Replies View RelatedI am trying to install Koha on centos5.5. Afte installing myqsl it starts normally. But when i add following lines into my.cnf and trying to restart mysql again it says that restart is failed.
here is the lines that i add into [mysqld] section
default-character-set = utf8
character-set-server = utf8
skip-character-set-client-handshake
I want to setup my MySQL database and have MySQL up and running. I sill look for a good editor to add and configure my tables, it appears that MySQL Administrator is the only GUI client available.
But when I try to add a foreign key to one of my tables, there appears to be a problem. Both of my tables are InnoDB and both have a primary key.
-First I choose the tab "Foreign Keys" on my CLIENT table.
-Then I press the green + sign to add a foreign key, it is default named new_fk_constraint.
-I choose my table USER in the Refer.Table dropdownbox
-And then I should be able to match the FK field and the PK field in the box on the right... but this box is empty. Double clicking shows nothing. I only can drag the user_id of the USER table to it, but have no option to select the foreign column.
What the hell is wrong here??? This client is years old and should be really REALLY working IMHO! I was told by a friend that there is no good client available and therefore he is using some Windows program for this...
I am trying to modify the source code of a C application (quagga) in order to insert data into a mysql table. I have added 2 new source files to the source (neto_mysql, neto_trend) which in turn use mysql.h. I have also modified the Makefile.am file to include the /usr/include/mysql directory.
When trying to compile, i get the following error. What am I missing? I have minimal experience with formal C applications like this. I feel like I may also have to include the mysql.h file in the libbgp? I dont understand why it cant find the mysql functions...
Code:
if gcc -DHAVE_CONFIG_H -DSYSCONFDIR="/usr/local/etc/" -I. -I. -I.. -I.. -I.. -I../lib -I/usr/include/mysql/ -fPIE -Os -fno-omit-frame-pointer -g -std=gnu99 -Wall -Wsign-compare -Wpointer-arith -Wbad-function-cast -Wwrite-strings -Wmissing-prototypes
[code]....
have a problem with my network-manager in ubuntu 10.10.when I dial one of my vpn connections, my other vpn connections be disabled and I can't use them!I tried to restart network-manager and gnome-panel, but it does't seem to solve this problem.
View 1 Replies View RelatedIn linuix how is it possible to access obdc? and how am i able to create new odbc links?
View 5 Replies View RelatedI am trying to push some data from LINUX system to SQL Server using perl scripts. To do this I need ODBC SQL Driver for linux system. Right now I am using easysoft ODBC driver. But it is trail version. Do any one have a idea is there any free ODBC SQL driver that I can install on linux system??
View 3 Replies View RelatedI'm trying to write a script to do the bulk of my work for me. What I want to do is go through a loop and select records based on loop control variable states. Unfortunately the database I have to use is an MS Access MDB file. I've been reading around and found a link to PHP documentation [below]. What I read in this was that if you have PHP on a Windows BOX you already have the ODBC drivers required to make the database connection. If you're on a *nix box you will need unixODBC drivers from openlink[not open source]. But it also goes on to say that this will allow you to connect from a Linux box to an MDB on a Windows box. What I really want to do is connect to the MDB on the local Linux box. Is this possible?
PHP Access Database Docs: [URL]
Mysql starting problem after changing mysqladmin password.I tried all the solutions available on forums, but not solve the problem.At last I restored the mysql db backup, this make mysql service start, but till other databases not showing all tables.
View 1 Replies View RelatedI've been attempting to set up a LAMP for local web development, which meant installing mysql-server. But now have a problem when trying to run mysql, I get:-
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
When trying to downgrade mysql-server I saw that there are dependency problems between the various modules (but can't recall which). But whichever route I truied the results are always the same.
Thought about trying XAMPP but I note that even has it's problems, is there any way I can get a lamp set up on FC14, or must I give it up as a bad job.
Howver, just been trying to again to fix the problems with downgrading mysql and get:-
Error: Package: mysql-server-5.1.55-1.fc14.i686 (@updates)
Requires: mysql(x86-32) = 5.1.55-1.fc14
Removing: mysql-5.1.55-1.fc14.i686 (@updates)
mysql(x86-32) = 5.1.55-1.fc14
I have the latest LAMP running on F10 but need to do a database conversion from mysql 4.1.22 to mysql 5 for a client.
View 4 Replies View RelatedI have mysql downloaded and when I type mysql into the command line I get this:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
I think this goes here, but I'm not sure. I decided that XAMPP had been troublesome enough. MySQL never worked. So I decided to instal the LAMP stack offered by YaST. I went about installing it thinking that it would all work. But it seems that I was wrong. So I try to start mysql, and here's what I get:
Code:
the-matrix:~ # mysql start
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) or
Code:
the-matrix:~ # rcmysql start
Starting service MySQL warning: /var/mysql/mysql.sock didn't appear within 30 seconds
chmod: cannot access `/var/run/mysql/mysqld.pid': No such file or directory
[Code]...
I'm trying to set up a firewall using ufw. I had planned on denying all network traffic and allowing as it became a problem. I expected to need port 80 8(http) 88(https) and 1863(MSN).
I tried:
Code:
Me@Ubuntu:~$ sudo ufw enable
Firewall is active and enabled on system start up
Me@Ubuntu:~$ sudo ufw default deny
Default incoming policy changed to 'deny'
(be sure to update your rules accordingly)
Me@Ubuntu:~$ sudo ufw status
Status: active
If I have understood I should not be able to connect to the Internet now but I still can (I am posting this with these settings). I have tried rebooting and this did not help although the status was persistent. I am currently using version 9.10 of Ubuntu upgraded from 9.04 (itself from 8.10 which was a clean install). I am using a wireless network called wmaster0 with driver rt61pci if that helps. How to configure firewall?
Is it fair to say that connLimit and hashlimit are very similiar on Linux i.e. while hashlimit caters to limits for groups of ports, they both set the connection rate limit per host? How in IPTables, do I configure a policy that limits connections on a port that encapsulates the total sum of all connections from all hosts? i.e. I do not want to allow more than 6000conn/minute for port range that is the sum of all connecting hosts?
View 3 Replies View Relatedi am using liferay5.2(mysql included in the download pack) on fedora. while liferay is working fine but i cannot connect to mysql.i am getting the error
[
[root@localhost ~]# ln -s /var/lib/mysql/mysql.sock /tmp
[root@localhost ~]# /etc/init.d/mysqld start
Timeout error occurred trying to start MySQL Daemon.
[code]....
i didnt find the mysql.sock file in the location /var/lib/mysql/mysql.sock. i cannot find the portal-ext.properties file also to make intial settings.
I did a d-u today, all went well. Then tried to install dkms, and apt came back with a list of programs it says were automatically installed by no longer required, including several libqt4 packages. I'd like to know what programs would be affected by removing each one.
View 9 Replies View RelatedI have two Ubuntu installations: a full one and a light/custom. The full one has every default package installed using the Live CD and some extra packages I've been adding as I need them, the custom one is created using debootstrap and then I add some packages: xserver, fluxbox, alsa... among others.
But I have one problem: plymouth shows a low-res splash screen for the custom installation, while it works great with the full one. Both running on the same motherboard and with the same monitor. Besides, I need to set the FRAMEBUFFER=y option in the custom installation to make plymouth show the splash screen at boot.
I've tried setting GRUB_GFXMODE, GRUB_GFXPAYLOAD and GRUB_GFXPAYLOAD_LINUX for GRUB without any change, I'd like to know what other programs/drivers/configurations may affect Plymouth resolution so that I could find what is preventing my custom installation from showing a nice plymouth splash screen.
I am compiling some software (JWM) and it says that I must install the "development headers" for X11 and Xlib.My main question is, how will installing those packages affect my system.My less main question is how do I install them?
View 1 Replies View RelatedI'm moving over to Linux when the new SSD arrives. SSD gives increased performance, so I thought that I could encrypt everything.
But then I came to think about TRIM, and garbage collection on the drive. Will a LUKS encrypted drive affect the garbage collection system? (TRIM).
I added a directory to the $PATH variable in /etc/profile. This works for my user account but not for root. It's easy to add it to my /root/.bashrc but I would like to understand whats's wrong. It's a widely unmodified Debian 6 so I think my changes should do the trick.
Here is what my /etc/profile looks like:
# /etc/profile: system-wide .profile file for the Bourne shell (sh(1))
# and Bourne compatible shells (bash(1), ksh(1), ash(1), ...).
if [ "`id -u`" -eq 0 ]; then
[code]....
Edit: The path I added is the distcc-stuff. Here is what echo $PATH tells me:
$ echo $PATH
/usr/lib/distcc/bin:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
# echo $PATH
/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
