I already get data from mysql server by followed functions:
mysql_stmt_init();
mysql_stmt_prepare();
mysql_stmt_execute();
mysql_stmt_bind_result();
mysql_stmt_store_result();
then I want to use the API mysql_fetch_rows(MYSQL_RES *res) instead of mysql_stmt_fetch(MYSQL_STMT *stmt) to fetch rows, any one can tell is there any solution that can translate struct MYSQL_STMT into struct MYSQL_RES?
thanks in advance.
Oh
Now I cannot connect to mysql on RHEL
I try:mysql --user=myuser--password=mydbpass mysql
and i get:
Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'
Sorry I have done this many times before but cannot get in on this server. If I
mysqladmin -u root -p status, it states:
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
Cheers and sorry
PS /var/lib/mysql does not exist on my box
Hey guys,
I have fedora version 8 with mysql 5.0.45 istalled. I have also installed drupal. Recently drupal gave me an error "error code 28". When i checked it out it seemed to be with the db. When i tried to created a db (for testing puposes) in root...i wasnt able to. so then i tried to restart mysql ...it stopped but unfortunately i have not been able to get mysql back up...i get a messeage saying
"Timeout error occurred trying to start MySql Daemon"
Could you please assist...
Thanks in advance,
Hi All I'm newbie here asking for help
I'm using VMware for my Redhat Linux where my sql is installed
I receive this error from the time we transfer our server to our new office this February 9th.
I don't know what to do i already search this in google and tried solutions still not solve.
TIA
hello there!
the common communication between nodes is fine, but when i want to test the perimeter mode it has throw the error "Wrong the other node", it seems that it couldn't find its next hop node.
i trace the code as show below
Code:
int
GPSRNeighbors::intersect(nsaddr_t theother, double sx, double sy,
double dx, double dy){
//line 1 (x1,y1)--(x2,y2) is the segment
//line 2 (x3,y3)--(x4,y4) is the xD
struct gpsr_neighbor *other = getnb(theother);
if(other==NULL){
printf("Wrong the other node\n");
exit(1);
}
****************
struct gpsr_neighbor*
GPSRNeighbors::getnb(nsaddr_t nid){
struct gpsr_neighbor *temp = head_;
while(temp){
if(temp->id_ == nid){
if((GPSR_CURRENT - temp->ts_) < DEFAULT_GPSR_TIMEOUT)
return temp;
else {
delnb(temp); //if this entry expire, delete it and return NULL
return NULL;
}
return temp;
}
temp = temp->next_;
}
return NULL;
}
the simulation scene was shown in the attachment.
when i make node 0 send packet to node 1, the error will occur.
would somebody know how to solve it?
thank you for your time!
Hi, I've just recently installed MySQL connector/c from source code on my Slackware 14.1 x64
I read the official instructions of the connector but I felt a bit disorientated when I read:
Code:
1 -Change location to the top-level directory of the source distribution.
I interpreted that I have to go to the "highest" directory
Code:
/
So I wrote:
Code:
# cd /
root@- /# tar xzvf /home/normal/Downloads/mysql-connector-c-6.1.6-src.tar.gz
root@- /# cd /mysql-connector-c-6.1.6-src/
root@- /mysql-connector-c-6.1.6-src# cmake -G "Unix Makefiles"
root@- /mysql-connector-c-6.1.6-src# make
root@- /mysql-connector-c-6.1.6-src# make install
Then I did:
Code:
ln -s /usr/local/mysql-5.6.25/include /usr/include
But when I try to compile a program in c with #include <mysql.h> i get this error:
Code:
# gcc ctemp.c
In file included from ctemp.c:2:0:
/usr/include/mysql.h:57:27: fatal error: mysql_version.h: No such file or directory
#include "mysql_version.h"
^
What can I do? Thanks a lot and sorry for poor english
PD: If you need the official instructions I paste here the link: https://dev.mysql.com/doc/connector-...on-source.html
Hi everyone,
i tried to install mysql on my slackware 14.1.
typed mysql_install_db --user=mysql and went to the automatic configuration of secure access and receive this "Enter current password for root (enter for none):
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)".
How can remove this installation, to try to reinstall the db?
And another error when try to reinstall :
"bash-4.2# mysql_install_db --user=mysql
Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
150130 9:40:11 [ERROR] mysqld: File '/var/lib/mysql/aria_log_control' not found (Errcode: 13)
150130 9:40:11 [ERROR] mysqld: Got error 'Can't open file' when trying to use aria control file '/var/lib/mysql/aria_log_control'
150130 9:40:11 [ERROR] Plugin 'Aria' init function returned error.
150130 9:40:11 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
150130 9:40:11 [ERROR] mysqld: Can't find file: './mysql/db.frm' (errno: 13)
ERROR: 1017 Can't find file: './mysql/db.frm' (errno: 13)
150130 9:40:11 [ERROR] Aborting
150130 9:40:11 [Note] /usr/libexec/mysqld: Shutdown complete
Installation of system tables failed! Examine the logs in
/var/lib/mysql for more information.
The problem could be conflicting information in an external
my.cnf files. You can ignore these by doing:
shell> /scripts/mysql_install_db --defaults-file=~/.my.cnf
You can also try to start the mysqld daemon with:
shell> /usr/libexec/mysqld --skip-grant --general-log &
and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:
shell> /usr/bin/mysql -u root mysql
mysql> show tables
Try 'mysqld --help' if you have problems with paths. Using
--general-log gives you a log in /var/lib/mysql that may be helpful.
The latest information about mysql_install_db is available at
http://kb.askmonty.org/v/installing-...sql_install_db.
MariaDB is hosted on launchpad; You can find the latest source and
email lists at http://launchpad.net/maria
Please check all of the above before mailing us! And remember, if
you do mail us, you should use the /usr/bin/mysqlbug script!
bash-4.2#
"
Hello,
In debian I created a new user "myUser".
In /home/myUser/.profile
I added "mysql -u user -password"
So automatically after login to linux terminal the user is logged in mysql command line.
What I need to do is to exit terminal after user exit mysql, so he want have access to comand line.
Hi,
my server centos 6 32bit, server config. 12core 16gb ram,only http and mysql(innodb).
promble: httpd service taking 90% cpu usage.
below is top command result and my.cnf conf..
some times site hangs.
any solution on this issue
top - 16:11:13 up 6 days, 5:38, 3 users, load average: 31.50, 30.64, 24.67
Tasks: 259 total, 35 running, 224 sleeping, 0 stopped, 0 zombie
Cpu(s): 61.2%us, 7.9%sy, 0.0%ni, 30.5%id, 0.2%wa, 0.1%hi, 0.1%si, 0.0%st
Mem: 15982704k total, 6111196k used, 9871508k free, 365788k buffers
Swap: 6291448k total, 0k used, 6291448k free, 2648472k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
1500 apache 20 0 81188 55m 4660 R 47.7 0.4 3:53.51 httpd
1167 apache 20 0 80184 55m 4680 R 36.3 0.4 13:37.91 httpd
942 apache 20 0 86352 61m 4708 R 34.3 0.4 12:59.12 httpd
1157 apache 20 0 84272 59m 4704 R 34.3 0.4 13:04.18 httpd
1307 apache 20 0 86316 60m 4684 R 34.3 0.4 10:33.57 httpd
1363 apache 20 0 80164 55m 4676 R 34.3 0.4 7:07.59 httpd
1386 apache 20 0 86336 60m 4676 R 34.3 0.4 5:58.29 httpd
1620 apache 20 0 80164 54m 4660 R 34.3 0.3 3:01.97 httpd
937 apache 20 0 84084 59m 4712 R 32.4 0.4 13:04.31 httpd
1147 apache 20 0 84260 59m 4696 R 32.4 0.4 12:21.55 httpd
1158 apache 20 0 84084 60m 4688 R 32.4 0.4 12:39.18 httpd
1159 apache 20 0 84288 59m 4696 R 32.4 0.4 13:12.04 httpd
my.cnf conf. file
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
set-variable=max_allowed_packet=100M
set-variable=max_connections=500
set-variable=key_buffer_size=100M
#set-variable=key_buffer_size=64M
set-variable=sort_buffer_size=64M
#set-variable=innodb_buffer_pool_size=32M
set-variable=innodb_buffer_pool_size=1024M
#set-variable=innodb_buffer_pool_size=2048M
#set-variable=table_cache=1024
set-variable=table_cache=256
set-variable=thread_cache_size=16
set-variable=query_cache_size=16M
#set-variable=innodb_log_file_size=100MB
set-variable=interactive_timeout=60
set-variable=wait_timeout=60
I have connected to mysql console by "mysql -uroot -p" , then use the command "show processlist ;" to list the processes , but I can't see the result , may be the command is too long , the column only allow around 85 characters , the command should over the limit , how can I see the full command ?
thanks
Hello,
I am configuring OCS Server using the following two documentations:
http://wiki.centos.org/HowTos/OCSNG
http://www.howtoforge.com/how-to-ins...-on-centos-5.5
Getting below error during installaton:
""Checking for DBI PERL module...
Found that PERL module DBI is available.
Checking for Apache:BI PERL module...
*** ERROR: PERL module Apache:BI is not installed !
Checking for DBD::mysql PERL module...
Found that PERL module DBD::mysql is available.
Checking for Compress::Zlib PERL module...
Found that PERL module Compress::Zlib is available.
Checking for XML::Simple PERL module...
Found that PERL module XML::Simple is available.
Checking for Net::IP PERL module...
Found that PERL module Net::IP is available.
*** ERROR: There is one or more required PERL modules missing on your computer !
Please, install missing PERL modules first.""
i have googled for the solution unsuccessfully.
please help me in installing the missing perl module.
thanks in advance..
--
Anil Anji