04-27-2009
Strange Mysql issue
Hi all,
I recently changed the name of my hostname from 'abc123' to 'abc456' (as an example).
I then added a user in my mysql database with the new host and removed references to the old users and hostname.
The strange thing is though, a process using the database still uses the old hostname!!
which then forced me to add the old names back into the database....
can anyone explain to me why this is the case and how i can ensure that all processes use the
new hostname i.e. 'myuser'@'abc456' and NOT 'myuser'@'abc123'
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
Hi,
I am comparing two numbers, but it gives strange results:
My Code:
if
then
echo "True"
else
echo "False"
fi
This code gives False for the follwoing comparison
where as True for the following:
Any reason for this? Both Should have given False...
I am using... (9 Replies)
Discussion started by: shihabvk
9 Replies
2. Cybersecurity
hi there , :cool:
um facing a problem with my root passwd
i want to set my root password and when i do i get the following ::
#
# passwd
passwd: Changing password for root
New Password:
Re-enter new Password:
passwd(SYSTEM): They don't match.
Please try again
New Password:... (6 Replies)
Discussion started by: badrali
6 Replies
3. UNIX for Dummies Questions & Answers
I have created a server monitor program in Java that connects to servers via SSH and constantly refreshes the new server load every 3 mins. The problem is that even though it is a Java app running shell commands to get the load info, the commands still appear in 'history'.
The question is.. is... (1 Reply)
Discussion started by: AndrewSH
1 Replies
4. UNIX for Advanced & Expert Users
hi again
i'm running a centos 4.x box with sendmail and openwebmail. I had a weird situation where users couldn't not get authenticated using a pop mail client but but were able to aunthenticate using the openwebmail webmail client. I looked through the logs and didn't see anything strange. I... (0 Replies)
Discussion started by: mcraul
0 Replies
5. Solaris
Hi ,
running solaris 10 on t5120 and i see ILOM and ALOM (SC) interfaces working fine earlier and suddenly they are responding strangely,
First thing , I can connect fine to ILOM or ALOM but then console -f just hangs..
resetsc error :
I do not really want to poweroff and poweron... (13 Replies)
Discussion started by: upengan78
13 Replies
6. AIX
hi all
we upgraded hacmp(powerha) from 5.2 to 5.4 recently .
during the failover testing, we found a strange network issue. after standby node took service ip address (172.15.100.8) online at standby NIC, we were able to log in the standby node by telnet 172.15.100.8 which stays at... (1 Reply)
Discussion started by: rs6000er
1 Replies
7. UNIX for Dummies Questions & Answers
Hello All,
PC: CuBox-i (*i.MX6) Mini-PC
OS: openSUSE 13.1 (Bottle) (armv7hl)
Kernel: 3.14.14-cubox-i
# uname -a
Linux CuBox-HQ 3.14.14-cubox-i #1 SMP Sat Sep 13 03:48:24 UTC 2014 armv7l armv7l armv7l GNU/LinuxSo I've been having this random issue happen on this PC where a few strange... (12 Replies)
Discussion started by: mrm5102
12 Replies
8. Shell Programming and Scripting
more works.sh
#!/bin/ksh
{
print "From: reportgenerator@myserver.com"
print "To: randomguy@myfirm.com"
print "MIME-Version: 1.0"
print "Content-Type: text/html"
print "Subject: Disk Report"
print "<body>"
print "<table border=1>"
... (3 Replies)
Discussion started by: mohtashims
3 Replies
9. Shell Programming and Scripting
Starting sendmail throws this error:
I decided to see the permission on the files under /etc/mail and this is the output:
# ls -ltr
total 284
-rwxr-xr-x. 1 root root 1847 Jan 27 2014 virtusertable
-rwxr-xr-x. 1 root root 127 Jan 27 2014 trusted-users
-rwxr-xr-x. 1 root root 92... (3 Replies)
Discussion started by: mohtashims
3 Replies
10. AIX
I just intalled java8_64.jre and .sdk respectively
installp -agXYd . Java8_64.jre Java8_64.sdk 2>&1 | tee installp.log
Worked like a champ. Now I see this--
jeff@server:/usr> ls -l | grep java
drwxr-xr-x 9 bin bin 512 Sep 22 2010 java14
drwxr-xr-x 7 bin bin ... (9 Replies)
Discussion started by: jeffs42885
9 Replies
LEARN ABOUT DEBIAN
grass-mysql
grass-mysql(1grass) Grass User's Manual grass-mysql(1grass)
NAME
grass-mysql - MySQL driver
MySQL driver MySQL driver in GRASS MySQL database driver in GRASS enables GRASS to store vector attributes in MySQL server.
Because vector attribute tables are created automaticaly when a new vector is written and the name of the table is the same as the name of
the vector it is good practice to create a new database for each GRASS mapset.
Creating a MySQL database
A new database is created within MySQL:
mysql> CREATE DATABASE mydb;
See the MySQL manual for details.
Driver and database name
GRASS modules require 2 parameters to connect to a database. Those parameters are 'driver' and 'database'. For MySQL driver the parameter
'driver' should be set to value 'mysql'. The parameter 'database' can be given in two formats:
Database name - in case of connection from localhost
String of comma separated list of kye=value options. Supported options are:
dbname - database name
host - host name or IP address
port - server port number
Examples of connection parameters:
db.connect driver=mysql database=mytest
db.connect driver=mysql database='dbname=mytest,host=test.grass.org'
Data types
GRASS supports almost all MySQL data types with following limitations:
Binary columns (BINARY, VARBINARY, TINYBLOB, MEDIUMBLOB, BLOB, LONGBLOB) are not not supported. If a table with binary col-
umn(s) is used in GRASS a warning is printed and only the supported columns are returned in query results.
Columns of type SET and ENUM are represented as string (VARCHAR).
Very large integers in columns of type BIGINT can be lost or corrupted because GRASS does not support 64 bin integeres on
most platforms.
GRASS does not currently distinguish types TIMESTAMP and DATETIME. Both types are in GRASS interpreted as TIMESTAMP.
Indexes
GRASS modules automaticaly create index on key column of vector attributes table. The index on key column is important for performance of
modules which update the attribute table, for example v.to.db, v.distance and v.what.rast.
Privileges
Because MySQL does not support groups of users and because only MySQL 'root' can grant privileges to other users GRASS cannot automaticaly
grant select privileges on created tables to group of users.
If you want to give privilege to read data from your mapset to other users you have to ask your MySQL server administrator to grant select
privilege to them on the MySQL database used for that mapset. For example, to allow everybody to read data in from your database 'mydb':
shell> mysql --user=root mysql
mysql> GRANT SELECT ON mydb.* TO ''@'%';
Schemas
Because MySQL does not support database schemas the parameter 'schema' of module db.connect should never be set to any value. If you set
that parameter for MySQL driver GRASS will try to write tables to the specified schema which will result in errors.
Groups
MySQL does not support user groups. Any settings specified by 'group' parameter of module db.connect are ignored by GRASS for MySQL driver.
SEE ALSO
db.connect, SQL support in GRASS GIS
Credits
Development of the driver was sponsored by Faunalia (Italy) as part of a project for ATAC.
AUTHOR
Radim Blazek
Last changed: $Date: 2011-02-07 18:59:50 +0100 (Mon, 07 Feb 2011) $
Help Index
GRASS 6.4.2 grass-mysql(1grass)