Server :: Can Bind Dlz Work With The Mysql Stored Procedure

Jan 21, 2011

I have some trouble when I build a DNS server. I need use mysql stored procedure work with the bind dlz mysql driver, but failed.

dlz "Mysql zone" {
database "mysql
{host=127.0.0.1 dbname=dnsdata ssl=false}
{select domain from domains where domain='$zone$' LIMIT 1}

[code]....

View 1 Replies


ADVERTISEMENT

Software :: Creating Stored Procedure In MySQL Administrator?

Jul 22, 2010

what is wrong with this SQL to create a stored procedure in MySQL please?

Code:

CREATE DEFINER=`root`@`localhost` PROCEDURE `CheckStatus`(
IN start_date DATE,
IN end_date DATE)
BEGIN

[code]...

To me the syntax is correct. It complains with error 1327 'Undeclared variable: temp_sales'. What I don't understand is why I would need to declare a temporary table's name as a variable. Am I missing something here?

View 1 Replies View Related

Ubuntu :: Create A Stored Procedure In 10.04 Mysql Error 1307

May 5, 2010

recently upgraded, now none of my stored procedures work. All return error 1307. what can I do to prevent this from happening?

View 3 Replies View Related

Software :: Use HTML Tag In Sybase Stored Procedure?

Jul 6, 2011

I have a query in which i need to display the part of query output in bold

Example: select 'Previous NAV value for the fund is '+ CONVERT(VARCHAR(50),@prevNav) OUTPUT:Previous NAV value for the fund is 12345 so i need to display the output in BOLD like

Previous NAV value for the fund is 12345 OR

Previous NAV value for the fund is 12345

either the value can be in bold or the text can be in bold

View 9 Replies View Related

CentOS 5 Server :: BIND Nslookup Don't Work From Clients OS?

Oct 20, 2009

Don't work nslookup from clients guest OS.I have LinuxMint 7 and I'm installed VirtualBox on her. I created three guests OS. Two CentOS and XP

Name
The first CentOS linux1.starline.ca
The second CentOS centos.starline.ca
The third XP xp2.starline.ca[code].....

On the clients guest OS nslookup don't work. It write : timed out; no servers could be reached .What is going on? Why nslookup don't work from clients guest OS?On client machine in the file /etc/resolv.conf have record ameserver 168.135.88.2

View 2 Replies View Related

Ubuntu :: Backup MYSQL Database From Where Its Stored?

Feb 2, 2010

I had a problem with my ubuntu installation, but I don't want to get into that...The OS wouldn't load...Now, that I have a ubuntu partition mounted on a live cd, is there a way I can access or backup my database without booting the system? I'm pretty sure the database is stored somewhere, but how can I find it and back it up?

View 8 Replies View Related

Server :: What Is Bind Vs Bind-chroot Vs Caching-nameserver?

Jul 8, 2011

what is bind vs bind-chroot vs caching-nameserver ?what is the different between eatch others ?

View 7 Replies View Related

Server :: Getting MySQL To Work With SSL?

Mar 3, 2010

I have installed the MySQL server on two machines and got them to work as master - master over the internet. But since this is not very safe I wanted to get them to work over SSL. I first setup one machine and that worked. However, after setting the second machine to work over SSL it all stopped. I have checked many howto and faq documents without success.

It seems to be related to the certificate I think. This is a dump from the /var/log/syslog file for MySQL:

Mar 3 17:33:02 asterix mysqld: SSL error: Unable to get certificate from '/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem'
Mar 3 17:33:02 asterix kernel: [ 7209.109831] type=1503 audit(1267633982.018:274): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/ca-cert.pem"
Mar 3 17:33:02 asterix kernel: [ 7209.109877] type=1503 audit(1267633982.018:275): operation="open" pid=1324 parent=1071 profile="/usr/sbin/mysqld" requested_mask="r::" denied_mask="r::" fsuid=102 ouid=102 name="/etc/mysql/mysqlcerts/remoteMaster/client-cert.pem"

This is repeated many times...

I have copied the certificate files in a folder that is owned by mysql:mysql so I assumed that this would be ok.

View 4 Replies View Related

Ubuntu :: MySQL Not Starting When Bind-address Set To LAN?

Jun 17, 2010

I have MySQL installed on my Kubuntu 10.04 desktop machine which I use for developing web applications.First, all worked fine. But then I wanted to synchronize the database with the MySQL database on my laptop, so I had to allow connections from the LAN interface. So I addedCode:bind-address =192.168.0.100to /etc/mysql/my.cnf. This worked and the synchronization was performed. I want to do this on a regular basis so I would like to keep that line in there.The problem now is that MySQL does not start on system boot. When I start up, mysql simply is not started. There are no errors in /var/log/mysql/mysql.err or /var/log/mysql.err; these files remain empty.When I try to start it using 'sudo start mysql' I get the same result. The 'start mysql' shows up in 'ps aux', but the mysql process itself does not.Now, I found out that when I run

Code:
sudo -u mysql mysqld
The mysqld daemon does start, and the server works fine. To make matters even more strange, if I kill this

[code]....

View 2 Replies View Related

Ubuntu Servers :: Config Bind DNS With MySQL?

Jul 15, 2010

I have searched some about Bind9 and have it installed in my server. Now I'm looking for a Tools like mysqlBind and I found unxsBind is the next version of mysqlBind (These tools help you config BIND DNS with MySQL). But the issue is: I don't know how to Install it in Ubuntu - there just say how to install with Centos.

View 2 Replies View Related

OpenSUSE Network :: ERROR 2002 (HY000): Can't Connect To Local MySQL Server Through Socket '/var/mysql/mysql.sock

Jun 7, 2011

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]...

