| | Can you access the Solaris DB from your Windows box? | | mysql -u <user> -h <ip_of_solaris_box> -p |
Yep. | Also, what is the error your getting exactly? Are you | running the web | server on the Solaris box as well? If so drop this into | the document root: | <? | phpinfo(); | ?> | | and call it something original like info.php, and call it | from a browser. | It should show the mysl support section. Apache/PHP/Mysql on the Sol 2.6 box (Generic_105181-26). Yes, paleo-computing but I don't think that is the problem. If I empty the data and keep the schema (i.e. start with a minimal-populated DB) it works... In phpinfo() the mysql section looks like this: MySQL Support enabled Active Persistent Links 2 Active Links 2 Client API version 3.23.39 MYSQL_MODULE_TYPE builtin MYSQL_SOCKET /tmp/mysql.sock MYSQL_INCLUDE MYSQL_LIBS Directive Local Value Master Value mysql.allow_persistent On On mysql.default_host no value no value mysql.default_password no value no value mysql.default_port no value no value mysql.default_socket no value no value mysql.default_user no value no value mysql.max_links Unlimited Unlimited mysql.max_persistent Unlimited Unlimited Hmm, include and libs is empty...can't see that being the issue though. This is all stuff as set (default?) from the Sol 2.6 mysql package at sunfreeware.com. The PHP error I am getting is: Warning: Supplied argument is not a valid MySQL result resource in /www/sapdoc.rmoc.on.ca/html/lib/db.php on line 69 Which normally means the select from the db was malformed, but I can't see where it is broken, and this exact same code works on the "identical" db that is on the PC via a socket connection (but throws this error when data is called from localhost). Weird. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
