| View previous topic :: View next topic |
| Author |
Message |
cybofax
Junior Member
Joined: 26 Jan 2015
Posts: 4
Location: UK
|
 Posted: Mon Feb 02, 2015 4:33 pm Post subject: PHP mysql extension for mysql |
 |
|
Hi all,
The PHP mysql extension won't load when uncommented in php.ini
| Quote: | | "...PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/msql.so' - /usr/lib/php/extensions/msql.so: cannot open shared object file: No such file or directory in Unknown on line 0..." |
This can't be installed using slapt-get (e.g. php5-mysql)
| Quote: | "...Reading Package Lists...Done
No such package: php5-mysql..." |
Is there a way to get this installed? Or would it break something? |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Mon Feb 02, 2015 9:32 pm Post subject: |
|
|
mysql extension is already uncomment and loaded by default...
extension=mysql.so
You can see it at phpinfo.php also...
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
cybofax
Junior Member
Joined: 26 Jan 2015
Posts: 4
Location: UK
|
| Posted: Mon Feb 02, 2015 10:46 pm Post subject: |
|
|
Hi gerasimos_h,
Thanks for the quick reply. OK - it looks like I commented out msql.so which gives the error. Very sharp-eyed of you!
The only error I get now is
| Quote: | PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php/extensions/xsl.so' - /usr/lib/php/extensions/xsl.so: undefined symbol: dom_node_class_entry in Unknown on line 0
|
Now this may or may not have a bearing on my "original" issue which is getting the webshop part of webERP working. I will do some more troubleshooting! I was told by the webERP guy that the extension was required and I leapt on this as being a possible cause of the php script not working.
Please mark this as "solved" and I'll do some further testing.
Thanks again!
 |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Tue Feb 03, 2015 8:29 am Post subject: |
|
|
Which SMS version do you have...?
Also if you upgrade php from slapt-get, we switch to php-5.4 so you need to switch /etc/httpd/php.ini and restart apache
| Code: | cp /etc/httpd/php.ini{.new,}
apachectl stop
apachectl start |
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
cybofax
Junior Member
Joined: 26 Jan 2015
Posts: 4
Location: UK
|
| Posted: Tue Feb 03, 2015 2:16 pm Post subject: |
|
|
Version from uname is
Linux sms 3.4.67 #2 Sat Oct 26 23:18:05 EEST 2013
phpinfo()
PHP Version => 5.4.37
I do have a php.ini at /etc/httpd
I did a cp and restarted apache as suggested.
| Quote: |
]root@sms:~# ls /etc/httpd -lash
total 576K
4.0K drwxr-xr-x 4 root root 4.0K Feb 3 11:52 ./
12K drwxr-xr-x 99 root root 12K Feb 2 13:05 ../
4.0K drwxr-xr-x 2 root root 4.0K Sep 14 18:44 extra/
20K -rw-r--r-- 1 root root 18K Jan 5 10:21 httpd.conf
20K -rw-r--r-- 1 root root 18K Sep 4 2010 httpd.conf.new
16K -rw-r--r-- 1 root root 13K Feb 16 2008 magic
32K -rw-r--r-- 1 root root 29K Feb 16 2008 mime.types
4.0K -rw-r--r-- 1 root root 783 Mar 21 2014 mod_perl.conf
4.0K -rw-r--r-- 1 root root 783 Nov 14 2012 mod_perl.conf.example
4.0K -rw-r--r-- 1 root root 903 Mar 16 2013 mod_php.conf
4.0K -rw-r--r-- 1 root root 903 Sep 8 2007 mod_php.conf.example
4.0K -rw-r--r-- 1 root root 903 May 25 2008 mod_php.conf.new
4.0K drwxr-xr-x 3 root root 4.0K Feb 16 2008 original/
68K -rw-r--r-- 1 root root 67K Feb 3 11:43 php.ini
68K -rw-r--r-- 1 root root 65K Jan 23 20:29 php.ini-development
44K -rw-r--r-- 1 root root 44K May 7 2008 php.ini-dist
68K -rw-r--r-- 1 root root 65K Jan 23 20:29 php.ini-production
48K -rw-r--r-- 1 root root 47K May 7 2008 php.ini-recommended
68K -rw-r--r-- 1 root root 67K Jun 15 2012 php.ini.new
68K -rw-r--r-- 1 root root 67K Feb 3 11:52 phph.ini
4.0K -rw-r--r-- 1 root root 1.2K Feb 5 2013 server.cert
4.0K -rw-r--r-- 1 root root 1.2K Feb 5 2013 server.crt
4.0K -rw------- 1 root root 1.7K Feb 5 2013 server.key
root@sms:~# |
webERP appears to run fine - I just have a problem with getting the webshop to run. It seems to have an issue with the database credentials - I'm not sure why as the credentials are correct in weberps config.php and the webshop's config is pointing to it. | Quote: | The configuration in the file config.php for the database user name and password do not provide the information required to connect to the database server
Click here to try logging in again |
The weberp guy mentioned the PHP mysql extension - but as you pointed out - those are there anyway. He also mentions that the dbType should be mysqli and not mysql - but that is also correct in weberp's config.php.
Would it be possible to (re) install weberp on SMS? I hear version 12 was released recently. |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Tue Feb 03, 2015 8:51 pm Post subject: |
|
|
I don't know webshop, do you have a separate config.php on webshop or a setup to install extra tables in database...?
Can I take a look to see what is this all about?
You can upgrade or reinstall weberp, although I don't see how this will solve your problem...
just untar latest weberp on your webserver and try it...
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
cybofax
Junior Member
Joined: 26 Jan 2015
Posts: 4
Location: UK
|
| Posted: Tue Feb 03, 2015 9:05 pm Post subject: |
|
|
Hi gerasimos_h,
the webshop is an add-on that the developer of webERP wrote to enable (say) paypal purchases but it uses all the information from webERP. He is as mystified as you seem to be and he has requested credentials to have a look.
There is an "extra" config.php for the webshop scripts but apart from the database name - it relies on webERP's config.php to access the database.
I'll keep you posted - however if you want to have a look anyway - let me know.
By the way - thanks for your support! |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Tue Feb 03, 2015 9:31 pm Post subject: |
|
|
I'm not mystified, it's that I don't know how webshop installs, and since I provide webERP, I would like to know if there is a problem with purchased addons...
You can pm me the login information whenever you are ready or if the webERP developer finds what's wrong let me know...
Also please take a look at securing and optimizing you server, for changing default passwords., including weberp's database credentials...
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
|
