General :: Run A Query Browser For Mysql - X11 Connection Rejected Because Of Wrong Authentication
Nov 17, 2010
I am running Ubuntu 10.04 LTS. I am trying to run a query browser for mysql but keep receiving the following error:
X11 connection rejected because of wrong authentication.
The application 'mysql-query-browser-bin' lost its connection to the display localhost:10.0; most likely the X server was shut down or you killed/destroyed the application.
I have two machines X , Y . X is running on runlevel 5 while Y is running in runlevel 3 , I am trying to connect from machine x to y using X11 forwarding using the following command.
ssh -X username@IP
But i have the following error message.
"X11 connection rejected because of wrong authentication"
On host running; $ ssh -XfC -c blowfish user@guest_IP xterm$ /usr/bin/X11/xauth: error in locking authority file /home/user/.Xauthority X11 connection rejected because of wrong authentication. xterm Xt error: Can't open display: localhost:10.0 (hanging here) /home/user/.Xauthority is an empty file, just created. $ sudo ls -l /home/user/.Xauthority-rw-rw-rw- 1 user user 1 2010-07-19 03:16 /home/user/.Xauthority
Nor lock exists. The password is correct. $ ssh user@guest_IP xterm I can connect the guest.
i have MySQL on my CentOS server and have installed it and got it up and running through the command line.
I have changed root's username and password so there is no user called 'root' anymore. I also created a database called pancakes.Now when i try to log in using Query Browser, i put the server's IP in 'hostname', my new roots username and password in 'username' and 'password'.When i try to log in it gives me error 1130 and says connection from myhostname not allowed.
I've tried to use workbench but it's such a big step backwards in that you can't easily edit the output from a "select x,y,z from table" query. I'd have thought that was a pretty basic requirement...
I have installed mysql package in ubuntu 9.04 .I have also installed the query browser software can someone tell me how to configure the connection dialogue box in query browser. also my friend is using ubuntu 8.04 when he writes mysql in terminal he can directly execute database queries there but when i try the same thing on 9.04 i get an error as "Access denied for user 'ravi'@'localhost' (using password: NO)"
I 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:
I am on a CentOS 64 bit and used webmin to rotate MySQL slow query log. Now the thing is although logs are being rotated daily but the new log files being created are empty which means MySQL is unable to write them due to some reason. I have checked using "ls -l" that both permission and owner of files is same but still MySQL is not writing logs. What could be the reason?
I've been using the Ubuntu desktop for a couple of years now, but I don't have much experience using the terminal.
I've just set up a home server using Ubuntu-server 64bit which will be headless and its main function will be a Mythtv backend.
I've worked out how to use VNC to send a desktop from the server to my laptop, but when I try to use any programs which require root privileges such as synaptic or the user/groups manager, the pop-up asking for authentication refuses to accept my password.
Is there a setting I need to change on the server which prevents remote users from getting root privileges on the desktop?
I have 2 laptops running Ubuntu 10.04. One connects to my Linksys wireless modem fine while the other does not. The one that does not connect, will connect fine within the instances of Windows XP SP3 and Puppy Linux 5.1 that run on the same laptop. Ubuntu wireless worked fine with version 8.04 on this laptop before upgrading to 10.04.
When trying to connect within 10.04, Ubuntu pops up the dialog box to enter the authentication key. It rejects the correct key, and after a moment, pops up the same dialog box asking for the key again. I'm using WEP 40/128-bit encryption and the key I enter in the dialog box is the correct 26-character key.
The laptop is a Toshiba Satellite Pro 6000 (1g ram/40g disk). Here are some vital outputs root@user-laptop:/home/bsmis# iwconfig
lo no wireless extensions. eth0 no wireless extensions. irda0 no wireless extensions. eth1 IEEE 802.11b ESSID:"kr_wireless" Mode:Managed Frequency:2.457 GHz Access Point: None Bit Rate:11 Mb/s Sensitivity:1/0
I installed Jessie with Cinnamon alongside Win 7 - all went quite well though I did have to do a bit of guessing along the way.
Following online tutorials etc, I tried to install sudo from the terminal. It did not go well - some stuff appeared that was not shown in the instructions from many sites. So I abandoned it, or so I thought.
Then I discovered that my root password was no longer recognised. So I reset it, following online instructions.
This was successful apparently, as I can log in as root and see this in the terminal.
But on trying to start Synaptic ( and later others), I found that the new root password would is not authenticated, but my user password does authenticate successfully. This seems to be the wrong way round!
We use courier mail server for pop3 mailboxes, and postfix for in/out mail delivery
Code:
Now Pop3 users, could not authenticate with there username/pass
It does not work now, and I have this message in my log file
Code:
I could see in my postfix.main
Code:
And I could successful run query from mysql
Code:
I tried to change the password for this user, insert new user to the same tables, but no success to authenticate
I suppose that the problem is authentication of courier mail demon (which in my mind ) should work with mysql 'mail' database in the way is postfix work
Code:
I could not find any reference with courir demon to mysql database username,password to authenticate users..
So, my quetions is, if it's possible to tracert mysql db to find out if courier demon 'asking' for authentication, or is there any error with this, and which configuration file should be checked, in order to find out what authentication method is courier mail demon use for.
Quote: select * from s_transaction Where between UNIX_TIMESTAMP('2010-06-28 15:40:00') and UNIX_TIMESTAMP('2010-06-28 16:00:00') and user_id = '15545941';
Is this the syntax correct to retrieve a particular user transaction between given time period? because "its return error check the syntax near the between"
I have created a database which stores students grades for different stages of a project. One of the stages of the project is the specification part. I have a simple bit of html code which is going to be used as the searching facility. I want the user to be able to enter their ID and then it will display only their results. At the moment, it is displaying the results for EVERY student because I cant seem to find the correct syntax for my statement.
I tried moving firestarter boot script around, calling firestarter in /etc/rc.local and in gnome-sessions (start programs) and so forth. Alas, only way to get it started is from root terminal with # firestarter --start-hidden & i use wicd, wlan0 and a router. Network monitor and iptables are installed.
Trying to export a Mysql query to a .csv file the query draws from multiple tables, e.g. sales, purchase and currency
Code:
What i'm trying to do is to export both the sales and purchase to a single line where both the currency for the sales and the purchase is specified.
Basically like this:
Code:
Problem here is that i'm stating currency.value twice in the same select and don't know how to define which currency.value applies to sales and which to purchase.
It is under PHP/MySQL $queryresult = $conn->query("INSERT INTO normalrequests VALUES($finalkey, 1234, 5678, FALSE)"); It is connected to the database successfully but I feel there is something wrong with the statement up there.
I am having trouble with my local ssh connection. In my hosts.deny I have ALL, and in my hosts.allow I have my computer. I cannot connect unless I comment out the ALL in hosts.deny. Why is it not allowing a connection?
i will be quick, im trying to send a mysql query output into an array ie:
Code: declare -a HD HD=`echo "USE db; SELECT uid FROM user" | mysql -u $login -p$pwd -h $dbhost -B` echo ${#HD} those vars in mysql connection are previously and correctly assigned. but got an error
I am querying a single string column in a table. The string values have spaces in them. I want to loop over each value in bash. I set IFS to split lists on newlines instead of spaces. When I try this, it is splitting the list of results on the actual character 'n', not the newline ''.
DATA=`mysql -u root -ppassword --silent 'SELECT name FROM table_a;'` IFS=$' ' for i in $DATA; do echo "item = $i"
I am not sure if this is possible. I have IP's stored in a mysql database. When I query the database, it returns the IP. I would like to replace the IP with something else prior to displaying the results. Is it possible even though I have not stored it in the database?
I have the following in a while loop (mysql_fetch_array).
Code: <td align="left">' . $row[IP] . '</td>
Instead of displaying $row[IP] from the database, I would like it to display something else which I define in the PHP code but based on the IP.
So I've got a rather vast database, one of the columns is date in the following format: DD/MM/YY HH:MM:SS. This is starting to cause problems with a php page I'm writing which asks the user for a 'start date'. Would it be better for me to split the date column into date and say time? Or is there a way of using distinct and masking the times.
I am using MySQL 5.0.77 Version rpm on CentOS 5 Red Hat Linux. I want to install micro second slow query log patch on this MySQL S/W version.As I found the slow query micro second patch on percona site i.e. [URL]step by step to install above mentioned patch with rpm based MySQL installation? Do we need MySQL source files to apply patch ?
I need help about the error in my website. I have the following error....
Code: user warning: Got error 134 from storage engine query: SELECT data, created, headers, expire, serialized FROM cache WHERE cid = 'theme_registry:database1' in /var/www/html/web/includes/cache.inc on line 26.
Using acer aspire one (ZG5) and have lost connection to Firefox browser after changing setting to make google my home default web page. I have no experience with linux so any help would be appreciated. There's no problem with my internet connection it shows connected.