View 6 Replies View Related

Fedora Servers :: Mysql Driver For Bind In RPM Format?

May 14, 2011

anyone come across a mysql driver for Bind that is already in RPM format? I know there is one that you can compile, but i was just curious if anyone knew of a MAINTAINED package that does that same thing?

==Edit== While i'm at it, does anyone know of a way to have bind call a STORED PROCEDURE, instead of directly querying a table? That'd be sweet. --Or, even having bind query a php file, or a webhost, would be good... I'm going to google that one now....

==Edit== Screw the mysql driver: [URL]

how to use php to serve dns requests...

View 1 Replies View Related

General :: Can't Connect To Local MySQL Server Through Socket '/var/lib/mysql/mysql.sock' (2)

Jun 2, 2010

i 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.

View 9 Replies View Related

CentOS 5 Server :: Apache MySQL PHP Does Not Work On New Install

Jul 17, 2010

I just installed Centos 5.5 on one of my systems today and something is eluding me. Basically I had a web site and forum software (phpBB, but I don't think it's that, other forum software like Xoops does the same thing) running on Fedora 13, and I copied it over to the new Centos installation. Apache is running fine and displays a PHP test file and .html files just fine.

MySQL seems to be fine, I can log into that, show databases etc. Just can't get any forum software to know there is MySQL there. I did change the path of the site, and the databases, and edited /etc/my.cnf and /etc/httpd/conf/httpd.conf to reflect that. Thought I made the needed changes in /etc/php.ini but who knows. Seemed like everything should have tar'd up and moved easy, but not the case...

View 5 Replies View Related

CentOS 5 Server :: MySQL Shell Access Denied / Get It To Work?

Feb 20, 2011

I'm having a hard time to access MySQL from the local or remote shell.
If I try to access MySQL, using mysql -u root -pxxxx I get the error 1045 Access denied...

MySQL is running and I can access it, using phpmyadmin.

There must be something blocking shell access. Can anybody confirm and tell me how to check/configure for shell access?
I'm using ca preconfigured CenOS from PBX in a flash and it seems they did some security settings - but I can't find any further information.
I know I should probably post there, but the Mods didn't activate my account yet. And you know how it is if you try to figure something out. You won't stop.

View 1 Replies View Related

Red Hat / Fedora :: Enabling Mysql In Server (port 3306) It Doesn't Work?

Apr 12, 2011

when i am enabling mysql in server (port 3306) it does'nt work. but when i execute iptables -F it works what may be the reson?

View 6 Replies View Related

General :: Created Users In Pureftpd And The Users Are Stored In Mysql Database?

Dec 19, 2010

How to created users in pureftpd and the users are stored in mysql database. I tried when i try to connect i got like this error authentication failed error

View 1 Replies View Related

Fedora :: Where Are Stored PWs For Remote Desktop Viewer Stored?

Oct 20, 2010

I have machine that I used to VNC to on my network with Remote Desktop Viewer from my Fedora 12. When I first connected I checked the checkbox that I wanted to store the pw. Now the pw on the other machine has changed but Remote Desktop Viewer does not ask for a new password, it just gives me a black screen, like I am connected but I can't see anything. I'd like to know if anyone knows where this pw data is stored on the system so I can start fresh. I already tried uninstalling Remote Desktop Viewer and installing it again.

