I get some trouble setting up good environment in linux.. i have problem regarding connecting php(under linux) to a sybase server(under windows),,, is there anyway connecting this two technologies?..
View 7 Repliesi get some trouble setting up good environment in linux.i have problem regarding connecting php(under linux) to a sybase server(under windows)is there anyway connecting this two technologies?.
View 1 Replies View RelatedAt work we have a Sybase Adaptiver Server 9.0 database running, it has to stay there for now, and we are developing a web application that will connect to it using PHP.I was already able to make it work using ODBC on Windows and using odbc_connect on PHP.But now we are moving to Ubuntu, and we are trying to get it to work on it.I already have Apache2 and PHP5 up and running.There are two ways (I can think of) we can do this, one is using ODBC and then use "odbc_connect" and the other is making "sybase_connect" work on PHP. Being the latter probably the best one since you wouldn't have ODBC as an intermediary.
Either way, as long as it works I'm happy. ODBC would be fine to meet our requirements for now.I already have ODBC Data Source Administrator but no idea how to create/include/add the Sybase driver.We also tried setting freetds up, but that didn't work either, we might be missing something.
I need to reconfigure my php to have Sybase support. However, I am not sure which library to use. I'll try freetds but I am not sure if it will work. I used it before with Microsoft MSSQL.
View 3 Replies View RelatedI mean, isn't that exactly how normal home users can visit search engines such as Google or Bing and search for information?
View 7 Replies View RelatedI'm attempting to get freetds and sybase up and running on my centos server, mainly for nagios - MSSQL checks. I've installed freetds freetds-devel ok but am having issues getting SYBASE installed. I've had a go via cpan but get a failure on the sybase environment variable. I've set it to /etc where the conf file is located as well as trying /urr/lib64 for the tds libs, but no joy. Has anyone had much luck with this on centos?
export SYBASE=/etc
[root@nagios ~]# echo $SYBASE
/etc
cpan DBD::Sybase
CPAN: Storable loaded ok (v2.15)
[Code]...
I am writing a simple application that will run as user foo (i.e. Ubuntu user foo).However, the application will connect to my database as (database user foobar). IIRC, database users have nothing to do with Linux system users - but I just need to clarify that.So can an app launched to run as user 'foo', connect to a database as user 'foobar'?
View 1 Replies View RelatedI'm new to linux, and setting up the mysql database server.
Here are my situation:
OS: CentOS 6
mysql version: 5.5
I tried to use MySQL Administrator to connect to my database on the host 192.168.1.120
and my computer is under the same network with ip: 192.168.1.105
But it shows the error msg: Could not connect to MySQL instance at 192.168.1.120
Error: Can't connect to MySQL server on '192.168.1.120'(61)(code 2003)
On the server side I've tried:
Code:
skip_networking is off and I've set the port for it.
When I check the process in OS:
Code:
When I try netstat:
Code:
I thought it's the problem of firewall, so I have check it also:
Code:
how do I create a shell script that looks for connections running on a oracle database. e.g connection name is CONNECT and database name is DBTEST. I want to know what processes with the name CONNECT are running in database called DBTEST. Am creating the script on the server side. I know about the ps -ef | grep command but how to point to a particular database I don't know.
View 4 Replies View RelatedWe purchased a new database system at work last October, ditching the old system because of a lack of support from the vendor. This is a retail Point of Sale and Backoffice database system. I am not sure what system the new one runs on, but the system we replaced was a Firebird data base. The reason I am posting is because we are now in need of the information contained in the old database which was not completely imported into the new system. Unfortunately, we parted company with the old vendor under extremely hostile conditions, and they are not a source of help for this problem, nor are the new vendors.
Basically the problem is this: The database in on a Windows XP system and I found a copy of SQL Manager Lite 2008 on the system, which after quite a bit of studying, I figured out how to extract the database into a removable file. I have this file (178MB) on a USB stick in a file called Backoffice.fbd. I can get into this database with MySQL. All I want to be able to do get into the database and create tab deliminated spreadsheet files for each of the database sections (Customers, Repairs, Sales History, stock files, etc.) Is it possible to do this with Ubuntu and MySQL and if so, can an expert suggest one or two things to get me started.
I have an application running on a centOS machine that needs to access a database on a CentOS server. I granted access to all users with a certain user name and password.i opened up port 3306 as well with the following command: /sbin/iptables -A INPUT -i eth0 -p tcp --destination-port 3306 -j ACCEPTbut whenever i try to connect from my machine i get an error:ERROR 2003 (HY000): Can't connect to MySQL server on '172.16.102.129' (113)I am using mysql version 5.0.77 on centOS 5.5.
View 1 Replies View RelatedI have 32 gigabytes of my hard drive wasted with a vistool installation a flaky don't look at me wrong or I will brake and you will have to reinstall me stinking winbloze
simple I want to fly my radio controlled helicopter and both programs that configure the radio transmitter so it talks sense to the model are windoze only almost (the wrong driver for the interface cable came with it the driver crashed and scrambled the configuration of the transmitter) the lesson here is XP drivers DO NOT! work with Vis-Stool
One of them will run on .NET (for windoze) and wine (I have no idea of how to install .net for linux ) it just dose not talk to the interface cable witch has a linux kernel module and connects the cable to /dev/ttyUSB0
Is there a way to make /dev/ttyUSB0 show up as a COM4 in wine.
i have two machines at home running ubuntu linux and windows connected by lan. on ubuntu machine i have mysql installed, how do i go about accessing ubuntu mysql database on my windows machine.
View 2 Replies View RelatedIs it possible to setup apache to normally block an IP from accessing a site until that IP is in a database/file?More or less, I need a login system that another script can add/remove the IPs and the site can be accessed by only those IPs.
View 1 Replies View RelatedWell i have got a problem with connecting to a mysql database using php. I used this package "mysql-noinstall-5.1.44-win32.zip" and extracted it to c:mysql and added c:mysqlin to the PATH variable and used the following command in command prompt to start mysql: c:mysqlinmysqld --standalone
well mysql did start and everything went well accessing mysql in command prompt. Well under the database "mysql" in the table "user" i created a new user "php" with a password="****" and hostname = "localhost" but when i try to access this database with a following php routine:
And when i accesses it with my browser using localtost/test.php, all i get is "localhost" displayed on screen, "Connected to mysql" never gets displayed not i get any error..i am using windows 7(32-bit-ultimate)and mysql 5.1.44.
I've just installed the Oracle Instant client using this: https://help.ubuntu.com/community/PHPOracle
The phpinfo() show me that oci8 is enable, but when I try to query that database I've got the following message:
PHP Code:
Code:
How to troubleshoot.
I've got a database and I've got a Java program that I'm programming in Netbeans that is suppose to run queries to the database. how I will set about to connect the database with the Java program so that I can run the queries?
It is very important that I learn how to do this, else I am forced to go back to XP in order to finish this project on time.
We are hoping to build a central database server so that we can take all the singular instances of mysql off our web servers and have the data stored in one place (we also run a number of syslogging servers that use mysql, netflow servers that use mysql, and many other servers that have mysql tables that we would like to consolidate as well). Now I have run into the problem that requires all the customer web sites to change the configuration for their connection to the mysql server from a local connection to a remote connection, which is something we are trying to avoid. I am wondering if there is a software suite or a function of mysql itself that allows you to present the remote database information as local databases to a server, allowing customer configurations to remain intact, as if the mysql server never moved off the local machine? Or a different question, can you configure mysql server to take local requests and forward them to a central mysql server?
View 9 Replies View RelatedHow to connect to remote oracle database using perl?
This is what I tried.
Code:
But I am unable to connect.
I want to install Sybase ASE 15 on CentOS Linux 5.6 has anyone ever done that.
View 1 Replies View RelatedI'm trying to install Sybase ASE EXpress 15.5 on Ubuntu and am getting the following error message: ./startserver: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory.
View 3 Replies View RelatedMy home network is has a Netcomm NB5 ADSL modem with a D-Link DI-524 wireless router (WEP encryption). While I can access the internet using the Vista partition, on the Ubuntu partition, I cannot access anything. Further investigating the problem, I have noticed that there is something wrong with the DNS on the Ubuntu partition. Pinging the IP address of a website (such as linuxquestions.org) loads up, yet, when I type in the Domain Name, there is an endless wait. I have already deleted and re-entered the contents of the resolv.conf file as well as try to change the settings but to no avail.
View 5 Replies View RelatedI have never seen this before but to connect to the internet either wired or wireless I have to connect to a broadband connection as well. I am currently using wireless; I connect to ISP with wireless but in order to access the internet I have connect to the wireless connection through my broadband connection(This is where I enter a user name and password.). I'm not sure why this is, I have always just plugged an Ethernet cable in and the computer just knew I guess.
I am using ubuntu-10.04-netbook-i386.iso that I had put onto a USB drive. It booted fine, but when I tried accessing the internet I couldn't. I was able to connect to the ISP, but I couldn't find any settings for a broadband connection. My computer is a Acer Aspire One Netbook 250
Intel Atom
CPU N270 @ 1.60GHz
1.60 GHz 1.99 GB of RAM
Network Adapters
Atheros AR 5B95 Wireless Network Adapter
Atheros AR8132 PCI-E Fast Ethernet Controller
I have recently installed Java in my Ubuntu 9.04 environment so that I can teach myself Java. Basic Java programs work, but I am having trouble connecting to a MySQL database. I installed these packages using Synaptic Package Manager.
1.gsfonts-x11
2.java-common
3.odbcinst1debian1
4.sun-java6-bin
5.sun-java6-jdk
6.sun-java6-jre
7.unixodbc
After these packages were installed, I was not sure if I needed to do this, but I downloaded the MySQL connector from MySQL :: MySQL Connectors and installed in a directory called /home/mark/mysql/.
I then did "sudo gedit /etc/environment" and added a CLASSPATH to where I installed the connector:
Code:
I found an example Java program from Using JDBC with MySQL, Getting Started and stripped it down even further to test the MySQL connection.
This is the program I am running:
Code:
Could not find the main class: Jdbctest. Program will exit. I am new to Linux, Ubuntu, Java and MySQL, so I have probably left out something that is very obvious.
So i ran a srcds server (source) in the backround using &.ccess it again or atleast kill it" ./srcds_run -console -game garrysmod +maxplayers 52 -autoupdate &"
View 2 Replies View RelatedI've been trying to figure out how to access tomcat6 pages outside of the computer actually running the tomcat6 server. I can access the tomcat6 web pages fine on the computer running the server, but I can't seem get to it on another. I'm probably not setting it up correctly or something, but I've attempted to access the tomcat6 server by following this form:
[URL
Did I not set up the tomcat6 server correctly?
am using zabbix open source solution for systems monitoring. I am facing a problem and discussed it on zabbix forum. my post was as "My zabbix server is behaving abnormally, approximately daily from 9 to 12, the server stop accumulating logs. I observed that the server report is RUNNING but it did not accumulate log values and also the machine have no extra load. Its shown in the graph image attached.t the following reply,"database performance?are you monitoring database IO and available database threads? "So any one have any idea that how can I do this as I am using MySQL as backend database on RHEL 3.
View 1 Replies View RelatedI'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:
1. i need to check whether the oracle database is running or not if it is running it will run auto mount script.nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt&nohup /u01/app/oracle/product/11.2.0/dbhome_1/bin/dbfs_client dbfs@xxxxxx -o allow_other,direct_io /u01/app/oracle/DBFS/XXXXX < /home/oracle/passwd_dbfs.txt &2. For every 1 hour i need to check above mount points is mounted or not if it is not mounted it should be mounted.
View 3 Replies View RelatedI installed Tomcat5.5.23 on CentOS5.2 running on Sun xVM Virtual Box2.1.2. When i try to view Tomcat( Running in Vitual Centos)'s home page in the web browser of Host( XP sp2) am getting the "Connection Time out" error.. How to resolve this problem.
View 2 Replies View Related