ODBC Connection Not Working Correctly
May 28, 2009
I had a small question about ODBC. I created a new connection to a MySQL database with the 'ODBC Data Source Administrator' on my Win 2008 / IIS 7 webserver.
In this administration panel the ODBC data source works just fine. When I fill in the required values I receive the list of available databases and pressing the "test" button results in a successful connection.
But when I want to use this connection in other software, a C++ application and a PHP application, they supply me with errors "Couldn't connect to database", etc.
So the ODBC connection is correct (so are the credentials in the software 100% sure of that), but software can't use the connection. Because the software worked perfectly on an older server I think I'm missing out on some sort of setting which enables applications to use the connection (or something like that).
View 0 Replies
ADVERTISEMENT
Dec 21, 2008
if it's possible to use ODBC to connect to a Windows box from a Linux cPanel server. We have attempted connections from PHP (both as CGI as well as Apache module) and we get:
Fatal error: Call to undefined function odbc_pconnect() in...
and
Fatal error: Call to undefined function odbc_connect() in...
Is ODBC possible on cPanel servers?
View 2 Replies
View Related
Jun 7, 2008
I have suPHP installed in FastCGI mode. PHP5 is my default installation but I have it setup so that PHP4 can also run. At least that is my intention.
I have PHP5 working without a problem.
PHP4 is loading if I add the directinf x-httpd-php4 .php into my .htaccess file.
HOWEVER: PHP (via phpinfo) is trying to load the config file from /usr/local/etc/php5/cgi/php.ini when it should be from ....php4/cgi/php.ini
Where do I go to fix this? Or is there a second directive that I need to load in the .htaccess file?
Also... In either php5 or php4, if I put a php.ini file into a directory, it is suppose to load that one. However, it is not doing this either.
View 9 Replies
View Related
Aug 23, 2014
When I modify rules using the firewall panel it is not generating rules correctly when selecting allow from selected sources deny from others.
View 2 Replies
View Related
Sep 2, 2014
Latest Plex installed on a fresh machine. Have tried both Ubuntu 12.04 and 14.04 and cannot seem to have my website work correctly regarding URL rewrites. Its enabled in apache...
View 1 Replies
View Related
Jun 25, 2015
When I deny all other traffic for the "System policy for incoming traffic" to secure the server by only allowing the explicit ports I've requested to open, my server stops operating correctly.
It appears when I set the "System policy for incoming traffic" to deny, it appears to be disrupting various functions such as web traffic over ports 80/443, FTP, SSH, they either work extremely slow or don't work at all.
I brought this up with my Plesk license provider and they stated that the Plesk firewall doesn't add any tracking for ephemeral ports, therefore if you set the policy to drop for incoming/outgoing, it's not going to allow proper TCP communication since the return socket can't be opened. Also that the firewall is an explicit deny system rather than explicit allow based system.
Am I doing something wrong? All I want to do is to block all ports other than the ones I've set to allow. Is this how it is supposed to work?
View 1 Replies
View Related
Jul 9, 2008
I have been having great trouble sending mails from my local Thunderbird/Windows client to my Debian/Exim-server via TLS/SMTP.
I am no expert on TLS and SMTP, but I managed to create a server certificate and set up a secure (TLS) connection more than a year ago, and it has been working fine until it suddenly stopped working a couple of weeks ago.
Sending to external addresses from web pages still works fine, the problem seems to be in the SMTP connection. If I try to "telnet xxx.xxx.xxx.xxx 25" I get no reply whatsoever (it seems to connect but it just gives me a blank screen with a blinking cursor) and I am wondering if there is a firewall issue or if I am simply not running the right daemon to listening for incoming SMTP connections...
POP continues to work fine with teapop/stunnel enabled.
I am running Exim 4.63-17 on Debian Etch. I configured Exim to be of the type "internet site; mail is sent and received directly using SMTP"
==============================
Firewall shouldn't be a problem (?):
debian:~# iptables -L
Chain INPUT (policy ACCEPT)
target prot opt source destination
Chain FORWARD (policy ACCEPT)
target prot opt source destination
Chain OUTPUT (policy ACCEPT)
target prot opt source destination
==============================
I really don't know what to do. I have tried running:
tail -f /var/log/daemon.log
Which responds when I access my mail using POP but not when I try to send using SMTP.
View 4 Replies
View Related
Nov 13, 2008
connection state ESTABLISHED,RELATED is not working in my iptaables...?
Accept If input interface is lo
Accept If state of connection is ESTABLISHED,RELATED
Drop If protocol is ICMP
Accept If protocol is TCP and destination port is 80
Accept If protocol is TCP and destination port is 99
Accept If protocol is TCP and destination port is 25
Accept If protocol is TCP and destination port is 110
Accept If protocol is TCP and destination port is 10000
Accept If protocol is TCP and destination port is 21
Accept If protocol is TCP and destination port is 30000:30500
Accept If protocol is UDP and destination port is 53
Accept If protocol is UDP and source port is 53
Accept If protocol is TCP and destination port is 445
Accept If protocol is TCP and destination port is 2390
this in my Incoming packets rules..
Outgoing packets are all accepted..
so if i made connection from the server the input rules shuld accept them because it is established and related connection.. But it wont work.. any ideas about it..?
my vps is running on cent os 5.2 final..
and the control panel is webmin.
View 10 Replies
View Related
May 5, 2015
For some reason FTPS is no longer working as it used to before plesk upgraded. At this point, I am not sure which Plesk upgrade caused this since I do not FTPS or ftp in general often. its enabled as it was before, even disabled and re-enabled it again. Still gives a "could not establish connection". Restarted the service via command Line with "service xinetd restart". still isnt working...
View 19 Replies
View Related
Feb 21, 2007
I am configuring a Linux server to connect to a MSSQL database using freetds and an ODBC driver setup.
I have all but completed this, but I am stuck with some mis-configuration that I cant figure out.
Here's the problem. I can connect the the mssql server using tsql, but I cannot connect to it using isql, which is what I need to get php to connect to it.
Here is applicable part of the freetds.conf file.
Code:
[TDS]
host = 10.10.64.102
port = 1433
tds version = 8.0
here's the odbc.ini. (This was setup using the linux GUI ODBCadmin tool).
Code:
[MSSQLServer]
Description = TDS
Driver = TDS
Servername = 10.10.64.102
Database = MyDb
UID = myuser
PWD = mypassword
Port = 1433
here are the commands I am using to connect:
Code:
#tsql -H 10.10.64.102 -p 1433 -U username -P password
#isql -v MSSQLServer username password
I can connect with the username and password using tsql, but not with isql or php.
View 1 Replies
View Related
Apr 20, 2014
I suddenly started to get the following error
Windows 2008 server 64 bits 24 gigs ram sql express php plesk 11.5.30 latest update passed the latest self test with no problem
Internal error: ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
Message ODBC error #42S02: [MySQL][ODBC 3.51 Driver][mysqld-5.5.31]Table 'apsc.aps_package' doesn't existODBC error #42S02:
File aps_php.php
Line 11933
Type Exception
Go To Previous Page
View 1 Replies
View Related
Sep 29, 2014
I am using user authentication with the following components:
Apache/2.4.10 (Win32) + mod_auth_basic + mod_authn_dbd + mod_dbd + ODBC Driver + Microsoft SQL Server 2008(SP3).
It works fine except when I do not provide any username when browser asks for username and password. In this case I receive the "Internal Server Error" as the response instead of "Unauthorized" response.
The most interesting part of the error.log is:
[Sat Sep 27 21:23:17.639860 2014] [authn_dbd:error] [pid 1208:tid 1636] [client 127.0.0.1:1363] AH01656: Query execution error looking up '' in database [[dbd_odbc] SQLBindParameter returned SQL_ERROR (-1) at apr_dbd_odbc.c:604 [Microsoft][ODBC SQL Server Driver]Invalid precision value HY104 ]
The AuthDBDUserPWQuery directive in my httpd.conf is:
AuthDBDUserPWQuery "SELECT password FROM member WHERE CONVERT(VARCHAR(10), member_Index) = %s"
And the member_Index column in the database is smallint.
View 5 Replies
View Related
Apr 7, 2008
I have ftp server (pure-ftp). with firewall.
i allowed 20 and 21 port in "CSF" firewall
now when i or our client connect to the server connection done.
and the they fire dir or ls command they will receive error
"425 Could not open data connection to port 2535: Connection timed out"
what is the problem.i have already allowed passive port 2500:3500 then why i received this types of error
View 3 Replies
View Related
Jan 28, 2008
I am being rejected by Hotmail when sending mail from my VPS. I want to send mails from punbb and OSCommerce, with various website hosted on one VPS/Cpanel/LAMP solution. And with sendmail or SMTP, it'a always the same : passing almost every ISP except Hotmail/Gmail. I also always get this part in my email header regardless of which website i'm sending email from :
Code:
Received: from host.locker4adream.com ([74.200.75.7])
by host.locker4adream.com with esmtpa (Exim 4.68)
So I think it's the host.locker4adream.com part that makes me rejected. Because it's almost the only line in the email header that is different when I am using Outlook/Thunderbird to send mail. This ip (74.200.75.7]) is mine and I never spammed or anything.
So i asked my host ro add rDNS. And I added this line to my DNS zone on my mail domain:
Code:
lockeradream TXT "v=spf1 mx a ptr ip4:74.200.75.7/32 ip4:74.200.81.156/32?all"
I am really out of solutions! Can anyone tell me if the SPF record stated above is ok?
View 1 Replies
View Related
Jan 15, 2007
I was checking this tutorial and thank the lord I did this all correct before I saw this thanks to all of you here on WHT (you all rock!) but right at the end of the tutorial it talks about setting up PTR dns... what exactly are they for? And are they needed?
[url]
Also does anyone know how to check/configure the reverse DNS settings?
View 3 Replies
View Related
Apr 26, 2008
I have just ran easyapache to update from 5.2.4 to 5.2.5 and selected suhosin.
I can see no evidence of it by viewing phpinfo scripts such as vbulletin's.
i should be able to see something like this yes?
[url]
and there is nothing new in php.ini other than:
Directory in which the loadable extensions (modules) reside.
extension_dir = "/usr/local/lib/php/extensions/no-debug-non-zts-20060613"
zend_extension="/usr/local/IonCube/ioncube_loader_lin_5.2.so"
zend_extension_ts="/usr/local/IonCube/ioncube_loader_lin_5.2_ts.so"
extension="suhosin.so"
Via SSH i get this
# php -v
PHP 5.2.5 (cli) (built: Apr 26 2008 06:45:31)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Suhosin v0.9.23, Copyright (c) 2007, by SektionEins GmbH
with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies
# /usr/bin/php -v
PHP 5.2.5 (cgi) (built: Apr 26 2008 06:49:11)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and
with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technologies
with Suhosin v0.9.23, Copyright (c) 2007, by SektionEins GmbH
with Zend Optimizer v3.3.3, Copyright (c) 1998-2007, by Zend Technologies
View 3 Replies
View Related
Nov 7, 2008
I am using version 2.14.5 of MRTG, it is old.
The old MRTG works correctly?
View 1 Replies
View Related
Aug 25, 2007
to run my mail through the main IP of my server, which has reverse DNS. At present my mail is running through an other IP address on the same server.
I need someone to show me hows to set it up correctly. My host has alerted me to the problem but their support doesn't include doing this kind of work.
I will pay someone who knows what they are doing, to do this work for me.
View 3 Replies
View Related
Apr 27, 2007
I've had this problem for a while. My HTTP will stop functioning, so I attempt to restart it via SSH. I restart it, yet it doesn't fix the problem. So I reboot the server via SSH. I wait 5-10 minutes and the server STILL isnt up. Can't login via SSH or anything.
So every time I have to tell my host to manually reboot the server. I've had apache recompiled multiple times, but I don't think that's the issue.
View 1 Replies
View Related
Mar 14, 2008
I get this error with netdiag:
DNS test . . . . . . . . . . . . . : Failed
[WARNING] The DNS entries for this DC are not registered correctly on DNS se
rver 'DNS.FIRST.IP.HERE'. Please wait for 30 minutes for DNS server replication.
[WARNING] The DNS entries for this DC are not registered correctly on DNS se
rver 'DNS.SECOND.IP.HERE'. Please wait for 30 minutes for DNS server replication.
[FATAL] No DNS servers have the DNS records for this DC registered.
configuration:
Server is a DC/AD. It has 2 IP's, both are static of course. the DNS Servers are manually added into the network configuration properties, as these are provided by the hoster.
View 2 Replies
View Related
Dec 6, 2014
I am running a CentOS 6.6 (Final) with Plesk 12.0.18 Update #27 on my dedicated server. I was advised to upgrade my server to one that has a SSD due to better performance. What they failed to tell me was that I would need to perform additional configurations so that Plesk stores the subscription files in the /HDD-var/ directory and NOT the /SDD-var/ directory. Current server
Here are my questions:
1. How difficult would it be (I am a quick learner and can follow exact steps or directions very well) to make Plesk store the files on the HDD rather than the SDD?
2. Is this something I should undertake or is this very difficult to do?
3. If I perform these changes, will they revert to the old way if I perform Plesk updates? Or will the changes I make become permanent?
SSH: df -h
Filesystem Size Used Avail Use% Mounted on
/dev/md1 4.0G 916M 3.1G 23% /
/dev/mapper/ssd-usr 3.9G 1.9G 1.8G 51% /usr
/dev/mapper/ssd-var 3.9G 3.7G 2.7M 100% /var (Plesk is storing data here)
/dev/mapper/ssd-home 3.9G 792M 2.9G 22% /home (Would also like this data to be on the HDD)
[Code] ....
View 3 Replies
View Related
May 14, 2009
We are planing to implement a spam appliance like the mailfoundry for our 60 cpanel servers.
What is the best and easiest way to replace the standard cpanel mx entry in the dns zonefiles with our two new MX entries?
Additionaly we need to enable the option "Always accept mail locally even if the primary mx does not point to this server." for all the dnszonefiles where we use the new MX entries.
The problem is, that some customers are using already own mx entries, therefore we can not change all of them, but only the entries which point to the cpanel server.
Does someone have a script for this, or how would you change this?
View 2 Replies
View Related
May 3, 2007
I just finished installing a new webserver :
debian 4 , 2.6.18-4-686 , PHP Version 4.4.4-8+etch2 , Apache 2.0
Everything is working fine, except that a lot of excotic letters and symbols on the site are not displayed correctly. Most of the special letters in Swedish, Russian or Polish are replaced by a '?' or a small square. It is a serverside problem, as the same texts are displayed correctly on another, older webserver.
I assume it has something to do with a character set or font that I need to install. But I don't know the exact name of this option, so searching on google doesnt give much relevant results.
View 1 Replies
View Related
Oct 2, 2013
Yesterday i was putting a website to manage in localhost but i had to abilitate the usage of mod_rewrite. when i'm in the index and i try to open links i have this message..The requested URL /c3click.php was not found on this server.Here are the steps that i followed:
1) Search for LoadModule ReWrite and decommenting
2) Search for Servername localhost
<Directory />
AllowOverride all
Require all granted
</Directory>
3) Search for C:/wamp/www
Options all
#
# AllowOverride controls what directives may be placed in .htaccess files.
# It can be "All", "None", or any combination of the keywords:
# AllowOverride FileInfo AuthConfig Limit
#
AllowOverride all
#
# Controls who can get stuff from this server.
#
# Require all granted
# onlineoffline tag - don't remove
Order Deny,Allow
Allow from all
Allow from 127.0.0.1
Allow from ::1
Allow from localhost
4) Reboot the server
In the beginning of my .htaccess file there's written
RewriteEngine On
RewriteBase /
Options -Multiviews
My configuration is Windows 7, Apache 2.4.4 on Wamp Server 64bit.
In the apache_error.log file i discovered this
[Wed Oct 02 10:33:47.582049 2013] [:error] [pid 2412:tid 1496] [client 127.0.0.1:50195] script 'C:/wamp/www/c3click.php' not found or unable to stat, referer: http://localhost/Lavoro/C3click/01-10-2013_Sito/
View 1 Replies
View Related
Jul 1, 2014
Microsoft Windows Server 2012 Panel version 11.5.30 Update #47
The Webadmin app does not install all the folders it needs to run correctly. I have downloaded and repaired the install as noted in [URL] ..... This did not repair the install. All the folders that are needed in the application directory in the vhosts folder are still missing. I have attached the install log.
View 1 Replies
View Related
Nov 25, 2014
I have domainA and domainB. domainA hosting files, for security ALL browser access should denied.. EXCEPT domainB make in php call with readfile() to a file on domainA. This should allowed.
domainB => readfile(http://domainA/myfile) => allowed ... all other access should denied.
So I set in vhost of domainA this:
<DirectoryMatch "^/var/www/vhosts/domainA/httpdocs/folder/">
Order deny,allow
Deny from all
Allow from 127
Allow from server-ipv4
Allow from server-ipv6/128
Allow from ::1/128
</DirectoryMatch>Click to expand...
View 3 Replies
View Related
Oct 27, 2009
I getting that message when i try to run one windows program.
Any idea how to fix it?
That program works on netbook but i need to make it work on my main pc.
View 1 Replies
View Related
Jan 24, 2008
I am setting up the HotLinking access in cPanel for one of my accounts and don't understand the wording of this section.
It first has the list where you put in the domains that you want to allow hotlinking for.
Then below that it has an input that says, "Extensions to allow:". For this input, does that mean extensions to allow for EVERYONE, or just the domains listed in the section above?
You think they'd be clearer on that in the documentation, but they aren't. Help on this is greatly appreciated.
View 4 Replies
View Related