View 1 Replies View Related

General :: What Are Steps To And Procedure To Follow For Securing Server?

Apr 15, 2011

What are the steps to and Procedure to follow for securing Linux Server???

View 3 Replies View Related

Server :: Redhat Linux Kickstart Installation Procedure

Jan 20, 2010

Any one help me to build Redhat Linux 5.3 Server using Kickstart Installation.

View 1 Replies View Related

Server :: Procedure To Replace Failed Drive On RedHat Running LVM2

Nov 19, 2009

I am learning Linux and I am documenting procedures for troubleshooting for any disk related issues and I would like to know the procedure to replace a Failed hard drive running Redhat 5.1 running LVM2.

View 5 Replies View Related

Ubuntu Servers :: Completely Chroot Enviornoment Where Every Single Service Is In Chroot Mode (bind,mysql, Postfix)?

Jul 12, 2011

recently we decided to make our own panel (like Plesk or cPanel) but for Ubuntu and it will be licenced under GPL (like any other professional sofware).want to make a panel not only that fits our needs but also the needs of other system administrators and domain owners. We researched other panels and found out that non of them has security/look/ease of use in one package. Bad codig is another problem found in other panels.I made a short overwiev of what I think we have to have in the beginning.I Security :1. Completely chroot enviornoment where every single service is in chroot mode (bind,mysql, postfix, .... )2. Easily managed IPtables trough web-based interface. 3. Coding rules has to be strict.

II Software selection :
1. MTA - Postfix
2. POP - dovecot

[code]....

View 7 Replies View Related

General :: BIND Dns Wont Work

Dec 10, 2010

i just installed bind on my fedora 14 machine.and it work perfectly on the local-host, but my others machines can't use it.

by the way,I've already opened the port 53 .

View 7 Replies View Related

Software :: Getting BIND To Work On Ubuntu?

May 21, 2011

I'm having trouble getting BIND to work on ubuntu. It won't resolve my domain properly, or any entries i've manually added in the zone file.

My zone file is:

bendall.com. IN SOA bendall.com. admin.bendall.com. (
2011052101
28800
3600
604800
38400

[Code]...

I followed a tutorial to the letter and it told me to use the named.conf.local instead of named.conf, but there's an 'include' statement pointing to the named.conf.local.

View 2 Replies View Related

Ubuntu Servers :: Mysql Error Stopping MySQL Database Server Mysqld?

Jun 17, 2010

I have installed Mysql in Ubuntu 9, for the use of roundcube database.After installing iam getting the error like this

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

So because of this in the roundcube configuration its giving the error message that MYSQL is not installed. So Kindly give me a idea how to solve this.

View 1 Replies View Related

Software :: Connecting To Mysql Database - Can't Connect To Local MySQL Server Through Socket

Aug 25, 2010

I'm having problems connecting to the mysql database on my system. I first noticed this when I was trying to set up the program anymeal. I subsequently tried using MySQL Administrator (mysql-admin), but had no luck. It gives my the following feedback:

Code:

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Click the 'Ping' button to see if there is a networking problem. I press the ping button, and it seems to connect.

Code:

View 4 Replies View Related

Fedora :: MYSQL Error 2002 (HY000): Can't Connect To Local MySQL Server Through Socket?

Feb 22, 2011

I'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

View 7 Replies View Related

Server :: Mysql 'Table 'mysql.user' Doesn't Exist'?

Aug 2, 2010

I'm trying to setup wordpress on my server, which of course I need mysql for. I setup a database the other day, which worked perfectly, but I had to start again as I put some information in wrong. Now, I can create a database fine, but when I run

Code:
GRANT ALL ON wordpress.* TO wordpress@localhost IDENTIFIED BY "password";
I get the output:

[code]...

View 13 Replies View Related

CentOS 5 :: Error: Mysql Conflicts With Mysql-server-community

Jun 4, 2009

I have MySQL 5.1.34 and PHP 5.1.6 installed on my system, how do I install php-mysql? Each time I try, it says

mysql-5.0.45-7.el5.i386 from base has depsolving problems
-- > mysql conflicts with mysql-server-community
error: mysql conflicts with mysql-server-community

View 16 Replies View Related

Server :: Where Are The Booleans For SELinux Stored

Sep 23, 2010

I always thought that whenever /usr/sbin/setsebool was used, it would write either a "0" or a "1" into the corresponding boolean file. All SELinux boolean files are in /selinux/booleans but If I check, for example, this boolean ...

[Code]....

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved